Migration to new server – WP-eStore

[jelsom]

Hi,

I have recently moved away from a windows server to a LAMP solution.

I copied all of my clients site files over and also I exported the MySQL DB and then imported it onto the new server. I have wordpress running fine with the plugins installed and activated and a good connection to the MySQL DB.All is working well on the site. The only issue i have since the migration is that i cannot see any of the data – products, customers, sales etc within the dashboard. From looking at the MySQL db tables i can see all the information there – its just not being pulled into the dashboard. any ideas!?

Thanks for any help anyone can provide

[admin]

Usually this issue happens when the database tables names do not match. eStore will expect the table names to be like the following (CASE SENSITIVE):

wp_eStore_tbl

wp_eStore_customer_tbl

wp_eStore_coupon_tbl

......

So make sure the table names in your MySQL database on the new site exactly match the ones it is expecting.

The following posts should also be very helpful for you:

https://support.tipsandtricks-hq.com/forums/topic/migrating-db-from-windows-server-to-linux-server-loses-products-and-categories

The following post should be useful too:

https://www.tipsandtricks-hq.com/move-your-wordpress-blog-to-a-new-host-5279

[jelsom]

Thanks so much for this – it worked!

Would i also need to do the same for eMember and the other plugins would you think?

Thanks again for your help!

[admin]

First check and see if the same issue is present for the others. If it is then apply the same solution.

[Author]

Posts