Backing up and restoring 500mb MySQL database anyone?

CraigN · 16 Feb 2011 at 10:48

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.

MossyUK · 16 Feb 2011 at 11:06

Are you doing it using a tool like phpmyadmin? These tend to bomb out on big tables.

Either do it from your ssh shell or get your host to do it - a cmd line dump basically. It's much quicker and reliable.

mysqldump is the cmd I believe. I have done this but only relatively infrequently. I feel your pain.

MikeHiow · 16 Feb 2011 at 11:16

Do you have root access to each server?

daz · 16 Feb 2011 at 11:18

You don't need root, just command line mysql and mysqldump.

MikeHiow · 16 Feb 2011 at 11:25

daz said:
You don't need root, just command line mysql and mysqldump.

What makes you think my question had anything to do with mysqldump?