31,029
edits
Backups: Difference between revisions
Jump to navigation
Jump to search
m
→Using mysqldump
| Line 87: | Line 87: | ||
'''Example:''' | '''Example:''' | ||
With Linux, to make a regular backup at 1:30 each day into file mysqldump_databasename_DD.sql, you can add this into your cron file: | With Linux, to make a regular backup at 1:30 each day into file mysqldump_databasename_DD.sql.bz2, you can add this into your cron file: | ||
<source lang="bash"> | <source lang="bash"> | ||
30 1 * * * mysqldump databasename -h host -u user -pyourpass -l --single-transaction -K --add-drop-table=TRUE --tables -c -e --hex-blob --default-character-set=utf8 | bzip2 > mysqldump_databasename_`date +%d`.sql.bz2 | 30 1 * * * mysqldump databasename -h host -u user -pyourpass -l --single-transaction -K --add-drop-table=TRUE --tables -c -e --hex-blob --default-character-set=utf8 | bzip2 > mysqldump_databasename_`date +%d`.sql.bz2 | ||