Issue DB Backup/restore issue

[Johan]

We are running a large WooCommerce webshop, some of our MySQL contents are quite huge.
At this moment the DB is around 600mb.
When export/copy the DB, a lot of content disappears, we notices this when we ran a copy of our webshop and noticed that some content was not in the copy version. Because of this issue we unfortunately lost some stuff that we had to re-do.
Is there a reason why this happens and is there a way to prevent this from happening?

Server: VPS running with 8 cores & 16gb on ram
This is the only webshop/website running on this vps.

 

[Ales]

While exporting and importing such large databases through the GUI is something that can be investigated further, I'd advise using mysqldump and mysql in the shell instead.

Exporting and importing databases using these tools is relatively simple and should provide you with more control.