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:
- When to use this guide
- How to export a database
- How to import into a database
- Common Problems
- Frequently Asked Questions
When to use this guide
- You restored your website from a backup, but it shows empty or the original content is missing: The website does not show the original data after import.
- The import ended with error #1044, #1046, #1062 or #1142: Common Problems.
- You need to move data from an old database to a new one, or from another provider: Frequently Asked Questions.
- You don’t know where to find phpMyAdmin or how to log in to it: Frequently Asked Questions.
- You want to save a database backup before editing the data: Database Export.
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
Exporting a database usually goes smoothly, but you may run into the following problems during import:
- 1044 Access denied
- 1046 No database selected
- 1062 Duplicate entry
- 1142 Create command denied
- The website does not show the original data after import
#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.
The website does not show the original data after import
Problem: The import completed without errors, but after restoring from the backup the website shows empty content or the original data is missing.
Cause: The website is connected to a different database than the one you imported the data into. This is typically a new, empty database specified in the website’s configuration file (in WordPress wp-config.php).
Solution: Check the database name in the configuration file and import the data into that database, or change it to the database you imported into. You can find your webhosting databases and their names in 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.
How do I move data from an old database to a new one?
Export the old database and import the file into the new one, always using the administrator account of that database. Then verify that the website uses the new database (in WordPress, in the wp-config.php file).
How do I move a database from another provider when automatic migration failed?
Export the data in the original provider’s interface (typically phpMyAdmin or Adminer) and import it into a database with us. The provider may block external access to the database, which is why automatic migration fails, see Webhosting – Automatic Data Migration.
I can’t log in to phpMyAdmin. What should I log in with?
Use the database login name and password; for import, use the administrator account (andXXXXXX_…). You can find the details in the service activation email, or in the guide Webhosting – Databases.