Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database transfer / copy to another site?


Qacer

Recommended Posts

At the server with the data, in PHPMyAdmin, select the export tab, select the tables listed below, select structure and data, drop table, complete inserts, extended inserts.

 

If you have the option to save to file then do so otherwise say ok and save the resulting file.

 

Regardless, name the file db_backup.sql

 

Then at the new server, in PHPMyAdmin, select the SQL tab, click the browse button, select the db_backup.sql file and that should do it.

 

Tables to Export.

categories

categories_description

manufacturers

manufacturers_info

products

products_attributes

products_attributes_download

products_description

products_options

products_options_values

products_options_values_to_products_options

products_to_categories

reviews

reviews_description

specials

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...