MySQL Forums
Forum List  »  Data Recovery

entire server restore with dumps of user databases system database along with transaction log backups
Posted by: Ravi Thati
Date: February 02, 2012 09:02AM

Hello Everyone,


I have taken the backup in the following way:

Backup steps:
1.db1,db2,db3 and mysql system databases dumped using mysqldump one by one.
mysqldump db1 >db1.sql

2.flush logs done and noted down the new LogNumber for each database which should the starting log number from which we have to apply logs for that database.

3.copied all logs to media as part of incremental backups.

Restore method I am trying to follow:

1. for each database.sql file
mysql -u user -ppassword dbname <dbname.sql

2. Now I am trying to apply the log files after filtering using mysqlbinlog.
For each database
{
for each log file
{
mysqlbinlog -s dbname logfile > tempfile
mysql dbname <tempfile
}
}


Issue:
User databases are getting restored correctly. But system database 'mysql' is not getting restored upto latest. Any new users created/dropped, etc that get reflected on system database that went into transaction logs are not getting restored.
I can only see the system database 'mysql' content that was backedup using mysqldump. Roll forwarding logs is not bringing further changes.


when I run mysqlbinlog commmand with 'mysql' i get no entries filtered.

Does any have a way to overcome this?


--
Thanks in Advance,
Ravi Thati

Options: ReplyQuote


Subject
Views
Written By
Posted
entire server restore with dumps of user databases system database along with transaction log backups
3024
February 02, 2012 09:02AM


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.