Re: [Carrie] Migrating a CMS Builder site
Carrie -
Sounds like you may have this figured out, but here is a tutorial for anyone else with this predicament.
Install CMS Builder in the new location as normal, creating a database and running through the setup.
1. Open the old CMS database in PHPMyAdmin
2. Click on the export tab
3. On the left side make sure all tables are selected and SQL is selected
4. Under "Structure" make sure the following is checked:
Add DROP TABLE / VIEW / PROCEDURE / FUNCTION
Add IF NOT EXISTS
Add AUTO_INCREMENT value
Enclose table and field names with backquotes
Add CREATE PROCEDURE / FUNCTION
5. Check "Save as file" and click go
6. It should ask you to save an sql file - click save
7. Open the new CMS database in PHPMyAdmin
8. Click "Import" and then select the sql file you saved earlier - then click go.
This should move all of your tables over.
As for moving the content, you'll have to move the code over to your new template manually.
You will have to change the settings in your new CMS to point to the new domain name of course so images will transfer over and such.
You can also make a "pre-configured" copy of CMSB with all of your extra stuff and install it to each site as well. Most of the files you will want to configure are in the "data" folder - such as schemas and schemaPresets and settings.dat.php
You can also use Package Foundry to make an automated installer that will do much of the work for you on the content, program installation, and program setup. http://www.ioncube.com/ipf/
If you are going to to be doing this quite a bit, you may want to consider it. We have about 75 active installations of CMSB and many more planned, so using Package Foundry has helped a lot - especially with upgrades.
Hope that helps you out - let me know if I need to fill in any gaps.
Kenny