How to transfer a database?

[boostanddestroy]

Hello, I am trying to transfer the database on one of oscommerce stores to another that i just created. Is there any easy way to do this?

 

Is there a way to just an FTP client to transfer the database etc?

 

Thank you

 

 

-Chisholm

[FIMBLE]

The easiest way would be to export the database using phpmyadmin, then once the database has been created on the new account or server simply upload it using phpmyadmin.

Nic

[rescuestat]

Hello, I am trying to transfer the database on one of oscommerce stores to another that i just created. Is there any easy way to do this?

 

Is there a way to just an FTP client to transfer the database etc?

 

Thank you

 

 

-Chisholm

Hi Chisholm,

 

Unfortunitely MySQL databases are not the same as, say a Access database or Excel spreadsheet - meaning that can not be copied in a straight forward manner.

 

The easiest way to transfer your MySQL database is to use phpmyadmin if you have access to it on your server. You will want to 'export' the database you want to copy using full MySQL statements into a file. You then use this file to 'import' into the new database. This can be a very daunting process it you are not famaliar with MySQL, but once you are used to it it becomes second hat.

 

A fairly good tutorial with just an overview of the export/import process can be found at:

http://www.siteground.com/tutorials/php-my...ysql_export.htm

 

Hope this helps,

Frank

[boostanddestroy]

Great! Thank you for your help!

[boostanddestroy]

Hello, I just went to import the data base " products_description" and I just got this error.

 

#1054 - Unknown column 'products_seo_url' in 'field list'

 

How do I fix this?

 

Thank you!