Importing only certain tables of a backed up database

[CandleMan]

I am wondering is it possible to only import certain tables from a previously backed up database?
If it is, can someone explain how, or point me in the right direction please?
I cannot find anything from searching, except a complete backup.

[mprough]

I am wondering is it possible to only import certain tables from a previously backed up database?
If it is, can someone explain how, or point me in the right direction please?
I cannot find anything from searching, except a complete backup.

If you have done this https://www.zen-cart.com/tutorials/i...hp?article=103 to create a dump, then in phpMyadmin you can drop just the tables from your dump in that you wish.

You will also find this helpful https://www.zen-cart.com/tutorials/i...hp?article=100

~Melanie

[CandleMan]

So if I dump the tables I want to overwrite, then when I import, it will only overwrite the "Dumped" tables yes?

[mprough]

You will open the dump (backup) you created in a text editor like PSPad and the copy the tables a few at a time and paste them in the SQL window in phpMyAdmin to overwrite.

~Melanie

[CandleMan]

Is there a list anywhere or maybe instructions so I can import certain things.

Ie, to import existing customers and their orders which tables do I import?

To import existing categories and products which tables do I import?

[awhfy99]

You will open the dump (backup) you created in a text editor like PSPad and the copy the tables a few at a time and paste them in the SQL window in phpMyAdmin to overwrite.

~Melanie

Is there a simple way to convert that data to a patch that can be inserted via the admin? Like maybe remove any db name reference? I was thinking of trying that scenerio of adding users from one to another db. My guess would be the zen_customer_info, the zen_customer and maybe the zen_address_book as well might do it. I have yet to try this on a test site but will try it soon. Any suggestions or hints are appreciated.

[DrByte]

Database Table reference: http://www.zen-cart.com/wiki/index.p...rdered_by_Data

[awhfy99]

Database Table reference: http://www.zen-cart.com/wiki/index.p...rdered_by_Data

Thanks, that confirmed my quess. I tried it and it worked great I copied two users from one test site to the second one. Everything AOK, including the address books. On a live site I would need to add the 4th insert as well, don't want to omit any group assignments.