MySQL Back-Up

[mozsumo]

I am trying to back up my databases on MySQL via PHPMyAdmin. I am using the export feature, but after 20 minutes or so, I got:

The connection to the server was reset while the page was loading...

How can I get the export to work? I really need a backup ASAP. (i am on a deadline, sort of)

 

[garrettroyce]

Is your database extremely large? If so, you may want to consider breaking up the backups into smaller pieces.

 

[mozsumo]

Is your database extremely large? If so, you may want to consider breaking up the backups into smaller pieces.

It is pretty huge. I will try that, thanks.

 

[garrettroyce]

If that doesn't work out, I have seen ways to work with extending timeouts, but I don't think they will work on X10. There's also an issue with trying to keep a connection alive for 20 minutes, that's just an extremely long time to not expect the server to have to kill the connection.

I found this script. You have to be a member of PHP classes, but they're a pretty trustworthy site. I've been a member for a while, they only send me an email maybe once a month and no spam.

http://www.phpclasses.org/browse/package/4017.html