{"id":248,"date":"2013-08-29T17:36:29","date_gmt":"2013-08-29T16:36:29","guid":{"rendered":"http:\/\/zsteva.info\/?p=248"},"modified":"2013-08-29T17:36:29","modified_gmt":"2013-08-29T16:36:29","slug":"migracija-mysql-servera","status":"publish","type":"post","link":"http:\/\/zsteva.info\/blog\/2013\/08\/migracija-mysql-servera\/","title":{"rendered":"Migracija mysql servera"},"content":{"rendered":"<p>Migracija mysql servera sa jednog servera na drugi podrazumeva: kreiranja baza i podesavanje privilegija na novom, kao i import exporta sa starog. Priprema exporta bazi je jednostavna, ali ako ih ima dosta scripta moze pomoci. Ja obi\u010dno imam urednu dokumentaciju sa SQL queriima za pravljenje baza i dodavanje korsnika\/privilegija, ali ponekad je zgodnije uraditi export i toga. Dve scripte za pomo\u0107 oko exporta.<\/p>\n<p><strong>export_create_db_and_grants.sh<\/strong> &#8211; pravi create database i grant upite za pravljenje baza i dodeljivanja usera\/privilegija na novom serveru:<\/p>\n<pre lang=\"bash\">#!\/bin\/bash\r\n\r\nAUTH=\"-u root -ppassword\"\r\n\r\necho \"SELECT Concat('create database ', SCHEMA_NAME, ';') FROM INFORMATION_SCHEMA.SCHEMATA where SCHEMA_NAME NOT IN ('mysql', 'information_schema');\" \\\r\n\t| mysql $AUTH --silent --skip-column-names\r\n\r\necho \r\n\r\necho \"select concat('show grants for ', User, '@\\\\'', Host, '\\\\';') from user where User != 'debian-sys-maint';\"  \\\r\n\t| mysql $AUTH mysql --silent --skip-column-names \\\r\n\t| mysql $AUTH --silent --skip-column-names \\\r\n\t| sed -e 's\/$\/;\/'\r\n<\/pre>\n<p><strong>export_all_db.sh<\/strong> &#8211; export svih baza u ime_baze.sql fajl:<\/p>\n<pre lang=\"bash\">#!\/bin\/bash\r\n\r\nAUTH=\"-u root -ppassword\"\r\n\r\necho \"SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA where SCHEMA_NAME NOT IN ('mysql', 'information_schema');\" \\\r\n\t| mysql $AUTH --silent --skip-column-names \\\r\n\t| while read DB; do\r\n\t\techo \"Exporting ${DB} to ${DB}.sql\"\r\n\t\tmysqldump $AUTH $DB > ${DB}.sql\r\n\tdone\r\n<\/pre>\n<p>Downaload: <a href='http:\/\/zsteva.info\/blog\/wp-content\/uploads\/2013\/08\/export_create_db_and_grants.sh_.txt'>export_create_db_and_grants.sh<\/a> <a href='http:\/\/zsteva.info\/blog\/wp-content\/uploads\/2013\/08\/export_all_db.sh_.txt'>export_all_db.sh<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Migracija mysql servera sa jednog servera na drugi podrazumeva: kreiranja baza i podesavanje privilegija na novom, kao i import exporta sa starog. Priprema exporta bazi je jednostavna, ali ako ih ima dosta scripta moze pomoci. Ja obi\u010dno imam urednu dokumentaciju &hellip; <a href=\"http:\/\/zsteva.info\/blog\/2013\/08\/migracija-mysql-servera\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[136,6],"tags":[33,108,40,39],"_links":{"self":[{"href":"http:\/\/zsteva.info\/blog\/wp-json\/wp\/v2\/posts\/248"}],"collection":[{"href":"http:\/\/zsteva.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/zsteva.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/zsteva.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/zsteva.info\/blog\/wp-json\/wp\/v2\/comments?post=248"}],"version-history":[{"count":4,"href":"http:\/\/zsteva.info\/blog\/wp-json\/wp\/v2\/posts\/248\/revisions"}],"predecessor-version":[{"id":254,"href":"http:\/\/zsteva.info\/blog\/wp-json\/wp\/v2\/posts\/248\/revisions\/254"}],"wp:attachment":[{"href":"http:\/\/zsteva.info\/blog\/wp-json\/wp\/v2\/media?parent=248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zsteva.info\/blog\/wp-json\/wp\/v2\/categories?post=248"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zsteva.info\/blog\/wp-json\/wp\/v2\/tags?post=248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}