{"id":1332,"date":"2019-02-08T10:36:10","date_gmt":"2019-02-08T10:36:10","guid":{"rendered":"https:\/\/blog.hostinger.io\/support\/2019\/02\/08\/1864324-how-to-upload-and-set-up-your-database-at-hostinger\/"},"modified":"2026-03-16T12:12:15","modified_gmt":"2026-03-16T12:12:15","slug":"1864324-how-to-upload-and-set-up-your-database-at-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/support\/1864324-how-to-upload-and-set-up-your-database-at-hostinger\/","title":{"rendered":"How to Upload and Set Up Your Database at Hostinger"},"content":{"rendered":"<p class=\"no-margin\">If you have previously created a MySQL or MariaDB database and want to use it at Hostinger, you can easily import it and set it up. Here&rsquo;s what you need to do:<\/p><h2 id=\"h_aa8596e533\">Step 1 &ndash; Preparation<\/h2><p class=\"no-margin\">First, make sure that your database file meets the following requirements:<\/p><ul>\n<li>\n<p class=\"no-margin\">The file format is <b>.sql<\/b> or <b>.sql.zip<\/b><\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">It does not contain commands to create or delete a database, such as <code>DROP DATABASE IF EXISTS<\/code> or <code>CREATE DATABASE IF NOT EXISTS<\/code><\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">There are no commands that require SUPER privileges, such as <code>GRANT ALL PRIVILEGES<\/code><\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">It does not include lines with <code>DEFINER<\/code> or <code>PROCEDURE<\/code>, or <code>TRIGGER<\/code><\/p>\n<\/li>\n<\/ul><div class=\"intercom-interblocks-callout\" style=\"background-color: #e3e7fa80;border-color: #334bfa33\">\n<p class=\"no-margin\">If your project requires SUPER privileges for databases, you can consider <b><a class=\"intercom-content-link\" href=\"\/support\/1583582-how-and-why-to-purchase-vps-hosting#h_f7c53bb886\" target=\"_blank\" rel=\"noopener\">migrating to a VPS plan<\/a><\/b> &#128161;<\/p>\n<\/div><h2 id=\"h_a9e4a72557\">Step 2 &ndash; Create a New Database<\/h2><p class=\"no-margin\">Navigate to <b><a class=\"intercom-content-link\" href=\"https:\/\/hpanel.hostinger.com\/websites\" target=\"_blank\" rel=\"noopener\">Websites<\/a> &rarr; Dashboard<\/b>. Look for <b>Databases <\/b>on the left sidebar and select <b>Management<\/b>.<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2019\/02\/9183343a-38bb-4618-aa7c-a7475b5530a1.jpg\" width=\"300\"><\/div><p class=\"no-margin\">Next, enter the database name, username, and password. A detailed guide is available here: <a class=\"intercom-content-link\" href=\"https:\/\/www.hostinger.com\/support\/1583542-how-to-create-a-new-mysql-database-in-hostinger\/\" target=\"_blank\" rel=\"noopener\">How to Create a New Database<\/a>.<\/p><h2 id=\"h_ab01d7bf1d\">Step 3 &ndash; Import Your Database&rsquo;s Backup<\/h2><p class=\"no-margin\">Open your newly created database using <a class=\"intercom-content-link\" href=\"\/support\/1583545-how-can-i-access-phpmyadmin\" target=\"_blank\" rel=\"noopener\">phpMyAdmin<\/a>, click <b>Import<\/b> and select the backup file from your computer. Here is a dedicated article with detailed steps: <a class=\"intercom-content-link\" href=\"\/support\/1884149-how-to-import-a-database-with-phpmyadmin\" target=\"_blank\" rel=\"noopener\">How to Import a Database With phpMyAdmin<\/a>.<\/p><h2 id=\"h_df3168e436\">Step 4 &ndash; Update the Configuration File<\/h2><p class=\"no-margin\">If a database is required for your website to work properly, you will need to update the connection details in your website&rsquo;s <a class=\"intercom-content-link\" href=\"\/support\/3313359-where-to-find-configuration-file-of-my-website\" target=\"_blank\" rel=\"noopener\">configuration file<\/a>.<\/p><p class=\"no-margin\">The specific steps will vary depending on the type of content management system (CMS) you are using. However, in general, you will need to open the configuration file and update the database name, username, password, and host using the <a class=\"intercom-content-link\" href=\"https:\/\/www.hostinger.com\/support\/1583552-how-to-find-your-mysql-database-details-in-hostinger\/\" target=\"_blank\" rel=\"noopener\">details of the new database<\/a>.<\/p><p class=\"no-margin\"><b>Additional Resources<\/b><\/p><ul>\n<li>\n<p class=\"no-margin\">Check our selection of <a class=\"intercom-content-link\" href=\"https:\/\/www.hostinger.com\/tutorials\/mysql\" target=\"_blank\" rel=\"noopener\">MySQL tutorials<\/a>.<\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>A step-by-step guide to importing and setting up a MySQL database at Hostinger<\/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":[210],"tags":[],"class_list":["post-1332","post","type-post","status-publish","format-standard","hentry","category-creating-your-own-website"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/1864324-how-to-upload-and-set-up-your-database-at-hostinger\/","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/1864324-como-cargar-y-configurar-una-base-de-datos-en-hostinger\/","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/1864324-comment-telecharger-et-configurer-votre-base-de-donnees-chez-hostinger\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/1864324-cara-upload-dan-setup-database-di-hostinger\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/1864324-como-subir-e-configurar-seu-banco-de-dados-na-hostinger\/","default":0},{"locale":"uk-UA","link":"https:\/\/www.hostinger.com\/ua\/support\/1864324------\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1332","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=1332"}],"version-history":[{"count":4,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1332\/revisions"}],"predecessor-version":[{"id":7329,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1332\/revisions\/7329"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/media?parent=1332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/categories?post=1332"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/tags?post=1332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}