From Fedora Project Wiki
(Created page with "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 d...") |
|||
(2 intermediate revisions by the same user not shown) | |||
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 | ||
Line 13: | Line 13: | ||
<pre> | <pre> | ||
$ mysql -u root -p < backup.sql | $ mysql -u root -p < backup.sql | ||
$ mysql -u root | |||
mysql> FLUSH PRIVILEGES; | |||
</pre> | </pre> | ||
Line 25: | Line 27: | ||
# restoreconf -r /var/lib/mysql | # restoreconf -r /var/lib/mysql | ||
</pre> | </pre> | ||
== Expected results == | |||
After starting the database daemon the data will work. |
Latest revision as of 13:02, 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 $ mysql -u root mysql> FLUSH PRIVILEGES;
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.