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

John,

You can also use this tool as well if you have some knowledge of mysql files.

CSV to MySQL
http://www.sqldbu.com/eng/sections/tips/mysqlimport.html

It will generate a file for you to import (or paste in the sql box)

Again, you will have to have a small bit knowledge of what you are looking at to get it to import right.

Kenny

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

John