eStore: Importing db from localhost to live

[JanArve]

Hi,

I exported the database from my localhost and imported it into online site today, but for some reason the products will not show in “Manage Products” (categories also won’t show).

The entries for both products and categories are imported and present in the database, just doesn’t want to display in wordpress admin.

I tried exporting and importing these combinations:

All tables – No products or categories display.

All tables except wp_options, wp_users and wp_usermeta – No products or categories display.

Is there any relationship check (like what user added the product) or any other check that is performed somewhere that could prevent the admin panel to display the products in the db?

[wzp]

Did you follow this procedure?

https://www.tipsandtricks-hq.com/how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin-3415

Is there any relationship check (like what user added the product) or any other check that is performed somewhere that could prevent the admin panel to display the products in the db?

Product & Catagory ID use the database index numbers. You cannot “append” imported data to an existing database.

[admin]

Is your eStore database tables names EXACTLY the same in your localhost and live site?

Check if one uses uppercase “S” and the other doesn’t. If it doesn’t match then it will look for a wrong table and see the entries.

[JanArve]

Thanks for getting back to me.

Yeah the problem was indeed the uppercase S. local mysql lowercased the table names.

Thank you.

[Author]

Posts