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:

  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:

Was this article helpful?

Related Articles

Leave A Comment?

You must be logged in to post a comment.