MySQL Forums
Forum List  »  Backup

Re: Restore backup leaves one database with no access
Posted by: marc fromm
Date: November 17, 2014 01:26PM

Can I avoid this problem by changing my backup script from using mysql.sock to --all-databases?

#!/bin/bash
backup_dir="/xxx/xxx/xxx/xxx"
timeslot=`date +%m-%d-%Y_%H-%M`
mysqldump -u root -p######## -S /var/lib/mysql/mysql.sock -A | gzip > "$backup_dir/alldbs-$timeslot.gz"


#!/bin/bash
backup_dir="/xxx/xxx/xxx/xxx"
timeslot=`date +%m-%d-%Y_%H-%M`
mysqldump -u root -p####### --all-databases --add-drop-table > alldb_backup.sql | gzip > alldbs.sql.gz

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Restore backup leaves one database with no access
1425
November 17, 2014 01:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.