Backup MYSQL Database Using PHPMyAdmin
How back Mysql Database Using PHPMyAdmin:
1. Log into PHPMyAdmin.
2. Select the database which you wish to backup from the drop down database menu at the left.
3. Click on "Export" tab.
4. Select Mysql table which you wish to export.
5. Select Export Options.
6. Enter a filename and compressions format.
7. Click "Go".
- If you select Compressions=None, a query windows will appear and displaying the raw mysql query of your exported tables.
- If you select Compressions="Zipped" or "GZipped", a pop up box will appear asking you to save the .sql file into your local drive.
Restoring MYSQL Database Using PHPMyAdmin
1. Log into PHPMyAdmin.
2. Select the database which you wish to restore to the drop down database menu at the left.
3. Click on "SQL" tab.
4. You may either paste the SQL query from the your backup to "Run SQL query/queries on database: tablename" text box or browse for your SQL query file.
5. Click "Go" to continue and wait until the query fully executed.
Notes:
- This is only ideal for restoring SQL query not larger than 2MB. For larger Mysql database restoration, we recommend you to run mysqldump query from SSH shell.