Post by coldrex » Wed Jun 29, 2016 4:34 pm


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?

User avatar
New member


Thu Jun 07, 2012 10:05 pm

Post by Richardorl » Thu Jun 30, 2016 1:07 am


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 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...




Mon Jun 06, 2016 4:08 pm

Post by coldrex » Thu Jun 30, 2016 4:27 pm

It helped, thanks so much!

User avatar
New member


Thu Jun 07, 2012 10:05 pm
Who is online

Users browsing this forum: No registered users and 7 guests