Re: Restore backup leaves one database with no access

[marc fromm]

Can the above scenarios have anything to do with the way I create and restore my backup file? I ask because I exported the one database that has the access problem from the live server with phpMyAdmin and then imported it with phpMyAdmin on the dev server and the above problems were not encountered.

Create Backup Script
#!/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"

Restore From Backup Command
mysql -u root -p -S /var/lib/mysql/mysql.sock < /tmp/alldbs-11-12-2014_04-14