This tutorial describes how to manage your database using the phpMyAdmin administrative tool ⧉. Log in with your database login and password.
In this guide you will learn:
- How to export the database
- How to import into the database
- Common problems
- Frequently Asked Questions
Database export
When you export a database, you download the current data contained in it. You can use the export, for example, for manual backups.
Export the database by following these steps:
- Login to phpMyAdmin ⧉ with the administrator account of the database you want to export.
- In the left menu, select a database from the drop-down menu.
- In the top menu, select the Export tab.
- Keep the Export Method: quick and Format: sql settings.
- Click the Execute button.
- Save (download) the exported *.sql file.
Import to database
You can import the exported file back into the database, for example, when restoring a backup.
You can only import files containing database tables. Files with multiple databases or unsupported commands will be rejected by the system. For more information about import errors, see Common Problems.
Import into the database by following these steps:
- Log into phpMyAdmin ⧉ with the administrator account of the database you want to import data into.
- In the left menu, select a database from the drop-down menu.
- In the top menu, select the Import tab.
- Click the Select File button and select the *.sql file that you want to import.
- Click the Execute button.
It may take some time to upload a file, depending mainly on the amount of data and the speed of the connection. The system will inform you when the import is complete.
Common problems
Exporting the database usually goes without a problem, but you may encounter the following errors during import:
#1044 Access denied
Problem: An error message is displayed #1044 Access denied for user 'X'@'%' to database 'dXXXXXX_database'.
Cause: this error is most often encountered when importing our backup data into a database with a different name, or when importing a database from another provider.
Solution: First, check that you are actually uploading the data to the correct database. If so, follow these steps:
- Open the SQL data file in any text editor.
- Find the lines beginning with the words
CREATE DATABASEaUSE. - Separate these lines by placing the characters
‐‐to the beginning of the line. - Save the SQL file and try importing again.
#1046 No database selected
Problem: Error message #1046 No database selected is displayed .
Cause: This common error means that you did not select the database before importing.
Solution: In the left column, select the database you want to import to and do the import again.
#1062 Duplicate entry
Problem: Error message #1062 Duplicate entry 'X' for key PRIMARY is displayed .
Cause: if you import data similar to data already in the database, an error may occur where PMA prevents the data from being overwritten.
Solution: If you are sure you no longer need the old data, delete it and import it again.
#1142 CREATE command denied
Problem: Displaying error message #1142 - CREATE command denied to user 'wXXXXXX_database'@'X.X.X.X' for table 'table_name'.
Cause: You will encounter this error if you are logged in as a web user, i.e. wXXXXXX_....
Solution: Log in as a user with administrator rights(aXXXXXX_...) and import again. You can find the login details in the service setup email or by following the Webhosting - Database instructions.
Frequently Asked Questions
When I try to import it I encountered an error that is not mentioned in the instructions, what should I do?
Take a screenshot of the ⧉ error message and send it to us on the &boxboxbox; form along with the name of the web host.