How do I import a .sql backup file to my database?
Before starting the process, please keep the following in mind:
While there is not a known limit to the maximum file size that can be imported to your database, PHPMyAdmin struggles with large .sql files. You may need to split your .sql file into multiple .sql files before importing.
There is a processing time limit for PHPMyAdmin. Similar to the large file size notice above, you can bypass this by splitting up your .sql file into multiple .sql files.
Let’s get started importing that backup file!
- Open the control panel for the account that you wish to import the database file to.
- Locate the “PHPMyAdmin” section in the control panel, and select the database you wish to import into (If the database does not exist, you will need to create it in the control panel first).
- At the top of the page, locate the “Import” tab.
- Click the “Upload File” button, select your file, then click “Go” at the bottom of the page.
- Wait for the upload to finish, and wait for a success (Yellow) or error (Red).
