{"id":6569,"date":"2022-08-20T22:16:19","date_gmt":"2022-08-20T21:16:19","guid":{"rendered":"https:\/\/solidt.eu\/site\/?p=6569"},"modified":"2024-03-04T22:25:12","modified_gmt":"2024-03-04T21:25:12","slug":"personal-mysql-backup","status":"publish","type":"post","link":"https:\/\/solidt.eu\/site\/personal-mysql-backup\/","title":{"rendered":"Personal Mysql Backup"},"content":{"rendered":"\n<div style=\"height: 250px; position:relative; margin-bottom: 50px;\" class=\"wp-block-simple-code-block-ace\"><pre class=\"wp-block-simple-code-block-ace\" style=\"position:absolute;top:0;right:0;bottom:0;left:0\" data-mode=\"sh\" data-theme=\"monokai\" data-fontsize=\"14\" data-lines=\"Infinity\" data-showlines=\"true\" data-copy=\"false\">#!\/bin\/bash\nuser=\"\"\npassword=\"\"\nhost=nx-mysql-2\ndir=$(dirname $0)\"\/$(date --iso-8601)_$host\"\nmysqldump=$(which mysqldump)\nmysql=$(which mysql)\n# --disable-ssl\ndatabases=`$mysql --host $host --port 3306 --ssl --user=$user --password=$password --batch --skip-column-names -e \"SHOW DATABASES;\" | grep -v 'mysql$\\|information_schema\\|performance_schema'`\n\n\nset -x #echo on\nmkdir -p $dir\n\nfor database in $databases; do\n    $mysqldump \\\n        --host $host \\\n        --ssl \\\n        --user=$user --password=$password \\\n        --force \\\n        --quote-names --dump-date \\\n        --opt --single-transaction \\\n        --events --routines --triggers \\\n        --databases $database \\\n        --result-file=\"$dir\/$database.sql\"\ndone\n\n# zip all files\n7z a -tzip \"$dir.zip\" $dir\n#rm -rf $dir\n<\/pre><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[20],"tags":[],"class_list":["post-6569","post","type-post","status-publish","format-standard","hentry","category-home-server"],"_links":{"self":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/6569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/comments?post=6569"}],"version-history":[{"count":4,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/6569\/revisions"}],"predecessor-version":[{"id":8348,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/6569\/revisions\/8348"}],"wp:attachment":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/media?parent=6569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/categories?post=6569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/tags?post=6569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}