Question about mysql backups

Portal Home > Knowledgebase > Articles Database > Question about mysql backups

Posted by jpilon, 12-12-2008, 06:59 PM
Question about mysql backups Hello, I have a dedicated server, linux centos, and currently I have a php script I wrote to do mysql backups every night using mysqldump (loops through all databases on the server, zips them up and ftp's them to my backup server). The databases are starting to get very big and as such doing more stress on the server. I have restored large databases before and it doesn't always work very good. Does anyone know of a better method of backing up all databases on a server? Ideally I'd like to be able to zip a folder containing all the databases so restoring them is as simple as unziping and overwriting the existing databases. Is this possible? Anyone have any tips?
Posted by ThatScriptGuy, 12-12-2008, 08:13 PM
mysqlhotcopy? __________________ Kevin CacklerThat Script Guy, LLC (501) 358-4064
Posted by jpilon, 12-12-2008, 08:28 PM
I think that just might be what I was looking for. Thanks!
Posted by stardot, 12-21-2008, 02:07 PM
I've used "automysqlbackup" and it works phenomenally -- it automatically keeps daily, monthly and weekly backups unless otherwise configured. Its a free shell script, just google it and you'll find it very easily.

Add to Favourites Print this Article