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?
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?