[SOLVED] How to import only category structure from database backup into fresh installation?

[xEpyonx]

Hi,

 

I goofed and deleted my prestashop installation files (I seriously have no idea what was going on in my mind when I did this) and I don't have a backup. Since I was still working on it, it won't take long to set it up again except the comprehensive category structure I had already made.

 

I DO have a complete database backup in .sql format though, but I just need to import the category structure and category descriptions into the clean install. How do I do this? I have no knowledge of building the proper sql queries to do this or if it's even possible...

 

Help would be very much appreciated!

Edited November 2, 2013 by xEpyonx (see edit history)

[vekia]

you will need to import:

- ps_category

- ps_category_lang

- ps_category_group

- ps_category_shop

[xEpyonx]

How can I select only those tables to import from my old sql db backup? When I'm in phpmyadmin I can only figure out how to import the whole db, which I tried, but prestashop breaks if I do that on a fresh install. That's why I only want to do the categories...

[vekia]

if i were you i will create temporary database, import whole data - and then - export only tables mentioned above.

then just import exported tables

[xEpyonx]

Are you Spock? Because the logic is strong with you!

 

Thanks, I'll try that!

[xEpyonx]

Thanks Vekia, it worked and you saved me a ton of work!

[vekia]

glad to hear that i could help you in this case

thank you for confirmation

 

with regards,

Milos