{"id":141,"date":"2014-10-14T20:07:04","date_gmt":"2014-10-14T20:07:04","guid":{"rendered":"http:\/\/adrhc.go.ro\/wordpress\/?p=141"},"modified":"2014-10-14T20:07:04","modified_gmt":"2014-10-14T20:07:04","slug":"mysql-backup","status":"publish","type":"post","link":"https:\/\/adrhc.go.ro\/blog\/mysql-backup\/","title":{"rendered":"Mysql backup"},"content":{"rendered":"<pre class=\"brush:bash shell\">\r\nmysqldump --ignore-table=exifweb.Image --databases exifweb --skip-comments -u root --password > 2014-08-28\\ exifweb.sql\r\nmysqldump -u root --password exifweb Image > 2014-08-28\\ exifweb\\ Image\\ only.sql\r\nmysqldump -u root --password --databases exifweb > 2014-08-28\\ exifweb.sql\r\nmysqldump -u root --password exifweb | gzip > exifweb.sql.gz\r\nmysqldump -u root --password wordpress | gzip > wordpress.sql.gz\r\n\r\nsau backup al fisierelor de date:\r\ncp -uiv \/ffp\/opt\/srv\/mysql\/innodb\/* \/e-data\/3ebe05e9-b9db-8dd1-a9c7-69017484513c\/MySqlBackup\/\r\n\r\nSET unique_checks = 0;\r\nSET foreign_key_checks = 0;\r\ndelete from Album;\r\nINSERT INTO `Album` ...\r\nSET foreign_key_checks = 0;\r\nSET unique_checks = 0;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>mysqldump &#8211;ignore-table=exifweb.Image &#8211;databases exifweb &#8211;skip-comments -u root &#8211;password > 2014-08-28\\ exifweb.sql mysqldump -u root &#8211;password exifweb Image > 2014-08-28\\ exifweb\\ Image\\ only.sql mysqldump -u root &#8211;password &#8211;databases exifweb > 2014-08-28\\ exifweb.sql mysqldump -u root &#8211;password exifweb | gzip > exifweb.sql.gz [&hellip;]<\/p>\n<div class=\"link-more\"><a href=\"https:\/\/adrhc.go.ro\/blog\/mysql-backup\/#more-141\" class=\"more-link\">Continue reading &#10142; <span class=\"screen-reader-text\">Mysql backup<\/span><\/a><\/div>","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-141","post","type-post","status-publish","format-standard","hentry","category-database"],"_links":{"self":[{"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/posts\/141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/comments?post=141"}],"version-history":[{"count":0,"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/posts\/141\/revisions"}],"wp:attachment":[{"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/media?parent=141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/categories?post=141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/tags?post=141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}