Clean up the DB file, leave only products, categories etc.

Hello,

on my old shop I had a custom theme, which had about 1000 products, 35 categories, 30 filters.

Now I need to transfer it to new shop with default theme.

Simple backup and then import is not working, as it shows that "the file is empty".

Also, phpmyadmin sql export and import also not working as it says "truncate .. tables".

It looks that custom theme used some DB strings, like megamenu etc.

So: is there a way to export ONLY products, categories and filters , leaving all other behind?

Hi!

Did you try the custom export method and didn't work?

Try with this steps:

Click on your database on the left side (so you'll see all the tables on the right side)
Press Export on top center

Then start the export process:

Export Method: Custom
Tables: Select the ones you need, product, product_attribute,product_description, etc...
Output: As it is by default
Format:SQL
Format specific options: Just select the radio button that says "data"
Data creation options: Leave as it is

Then export and check the file with notepad++ or similar.

You should have all the "INSERT INTO" statements to insert all the info in each table.

If the new database has the same table name and structure it should work.
If the name of the table changed, just edit the table name after the "INSERT INTO"
If you see that the old database had more columns (because of an extension for example) use the notepad delete the table columns before the VALUES statement and the values of each line...
Or maybe create the missing columns in the new database, then dump the data and finally remove the columns not needed...

That's what I would do... maybe there are better options... don't know...

Regards!

It helped, thanks so much!