Importing database to CMSB

6 posts by 4 authors in: Forums > CMS Builder
Last Post: June 10, 2009   (RSS)

By blind2uriz - May 12, 2009

Hey guys, I am taking over a website for a client. I have redesigned the site and need to get the database information that is already on the web. What is the best way to go about this? I am about to contact the current web designer who said he would give me any help. What I should ask him to do? What is the best way to go about this? As in exporting/importing the database, things of that nature. Thanks for any help.

John
John C. Morris
Interdimensional Designs
www.covdesigns.com

Re: [blind2uriz] Importing database to CMSB

By Damon - May 12, 2009

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.
Cheers,
Damon Edis - interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Damon] Importing database to CMSB

By blind2uriz - June 8, 2009

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 C. Morris
Interdimensional Designs
www.covdesigns.com

Re: [blind2uriz] Importing database to CMSB

By ross - June 9, 2009

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!
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/

Re: [blind2uriz] Importing database to CMSB

By Kenny - June 10, 2009 - edited: June 11, 2009

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