No replies to this topic

[Daemonj]

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.