Restoring a MySQL database from a dump file brings your store’s data back onto a server, whether you’re setting up a fresh environment or migrating from a backup. Here are two common ways to do it:<\/p>\n
1. Log in to your hosting control panel (such as cPanel) and open phpMyAdmin. 1. Upload your database dump file to your server via FTP or SSH. 3. Restore the dump into that database with:<\/p>\n 4. Enter your MySQL password when prompted, and wait for the process to complete.<\/p>\n Once restored, double-check that your store connects properly to the newly restored database, and that your data appears as expected.<\/p>\n If you have other questions or inquiries, please contact our Support Agents via live chat or email us at litextension@support.litextension.com<\/strong>.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":6184,"menu_order":13,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_tag":[1083,3613,3612,3614,3615],"class_list":["post-4017","docs","type-docs","status-publish","hentry","doc_tag-database-dump","doc_tag-mysql-dump","doc_tag-phpmyadmin","doc_tag-restore","doc_tag-restore-a-mysql"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/4017","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/comments?post=4017"}],"version-history":[{"count":7,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/4017\/revisions"}],"predecessor-version":[{"id":7757,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/4017\/revisions\/7757"}],"up":[{"embeddable":true,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/6184"}],"next":[{"title":"How to set permission for root folder?","link":"https:\/\/litextension.com\/faq\/docs\/migration-process\/migration-preparation\/set-permissions-for-root-folder-litextension-shopping-cart-migration\/","href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/288"}],"prev":[{"title":"What is Basic Authentication?","link":"https:\/\/litextension.com\/faq\/docs\/migration-process\/migration-preparation\/what-is-basic-authentication\/","href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/5746"}],"wp:attachment":[{"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/media?parent=4017"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/doc_tag?post=4017"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n2. If you don’t already have a database set up, create a new one first.
\n3. Select the target database from the left-hand menu.
\n4. Click the Import<\/strong> tab at the top.
\n5. Click Choose File<\/strong>\u00a0and select your database dump file (usually a .sql file).
\n6. Scroll down and click Go<\/strong> to start the import.
\n7. Wait for the confirmation message once the import completes.<\/p>\nOption 2: Using the command line (for advanced users)<\/h3>\n
\n2. Create a new database if needed, using a command like:<\/p>\nmysql -u your_username -p -e \"CREATE DATABASE your_database_name;\"<\/pre>\n
mysql -u your_username -p your_database_name < your_dump_file.sql<\/pre>\n