{"id":1096,"date":"2019-11-28T11:10:08","date_gmt":"2019-11-28T11:10:08","guid":{"rendered":"https:\/\/sectigostore.com\/page\/?p=1096"},"modified":"2019-12-26T10:58:54","modified_gmt":"2019-12-26T10:58:54","slug":"how-to-backup-mysql-database-on-linux-ubuntu","status":"publish","type":"post","link":"https:\/\/sectigostore.com\/page\/how-to-backup-mysql-database-on-linux-ubuntu\/","title":{"rendered":"How to Back Up a MySQL Database on Linux \/ Ubuntu?"},"content":{"rendered":"\n<p>Creating backups to increase your site\u2019s redundancy is a smart move in the face of a disaster. This is why most website admins build and download an offline version of their website data every single day for recovery. However, this traditional method of doing things has two major drawbacks. For one, it\u2019s effort-intensive (i.e., not lazy-proof), and two, you lose all your recent data if your website crashes before you have a chance to create your daily backup! <\/p>\n\n\n\n<p>In this article, we\u2019ll look at how to back up\nyour website\u2019s backend MySQL database in Linux or Ubuntu. But for those of you who\nare looking for a more elegant solution, we will also cover automated backups.\nWith automation, once you set it up, you don\u2019t need to worry about that one\ntime you forgot to create a backup or pushing all changes made to your website\nonto the recovery copy. It takes care of it for you!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Backup MySQL Database on Linux\/Ubuntu<\/strong><\/h2>\n\n\n\n<p>MySQL provides a command-line utility, mysqldump, that can be utilized to create backups by exporting databases as raw SQL files. You can run the command manually every day or install an automation script, like automysql backup, that will do it for you on a daily basis.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Use the mysqldump Command:<\/strong><\/li><\/ul>\n\n\n\n<p>From your\nterminal, without logging into your MySQL console, execute the command using\nthe basic syntax:<\/p>\n\n\n\n<p class=\"code\"><code>$ mysqldump -u [username] -p[password] [database_name] &gt; [backup_file_name].sql<\/code><\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Note that there is no space between -p and the password you input.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Back-Up a Single Table<\/strong><\/li><\/ul>\n\n\n\n<p>You can also back up the data of an individual table directly onto a text file using the general syntax mentioned below: <\/p>\n\n\n\n<p class=\"code\"><code>Select * Into Outfile 'table_backup_file' From name_of_table;<\/code><\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Restore MySQL Database:<\/strong><\/li><\/ul>\n\n\n\n<p>To restore your database from the backup you created in the previous step, log in to MySQL console by entering your credentials: <\/p>\n\n\n\n<p class=\"code\"> <code>$ <\/code><strong><code>mysql -u<\/code><\/strong><code> [username] <\/code><strong><code>-p<\/code><\/strong><\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Once you\u2019re logged in, type the\nfollowing command to restore the database, modifying the parameters as\nrequired: <\/p>\n\n\n\n<p class=\"code\"><code>$ <\/code><strong><code>mysql -u<\/code><\/strong><code> [username] <\/code><strong><code>-p<\/code><\/strong><code>[password] [database_name] <\/code><strong><code>&lt;<\/code><\/strong><code> [backup_name].sql<\/code> <\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Automate the Backup Process:<\/strong><\/li><\/ul>\n\n\n\n<p>To automatically back up your database, you will first need to install the <a href=\"https:\/\/www.linux.com\/tutorials\/how-do-painless-mysql-server-backups-automysqlbackup\/\">automysqlbackup<\/a> package. To do this, use the following command: <\/p>\n\n\n\n<p class=\"code\"><code>$ sudo apt-get install automysqlbackup<\/code> <\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>The script will run automatically on\na daily basis, and backups will be stored under the \u201c\/var\/lib\/automysqlbackup\u201d\ndirectory. Additionally, you can create a <a href=\"https:\/\/serverpilot.io\/docs\/how-to-use-cron-to-schedule-scripts\">crontab<\/a>\nentry to run automysqlbackup at any particular time.<\/p>\n\n\n\n<p>To view the\ncontents of the <strong>daily backup folder,<\/strong> run the following command:<\/p>\n\n\n\n<p class=\"code\"><code>$ sudo ls -a \/var\/lib\/automysqlbackup\/daily<\/code> <\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>If you\u2019d like to modify any configurations or add customizations to the utility, you can edit the file located at \u201c\/etc\/default\/automysqlbackup\u201d by executing the command below: <\/p>\n\n\n\n<p class=\"code\"><code>$ sudo nano \/etc\/default\/automysqlbackup<\/code> <\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>To create <strong>on-demand backups<\/strong>, run the command manually, as shown below: <\/p>\n\n\n\n<p class=\"code\"><code>$ sudo automysqlbackup <\/code><\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>CodeGuard\nWebsite Backup &amp; Restore<\/strong><\/h2>\n\n\n\n<p>As an automated backup solution for website data, CodeGuard safeguards you from experiencing massive downtime for issues related to data loss. It acts like an undo button or an autosave checkpoint in a game, except it works for your website and associated databases. In case of any buggy developmental updates, crashes, etc., you can revert to the last clean version with a single click. <\/p>\n\n\n\n<p>Let\u2019s look at how to back up your MySQL\nDatabase using CodeGuard:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How to Automatically Schedule Your Backups with CodeGuard<\/h2>\n\n\n\n<p>CodeGuard can back up your site either\nthrough FTP\/SFTP or using a <a href=\"https:\/\/codeguard.zendesk.com\/hc\/en-us\/articles\/115000621403-How-do-I-install-the-WordPress-plugin-\">WordPress\nplugin<\/a>. You can set it up to back up a few files, copy the entire website,\nor only make a copy of the data that has changed.<\/p>\n\n\n\n<div class=\"graysection\">\n<h2>Get CodeGuard for Only $1.63\/Month!<\/h2>\n<p>Schedule Automatic FTP Backup with CodeGuard. Buy it Today and Save Up to 50% With SectigoStore! <\/p>\n<a class=\"greenbutton\" style=\"text-decoration: none;\" href=\"https:\/\/sectigostore.com\/codeguard\/backup\">Shop Now<\/a>\n<\/div>\n\n\n\n<p>Login to your CodeGuard Dashboard and follow the steps below:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 1: Choose Your Backup Option<\/strong><\/h2>\n\n\n\n<p>You can add a website to back up using a WordPress plugin or via FTP. You can use either, but it is recommended to use the FTP\/SFTP option.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"379\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/add-website-codegaurd-1024x379.png\" alt=\"Add a website in codeguard\" class=\"wp-image-1097\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/add-website-codegaurd-1024x379.png 1024w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/add-website-codegaurd-300x111.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/add-website-codegaurd-768x284.png 768w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/add-website-codegaurd.png 1121w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 2: Obtain the Required Information to Add Your Website<\/strong><\/h2>\n\n\n\n<p>For adding a website via FTP or SFTP, you\nwill need some information from your hosting provider such as: <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>the URL of the website you want to add, <\/li><li>the FTP or SFTP server, <\/li><li>user credentials, and <\/li><li>port number. <\/li><\/ul>\n\n\n\n<p>You can find this information under\nsettings in your hosting account. It\u2019s always recommended to use SFTP instead\nof FTP whenever possible, as it\u2019s more secure.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"742\" height=\"871\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/add-your-website.png\" alt=\"Add your website\" class=\"wp-image-1098\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/add-your-website.png 742w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/add-your-website-256x300.png 256w\" sizes=\"auto, (max-width: 742px) 100vw, 742px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 3: Select Your Root Directory<\/strong><\/h2>\n\n\n\n<p>If the connection is successful, the next\nstep takes you to the Capture Your Code window, where you must select or\nmanually specify your root directory. Next, press <strong>Select Root Directory<\/strong>.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"767\" height=\"572\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/capture-your-code.png\" alt=\"Capture your directory\" class=\"wp-image-1099\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/capture-your-code.png 767w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/capture-your-code-300x224.png 300w\" sizes=\"auto, (max-width: 767px) 100vw, 767px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 4: Select the Contents to Backup<\/strong><\/h2>\n\n\n\n<p>Once that\u2019s done, select the website\ncontent (specific files and folders) that you would like to back up and click <strong>Begin\nFirst Backup<\/strong>. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"747\" height=\"472\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/take-your-first-backup.png\" alt=\"take your first backup\" class=\"wp-image-1100\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/take-your-first-backup.png 747w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/take-your-first-backup-300x190.png 300w\" sizes=\"auto, (max-width: 747px) 100vw, 747px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 5: Add a Database from the Completion Window<\/strong><\/h2>\n\n\n\n<p>Once your first\nbackup is complete, you will be taken to the completion window. From here, you\ncan add a database to back it up, or you can also do it from your website\ndashboard. <\/p>\n\n\n\n<p><em>Note: You\ncannot add a database without adding a website first.<\/em><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"545\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/codeguard-1024x545.png\" alt=\"codeguard\" class=\"wp-image-1101\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/codeguard-1024x545.png 1024w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/codeguard-300x160.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/codeguard-768x408.png 768w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/codeguard.png 1416w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 6: Get Database Details<\/strong><\/h2>\n\n\n\n<p>To add a database,\nyou will need: <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>a database name, <\/li><li>MySQL hostname or IP, <\/li><li>your username, <\/li><li>your password and <\/li><li>the port number. <\/li><\/ul>\n\n\n\n<p>If you are unable\nto find this information in your hosting account, please contact the CodeGuard\nsupport team to help you with the details. The default port number for MySQL is\n3306. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 7: Enter Database Credentials and Test Connection<\/strong><\/h2>\n\n\n\n<p>Access your\nCodeGuard dashboard and select the website for which you wish to add a\ndatabase. This step will take you to the website\u2019s dashboard. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"985\" height=\"905\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/access-your-website.png\" alt=\"Access your website\" class=\"wp-image-1102\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/access-your-website.png 985w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/access-your-website-300x276.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/access-your-website-768x706.png 768w\" sizes=\"auto, (max-width: 985px) 100vw, 985px\" \/><\/figure><\/div>\n\n\n\n<p>On the website dashboard, you will find an\noption to add your database. Once you click on it, you will be taken to the\ntest database connection page where you need to enter your database\u2019s IP or\nhostname.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"941\" height=\"740\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/file-backup-summery.png\" alt=\"\" class=\"wp-image-1103\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/file-backup-summery.png 941w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/file-backup-summery-300x236.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/file-backup-summery-768x604.png 768w\" sizes=\"auto, (max-width: 941px) 100vw, 941px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"708\" height=\"600\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/test-connection.png\" alt=\"Test Connection\" class=\"wp-image-1104\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/test-connection.png 708w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/test-connection-300x254.png 300w\" sizes=\"auto, (max-width: 708px) 100vw, 708px\" \/><\/figure><\/div>\n\n\n\n<p>Enter the credentials to access your database.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"608\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/add-credentials-1024x608.png\" alt=\"Add credentials\" class=\"wp-image-1105\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/add-credentials-1024x608.png 1024w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/add-credentials-300x178.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/add-credentials-768x456.png 768w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/add-credentials.png 1090w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p>In the next section, select the databases you want to add, click on <strong>Add Databases<\/strong>, and you\u2019re done! <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"995\" height=\"761\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/databases-status.png\" alt=\"Databases status\" class=\"wp-image-1106\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/databases-status.png 995w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/databases-status-300x229.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/databases-status-768x587.png 768w\" sizes=\"auto, (max-width: 995px) 100vw, 995px\" \/><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Creating backups to increase your site\u2019s redundancy is a smart move in the face of a disaster. This is why most website admins build and download an offline version of their website data every single day for recovery. However, this traditional method of doing things has two major drawbacks. For one, it\u2019s effort-intensive (i.e., not lazy-proof), and two, you lose all your recent data if your website crashes before you have a chance to create your daily backup! In this article, we\u2019ll look at how to back up your website\u2019s <a href=\"https:\/\/sectigostore.com\/page\/how-to-backup-mysql-database-on-linux-ubuntu\/\" class=\"more-link\">Continue Reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[],"class_list":["post-1096","post","type-post","status-publish","format-standard","hentry","category-codeguard"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Back Up a MySQL Database on Linux \/ Ubuntu?<\/title>\n<meta name=\"description\" content=\"A complete step-by-step guide on how to backup MySQL Database on Linux Ubuntu. Read and start taking your databases backup now.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sectigostore.com\/page\/how-to-backup-mysql-database-on-linux-ubuntu\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Back Up a MySQL Database on Linux \/ Ubuntu?\" \/>\n<meta property=\"og:description\" content=\"A complete step-by-step guide on how to backup MySQL Database on Linux Ubuntu. Read and start taking your databases backup now.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sectigostore.com\/page\/how-to-backup-mysql-database-on-linux-ubuntu\/\" \/>\n<meta property=\"og:site_name\" content=\"SectigoStore\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/sectigostore\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-28T11:10:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-26T10:58:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/add-website-codegaurd-1024x379.png\" \/>\n<meta name=\"author\" content=\"sectigostorepages\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sectigostore\" \/>\n<meta name=\"twitter:site\" content=\"@sectigostore\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sectigostorepages\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-backup-mysql-database-on-linux-ubuntu\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-backup-mysql-database-on-linux-ubuntu\\\/\"},\"author\":{\"name\":\"sectigostorepages\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/#\\\/schema\\\/person\\\/f38f303abd42ade13a74a5d3c12b1cec\"},\"headline\":\"How to Back Up a MySQL Database on Linux \\\/ Ubuntu?\",\"datePublished\":\"2019-11-28T11:10:08+00:00\",\"dateModified\":\"2019-12-26T10:58:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-backup-mysql-database-on-linux-ubuntu\\\/\"},\"wordCount\":987,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-backup-mysql-database-on-linux-ubuntu\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/add-website-codegaurd-1024x379.png\",\"articleSection\":[\"CodeGuard\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-backup-mysql-database-on-linux-ubuntu\\\/\",\"url\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-backup-mysql-database-on-linux-ubuntu\\\/\",\"name\":\"How to Back Up a MySQL Database on Linux \\\/ Ubuntu?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-backup-mysql-database-on-linux-ubuntu\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-backup-mysql-database-on-linux-ubuntu\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/add-website-codegaurd-1024x379.png\",\"datePublished\":\"2019-11-28T11:10:08+00:00\",\"dateModified\":\"2019-12-26T10:58:54+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/#\\\/schema\\\/person\\\/f38f303abd42ade13a74a5d3c12b1cec\"},\"description\":\"A complete step-by-step guide on how to backup MySQL Database on Linux Ubuntu. Read and start taking your databases backup now.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-backup-mysql-database-on-linux-ubuntu\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-backup-mysql-database-on-linux-ubuntu\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-backup-mysql-database-on-linux-ubuntu\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/add-website-codegaurd.png\",\"contentUrl\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/add-website-codegaurd.png\",\"width\":1121,\"height\":415},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-backup-mysql-database-on-linux-ubuntu\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"SSL Resources\",\"item\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CodeGuard\",\"item\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/codeguard\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Back Up a MySQL Database on Linux \\\/ Ubuntu?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/#website\",\"url\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/\",\"name\":\"SectigoStore\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/#\\\/schema\\\/person\\\/f38f303abd42ade13a74a5d3c12b1cec\",\"name\":\"sectigostorepages\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/78239165ecb118435d2709ba4dd124dd9151b1f6b069f87258c6514fe3728c7e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/78239165ecb118435d2709ba4dd124dd9151b1f6b069f87258c6514fe3728c7e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/78239165ecb118435d2709ba4dd124dd9151b1f6b069f87258c6514fe3728c7e?s=96&d=mm&r=g\",\"caption\":\"sectigostorepages\"},\"url\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/author\\\/sectigostorepages\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Back Up a MySQL Database on Linux \/ Ubuntu?","description":"A complete step-by-step guide on how to backup MySQL Database on Linux Ubuntu. Read and start taking your databases backup now.","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:\/\/sectigostore.com\/page\/how-to-backup-mysql-database-on-linux-ubuntu\/","og_locale":"en_US","og_type":"article","og_title":"How to Back Up a MySQL Database on Linux \/ Ubuntu?","og_description":"A complete step-by-step guide on how to backup MySQL Database on Linux Ubuntu. Read and start taking your databases backup now.","og_url":"https:\/\/sectigostore.com\/page\/how-to-backup-mysql-database-on-linux-ubuntu\/","og_site_name":"SectigoStore","article_publisher":"https:\/\/www.facebook.com\/sectigostore\/","article_published_time":"2019-11-28T11:10:08+00:00","article_modified_time":"2019-12-26T10:58:54+00:00","og_image":[{"url":"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/add-website-codegaurd-1024x379.png","type":"","width":"","height":""}],"author":"sectigostorepages","twitter_card":"summary_large_image","twitter_creator":"@sectigostore","twitter_site":"@sectigostore","twitter_misc":{"Written by":"sectigostorepages","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sectigostore.com\/page\/how-to-backup-mysql-database-on-linux-ubuntu\/#article","isPartOf":{"@id":"https:\/\/sectigostore.com\/page\/how-to-backup-mysql-database-on-linux-ubuntu\/"},"author":{"name":"sectigostorepages","@id":"https:\/\/sectigostore.com\/page\/#\/schema\/person\/f38f303abd42ade13a74a5d3c12b1cec"},"headline":"How to Back Up a MySQL Database on Linux \/ Ubuntu?","datePublished":"2019-11-28T11:10:08+00:00","dateModified":"2019-12-26T10:58:54+00:00","mainEntityOfPage":{"@id":"https:\/\/sectigostore.com\/page\/how-to-backup-mysql-database-on-linux-ubuntu\/"},"wordCount":987,"commentCount":0,"image":{"@id":"https:\/\/sectigostore.com\/page\/how-to-backup-mysql-database-on-linux-ubuntu\/#primaryimage"},"thumbnailUrl":"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/add-website-codegaurd-1024x379.png","articleSection":["CodeGuard"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/sectigostore.com\/page\/how-to-backup-mysql-database-on-linux-ubuntu\/","url":"https:\/\/sectigostore.com\/page\/how-to-backup-mysql-database-on-linux-ubuntu\/","name":"How to Back Up a MySQL Database on Linux \/ Ubuntu?","isPartOf":{"@id":"https:\/\/sectigostore.com\/page\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sectigostore.com\/page\/how-to-backup-mysql-database-on-linux-ubuntu\/#primaryimage"},"image":{"@id":"https:\/\/sectigostore.com\/page\/how-to-backup-mysql-database-on-linux-ubuntu\/#primaryimage"},"thumbnailUrl":"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/add-website-codegaurd-1024x379.png","datePublished":"2019-11-28T11:10:08+00:00","dateModified":"2019-12-26T10:58:54+00:00","author":{"@id":"https:\/\/sectigostore.com\/page\/#\/schema\/person\/f38f303abd42ade13a74a5d3c12b1cec"},"description":"A complete step-by-step guide on how to backup MySQL Database on Linux Ubuntu. Read and start taking your databases backup now.","breadcrumb":{"@id":"https:\/\/sectigostore.com\/page\/how-to-backup-mysql-database-on-linux-ubuntu\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sectigostore.com\/page\/how-to-backup-mysql-database-on-linux-ubuntu\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sectigostore.com\/page\/how-to-backup-mysql-database-on-linux-ubuntu\/#primaryimage","url":"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/add-website-codegaurd.png","contentUrl":"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/11\/add-website-codegaurd.png","width":1121,"height":415},{"@type":"BreadcrumbList","@id":"https:\/\/sectigostore.com\/page\/how-to-backup-mysql-database-on-linux-ubuntu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"SSL Resources","item":"https:\/\/sectigostore.com\/page\/"},{"@type":"ListItem","position":2,"name":"CodeGuard","item":"https:\/\/sectigostore.com\/page\/codeguard\/"},{"@type":"ListItem","position":3,"name":"How to Back Up a MySQL Database on Linux \/ Ubuntu?"}]},{"@type":"WebSite","@id":"https:\/\/sectigostore.com\/page\/#website","url":"https:\/\/sectigostore.com\/page\/","name":"SectigoStore","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sectigostore.com\/page\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/sectigostore.com\/page\/#\/schema\/person\/f38f303abd42ade13a74a5d3c12b1cec","name":"sectigostorepages","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/78239165ecb118435d2709ba4dd124dd9151b1f6b069f87258c6514fe3728c7e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/78239165ecb118435d2709ba4dd124dd9151b1f6b069f87258c6514fe3728c7e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/78239165ecb118435d2709ba4dd124dd9151b1f6b069f87258c6514fe3728c7e?s=96&d=mm&r=g","caption":"sectigostorepages"},"url":"https:\/\/sectigostore.com\/page\/author\/sectigostorepages\/"}]}},"_links":{"self":[{"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/posts\/1096","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/comments?post=1096"}],"version-history":[{"count":0,"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/posts\/1096\/revisions"}],"wp:attachment":[{"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/media?parent=1096"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/categories?post=1096"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/tags?post=1096"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}