How to import/export mysql databases using phpmyadmin

  1. Login to the cPanel of you website account

  2. Under database options open the phpMyAdmin application.



  1. Select your new database from the list on the left hands sidebar. Once it opens select the Import tab from the navigation menu.

  2. In the File to Import section click the Choose File button and select the SQL file located on your local computer.

  1. Untick the Partial Import check box, make sure the format is set to SQL and then click the Go button. The database import will now begin.



  1. You should receive a message informing you of the success of the import when it has finished.