Migrating a CMS Builder site

Hi Carrie

Thanks for the email!

We aren't really experts with phpMyAdmin so a walk through for using that wouldn't be something I can help out with too much.

Is there anyone else in the community that can help out here?

If both your new and old web servers allow external connections to your database, we could probably look at this through consulting for you.

Let me know what you think :).

Hi Carrie,

Do you need to move over the "records" in the database, or just the structure of the site (meaning the templates and the sections and field settings, etc)?

If you're selling pre-configured websites and just need to move the "setup" of it and the end user will enter the data then that's much simpler. Let me know and I can help you either way.

Hi Carrie,

Do you need to move over the "records" in the database, or just the structure of the site (meaning the templates and the sections and field settings, etc)?

If you're selling pre-configured websites and just need to move the "setup" of it and the end user will enter the data then that's much simpler. Let me know and I can help you either way.

Thanks guys for your fast response!

We want to be able to move the structure AND the content. Yes, that's the aim - to sell pre-configured websites with "value-added" content for specific niche markets (e.g. legal).

We have had some luck with exporting the SQL database and re-importing it as well as copying and uploading the CMS files, although we noted today that the paths for the migrated images still point to the old site. Any more tips or ideas would be welcomed.

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

Hey Kenny,

Thanks for the tutorial.

Package Foundry sounds great - I had a quick look at this. Is it easy to configure, or would you guys be able to help with the config at a later stage? We will be doing this alot, so anything that can save us time means we can build more websites in a shorter time frame.

Carrie

We did the steps described but when we log into the Admin, no pages come up.

The database after the move looks correct.

Thanks,

Chris B.

OK...

After a few minutes of digging, we figured it out.

We needed to upload the schemas and change the 1st line of code to each page - require_once "/usr/home/OurNewWebsiteFolder/www/htdocs/cmsAdmin/lib/viewer_functions.php";

Thanks,

Chris B.

Hi, Like Chris B my database is all looking OK after the transfer but I am getting this error which links to what Chris said above:

Fatal error: main() [function.require]: Failed opening required '/home/Donylanduk/public_html/cmsAdmin/lib/viewer_functions.php' (include_path='.:/usr/lib/php') in /homepages/31/d271660971/htdocs/Donylanduk/cmsb/welcome.php on line 3

I've tried what he suggested but I get the same error just with the updated path. Any ideas what I need to change?

This is what I had before the move:
require_once "/home/Donylanduk/public_html/cmsAdmin/lib/viewer_functions.php";

Thanks!
Hannah