The PhpMyAdmin utility lets you IMPORT databases by using a text file containing the SQL statements of a database, which generates the tables and data previously exported from another database.
We need to import a previously generated file. Ensure you have a copy of the database, exported in SQL statements, saved in a file with a .sql, .zip, .tar.gz, or .tgz extension on your hard drive.
You must have a database created beforehand. If not, access your hosting control panel to create one.
1. Access PhpMyAdmin using your administrator username and password for the database you want to import.
2. Once inside PhpMyAdmin, we select the database we’ve created and want to import our file into.
3. After selecting the database, click the “Import” link.
4. A window will appear for us to browse the database file on our hard drive. Click “Browse,” choose the file, and confirm.
5. In the “Character Set” section, select the same option you used when exporting the database. UTF-8 is usually the choice.
6. After that, click “Continue” and wait for the file to upload. The time will vary based on the file size.
NOTE: Please note that if the file you want to import is larger than 4 MB, it cannot be imported using PhpMyAdmin. We suggest reaching out to our technical support team for assistance with this process. Please provide the SQL file and indicate the database for the import.