Database Backup Script
$30-75 USD
Paid on delivery
Purpose is to automatically **backup** multiple **MySQL** databases, using mysqldump utility. Script should be able to be invoked from command line, via either cron job on Unix-based platform, **or** scheduled task on Windows Platform. List of databases would be based on a MySQL database query.
## Deliverables
Software should be written in Perl, and able to run on Windows or Unix-based server environment.
Script shall be invoked from the command line as scheduled (via “cron?? on a Unix platform or “Scheduled Tasks?? on a Windows platform). Script shall access a database table using Perl “DBI?? module to gather list of active project IDs. Each project ID will occupy one column of a row in the result of a SQL select statement. Vendor may assume that MySQL server will have a database named by each listed project. Script shall call “mysqldump?? utility via command line or shell, to sequentially (not concurrently) backup each active project database to a single specific path on disk generated by a user-configurable function, including table creation statements, but without comments in output. Upon successful completion of each “mysqldump?? command, script should update (not inject) specific database table with applicable project ID and current timestamp. If “mysqldump?? command returns an error or fails, script should append pertinent information to an error log file on disk, including project ID, current timestamp, and any error output produced by “mysqldump?? utility.
The following parameters shall be easily configurable:
- File path generation function ??" will accept one argument, a project ID string, and will return an absolute file path, in the form of a string.
- File path of error log.
- Database authentication parameters for getting active project IDs and logging success (host, user, pass, database name, table name)
Project ID: #3700258