Mondoze Knowledge Base

Search our articles or browse by category below

Restoring MySQL Database Using PHPMyAdmin

Last modified: October 5, 2022
You are here:
Estimated reading time: < 1 min

How To Restore 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 way for restoring SQL query not larger than 2 MB. For larger MySql database restoration, we recommend you to run mysqldump query from SSH shell.

Was this article helpful?
Dislike 0
Views: 54