New Message: Flipping the Manila Sites Database

[webmaster at userland.com]

A new message was posted:

Address: http://frontier.userland.com/discuss/msgReader$11788

By: Lawrence Lee (lawrence at userland.com)

<rules><!-- 1.5 spacing -->
   <rule><outlineSpacing>1.5</outlineSpacing></rule>
   </rules>
When a new Manila website is created, it's stored in a database containing other Manila sites. By default, this database is manilaWebsites.root.
As manilaWebsites.root grows, it's a good idea to "flip" -- to start using another database for new Manila sites.
One of the reasons do this is that there's a 2GB limit on the size of databases. You should flip well before you reach that limit, so your sites have room to grow.
<rules><!-- internalLink, bold headings -->
   <rule level="1" to="1"><internalLink/><textStyle>bold</textStyle></rule>
   </rules>
Create a new database
   From the Frontier application, create a new object database via the File menu. Give it a name like manilaWebsites2.root and save it to the Guest Databases\\www\\ folder.
   With the new database in front, choose Add to user.databases... from the Server menu. This will ensure that the database is opened automatically when Frontier starts up.
Edit your Manila prefs
   Jump to config.manila.prefs.
   Set the hostingGdbName to the name of your new database. It's a string; its value should now be <code>manilaWebsites2.root</code> (or whatever you named your new database).
Test
   In the Control Panel, go to the New Site page. Create a new test site.
   Then, back in Frontier, look at your new database. Does it contain a new table, with a name that contains the name of the site you just created? It should.
   If there were an errors in testing, go back and make sure you typed the name correctly in your Manila prefs. Make sure the name matches the name of the database.