{"id":1173,"date":"2020-10-19T13:41:07","date_gmt":"2020-10-19T13:41:07","guid":{"rendered":"https:\/\/blog.hostinger.io\/support\/2020\/10\/19\/4549740-how-to-export-a-database-with-phpmyadmin-on-cpanel-at-hostinger\/"},"modified":"2025-08-27T07:09:34","modified_gmt":"2025-08-27T07:09:34","slug":"4549740-how-to-export-a-database-with-phpmyadmin-on-cpanel-at-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/support\/4549740-how-to-export-a-database-with-phpmyadmin-on-cpanel-at-hostinger\/","title":{"rendered":"How to Export a Database With phpMyAdmin on cPanel at Hostinger"},"content":{"rendered":"

You can easily export a database from your Hostinger cPanel hosting plan by following these steps:<\/p>

    \n
  1. \n

    Open your database using phpMyAdmin<\/a><\/b><\/p>\n<\/li>\n

  2. \n

    Select your desired database and click the Export<\/b> button:<\/p>\n

    ​<\/p>\n

    <\/div>\n

    \n<\/p><\/li>\n

  3. \n

    To export your database using the SQL file format – the most common to move databases, click on Go<\/b>:<\/p>\n

    ​<\/p>\n

    <\/div>\n<\/li>\n
  4. \n

    For special requirements, such as a different file format or export only some of the tables from your database, select the Custom<\/b> method and adjust the settings:<\/p>\n

    ​<\/p>\n

    <\/div>\n<\/li>\n<\/ol>

    That’s it! Once you click Go<\/b>, you will get a copy of your database on your local device.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Exporting a database via phpMyAdmin using cPanel<\/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":[195],"tags":[],"class_list":["post-1173","post","type-post","status-publish","format-standard","hentry","category-mysql"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/4549740-how-to-export-a-database-with-phpmyadmin-on-cpanel-at-hostinger\/","default":1},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/4549740-bagaimana-cara-ekspor-database-phpmyadmin-di-cpanel-di-hostinger\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/4549740-como-exportar-um-banco-de-dados-phpmyadmin-no-cpanel\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1173","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=1173"}],"version-history":[{"count":1,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1173\/revisions"}],"predecessor-version":[{"id":4612,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1173\/revisions\/4612"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/media?parent=1173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/categories?post=1173"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/tags?post=1173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}