Before importing your database, note that some SQL files contain CREATE and USE lines. We do not need these lines, and they generate an error message. This must be adjusted before the file is imported. To do this, open the file with a text editor such as Notepad.
- Delete the line that starts with CREATE DATABASE
- Delete the line that starts with USE
Step by step:
2. Click in database
- You can add the database in an existed database created in your panel. If you have any database, it will show on this page. If you don't have it, you can create one.
NOTE: Be careful to not import a database in a database being used by another website. Double-check the database name first.
- Open the phpMyAdmin under the database where you will import your file.
- Click in IMPORT and select the file you want to upload.
- Click on Start. The file is now sent to the server and processed.