MySQL Forums
Forum List  »  Backup

Re: Restore backup leaves one database with no access
Posted by: marc fromm
Date: November 13, 2014 12:51PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Restore backup leaves one database with no access
1405
November 13, 2014 12:51PM


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.