{"id":864,"date":"2018-03-03T23:02:28","date_gmt":"2018-03-03T23:02:28","guid":{"rendered":"https:\/\/webhostingplus.uk\/hosting\/?p=864"},"modified":"2018-03-03T23:02:28","modified_gmt":"2018-03-03T23:02:28","slug":"how-do-i-backup-mysql-database","status":"publish","type":"post","link":"https:\/\/webhostingplus.uk\/hosting\/how-do-i-backup-mysql-database\/","title":{"rendered":"How do I backup my MySQL database?"},"content":{"rendered":"<p>Backing up your MySQL database can be done in several ways: <\/p>\n<p>1. Using the backup tool from the Web Tools section.<br \/>\n2. Using phpMyAdmin web interface<br \/>\n3. Using command line through shell access<br \/>\n4. Using MySQL Workbench <\/p>\n<p><strong>(1) Using our backup tool<\/strong> <\/p>\n<p>Log into your Web Hosting Plus Control Panel and click on Web Tools. Click to configure MySQL Databases and click &#8216;Now&#8217; under backup database. Save this file to your local machine. <\/p>\n<p><strong>(2) Using phpMyAdmin<\/strong> <\/p>\n<p>Log into your Web Hosting Plus Control Panel and click on Web Tools. Click to configure MySQL Databases and choose the database that you want to manage. This will start phpMyAdmin. PhpMyAdmin can export your entire database by selecting the &#8220;Export&#8221; page. <\/p>\n<p>1. Select all tables<br \/>\n2. Select &#8220;Structure and data&#8221;<br \/>\n3. Select &#8220;Add drop table&#8221;<br \/>\n4. Select &#8220;Enclose table and field names with backquotes&#8221;<br \/>\n5. Select &#8220;Save as file&#8221;<br \/>\n6. Then click &#8220;Go&#8221; button <\/p>\n<p>You will be prompted to save the dump file on your computer. <\/p>\n<p><strong>(3) Using MySQL command line tools<\/strong> <\/p>\n<p>To use MySQL command line tools, you will need SSH access to be enabled on your hosting account. You can perform backup using the following command: <\/p>\n<p>mysqldump -h servername -u username -p &#8211;add-drop-table &#8211;create-options &#8211;skip-add-locks -e &#8211;set-charset &#8211;disable-keys -Q databasename > databasedump.sql <\/p>\n<p>To backup and compress your dump file: <\/p>\n<p>mysqldump -h servername -u username -p &#8211;add-drop-table &#8211;create-options -e &#8211;set-charset &#8211;skip-add-locks &#8211;disable-keys -Q databasename | gzip > databasedump.sql.gz <\/p>\n<p>The commands above will create the dump file in your current directory. You can download this backup file using scp or ftp for your archival purposes. If you perform this command in the public_html directory (or if you move the file into the public_html directory), you will be able to download this file from the web. <\/p>\n<p><strong>(4) You can download MySQL Workbench<\/strong> from <a href=\"http:\/\/wb.mysql.com\" rel=\"noopener\" target=\"_blank\">http:\/\/wb.mysql.com<\/a> &#8211; this will allow you to connect to the MySQL process on the server directly and create a local backup of the data. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Backing up your MySQL database can be done in several ways: 1. Using the backup tool from the Web Tools section. 2. Using phpMyAdmin web interface 3. Using command line through shell access 4. Using MySQL Workbench (1) Using our backup tool Log into your Web Hosting Plus Control Panel and click on Web Tools. &#8230; <a title=\"How do I backup my MySQL database?\" class=\"read-more\" href=\"https:\/\/webhostingplus.uk\/hosting\/how-do-i-backup-mysql-database\/\" aria-label=\"Read more about How do I backup my MySQL database?\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[],"class_list":["post-864","post","type-post","status-publish","format-standard","hentry","category-mysql-databases"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How do I backup my MySQL database? - Web Hosting Plus<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/webhostingplus.uk\/hosting\/how-do-i-backup-mysql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How do I backup my MySQL database? - Web Hosting Plus\" \/>\n<meta property=\"og:description\" content=\"Backing up your MySQL database can be done in several ways: 1. Using the backup tool from the Web Tools section. 2. Using phpMyAdmin web interface 3. Using command line through shell access 4. Using MySQL Workbench (1) Using our backup tool Log into your Web Hosting Plus Control Panel and click on Web Tools. ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/webhostingplus.uk\/hosting\/how-do-i-backup-mysql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting Plus\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-03T23:02:28+00:00\" \/>\n<meta name=\"author\" content=\"webhostingplus\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webhostingplus\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/how-do-i-backup-mysql-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/how-do-i-backup-mysql-database\\\/\"},\"author\":{\"name\":\"webhostingplus\",\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/#\\\/schema\\\/person\\\/ac818f1a9ee343e82657049f7c97c9dc\"},\"headline\":\"How do I backup my MySQL database?\",\"datePublished\":\"2018-03-03T23:02:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/how-do-i-backup-mysql-database\\\/\"},\"wordCount\":321,\"publisher\":{\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/#organization\"},\"articleSection\":[\"MySQL Databases\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/how-do-i-backup-mysql-database\\\/\",\"url\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/how-do-i-backup-mysql-database\\\/\",\"name\":\"How do I backup my MySQL database? - Web Hosting Plus\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/#website\"},\"datePublished\":\"2018-03-03T23:02:28+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/how-do-i-backup-mysql-database\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/how-do-i-backup-mysql-database\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/how-do-i-backup-mysql-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How do I backup my MySQL database?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/#website\",\"url\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/\",\"name\":\"Web Hosting Plus\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/#organization\",\"name\":\"Web Hosting Plus\",\"url\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/wp-content\\\/uploads\\\/Web-Hosting-Plus-Logo.png\",\"contentUrl\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/wp-content\\\/uploads\\\/Web-Hosting-Plus-Logo.png\",\"width\":339,\"height\":78,\"caption\":\"Web Hosting Plus\"},\"image\":{\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/#\\\/schema\\\/person\\\/ac818f1a9ee343e82657049f7c97c9dc\",\"name\":\"webhostingplus\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How do I backup my MySQL database? - Web Hosting Plus","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/webhostingplus.uk\/hosting\/how-do-i-backup-mysql-database\/","og_locale":"en_GB","og_type":"article","og_title":"How do I backup my MySQL database? - Web Hosting Plus","og_description":"Backing up your MySQL database can be done in several ways: 1. Using the backup tool from the Web Tools section. 2. Using phpMyAdmin web interface 3. Using command line through shell access 4. Using MySQL Workbench (1) Using our backup tool Log into your Web Hosting Plus Control Panel and click on Web Tools. ... Read more","og_url":"https:\/\/webhostingplus.uk\/hosting\/how-do-i-backup-mysql-database\/","og_site_name":"Web Hosting Plus","article_published_time":"2018-03-03T23:02:28+00:00","author":"webhostingplus","twitter_card":"summary_large_image","twitter_misc":{"Written by":"webhostingplus","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/webhostingplus.uk\/hosting\/how-do-i-backup-mysql-database\/#article","isPartOf":{"@id":"https:\/\/webhostingplus.uk\/hosting\/how-do-i-backup-mysql-database\/"},"author":{"name":"webhostingplus","@id":"https:\/\/webhostingplus.uk\/hosting\/#\/schema\/person\/ac818f1a9ee343e82657049f7c97c9dc"},"headline":"How do I backup my MySQL database?","datePublished":"2018-03-03T23:02:28+00:00","mainEntityOfPage":{"@id":"https:\/\/webhostingplus.uk\/hosting\/how-do-i-backup-mysql-database\/"},"wordCount":321,"publisher":{"@id":"https:\/\/webhostingplus.uk\/hosting\/#organization"},"articleSection":["MySQL Databases"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/webhostingplus.uk\/hosting\/how-do-i-backup-mysql-database\/","url":"https:\/\/webhostingplus.uk\/hosting\/how-do-i-backup-mysql-database\/","name":"How do I backup my MySQL database? - Web Hosting Plus","isPartOf":{"@id":"https:\/\/webhostingplus.uk\/hosting\/#website"},"datePublished":"2018-03-03T23:02:28+00:00","breadcrumb":{"@id":"https:\/\/webhostingplus.uk\/hosting\/how-do-i-backup-mysql-database\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/webhostingplus.uk\/hosting\/how-do-i-backup-mysql-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/webhostingplus.uk\/hosting\/how-do-i-backup-mysql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/webhostingplus.uk\/hosting\/"},{"@type":"ListItem","position":2,"name":"How do I backup my MySQL database?"}]},{"@type":"WebSite","@id":"https:\/\/webhostingplus.uk\/hosting\/#website","url":"https:\/\/webhostingplus.uk\/hosting\/","name":"Web Hosting Plus","description":"","publisher":{"@id":"https:\/\/webhostingplus.uk\/hosting\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/webhostingplus.uk\/hosting\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/webhostingplus.uk\/hosting\/#organization","name":"Web Hosting Plus","url":"https:\/\/webhostingplus.uk\/hosting\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/webhostingplus.uk\/hosting\/#\/schema\/logo\/image\/","url":"https:\/\/webhostingplus.uk\/hosting\/wp-content\/uploads\/Web-Hosting-Plus-Logo.png","contentUrl":"https:\/\/webhostingplus.uk\/hosting\/wp-content\/uploads\/Web-Hosting-Plus-Logo.png","width":339,"height":78,"caption":"Web Hosting Plus"},"image":{"@id":"https:\/\/webhostingplus.uk\/hosting\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/webhostingplus.uk\/hosting\/#\/schema\/person\/ac818f1a9ee343e82657049f7c97c9dc","name":"webhostingplus"}]}},"_links":{"self":[{"href":"https:\/\/webhostingplus.uk\/hosting\/wp-json\/wp\/v2\/posts\/864","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webhostingplus.uk\/hosting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webhostingplus.uk\/hosting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webhostingplus.uk\/hosting\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webhostingplus.uk\/hosting\/wp-json\/wp\/v2\/comments?post=864"}],"version-history":[{"count":0,"href":"https:\/\/webhostingplus.uk\/hosting\/wp-json\/wp\/v2\/posts\/864\/revisions"}],"wp:attachment":[{"href":"https:\/\/webhostingplus.uk\/hosting\/wp-json\/wp\/v2\/media?parent=864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webhostingplus.uk\/hosting\/wp-json\/wp\/v2\/categories?post=864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webhostingplus.uk\/hosting\/wp-json\/wp\/v2\/tags?post=864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}