This guide describes how to manage a database using the administration tool phpMyAdmin ⧉. Log in with the database login name and password.
In this guide, you will learn:
Database Export
When you export a database, you download the current data it contains. You can use export, for example, for manual backup.
Export the database by following these steps:
- Log in to phpMyAdmin ⧉ with the administrator account of the database you want to export.
- In the left menu, select the database from the drop-down list.
- In the top menu, select the tab Export.
- Keep the settings Export method: Quick and Format: SQL.
- Click the button Go.
- Save (download) the exported *.sql file.
Import into a 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. The system rejects files with multiple databases or unsupported commands. For more information about import errors, see the chapter Common Problems.
Import into the database by following these steps:
- Log in to phpMyAdmin ⧉ with the administrator account of the database you want to import the data into.
- In the left menu, select the database from the drop-down list.
- In the top menu, select the tab Import.
- Click the button Choose File and select the *.sql file you want to import.
- Click the button Go.
Uploading the file may take some time – it depends mainly on the amount of data and the connection speed. The system will notify you when the import is complete.
Common Problems
Database export usually goes without any problem, but during import you may encounter these errors:
#1044 Access denied
Problem: The following error message is displayed #1044 Access denied for user ‘X’@’%’ to database ‘dXXXXXX_database’.
Cause: You will most often encounter this error when importing our data backup into a database with a different name, or when importing a database from another provider.
Solution: First, check that you are uploading the data to the correct database. If so, proceed with these steps:
- Open the SQL file with the data in any text editor.
- Find the lines starting with the words
CREATE DATABASEandUSE. - Comment out these lines by placing the characters
‐‐at the beginning of the line. - Save the SQL file and try importing again.
#1046 No database selected
Problem: The following error message is displayed #1046 No database selected.
Cause: This common error means that you did not select a database before the import.
Solution: In the left column, select the database you want to import into, and run the import again.
#1062 Duplicate entry
Problem: The following error message is displayed #1062 Duplicate entry ‘X’ for key PRIMARY.
Cause: If you import data similar to the data already in the database, an error may occur because PMA prevents the data from being overwritten.
Solution: If you are sure you no longer need the old data, delete it and run the import again.
#1142 CREATE command denied
Problem: The following error message is displayed #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 the website user, i.e. wXXXXXX_….
Solution: Log in as a user with administrator rights (andXXXXXX_…) and run the import again. You can find the login details in the service setup email, or follow the guide Webhosting – Databases.
Frequently Asked Questions
I encountered an error during import that is not described in the guide. What should I do?
Take a screenshot ⧉ of the error message and send it to us using the form ⧉ together with the name of your Webhosting.