{"id":24960,"date":"2026-11-10T03:10:42","date_gmt":"2026-11-10T03:10:42","guid":{"rendered":"https:\/\/www.hostinger.com\/support\/?p=24960"},"modified":"2026-11-10T03:10:42","modified_gmt":"2026-11-10T03:10:42","slug":"how-to-import-a-database-from-the-hostinger-dashboard","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/support\/how-to-import-a-database-from-the-hostinger-dashboard\/","title":{"rendered":"How to import a database from the Hostinger dashboard"},"content":{"rendered":"<p>Import a database from the Hostinger dashboard by uploading a <code>.sql<\/code> or <code>.sql.gz<\/code> file in <b>Databases &rarr; Management<\/b>. Hostinger creates a new MySQL database and database user for the file and imports your data into it. When the import finishes, save the login details and update your website&rsquo;s configuration file.<\/p><h3><b>Before you start<\/b><\/h3><ul>\n<li>Prepare your database file in <code>.sql<\/code> or <code>.sql.gz<\/code> format. If your database is hosted with another provider, follow <a data-click-id=\"hgr-post-content-link-how-to-generate-backups-from-other-providers-at-hostinger\" href=\"https:\/\/www.hostinger.com\/support\/1863862-how-to-generate-backups-from-other-providers-at-hostinger\/\">How to generate backups from other providers at Hostinger<\/a> to get the file.<\/li>\n<li>Importing from the Hostinger dashboard always creates a new database. To import into an existing database, use <a data-click-id=\"hgr-post-content-link-phpmyadmin\" href=\"https:\/\/www.hostinger.com\/support\/1884149-how-to-import-a-database-with-phpmyadmin-in-hostinger\/\">phpMyAdmin<\/a> or <a data-click-id=\"hgr-post-content-link-ssh\" href=\"https:\/\/www.hostinger.com\/support\/4536306-how-to-import-a-database-over-ssh-in-hostinger\/\">SSH<\/a> instead.<\/li>\n<\/ul><h2 id=\"h-import-a-database-file-from-the-hostinger-dashboard\">Import a database file from the Hostinger dashboard<\/h2><p>Use the <b>Import database<\/b> button in <b>Databases &rarr; Management<\/b> to upload your file. Hostinger creates the database and user automatically, so you don&rsquo;t need to <a data-click-id=\"hgr-post-content-link-create-a-new-mysql-database\" href=\"https:\/\/www.hostinger.com\/support\/1583542-how-to-create-a-new-mysql-database-in-hostinger\/\">create a new MySQL database<\/a> first.<\/p><ol>\n<li>Go to <b>Websites &rarr; Manage site<\/b>. Then, select <b>Databases &rarr; Management<\/b> in the left sidebar.<\/li>\n<li>Select <b>Import database<\/b> next to <b>List of Current MySQL Databases And Users<\/b>.<br>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-24961\" src=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-10_10-06.png\" alt=\"\" width=\"1280\" height=\"601\" srcset=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-10_10-06.png 1280w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-10_10-06-300x141.png 300w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-10_10-06-1024x481.png 1024w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-10_10-06-768x361.png 768w\" sizes=\"(max-width: 1280px) 100vw, 1280px\" \/><\/li>\n<li>Drag and drop your <code>.sql<\/code> or <code>.sql.gz<\/code> file into the <b>Import a database<\/b> window, or select <b>Choose file<\/b>.<br>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-24962\" src=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-10_10-07.png\" alt=\"\" width=\"513\" height=\"407\" srcset=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-10_10-07.png 513w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-10_10-07-300x238.png 300w\" sizes=\"(max-width: 513px) 100vw, 513px\" \/><\/li>\n<li>Wait for the file to upload. Keep <b>Delete the .sql file after import<\/b> selected to remove the uploaded file from your files after the import. Clear the checkbox to keep the file.<br>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-24963\" src=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-10_10-07_1.png\" alt=\"\" width=\"509\" height=\"296\" srcset=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-10_10-07_1.png 509w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-10_10-07_1-300x174.png 300w\" sizes=\"(max-width: 509px) 100vw, 509px\" \/><\/li>\n<li>Select <b>Import<\/b>. Hostinger uploads the file, creates the database and user, and imports the data. The window shows the progress of each stage.<br>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-24964\" src=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-10_10-08.png\" alt=\"\" width=\"510\" height=\"277\" srcset=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-10_10-08.png 510w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-10_10-08-300x163.png 300w\" sizes=\"(max-width: 510px) 100vw, 510px\" \/><\/li>\n<li>Keep the page open until the import finishes to get the login details.<\/li>\n<li>Copy the <b>Database name<\/b>, <b>Username<\/b>, and <b>Password<\/b> from the <b>Your database is ready<\/b> window. Then, select <b>Done<\/b>.<br>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-24965\" src=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-10_10-08_1.png\" alt=\"\" width=\"501\" height=\"568\" srcset=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-10_10-08_1.png 501w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-10_10-08_1-265x300.png 265w\" sizes=\"(max-width: 501px) 100vw, 501px\" \/><\/li>\n<\/ol><div class=\"intercom-interblocks-callout\" style=\"background-color: #feedaf80;border-color: #fbc91633\">\n<p>The database password appears only once, when the import finishes. Save it before closing the window. You can <a data-click-id=\"hgr-post-content-link-change-the-database-password\" href=\"https:\/\/www.hostinger.com\/support\/1583522-how-to-change-a-database-password-in-hostinger\/\">change the database password<\/a> later in the database list.<\/p>\n<\/div><p>To check the imported tables, select <b>Enter phpMyAdmin<\/b> in the <b>Your database is ready<\/b> window. Learn more about <a data-click-id=\"hgr-post-content-link-how-to-access-phpmyadmin-at-hostinger\" href=\"https:\/\/www.hostinger.com\/support\/1583545-how-to-access-phpmyadmin-at-hostinger\/\">how to access phpMyAdmin at Hostinger<\/a>.<\/p><h2 id=\"h-connect-your-website-to-the-imported-mysql-database\">Connect your website to the imported MySQL database<\/h2><p>The new database appears in the MySQL database list with a <b>New<\/b> label. It is assigned to the website you imported it from.<\/p><p>Update your website&rsquo;s <a data-click-id=\"hgr-post-content-link-configuration-file\" href=\"https:\/\/www.hostinger.com\/support\/3313359-how-to-find-the-website-s-configuration-file-at-hostinger\/\">configuration file<\/a> with the new database name, username, and password. The steps depend on your content management system (CMS). Find these values later in <a data-click-id=\"hgr-post-content-link-your-mysql-database-details\" href=\"https:\/\/www.hostinger.com\/support\/1583552-how-to-find-your-mysql-database-details-in-hostinger\/\">your MySQL database details<\/a>.<\/p><p>If your website shows a database connection error after the update, follow <a data-click-id=\"hgr-post-content-link-how-to-fix-error-establishing-a-database-connection-at-hosti\" href=\"https:\/\/www.hostinger.com\/support\/1583224-how-to-fix-error-establishing-a-database-connection-at-hostinger\/\">How to fix &ldquo;Error establishing a database connection&rdquo; at Hostinger<\/a>.<\/p><p>Your database is now imported and ready to connect to your website. For the full process of moving a database to Hostinger, see <a data-click-id=\"hgr-post-content-link-how-to-upload-and-set-up-your-database-at-hostinger\" href=\"https:\/\/www.hostinger.com\/support\/1864324-how-to-upload-and-set-up-your-database-at-hostinger\/\">How to upload and set up your database at Hostinger<\/a>.<\/p><p><b>NOTES<\/b><\/p><ul>\n<li>The maximum file size for a database import from the Hostinger dashboard depends on your hosting plan.<\/li>\n<li>To rename, delete, or manage the new database, see <a data-click-id=\"hgr-post-content-link-how-to-manage-mysql-databases-in-hostinger\" href=\"https:\/\/www.hostinger.com\/support\/1864454-how-to-manage-mysql-databases-in-hostinger\/\">How to manage MySQL databases in Hostinger<\/a>.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Upload a .sql or .sql.gz file in the Hostinger dashboard to create and import a new MySQL database.<\/p>\n","protected":false},"author":594,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_content_updated_date":"","include_on_kodee":true,"footnotes":""},"categories":[243],"tags":[],"class_list":["post-24960","post","type-post","status-publish","format-standard","hentry","category-importing-and-exporting-databases"],"hreflangs":[],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/24960","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\/594"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/comments?post=24960"}],"version-history":[{"count":2,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/24960\/revisions"}],"predecessor-version":[{"id":24967,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/24960\/revisions\/24967"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/media?parent=24960"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/categories?post=24960"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/tags?post=24960"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}