{"id":13526,"date":"2019-11-12T07:09:00","date_gmt":"2019-11-12T07:09:00","guid":{"rendered":"https:\/\/dbtut.com\/?p=13526"},"modified":"2019-11-12T07:09:01","modified_gmt":"2019-11-12T07:09:01","slug":"how-to-backup-mysql-databases-with-mysqldump","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/","title":{"rendered":"How To Backup MySQL Databases With mysqldump"},"content":{"rendered":"<p>Mysql database should be backed up daily or periodically. It is possible to back up regularly with a script that we will create in the operating system for the backup process. We can use the mysqldump tool for backup.<\/p>\n<p>We can create and schedule a shell script like the one below.<\/p>\n<h1>Backup All MySQL Databases<\/h1>\n<p>Create a script named mysql_backup.sh with the following content. The script will create a backup file for all databases.<\/p>\n<pre class=\"lang:default decode:true \">#! \/bin\/bash\n \nTIMESTAMP=$(date +\"%F\")\nBACKUP_DIR=\"\/backup\"\nMYSQL_USER=\"root\"\nMYSQL=\/usr\/bin\/mysql\nMYSQL_PASSWORD=\"root_password\"\nMYSQLDUMP=\/usr\/bin\/mysqldump\n \nmkdir -p \"$BACKUP_DIR\/$TIMESTAMP\"\n \ndatabases=`$MYSQL --user=$MYSQL_USER -p$MYSQL_PASSWORD -e \"SHOW DATABASES;\" | grep -Ev \"(Database|information_schema|performance_schema|oldiblog|ndbinfo|ndb_2_fs|backup)\"`\n \nfor db in $databases; do\n  $MYSQLDUMP --force --opt --user=$MYSQL_USER -p$MYSQL_PASSWORD --databases $db | gzip &gt; \"$BACKUP_DIR\/mysql\/$db.gz\"\ndone\n\n\n# delete backups created before 7 days\nfind $BACKUP_DIR -ctime +7 -type f -delete<\/pre>\n<p>Let&#8217;s make the script executable.<\/p>\n<pre class=\"lang:default decode:true \">chmod 755 mysql_backup.sh<\/pre>\n<h2>mysqldump Exclude Database<\/h2>\n<p>With the grep -Ev command, we can specify directories that are not associated with the database in the data directory, or databases that we do not want to back up.<\/p>\n<h2>Create a Crontab For Backing up Databases Regularly<\/h2>\n<p>FAdd the script to crontab to back it up periodically.<\/p>\n<pre class=\"lang:default decode:true \">[root@mysqldb1 mysql]# crontab -e\n\n0 0 * * * \/root\/scripts\/mysql_backup.sh<\/pre>\n<pre class=\"lang:default decode:true \">[root@mysqldb1 mysql]# crontab -l\n0 0 * * * \/root\/scripts\/mysql_backup.sh<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13526\" class=\"pvc_stats all  \" data-element-id=\"13526\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Mysql database should be backed up daily or periodically. It is possible to back up regularly with a script that we will create in the operating system for the backup process. We can use the mysqldump tool for backup. We can create and schedule a shell script like the one below. Backup All MySQL Databases &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13526\" class=\"pvc_stats all  \" data-element-id=\"13526\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":13528,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[1],"tags":[5468,5462,5466,5465,5464,5481,5467,5474,5471,5463,5472,5473,5479,5478,5476,5477,5480,5475,5470,5469],"class_list":["post-13526","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-uncategorized","tag-any-option-for-mysqldump-to-ignore-databases-for-backup","tag-backup-all-mysql-databases","tag-backup-mysql-database","tag-backup-mysql-databases","tag-backup-mysql-databases-with-mysqldump","tag-create-a-crontab-for-backing-up-databases-regularly","tag-exclude-a-database-from-backup-mysql","tag-exclude-database-mysqldump","tag-how-do-i-backup-multiple-mysql-databases","tag-how-to-backup-mysql-databases","tag-how-to-mysqldump-all-databases-excluding","tag-ignore-database-mysqldump","tag-mysqldump-exclude-database","tag-mysqldump-ignore-database","tag-mysqldump-ignore-database-name","tag-mysqldump-ignore-mysql-database","tag-mysqldump-skip-database","tag-skip-database-mysqldump","tag-what-is-mysqldump-in-mysql","tag-which-database-is-ignored-by-mysqldump-while-dumping-a-collection-of-databases-for-backup"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Backup MySQL Databases With mysqldump - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Backup MySQL Databases With mysqldump\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Backup MySQL Databases With mysqldump - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Backup MySQL Databases With mysqldump\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-12T07:09:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-12T07:09:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-16.png\" \/>\n\t<meta property=\"og:image:width\" content=\"622\" \/>\n\t<meta property=\"og:image:height\" content=\"326\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Backup MySQL Databases With mysqldump\",\"datePublished\":\"2019-11-12T07:09:00+00:00\",\"dateModified\":\"2019-11-12T07:09:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/\"},\"wordCount\":142,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-16.png\",\"keywords\":[\"Any option for mysqldump to ignore databases for backup\",\"Backup All MySQL Databases\",\"Backup MySQL Database\",\"Backup MySQL Databases\",\"Backup MySQL Databases With mysqldump\",\"Create a Crontab For Backing up Databases Regularly\",\"Exclude a database From Backup MySQL\",\"exclude database mysqldump\",\"How do I backup multiple MySQL databases?\",\"How To Backup MySQL Databases\",\"How to mysqldump All Databases Excluding\",\"ignore database mysqldump\",\"mysqldump exclude database\",\"mysqldump ignore database\",\"mysqldump ignore database name\",\"mysqldump ignore mysql database\",\"mysqldump skip database\",\"skip database mysqldump\",\"What is Mysqldump in MySQL?\",\"Which database is ignored by Mysqldump while dumping a collection of databases for backup?\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/\",\"name\":\"How To Backup MySQL Databases With mysqldump - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-16.png\",\"datePublished\":\"2019-11-12T07:09:00+00:00\",\"dateModified\":\"2019-11-12T07:09:01+00:00\",\"description\":\"How To Backup MySQL Databases With mysqldump\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-16.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-16.png\",\"width\":622,\"height\":326},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Backup MySQL Databases With mysqldump\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Backup MySQL Databases With mysqldump - Database Tutorials","description":"How To Backup MySQL Databases With mysqldump","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:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/","og_locale":"en_US","og_type":"article","og_title":"How To Backup MySQL Databases With mysqldump - Database Tutorials","og_description":"How To Backup MySQL Databases With mysqldump","og_url":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/","og_site_name":"Database Tutorials","article_published_time":"2019-11-12T07:09:00+00:00","article_modified_time":"2019-11-12T07:09:01+00:00","og_image":[{"width":622,"height":326,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-16.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Backup MySQL Databases With mysqldump","datePublished":"2019-11-12T07:09:00+00:00","dateModified":"2019-11-12T07:09:01+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/"},"wordCount":142,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-16.png","keywords":["Any option for mysqldump to ignore databases for backup","Backup All MySQL Databases","Backup MySQL Database","Backup MySQL Databases","Backup MySQL Databases With mysqldump","Create a Crontab For Backing up Databases Regularly","Exclude a database From Backup MySQL","exclude database mysqldump","How do I backup multiple MySQL databases?","How To Backup MySQL Databases","How to mysqldump All Databases Excluding","ignore database mysqldump","mysqldump exclude database","mysqldump ignore database","mysqldump ignore database name","mysqldump ignore mysql database","mysqldump skip database","skip database mysqldump","What is Mysqldump in MySQL?","Which database is ignored by Mysqldump while dumping a collection of databases for backup?"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/","url":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/","name":"How To Backup MySQL Databases With mysqldump - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-16.png","datePublished":"2019-11-12T07:09:00+00:00","dateModified":"2019-11-12T07:09:01+00:00","description":"How To Backup MySQL Databases With mysqldump","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-16.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-16.png","width":622,"height":326},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/12\/how-to-backup-mysql-databases-with-mysqldump\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Backup MySQL Databases With mysqldump"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13526","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=13526"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13526\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/13528"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=13526"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=13526"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=13526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}