{"id":993,"date":"2015-06-04T11:32:14","date_gmt":"2015-06-04T09:32:14","guid":{"rendered":"http:\/\/fougere.myds.me:8080\/info\/?p=993"},"modified":"2015-06-04T11:32:14","modified_gmt":"2015-06-04T09:32:14","slug":"my_coldbackup_database-sh","status":"publish","type":"post","link":"http:\/\/les-fougs.com\/wordpress\/2015\/06\/04\/my_coldbackup_database-sh\/","title":{"rendered":"my_coldbackup_database.sh"},"content":{"rendered":"<pre>w_date=$(date '+%Y_%m_%d_%H_%M_%S')<\/pre>\n<pre># avec generation log\n# su mysql --command=\"mysqlbackup --user=root --password=motdepasse --ibbackup=\/opt\/mysql\/meb-3.5\/bin\/ibbackup \/etc\/mysql\/my.cnf \/data\/backups\/mysql\" &gt; \/exploit\/logs\/my-backup-${w_date}.log<\/pre>\n<pre># sans log pour remonter dans VTOM\nsu mysql --command=\"mysqlbackup --user=root --password=motdepasse --ibbackup=\/opt\/mysql\/meb-3.5\/bin\/ibbackup \/etc\/mysql\/my.cnf \/data\/backups\/mysql\"<\/pre>\n<pre>[root@pdtb2 scripts]# cat my_coldbackup_database.sh\n#w_date=$(date '+%Y_%m_%d_%H_%M_%S')\nw_date=$(date '+%A')<\/pre>\n<pre>BACKUPDIR=\/data\/backups\/mysql\/${w_date}_coldbackup\nDATADIR=\/data\/mysql<\/pre>\n<pre>echo \"rm -rf $BACKUPDIR\"\nrm -rf $BACKUPDIR<\/pre>\n<pre>echo \"stop mysql database\"\n\/exploit\/scripts\/my_stop_database.sh<\/pre>\n<pre>su mysql --command=\"mkdir $BACKUPDIR\"<\/pre>\n<pre>echo \"copy my.cnf\"\ncp -p \/etc\/mysql\/my.cnf $BACKUPDIR\/<\/pre>\n<pre>echo \"copy database sans compression\"\ntime cp -rp $DATADIR\/ $BACKUPDIR\/<\/pre>\n<pre>echo \"start mysql database\"\n\/exploit\/scripts\/my_start_database.sh<\/pre>\n<pre>sleep 120<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>w_date=$(date &lsquo;+%Y_%m_%d_%H_%M_%S&rsquo;) # avec generation log # su mysql &#8211;command=&nbsp;&raquo;mysqlbackup &#8211;user=root &#8211;password=motdepasse &#8211;ibbackup=\/opt\/mysql\/meb-3.5\/bin\/ibbackup \/etc\/mysql\/my.cnf \/data\/backups\/mysql&nbsp;&raquo; &gt; \/exploit\/logs\/my-backup-${w_date}.log # sans log pour remonter dans VTOM su mysql &#8211;command=&nbsp;&raquo;mysqlbackup &#8211;user=root &#8211;password=motdepasse &#8211;ibbackup=\/opt\/mysql\/meb-3.5\/bin\/ibbackup \/etc\/mysql\/my.cnf \/data\/backups\/mysql&nbsp;&raquo; [root@pdtb2 scripts]# cat my_coldbackup_database.sh #w_date=$(date &lsquo;+%Y_%m_%d_%H_%M_%S&rsquo;) w_date=$(date &lsquo;+%A&rsquo;) BACKUPDIR=\/data\/backups\/mysql\/${w_date}_coldbackup DATADIR=\/data\/mysql echo &laquo;&nbsp;rm -rf $BACKUPDIR&nbsp;&raquo; rm -rf $BACKUPDIR echo &laquo;&nbsp;stop mysql database&nbsp;&raquo; \/exploit\/scripts\/my_stop_database.sh su &hellip; <a href=\"http:\/\/les-fougs.com\/wordpress\/2015\/06\/04\/my_coldbackup_database-sh\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de &laquo;&nbsp;my_coldbackup_database.sh&nbsp;&raquo;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[53,35],"tags":[],"_links":{"self":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/993"}],"collection":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/comments?post=993"}],"version-history":[{"count":0,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/993\/revisions"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=993"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=993"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}