cron job - command to backup a database ?

[king007]

What is the cron command to backup a mysql database, daily either by emailing the database to me or backing it up on the webserver ?

[trich]

Check out mysqldump. Use something like:

mysqldump --opt (DB_NAME) -u (DB_USERNAME) -p(DB_PASSWORD) > /path/to/dbbackup.sql

Notice no space after -p.

[Shinichi Kato]

Check out mysqldump. Use something like:

mysqldump --opt (DB_NAME) -u (DB_USERNAME) -p(DB_PASSWORD) > /path/to/dbbackup.sql

Notice no space after -p.

Or

0 0 * * * mysqldump --opt (DB_NAME) -u (DB_USERNAME) -p(DB_PASSWORD) > DB_NAME-$(date +%m%d%Y).sql

[jalal]

Or

0 0 * * * mysqldump --opt (DB_NAME) -u (DB_USERNAME) -p(DB_PASSWORD) > DB_NAME-$(date +%m%d%Y).sql

It is better to put in the path for the binary, so better would be:

0 0 * * * /usr/bin/mysqldump --opt (DB_NAME) -u (DB_USERNAME) -p(DB_PASSWORD) > DB_NAME-$(date +%m%d%Y).sql

[Shinichi Kato]

It is better to put in the path for the binary, so better would be:

0 0 * * * /usr/bin/mysqldump --opt (DB_NAME) -u (DB_USERNAME) -p(DB_PASSWORD) > DB_NAME-$(date +%m%d%Y).sql

So, yes.