Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MYSQL- tranfering data from one server to another


Anton_FA

Recommended Posts

Assuming you have access to phpmyadmin on each server.

 

Select the database on your old server and select the export tab on the top. When the export box comes up, select all tables (data and structure). Then, check the Add 'drop table' and save as file check boxes. This will not damage your database in any way. It will export (dump) your database into a file which should be downloaded automatically to your computer. This file will be named xxx.sql where xxx is your database name.

 

Then go to your new server. Create a new database in phpmyadmin. Select the SQL tab from the top menu. Click on the browse button and select the new dump file you created. Click the GO button and the old database will automagically be dumped into your new database.

 

Hope this helps. Backup any and all data that is important before doing this.

 

God Bless,

 

Russell

"On the plains of hesitation lie the blackened bones of countless millions who at the dawn of victory lay down to rest, and in resting died." -A. Stevenson

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...