[andes1]

Sometimes we want to transfer the catalog of products from one store to another new or modified store, without make modifications on excel and so on.
We only seek a clean transfer of information, well…
Here we have an easy way to achieve this purpose
On PhpMyAdmin choose the tab export; after that you should see something like the picture below First select: categories categories_description products products_attributes products_attributes_download products_description products_notifications products_options products_options_products products_options_values products_options_values_to_products_options products_to_categories Next, chose the fallowing options: sql Structure: Add DROP TABLE Add IF NOT EXISTS Add AUTO_INCREMENT value Enclose table and field names with backquotes export type : insert “from the menu”. Select save as a file; give a name to the table, i.e. fer__DB__products select Compression none. This should looks like: [img]http://www.latinrebels.net/cosas-varias/images_ayuda_sql_guia/2.gifSave on your hard drive. Now the next part is to place the saved data on your new or heavy modified store. 1. Select the new store’s database 2. Then, select the tab SQL. 3. Now, upload the database file that you save in your hard drive, (select auto detect) and click on Go. [img]http://www.latinrebels.net/cosas-varias/images_ayuda_sql_guia/3.gif
4. Check your store and admin.

That is all…. Easy.
You can do the same with whatever table as you want i.e. Customers.

[andes1]

sorry the first and second picture should be swichet respectively

[axioma]

nice and easy... thanks

[solucionesmipc]

i would suggest to make an entire backup in admin tools

Diego Ruales
Cali- Colombia

[andes1]

solucionesmipc, on Aug 14 2006, 10:42 PM, said:

i would suggest to make an entire backup in admin tools

Diego Ruales
Cali- Colombia

but, doing so, you will overwrite al the new DB setup and information of your new site.... not only changing the produts and attributes information