How do I import a .sql file via phpMyAdmin?

Databases
Databases – MySQL
Austin B.
Published: 22 April 2019Last updated: 5 September 2024
Share:

You can use phpMyAdmin to import an .SQL file with your database information. To do this:

  • Log in to your database via phpMyAdmin (My20i > Manage Hosting > [select package] > phpMyAdmin) 
  • Choose the database you want to import your .SQL file to from the left hand side.
  • Click the Import tab at the top of the page.
  • Select Choose File and locate the .SQL file on your device or computer.
  • Click Go

The .SQL file will be uploaded and imported to the database you've selected. 

For further help there's a video showing how to import and export databases via phpMyAdmin:

20i's shared web hosting offers 1 GB MySQL databases.