This tutorial provides a description of how to import database tables via SQL tab in phpMyAdmin.
How to import database tables via SQL tab in phpMyAdmin
In order to import database tables via SQL tab in phpMyAdmin, you should do the following:
-
Open your dump.sql file with a text editor (e.g., Notepad++, Sublime Text 3).
-
Select all the content/tables of the file (Ctrl+A) and copy them (Ctrl+C).
-
Navigate to your database in phpMyAdmin, click the SQL tab above, paste all the content/tables of dump.sql file (ctrl+V):
-
Click Go:
Feel free to check the detailed video tutorial below: