Restoring MySQL/MariaDB Databases with phpMyAdmin
Please use the “Print” function at the bottom of the page to create a PDF.
For Linux or Windows Web Hosting Packages and Managed Dedicated Servers
In this article, we'll show you how to insert a backup file into your MySQL or MariaDB database.
Prerequisite
The data to be restored is already available as a backup file.
Warning
For data backups larger than 1GB (Gigabyte), the restore must be done through SSH access. Otherwise the restore will fail due to a timeout.
- Open the target database for editing with phpMyAdmin.
- Click Import in the menu bar. The import settings page will be displayed.
- In the File to import: section, click Select file and select your backup file.
- Specify the desired import settings.
- The default character encoding setting is UTF-8, and since just about every current application now supports this format, you probably don't need to change anything here.
The format must match that of your data file. The default setting is SQL. - You can typically leave the other settings as they are by default.
- The default character encoding setting is UTF-8, and since just about every current application now supports this format, you probably don't need to change anything here.
- Click OK to start the import.
Your data and table structure will now be restored from the backup.
Error #1044
If the data import fails with a message of the type #1044 - User 'dboxxxxxxxx'@'%' does not have access permission for database 'dbxxxxxx' , please see the article this article for more information.