MySQL Forums
Forum List  »  Data Recovery

Restoring MySQL user accounts, databases and configuration from backed up /var/lib/mysql directory
Posted by: Michael Park
Date: April 30, 2011 04:59AM

Last night, I backed up my Ubuntu 10.10 box using the sbackup utility. The process ran with the default options, which backed up the /etc /home /usr /var directories to a separate partition on my machine.

After the backup completed successfully, I installed Ubuntu 11.04 over the existing Ubuntu 10.10 partition and installed the lamp-server meta package using tasksel:

$ sudo apt-get install tasksel
$ sudo tasksel install lamp-server

When prompted, I entered the same MySQL root password as used on Ubuntu 10.10.

What's the easiest way to restore the user accounts, databases and configuration from /media/backup/var/lib/mysql to the new installation?

Thank you.

Options: ReplyQuote


Subject
Views
Written By
Posted
Restoring MySQL user accounts, databases and configuration from backed up /var/lib/mysql directory
3263
April 30, 2011 04:59AM


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.