Backing up and restoring 500mb MySQL database anyone?

Soldato
Joined
30 Jul 2005
Posts
2,974
Location
Bristol
I have a webserver with a mysql database thats around 500mb that i need to restore onto a new mysql server.

Im having a mare of a time doing it however.

I've tried multiple backup types but whenever i restore it always get stuck on a table and doesn't restore any tables beyond this one. I have tried backing up tables after this problematic one however the restore always seems to try and restore all of them.

Im a bit of a MySQL noob so looking for any help to solve this problem.
 
Back
Top Bottom