MySQL

How to import a MySQL (.SQL) file to your database ?
    Copying the SQL script
  1. On your computer, navigate to the .sql file you intend to import to your database.
  2. Open the .sql file in a regular text editor such as Notepad or TextEdit.
  3. Select all the content by pressing Ctrl (Cmd) + A.
  4. Copy the content by pressing Ctrl (Cmd) + C.
  5. Close your text editor application. Executing the script
  6. In phpMyAdmin, choose the database you intend to work with from the Database menu list.
  7. Choose the SQL tab.
  8. Paste the SQL script you copied by pressing Ctrl (Cmd) + V
  9. Choose Go.
  10. Confirm that your new table has been imported by clicking the Structure tab.