Daemonj Posted May 18, 2003 Posted May 18, 2003 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.