{"id":727,"date":"2020-07-26T08:58:15","date_gmt":"2020-07-26T08:58:15","guid":{"rendered":"https:\/\/hostingspell.com\/blog\/?p=727"},"modified":"2020-07-26T08:58:18","modified_gmt":"2020-07-26T08:58:18","slug":"how-to-import-and-export-database-in-phpmyadmin","status":"publish","type":"post","link":"https:\/\/blog.hostingspell.com\/how-to-import-and-export-database-in-phpmyadmin\/","title":{"rendered":"How to import and export database in PhpMyAdmin"},"content":{"rendered":"\n

PhpMyAdmin<\/em> is a graphical interface, an open-source tool pre-installed with your hosting subscription. You can wade through your database to make preferred changes.<\/p>\n\n\n\n

All the data on your website is stored in a database. For example, all your posts and articles, including, the comments are stored by WordPress in a database.<\/p>\n\n\n\n

Note- It is not possible to undo the modifications. Be cautious while working in phpMyAdmin.<\/strong> <\/em><\/p>\n\n\n\n

Step 1.<\/strong> Control panel<\/p>\n\n\n\n

  1. Log into your Cpanel.<\/strong><\/li>
  2. Choose phpMyAdmin<\/strong><\/em>.<\/li><\/ol>\n\n\n\n

    Step 2. <\/strong>Database selection<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n
    1. In the phpMyAdmin<\/strong> section, click and choose the database you want to access.<\/li><\/ol>\n\n\n\n

      Step 3.<\/strong> Managing your database<\/p>\n\n\n\n

      You can manage your database on the new window that shows up in phpMyAdmin. To access the individual tables in the database, click \u2018+\u2019<\/strong> sign.<\/p>\n\n\n\n

      Now that you have access to your database, let us learn how to import the database.<\/p>\n\n\n\n

      How to import database<\/h3>\n\n\n\n

      Step 1.<\/strong> Choose\/ click the name of the database you wish to import.<\/p>\n\n\n\n

      Step 2<\/strong>. Find and select the \u2018Import\u2019<\/strong> option.<\/p>\n\n\n\n

      Step 3. <\/strong>Choose the required database file in the \u2018choose file\u2019<\/strong> section. And click on the \u2018Go\u2019 <\/strong>option.<\/p>\n\n\n\n

      Note \u2013 this file is necessarily a .sql or .zip file.<\/em><\/p>\n\n\n\n

      Step 4.<\/strong> Finishing<\/p>\n\n\n\n

      At this point, the import should be over. You will see a message on your screen, verifying the import.<\/p>\n\n\n\n

      There should be tables in the column to the left in phpMyAdmin, confirming a successful import.<\/p>\n\n\n\n

      Now, it is important to backup your database if your website is using a database.<\/p>\n\n\n\n

      Let us look at how to back up this database with these following steps;<\/p>\n\n\n\n

      How to backup the database<\/h3>\n\n\n\n

      Step 1.<\/strong> Click on the name of the database you wish to export.<\/p>\n\n\n\n

      Step 2.<\/strong> Click on the \u2018Export\u2019 <\/strong>option.<\/p>\n\n\n\n

      Step 3.<\/strong> Choose ‘Custom \u2013 display all possible options\u2019<\/strong><\/p>\n\n\n\n

      Step 4.<\/strong> Select the tables you wish to export. Selecting all the tables is recommended. <\/em><\/p>\n\n\n\n

      Step 5.<\/strong> Scroll down to Format- specific option<\/em><\/strong> and find \u2018Object creation options\u2019<\/strong>. <\/em>Check the box next to \u2018Add DROP TABLE\/ VIEW\/ PROCEDURE\/ FUNCTION\/ EVENT statement\u2019<\/strong>.<\/p>\n\n\n\n

      Step 6.<\/strong> Click on the \u2018Go\u2019<\/strong> option.<\/p>\n\n\n\n

      The exported tables will be saved as a file, named _.sql<\/em><\/strong>. You can <\/em>always import this file back into the database as required.<\/p>\n","protected":false},"excerpt":{"rendered":"

      PhpMyAdmin is a graphical interface, an open-source tool pre-installed with your hosting subscription. You can wade through your database to make preferred changes. All the data on your website is stored in a database. For example, all your posts and articles, including, the comments are stored by WordPress in a database. Note- It is not possible […]<\/p>\n","protected":false},"author":7,"featured_media":732,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-727","post","type-post","status-publish","format-standard","has-post-thumbnail","category-general","entry"],"featured_image_src":"https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2020\/07\/PhpMyAdmin-Logo.wine_.png","featured_image_src_square":"https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2020\/07\/PhpMyAdmin-Logo.wine_.png","author_info":{"display_name":"Nikitha S.","author_link":"https:\/\/blog.hostingspell.com\/author\/nikitha\/"},"uagb_featured_image_src":{"full":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2020\/07\/PhpMyAdmin-Logo.wine_.png",3000,2000,false],"thumbnail":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2020\/07\/PhpMyAdmin-Logo.wine_-150x150.png",150,150,true],"medium":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2020\/07\/PhpMyAdmin-Logo.wine_-300x200.png",300,200,true],"medium_large":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2020\/07\/PhpMyAdmin-Logo.wine_-768x512.png",768,512,true],"large":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2020\/07\/PhpMyAdmin-Logo.wine_-1024x683.png",1024,683,true],"1536x1536":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2020\/07\/PhpMyAdmin-Logo.wine_-1536x1024.png",1536,1024,true],"2048x2048":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2020\/07\/PhpMyAdmin-Logo.wine_-2048x1365.png",2048,1365,true],"single-featured-image":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2020\/07\/PhpMyAdmin-Logo.wine_-1200x385.png",1200,385,true],"blog-featured-image":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2020\/07\/PhpMyAdmin-Logo.wine_-680x290.png",680,290,true],"home-featured":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2020\/07\/PhpMyAdmin-Logo.wine_-380x570.png",380,570,true],"ab-block-post-grid-landscape":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2020\/07\/PhpMyAdmin-Logo.wine_.png",600,400,false],"ab-block-post-grid-square":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2020\/07\/PhpMyAdmin-Logo.wine_.png",600,400,false],"author-pro-image":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2020\/07\/PhpMyAdmin-Logo.wine_.png",360,240,false],"gb-block-post-grid-landscape":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2020\/07\/PhpMyAdmin-Logo.wine_.png",600,400,false],"gb-block-post-grid-square":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2020\/07\/PhpMyAdmin-Logo.wine_.png",600,400,false]},"uagb_author_info":{"display_name":"Nikitha S.","author_link":"https:\/\/blog.hostingspell.com\/author\/nikitha\/"},"uagb_comment_info":0,"uagb_excerpt":"PhpMyAdmin is a graphical interface, an open-source tool pre-installed with your hosting subscription. You can wade through your database to make preferred changes. All the data on your website is stored in a database. For example, all your posts and articles, including, the comments are stored by WordPress in a database. Note- It is not possible…","_links":{"self":[{"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/posts\/727","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/comments?post=727"}],"version-history":[{"count":0,"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/posts\/727\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/media\/732"}],"wp:attachment":[{"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/media?parent=727"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/categories?post=727"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/tags?post=727"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}