How can I import a database?
- Go to phpMyAdmin
- Click the new database name in the top left (optional)
- Click Import in the main area of phpMyAdmin
- Browse for the .sql file on your computer and click Go
The optional step depends on if the new database name exists. If yes, then go ahead and click it. If no, skip it.
Common Issues
#Your import file is too large!
You will know this is the case when phpMyAdmin times out. If you experience this timeout which can be due to the huge DB space, please upload the database backup file under your "www" directory and contact us at support@balasai.com with the details. We will perform the import for you.
#1049 - Unknown database 'username1_wrdp'
The problem is your import file does not have a query to create the database before importing the data. Simply go to cPanel > MySQL Databases and create a database with that name (in this example, "wrdp"). Then re-attempt your import.
