Importing database to CMSB

Hi John,

Just to confirm, you are talking about exporting/importing a CMS Builder database correct?

Most hosts will have tutorials or at least links to tutorials on how to export and import databases.

If the host has phpMyAdmin installed, you basically login, select the database from a dropdown list, then select the Export tab. Choose all the tables within the database and CSV for the format.

When importing the database, you select Import then Browse for the database file.

If you are exporting and importing a CMS Builder database, keep in mind that file paths will be different from server to server so some file path updates will need to be made. When you get to this step, I can provide more details.

Hey Damon,

Thanks for the reply. I received the CSV file from the company that was handling my clients website before. I imported the database in phpMyAdmin, but recieved this error when importing.....

Error

SQL query:

"1";

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near '"1"' at line 1

This is the first time ever importing anything into a database, and I'm very new to the whole database thing anyway. Could you point me in the right direction. Thanks for any help you can provide. I can send you the CSV file if needed. Just let me know. Thanks again

John

Hi John

Thanks for the update!

This is going to be more than we can handle through the support forums. This would probably something we can help out with through our consulting service though.

Drop me a line (consulting@interactivetools.com) and we'll go over the options from there.

Thanks!

Thanks for the info Kenny, I'll have a look at it this evening.

John