-1
votes
2answers
144 views

mysqldump in cron not working [duplicate]

I am trying to do a mysqldump on the cron for every 5 minutes but it seems that it is not working. I try to execute the mysqldump and it works fine. mysqldump mysqldump -uroot -ppassword ...
1
vote
2answers
457 views

how to execute bash script with crontab in centos? [duplicate]

My bash file is not executed by cronjob created as root. The cronjob setup looks as it follows 0 0 * * * mysql_backup.sh does need to be decalared with the bash command 0 0 * * * bash ...
1
vote
0answers
192 views

mysqldump not working/running via cron job

I have a crontask which runs at 1am every morning and dumps all databases. 0 1 * * * /var/backups/dumpit.sh 2>&1>> /var/backups/dumpit.log The dumpit.sh source: #!/bin/bash ...
-3
votes
2answers
153 views

crontab -e on Red Hat 4.1.2-48 [closed]

The following command on crontab does not work at all. 0 12 * * * mysqldump -hserverhpost -uuser -ppass db > /path/to/backu/$(date +%d-%m-%Y) I read extensively about this and i cannot see what ...
0
votes
1answer
211 views

linux cron mysqldump: php exec() vs shell script vs direct command in crontab

The system is running CENTOS 5.8, Apache 2.2.3, MySQL 5.0.95, PHP 5.3.3 We run mysqldump daily for a few databases. It's run via a php script called in crontab. They are run at the same time and ...
1
vote
1answer
456 views

Using AutoMySQLBackup on Rackspace Cloud

Since Rackspace Cloud only allows FTP access it makes using AutoMySQLBackup a little trickier, and while it is at least creating DB dumps I get errors in the backup log: ###### WARNING ###### Errors ...
2
votes
2answers
870 views

How to dump a mysql database and transfer to remote ftp in one line -for crontab-?

I need to do a weekly backup of a mySQL table and then transfer it to a remote machine using ftp. This is the command I have now in crontab: 0 18 * * 1 /usr/bin/mysqldump --add-drop-table ...
0
votes
3answers
240 views

Cronjob to Backup Database every day at 10pm

I managed to setup a cronjob: * 13 * * * date=`date +\%d-\%m-\%Y-\%s`; mysqldump -u root -pPassword1 db121 > /home/backup/xbackup_$date.sql; gzip /home/backup/xbackup_$date.sql I am hoping the ...
0
votes
3answers
988 views

Making a simple MySQL backup script to be run via cron, having permissions issues

This is a very basic mysqldump script that will do a dump and store it locally. Running mysqldump by itself works fine as does gzip (i.e. they are where they need to be in my path) ...
1
vote
1answer
767 views

MySQL equivalent to .pgpass, or automatic authentication in a cron job for mySQL

I'm writing a bash script to back up my databases. Most are postgresql, and in postgres there's a way to avoid having to authenticate by creating a ~/.pgpass file which contains the postgres password. ...