Cancelled

Perl to run mysqldump

This is a Perl job.

I just need a Perl script that backs up MySQL databases using mysqldump. I will run it from CRON.

It needs these editable settings (variables within the script):

- MySQL host.

- MySQL user name.

- MySQL user password.

- Databases to exclude.

- Backup location (a directory on the system).

- Compression (Y/N).

It needs to do this:

- Back up all tables of all databases except those databases that are excluded.

- Create a master backup directory named using the current date/time in this format: YYYY_MM_DD_HH_MM.

- Create a backup directory for each database. Name it the same as the database. Put it into the master directory.

- Create a dump file for each table. Text file should contain structure and data. Name each dump file the same as the name of the table. Put all dump files for each database into the backup directory created for that database.

- Create a gzip archive of the master directory if compression = Y.

- Move the master directory or archive to the backup location.

- Clean up temp files. The only think left should be the file/directory placed into the backup directory.

That’s it.

The server is LAMP.

Skills: Perl

See more: perl mysqldump, run mysqldump perl, mysqldump perl, run, gzip, data compression, compression, backup job, lamp database, script gzip, editable mysql, perl script file, mysql backup table, table perl, perl table, create backup script cron, dump create database, mysql clean data, archive system, perl backup database, lamp server backup script, clean text file, perl mysql dump, move files archive, perl file format

About the Employer:
( 88 reviews ) Durham, United States

Project ID: #195763

13 freelancers are bidding on average $45 for this job

gangabass

I can do this job for you. See PM for details.

$60 USD in 2 days
(136 Reviews)
5.8
marchent

ls check PMB

$50 USD in 1 day
(21 Reviews)
4.6
Georgia

I am interested.

$100 USD in 5 days
(2 Reviews)
2.7
lbosque

Hi, please check my PM.

$45 USD in 1 day
(2 Reviews)
2.5
kit1980

Please check PM

$30 USD in 1 day
(2 Reviews)
1.6
perou

Please see PMB.

$40 USD in 1 day
(1 Review)
1.6
blackcoffee

Hello. Please, check PMB.

$35 USD in 1 day
(1 Review)
1.0
propanoid

Please, check PM.

$50 USD in 1 day
(0 Reviews)
0.0
jkarthik

please let me know your id for contact.

$30 USD in 1 day
(0 Reviews)
0.0
rickumali

Good luck with the bidding process!

$60 USD in 2 days
(0 Reviews)
0.0
darkv0id

Please, check PM. =)

$30 USD in 2 days
(0 Reviews)
0.0
VitalkaDrug

I am ready to work. But I think in this case enougth to use the shell (bash, ash, etc.), not Perl. It is not so resource-intensive.

$30 USD in 1 day
(0 Reviews)
2.0
linuxtechguru

I can do this within minimum period of time

$30 USD in 1 day
(0 Reviews)
0.0