|
Restoring MySQL databases in Linux require a couple of extra steps. Please follow the instructions detailed below in sequential order.
|
Follow the steps for a regular restore operation and restore the required database backup files.
Restore!
-
The required files are now in their designated locations:
<Restore Path>/<GigaVaultStorage_Installed_Path>/mysqlbackup/<Backup_Name>/<Database_Name>/<Restore_File_Name>
The restored MySQL database files end with an extension ".gz". In order to use the restored database, you need to manually extract the restored ".gz" file to the original database location (which is /var/lib/mysql/" in most cases) as detailed below:
gunzip <Restore_File_Name> - this will result in a tar file <Tar_File>.
tar -xvf <Tar_File> - this will extract the tar and you will get the database directory <DB_NAME>.sql file which is the sql of the actual database.
Reload the database with the data using mysql -u [username] -p [password] [<DB_NAME>] < [<DB_NAME>.sql]. This will dump the sql back to the database.
|