MySQL Backup - a Perl script (the script) that uses mysqlshow to "capture" of database names, types and names of the tables available to the user, and then runs the mysqldump to save data in the folder specified in the script. The script then archives the files (using tar and gzip), specifying the date and time as the file name.
The script can be run daily on a schedule using cron. It removes old files and can send gzip files via e-mail to the administrator and / or via FTP to a remote server. The script has the ability to "select data to display or selection of data for users who can not use mysqldump.
It can work with a long list of databases and tables.
Subscribe to:
Post Comments (Atom)
0 Comments:
Post a Comment