This guide describes database management using the administrative tool phpMyAdmin ⧉. Log in with the database login name and password.
In this guide, you will learn:
Exporting a database
When exporting a database, you download the current data stored in it. Export is useful, for example, for manual backup.
Export the database by following these steps:
- Log in to phpMyAdmin ⧉ using the administrative 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 Export tab.
- Leave the Export method: Quick and Format: SQL settings unchanged.
- Click the Go button.
- Save (download) the exported *.sql file.
Importing 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. Files with multiple databases or unsupported commands will be rejected by the system. More information about import errors can be found in the Common issues section.
Import into the database by following these steps:
- Log in to phpMyAdmin ⧉ using the administrative account of the database where you want to import the data.
- In the left menu, select the database from the drop-down list.
- In the top menu, select the Import tab.
- Click the Choose file button and select the *.sql file you want to import.
- Click the Go button.
Uploading the file may take some time — it depends mainly on the amount of data and the speed of the connection. After the import is complete, the system will inform you.
Common issues
Database export usually completes without problems, but during import you may encounter these errors:
#1044 Access denied
Problem: The error message #1044 Access denied for user ‚X’@’%‘ to database ‚dXXXXXX_databáze‘. is displayed.
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 whether you are really uploading the data to the correct database. If so, continue with these steps:
- Open the SQL file with the data in any text editor.
- Find the lines starting with
CREATE DATABASEandUSE. - Disable these lines by placing
‐‐at the beginning of the line. - Save the SQL file and try importing again.
#1046 No database selected
Problem: The error message #1046 No database selected. is displayed.
Cause: This common error means that you did not select a database before importing.
Solution: Select the database you want to import into in the left column and perform the import again.
#1062 Duplicate entry
Problem: The error message #1062 Duplicate entry ‚X‘ for key PRIMARY. is displayed.
Cause: If you import data similar to data already present in the database, an error may occur in which PMA prevents overwriting the data.
Solution: If you are sure you no longer need the old data, delete it and perform the import again.
#1142 CREATE command denied
Problem: The error message #1142 – CREATE command denied to user ‚wXXXXXX_databáze’@’X.X.X.X‘ for table ‚název_tabulky‘ is displayed.
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 administrative privileges (aXXXXXX_…) and perform the import again. You can find the login details in the service setup email, or according to the guide Webhosting - Databases.
Frequently asked questions
I encountered an error while trying to import that is not described in the guide. What should I do?
Take a screenshot ⧉ of the error message and send it to us via the form ⧉ together with the name of the web hosting service.