Missing product variations after site migration

[Dropshipper101]

Dear dropshippers,

based on the high CPU usage issue I’ve been experiencing along with other people using AliDropship Woo Plugin I decided to move my site to a new VPS. So, we’ve copied the whole site 1:1 to the new server. However, after the migration it turned out that the product variations are missing.

Do you know what the reason might be? Are product variations stored in the same database? Is there a way to turn-on/turn-off the product variations displaying?

Thank you for your kind help.

Robert

 

[Direct Webstore]

Are product variations stored in the same database?

All product info is stored in the database. It probably got corrupted if you downloaded it in plain txt/sql format.

It's best to download and upload the database in zipped or gzipped format to avoid that. Did you do that?

If your database is still on the old server ... download it again in zipped form, drop all your tables on the new server, and re-import the fresh zipped one.

If none of that applies ... you'll just have to delete the affected products, empty the product trash and re-import the products again.

 

[Dropshipper101]

Hey @Direct Webstore, thank you for your response. Moving a 1GB+ database has been bit of a trick, but it seems that the database was corrupted indeed. I should know by tomorrow exactly. I’ll update.

 

[Direct Webstore]

Moving a 1GB+ database has been bit of a trick,

A 1 GB database! Wow! There's a neat little free program called SQL Dump Splitter that can split big databases up into smaller pieces for uploading. Maybe you could try that next time ... https://sqldumpsplitter.net/

 

[alexmorco]

Depends on the files, There would be some missing files like a repository where the products are saved. You can check this guide to learn more about properly moving the Website to a new host including products. https://www.cloudways.com/blog/migrate-wordpress-to-another-host/

 

[Direct Webstore]

Depends on the files, There would be some missing files like a repository where the products are saved. You can check this guide to learn more about properly moving the Website to a new host including products. https://www.cloudways.com/blog/migrate-wordpress-to-another-host/

Pretty sure, after a year and a half, he no longer has the problem. LOL