storegrid : mysql backup
TRANSCRIPT
MySQL Backup
StoreGrid can be configured to backup the MySQL Database(s) available in the local machine.
StoreGrid uses the internal MySQLDump utility (mysqldump.exe) to backup MySQL Database(s) and it uses the MySQL Exe (mysql.exe) to list the database names in the files/folders tree in the "Add Backup Schedule" page.
Steps
• install StoreGrid in service mode with administrative privileges.•configure the MySQL settings through "Administration->Advanced Options" and click on the "MySQL Settings" icon in the left hand side. Without correct values for MySQL settings, StoreGrid will not be able to list the databases to be configured for backups in "Add Backup Schedule" page.
Before configuring MYSQL Settings
My SQL is now available in the tree
Restoring MySQL databases in Windows 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.
Once restored, the required files are now in their designated locations:<Restore Path>\<Temp_Dump_Location>\<Backup_Name>\<Database_Name>\<Restore_File_Name>
The restored MySQL database files end with an extension ".sql".
In order to use the restored database, please follow the steps given below:
• Open windows command prompt utility Start > run > cmd
• Navigate to MY SQL folder and type the following command
“mysql –u root –pvishal123 < “C:\vishalrestore\c-drive\program Files\Vembu\StoreGrid\plugin-data\mysqlserver\database\vishal\vishal.sql”
Data Restored