Database Backup Script

Closed Posted Feb 7, 2008 Paid on delivery
Closed 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)

Engineering Linux Microsoft MySQL PHP Software Architecture Software Testing UNIX Windows Desktop

Project ID: #3700258

About the project

10 proposals Remote project Active Feb 29, 2008

10 freelancers are bidding on average $52 for this job

marchent

See private message.

$63.75 USD in 14 days
(169 Reviews)
6.3
vsespb

See private message.

$29.75 USD in 14 days
(100 Reviews)
6.1
watsysgroupvw

See private message.

$63.75 USD in 14 days
(49 Reviews)
5.8
tvsvw

See private message.

$63.75 USD in 14 days
(53 Reviews)
5.1
jjc1138

See private message.

$63.75 USD in 14 days
(42 Reviews)
5.0
Voldemarus

See private message.

$51 USD in 14 days
(18 Reviews)
4.5
jovino

See private message.

$34 USD in 14 days
(6 Reviews)
3.1
nightmare2u

See private message.

$63.75 USD in 14 days
(9 Reviews)
2.6
completework

See private message.

$42.5 USD in 14 days
(14 Reviews)
0.0
xmOe

See private message.

$42.5 USD in 14 days
(0 Reviews)
0.0