How to import database tables via SQL tab in phpMyAdmin

This tutorial provides a description of 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:

1. Open your dump.sql file with a text editor (e.g., Notepad++, Sublime Text 3).

2. Select all the content/tables of the file (Ctrl+A) and copy them (Ctrl+C).

3. Navigate to your database in phpMyAdmin, click the SQL tab above, paste all the content/tables of dump.sql file (ctrl+V):

   

4. Click Go:

   

Feel free to check the detailed video tutorial below: