Import SQL files into MySQL databases

If you backed up or exported a database to a SQL file, you can import it into one of your hosting account's MySQL databases through phpMyAdmin.

To Import SQL Files into MySQL Databases Using phpMyAdmin

1. Access your database via PHPMyAdmin
2. On the left, click the database you want to use.
3. Select the Import tab.
4. Click Browse, locate the SQL file on your computer, click Open, and then click Go.

This runs the SQL file and updates the database as specified in your SQL file. It might take several minutes to restore the database.

Article ID: 900
Created On: Wed, Jun 3, 2020 at 11:09 PM
Last Updated On: Wed, Jun 3, 2020 at 11:09 PM

Online URL: https://www.heartinternet.uk/support/article/import-sql-files-into-mysql-databases.html