Restoring MySQL databases in Linux/FreeBSD/Solaris

• Overview
• Restore MySQL database
• Troubleshooting Tips
• Limitations

Overview

Restoring a database is sometimes necessary when a database becomes corrupt. You can restore your MySQL Server databases using your most recent full backup. This section gives you information on how to restore MySQL Server database using in Linux/FreeBSD/Solaris.

Restore MySQL database[For Linux/FreeBSD/Solaris]

Restoring MySQL databases in Linux/FreeBSD/Solaris require a couple of extra steps. Please follow the instructions detailed below in sequential order.

1. Follow the steps for a regular restore operation and restore the required database backup files.
2. Restore!
3. Once restored, the required files are now in their designated locations:
   <Restore Path>/<SG_Installed_Path>/mysqlbackup/<Backup_Name>/<Database_Name>/<Restore_File_Name>.sql
   The restored MySQL database files end with an extension ".sql". In order to use the restored database, please follow the steps given below:
   1. If the restoring database is unavailable in MySQL Server, create the database using the command "CREATE DATABASE <DB_NAME>".
   2. Reload the database with the data using mysql -u [username] -p[password] [<DB_NAME>] < [<Restore Path>/<SG_Installed_Path>/mysqlbackup/<Backup_Name>/<Database_Name>/<Restore_File_Name>.sql]. This will dump the sql back to the database.

Troubleshooting Tips

Limitations