Mysqldump: Difference between revisions
From Freephile Wiki
Created page with "quick recipe on using mysqldump == Backup == <source lang="bash"> DB=wiki backupdir="$HOME/backups"; if [ ! -d "$backupdir" ]; then mkdir -p $backupdir; fi backup="$backupd..." |
adds date |
||
| Line 8: | Line 8: | ||
mkdir -p $backupdir; | mkdir -p $backupdir; | ||
fi | fi | ||
backup="$backupdir/dump-$(hostname)-$DB.sql"; | backup="$backupdir/dump-$(date +%F).$(hostname)-$DB.sql"; | ||
/usr/bin/mysqldump $DB > $backup; | /usr/bin/mysqldump $DB > $backup; | ||
ls -al $backup; | ls -al $backup; | ||
| Line 17: | Line 17: | ||
mysql $DB < $backup | mysql $DB < $backup | ||
</source> | </source> | ||
[[Category:Database]] | |||
Revision as of 14:18, 26 November 2014
quick recipe on using mysqldump
Backup
DB=wiki
backupdir="$HOME/backups";
if [ ! -d "$backupdir" ]; then
mkdir -p $backupdir;
fi
backup="$backupdir/dump-$(date +%F).$(hostname)-$DB.sql";
/usr/bin/mysqldump $DB > $backup;
ls -al $backup;Restore
mysql $DB < $backup
