Database Backup Script

Cerrado Publicado Feb 7, 2008 Pagado a la entrega
Cerrado Pagado a la entrega

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)

Ingeniería Linux Microsoft MySQL PHP Arquitectura de software Verificación de software UNIX Windows Desktop

Nº del proyecto: #3700258

Sobre el proyecto

10 propuestas Proyecto remoto Activo Feb 29, 2008

10 freelancers están ofertando un promedio de $52 por este trabajo

marchent

See private message.

$63.75 USD en 14 días
(169 comentarios)
6.3
vsespb

See private message.

$29.75 USD en 14 días
(100 comentarios)
6.1
watsysgroupvw

See private message.

$63.75 USD en 14 días
(49 comentarios)
5.8
tvsvw

See private message.

$63.75 USD en 14 días
(53 comentarios)
5.1
jjc1138

See private message.

$63.75 USD en 14 días
(42 comentarios)
5.0
Voldemarus

See private message.

$51 USD en 14 días
(18 comentarios)
4.5
jovino

See private message.

$34 USD en 14 días
(6 comentarios)
3.1
nightmare2u

See private message.

$63.75 USD en 14 días
(9 comentarios)
2.6
completework

See private message.

$42.5 USD en 14 días
(14 comentarios)
0.0
xmOe

See private message.

$42.5 USD en 14 días
(0 comentarios)
0.0