Re: Restore backup leaves one database with no access

[marc fromm]

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