https://interactivetools.com/forum/forum-posts.php?Importing-database-to-CMSB-70034 Mon, 20 Apr 2026 12:25:31 -0700 en-us https://interactivetools.com/forum/forum-posts.php?postNum=2197710#post2197710
John
]]> Wed, 10 Jun 2009 12:30:08 -0700 forum-posts.php?postNum=2197710#post2197710 https://interactivetools.com/forum/forum-posts.php?postNum=2197706#post2197706
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
]]> Wed, 10 Jun 2009 09:34:45 -0700 forum-posts.php?postNum=2197706#post2197706 https://interactivetools.com/forum/forum-posts.php?postNum=2197699#post2197699
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!
]]> Tue, 09 Jun 2009 11:53:50 -0700 forum-posts.php?postNum=2197699#post2197699 https://interactivetools.com/forum/forum-posts.php?postNum=2197695#post2197695
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
]]> Mon, 08 Jun 2009 19:03:11 -0700 forum-posts.php?postNum=2197695#post2197695 https://interactivetools.com/forum/forum-posts.php?postNum=2197317#post2197317
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.
]]> Tue, 12 May 2009 15:10:07 -0700 forum-posts.php?postNum=2197317#post2197317 https://interactivetools.com/forum/forum-posts.php?postNum=2197312#post2197312
John
]]> Tue, 12 May 2009 11:36:04 -0700 forum-posts.php?postNum=2197312#post2197312