Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Moving your store


Daemonj

Recommended Posts

Posted

If you need to move your store to another database (because you have decided to install the latest cvs version to gain the new functionality), do the following in PHPMyAdmin.

 

At your old domain:

1. Open PHPMyAdmin, select the database, and click the export tab. 

2. Select the following tables: 

   categories 

   categories_description 

   manufacturers 

   manufacturers_info 

   products 

   products_attributes 

   products_attributes_download 

   products_description 

   products_notifications 

   products_options 

   products_options_values 

   products_options_values_to_products_options 

   products_to_categories 

   reviews

   reviews_descriptions

   specials

3. Select data only 

4. Select complete inserts 

5. If you have the option, select to save as file and save it to your hard drive.

Then at your new domain:

1. Open PHPMyAdmin, select the database, and click the sql tab. 

2. Copy the insert statements that I provided earlier in this topic and click ok. 

3. Click the browse button and select the file that you saved of your data and click ok. 

4. Click the database name in the left-hand column to get the table list in the right-hand pane of the screen. 

5. Click the select all link and select optimize from the drop-down and say ok.

Now you just have to go through the Admin panel and set your settings.

"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

Archived

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

×
×
  • Create New...