Backup of mySQL via cronjob

software development

#1

Hello colleagues,

I tried to install a cronjob with a short script to make a backup of the SQL-Database and sending me the data via e-mail.

I saw many different solutions in the net, but I did not make someting working correctly.

Please It would be very nice if someone could show me the way forward with a script and the entry in cronjob text area @ dreamhost.

my solution was for script
USERNAME=***
PASSWORD=***
DBHOST=mysql.imkeronline.com
DBNAMES=***
BACKUPDIR="/backups"
MAILCONTENT="files"
MAXATTSIZE=“4000"
MAILADDR=”***"
MDBNAMES=“mysql $DBNAMES"
DBEXCLUDE=”"
CREATE_DATABASE=yes
SEPDIR=yes

my solution for the call of cronjob @ dreamhost was:
/usr/local/bin/perl /home/MYUSER/imkeronline.com/crontest.pl

The file crontest.pl I uploaded via ftp with the script.

many thanks
imkeronline.com


#2

This will help.


si-blog | Keystone Websites
Save $97 on yearly plans with promo code [color=#CC0000]SCJESSEY97[/color]