{"id":1469,"date":"2019-10-27T00:02:08","date_gmt":"2019-10-26T21:02:08","guid":{"rendered":"https:\/\/helia.ee\/koolitus\/?page_id=1469"},"modified":"2019-10-27T00:50:28","modified_gmt":"2019-10-26T21:50:28","slug":"mysql-andmebaasi-taastamine-kasurealt","status":"publish","type":"page","link":"https:\/\/helia.ee\/koolitus\/?page_id=1469","title":{"rendered":"MySQL andmebaasi taastamine k\u00e4surealt"},"content":{"rendered":"\r\n<p class=\"wp-block-preformatted\">#mysql andmebaasi importimine k\u00e4surealt <br \/><br \/><strong>mysql -u kasutajanimi -p andmebaas &lt; \/home\/koopiad\/file.sql<\/strong> <br \/><br \/>Check MySQL Options. Note-1: It is better to use the full path of the SQL file file.sql. Note-2: Use -R and &#8211;triggers to keep the routines and triggers of original database. They are not copied by default. Note-3 You may have to create the (empty) database from mysql if it doesn&#8217;t exist already and the exported SQL don&#8217;t contain CREATE DATABASE (exported with &#8211;no-create-db or -n option), before you can import it.<\/p>\r\n\r\n\r\n","protected":false},"excerpt":{"rendered":"<p>#mysql andmebaasi importimine k\u00e4surealt mysql -u kasutajanimi -p andmebaas &lt; \/home\/koopiad\/file.sql Check MySQL Options. Note-1: It is better to use the full path of the SQL file file.sql. Note-2: Use -R and &#8211;triggers to keep the routines and triggers of original database. They are not copied by default. Note-3 You may have to create the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1468,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-1469","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages\/1469","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1469"}],"version-history":[{"count":4,"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages\/1469\/revisions"}],"predecessor-version":[{"id":1492,"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages\/1469\/revisions\/1492"}],"up":[{"embeddable":true,"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages\/1468"}],"wp:attachment":[{"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}