Tagged Questions
1
vote
2answers
44 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 ...
0
votes
1answer
94 views
mysqldump asking for password even after telling it the password in the command line option
I am using the following command:
mysqldump -alv -h 123.123.123.123 --password=P@ssw0rd --user=UsernameHere --add-drop-table -p DatabaseSchemaName > dump.sql
Then it asks me to Enter Password. ...
0
votes
3answers
215 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
713 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
4answers
303 views
Shell MySQL Backups - What's your solution?
I'm looking for a great solution to backup my MySQL databases - all of them. I'd like each one in at least it's own file. I need FTP ability later, but not right now. Right now I just need it to ...
1
vote
1answer
600 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. ...
