{"id":1328,"date":"2019-02-08T10:36:10","date_gmt":"2019-02-08T10:36:10","guid":{"rendered":"https:\/\/blog.hostinger.io\/support\/2019\/02\/08\/1884149-how-to-import-a-database-with-phpmyadmin-in-hostinger\/"},"modified":"2026-03-16T12:12:15","modified_gmt":"2026-03-16T12:12:15","slug":"1884149-how-to-import-a-database-with-phpmyadmin-in-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/support\/1884149-how-to-import-a-database-with-phpmyadmin-in-hostinger\/","title":{"rendered":"How to Import a Database With phpMyAdmin in Hostinger"},"content":{"rendered":"

To import your database, first open it via phpMyAdmin<\/a><\/b> and check the current content.<\/p>

\n

It’s highly recommended to make sure that your database is empty<\/a><\/b> before importing a new database backup<\/p>\n<\/div>

Next, since your database will be selected by default, click on Import:<\/b><\/p>

\n<\/p>

<\/div>

Choose a file in .sql<\/b> or .sql.zip<\/b> format:<\/p>

\n<\/p>

<\/div>

Proceed further without making any other changes to the import settings and click Go<\/b>. In a few moments, your database will be imported 😊 <\/p>

\n<\/p>

If you encounter any issues, check the following section.<\/p>

\n<\/p>

Common Errors<\/h2>

Here you will find the most common issues when importing a database:<\/p>

\n<\/p>

The Database is Too Big<\/h3>

Max size for a database that can be uploaded via phpMyAdmin is 256 MB. If your database file is bigger, you can easily import it via SSH<\/a><\/b> instead.<\/p>

\n<\/p>

Incorrect Format Parameter<\/h3>

Make sure that your file format is .sql<\/b>. Alternatively, you can import a compressed database with the following formats: gzip, bzip2, and zip (for example, database.sql.zip<\/b>).<\/p>

\n<\/p>

If you have checked and the file format is correct, this error might also indicate a corrupted database file.<\/p>

\n<\/p>

Command Denied to User<\/h3>

If you get this error, it means that your database user doesn’t have enough permissions to import the database. All you need to do is fix the database permissions<\/a><\/b>.<\/p>

\n<\/p>

Access is Denied. You Need the SUPER Privilege for This Operation<\/h3>

This error means that your database includes queries that require SUPER privileges to be executed. In this case, double-check the nature of the queries on your .sql<\/b> file and remove them if possible using any text editor of your choice. Next, try importing the database again.<\/p>

\n<\/p>

If the queries that require SUPER privileges are definitely required, you may consider going for one of our VPS plans<\/a><\/b>.<\/p>

\n<\/p>

That’s it! Now you know how to import a MySQL database.<\/p>\n","protected":false},"excerpt":{"rendered":"

Importing a database via phpMyAdmin using hPanel<\/p>\n","protected":false},"author":581,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"include_on_kodee":true,"footnotes":""},"categories":[243],"tags":[],"class_list":["post-1328","post","type-post","status-publish","format-standard","hentry","category-importing-and-exporting-databases"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/1884149-how-to-import-a-database-with-phpmyadmin-in-hostinger\/","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/1884149-como-importar-una-base-de-datos-con-phpmyadmin-en-hostinger\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/1884149-bagaimana-cara-impor-database-dengan-phpmyadmin-di-hostinger\/","default":0},{"locale":"lt-LT","link":"https:\/\/www.hostinger.com\/lt\/support\/1884149-kaip-importuoti-duomenu-baze-per-phpmyadmin-hostinger-platformoje\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/1884149-como-importar-um-banco-de-dados-com-o-phpmyadmin-no-hostinger\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1328","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/comments?post=1328"}],"version-history":[{"count":1,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1328\/revisions"}],"predecessor-version":[{"id":5035,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1328\/revisions\/5035"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/media?parent=1328"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/categories?post=1328"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/tags?post=1328"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}