Import SQL files into a MySQL database
If you backed up (or exported) a database as an SQL file, you can import it into one of your hosting account's MySQL databases through phpMyAdmin.
Note: If your database is overly large or has many tables, you’ll need to import it through SSH.
- Sign in to phpMyAdmin.
- On the left menu, select the name of the database you want to use.
Note: If you see only information_schema, you should create a database in your Web Hosting (cPanel) or Windows Hosting (Plesk) account. - On the top menu, select Import.
- Select Choose file.
- Find and select the file you want to import and then select Open.
- At the bottom of the page, select Import.
It might take several minutes for the import to complete and update the database as specified in your SQL file.
More info
- Export MySQL databases
- Visit the phpMyAdmin site to learn more.
