From Fedora Project Wiki
No edit summary |
No edit summary |
||
Line 5: | Line 5: | ||
Suppose you have backed-up data into a dump file backup.sql | Suppose you have backed-up data into a dump file backup.sql | ||
=== | === Prerequisites === | ||
* make sure a user you are connecting to a database under has enough privileges to create all backed-up tables | * make sure a user you are connecting to a database under has enough privileges to create all backed-up tables |
Revision as of 04:43, 30 April 2013
For restoring backed-up data choose one of the methods bellow, depending which way you have chosen for back-up.
Restoring from a dump file
Suppose you have backed-up data into a dump file backup.sql
Prerequisites
- make sure a user you are connecting to a database under has enough privileges to create all backed-up tables
Restoring the data
$ mysql -u root -p < backup.sql
Restoring from copied binary files
Suppose you have copied the data stack to a location /save/directory/mysql. We should also pay attention on SELinux context, so running restoreconf
is a good idea.
# cp -r /save/directory/mysql /var/lib/mysql # restoreconf -r /var/lib/mysql
Expected results
After starting the database daemon the data will work.