{"id":918,"date":"2010-05-31T03:52:56","date_gmt":"2010-05-31T02:52:56","guid":{"rendered":"http:\/\/www.plagosus.net\/blog\/?p=918"},"modified":"2012-10-26T19:54:18","modified_gmt":"2012-10-26T18:54:18","slug":"export-import-velikih-mysql-baza-i-rezervne-kopije-back-up","status":"publish","type":"post","link":"https:\/\/www.plagosus.net\/blog\/tech\/sysop\/export-import-velikih-mysql-baza-i-rezervne-kopije-back-up\/","title":{"rendered":"Export\/Import velikih MySQL baza i rezervne kopije (Back-Up)"},"content":{"rendered":"<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright size-full wp-image-924\" title=\"MySQL Logo\" src=\"http:\/\/www.plagosus.net\/blog\/wp-content\/uploads\/2010\/05\/mysql-logo.png\" alt=\"\" width=\"200\" height=\"115\" \/>Ok, desi vam se da imate veliku (da ne ka\u017eem ogromnu) bazu podataka koju morate da preselite sa jednog mesta (servera) na drugo ili jednostavno \u017eelite da napravite rezervnu kopiju iste ili da, iz bilo kog razloga, vratite back-up. Ako je u pitanju baza manjeg sajta, bloga ili tome sli\u010dno, verovatno \u0107e vam muke olak\u0161ati projekat otvorenog koda pod nazivom <strong><a href=\"http:\/\/www.phpmyadmin.net\/\" target=\"_blank\">phpMyAdmin<\/a><\/strong>. Me\u0111utim, ukoliko je va\u0161a baza ve\u0107eg gabarita, verovatno \u0107ete morati da se dohvatite konzole i komandne linije.<\/p>\n<p style=\"text-align: justify;\">Ako radite na integrisanim <strong>LAMP<\/strong>\/<strong>WAMP<\/strong> re\u0161enjima, <strong>da bi importovali bazu<\/strong>, potrebno je da odete u konzolu \/ komandnu liniju i ukucate slede\u0107e *<\/p>\n<p>[bash]<br \/>\nmysql -u username -ppassword database_name &lt; file_name.sql<br \/>\n[\/bash]<\/p>\n<p style=\"text-align: justify;\">* napomena: Da bi pokrenuli komandnu liniju u Windows-u kliknite na &#8220;start &gt; run&#8221; i ukucajte &#8220;<span style=\"color: #3366ff;\">cmd<\/span>&#8221; i stisnite &#8220;ok&#8221;; U Linux-u na\u0111ite &#8220;terminal&#8221; ili &#8220;konsole&#8221;. \u00a0U Windows varijanti \u0107ete verovatno morati ru\u010dno da &#8216;odete&#8217; do lokacije gde je <strong>MySQL<\/strong> instaliran. To \u010dete u\u010diniti tako \u0161to \u0107ete u komandnoj liniji ukucati putanju do mysql.exe, npr (za wamp) &#8220;<span style=\"color: #3366ff;\">cd\u00a0C:\\wamp\\bin\\mysql\\mysql5.1.33\\bin<\/span>&#8220;.<\/p>\n<p style=\"text-align: justify;\">Ukoliko ovo radite na serveru, potrebno je da se na isti pove\u017eete preko <a href=\"http:\/\/en.wikipedia.org\/wiki\/Secure_Shell\" target=\"_blank\"><strong>SSH<\/strong><\/a>, gde \u0107ete primeniti postupak koji je prethodno opisan. Ukoliko nemate SSH pristup serveru, mo\u017eete upload-ovati bazu (tj <em>SQL dump<\/em>) negde na server i zamoliti tehni\u010dki podr\u0161ku da neko od administratora to uradi za vas ili da poku\u0161ate sre\u0107u sa <a href=\"http:\/\/www.dynamicdrive.com\/forums\/archive\/index.php\/t-11596.html\" target=\"_blank\">system() i shell_exec()\u00a0PHP funkcijama<\/a>.<\/p>\n<p style=\"text-align: justify;\"><strong>Da bi bazu eksportovali<\/strong> ili napravili njenu rezervnu kopiju postupite isto kao u prethodnom slu\u010daju, samo ukucajte:<\/p>\n<p>[bash]<br \/>\nmysqldump -u username -ppassword database_name &gt; file_name.sql<br \/>\n[\/bash]<\/p>\n<p style=\"text-align: justify;\">NAPOMENA: Parametar -p i sam password nisu razdvojini razmakom i unose se spojeno. U suprotnom \u0107e vam biti tra\u017eeno da password unesete ponovo.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ok, desi vam se da imate veliku (da ne ka\u017eem ogromnu) bazu podataka koju morate da preselite sa jednog mesta&#8230;<\/p>\n","protected":false},"author":2,"featured_media":924,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[210],"tags":[121,123,46,93,122,124,47],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.plagosus.net\/blog\/wp-json\/wp\/v2\/posts\/918"}],"collection":[{"href":"https:\/\/www.plagosus.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.plagosus.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.plagosus.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.plagosus.net\/blog\/wp-json\/wp\/v2\/comments?post=918"}],"version-history":[{"count":0,"href":"https:\/\/www.plagosus.net\/blog\/wp-json\/wp\/v2\/posts\/918\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.plagosus.net\/blog\/wp-json\/wp\/v2\/media\/924"}],"wp:attachment":[{"href":"https:\/\/www.plagosus.net\/blog\/wp-json\/wp\/v2\/media?parent=918"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.plagosus.net\/blog\/wp-json\/wp\/v2\/categories?post=918"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.plagosus.net\/blog\/wp-json\/wp\/v2\/tags?post=918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}