{"id":908,"date":"2015-06-04T09:42:57","date_gmt":"2015-06-04T07:42:57","guid":{"rendered":"http:\/\/fougere.myds.me:8080\/info\/?p=908"},"modified":"2015-06-04T09:42:57","modified_gmt":"2015-06-04T07:42:57","slug":"my_backup_binlog-sh","status":"publish","type":"post","link":"http:\/\/les-fougs.com\/wordpress\/2015\/06\/04\/my_backup_binlog-sh\/","title":{"rendered":"my_backup_binlog.sh"},"content":{"rendered":"<pre>w_date=$(date '+%Y_%m_%d_%H_%M_%S')<\/pre>\n<pre>BINLOGPATH=\/data\/mysql\/databases\nBINLOGNAME=mysql-bin.index\nBACKUPDIR=\/data\/backups\/mysql\/${w_date}_binlog\n# sans log pour remonter dans VTOM\n#su mysql --command=\"mysqlbackup --user=root --password=zsxedc --ibbackup=\/opt\/mysql\/meb-3.5\/bin\/ibbackup \/etc\/mysql\/my.cnf \/data\/backups\/mysql\"<\/pre>\n<pre>echo \"Flush Logs\"\nmysql -pzsxedc --batch --skip-column-names --execute=\"flush logs\"<\/pre>\n<pre>echo \"Copying binlogs\"<\/pre>\n<pre>su mysql --command=\"mkdir $BACKUPDIR\"\nfor FILE in `cat $BINLOGPATH\/$BINLOGNAME`\ndo\nSFILE=(${FILE\/*\\\/\/})\n#echo \"$SFILE\"\nsu mysql --command=\"cp -p $BINLOGPATH\/$SFILE $BACKUPDIR\/\"\n#gzip $\/$SFILE\ndone<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>w_date=$(date &lsquo;+%Y_%m_%d_%H_%M_%S&rsquo;) BINLOGPATH=\/data\/mysql\/databases BINLOGNAME=mysql-bin.index BACKUPDIR=\/data\/backups\/mysql\/${w_date}_binlog # sans log pour remonter dans VTOM #su mysql &#8211;command=&nbsp;&raquo;mysqlbackup &#8211;user=root &#8211;password=zsxedc &#8211;ibbackup=\/opt\/mysql\/meb-3.5\/bin\/ibbackup \/etc\/mysql\/my.cnf \/data\/backups\/mysql&nbsp;&raquo; echo &laquo;&nbsp;Flush Logs&nbsp;&raquo; mysql -pzsxedc &#8211;batch &#8211;skip-column-names &#8211;execute=&nbsp;&raquo;flush logs&nbsp;&raquo; echo &laquo;&nbsp;Copying binlogs&nbsp;&raquo; su mysql &#8211;command=&nbsp;&raquo;mkdir $BACKUPDIR&nbsp;&raquo; for FILE in `cat $BINLOGPATH\/$BINLOGNAME` do SFILE=(${FILE\/*\\\/\/}) #echo &laquo;&nbsp;$SFILE&nbsp;&raquo; su mysql &#8211;command=&nbsp;&raquo;cp -p $BINLOGPATH\/$SFILE $BACKUPDIR\/&nbsp;&raquo; #gzip $\/$SFILE done<\/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\/908"}],"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=908"}],"version-history":[{"count":0,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/908\/revisions"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=908"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=908"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=908"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}