QA:How to restore data in MySQL or MariaDB
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
- 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
After starting the database daemon the data will work.