{"id":36,"date":"2019-12-18T06:42:30","date_gmt":"2019-12-18T05:42:30","guid":{"rendered":"https:\/\/piotrgabriel.pl\/wiki\/?p=36"},"modified":"2019-12-18T06:42:30","modified_gmt":"2019-12-18T05:42:30","slug":"docker-jak-wgrac-duza-baze-sql-do-serwera-mysql","status":"publish","type":"post","link":"https:\/\/piotrgabriel.pl\/wiki\/docker-jak-wgrac-duza-baze-sql-do-serwera-mysql\/","title":{"rendered":"Docker – jak wgra\u0107 du\u017c\u0105 baz\u0119 SQL do serwera MYSQL"},"content":{"rendered":"

Wgranie du\u017cej bazy danych (1-2GB i wi\u0119kszej mo\u017ce by\u0107 niemo\u017cliwe do wykonania za pomoc\u0105 panelu PHPMyAdmin. Aby wykona\u0107 t\u0119 czynno\u015b\u0107 bez problemu za pomoc\u0105 Dockera, wystarczy:<\/p>\n

    \n
  1. umie\u015bci\u0107 plik do wgrania w folderze dockera<\/li>\n
  2. w tym wpisie<\/a> pisa\u0142em wcze\u015bniej o tym jak nazywa si\u0119 kontener, z kt\u00f3rego chcemy skorzysta\u0107, nale\u017cy go teraz znale\u017a\u0107.<\/li>\n
  3. w\u0142\u0105czy\u0107 bash<\/li>\n
  4. oraz wpisa\u0107 komend\u0119 jak ni\u017cej:<\/li>\n<\/ol>\n

    docker exec -i devilbox_mysql_1 mysql -uroot baza-danych< plik-do-wgrania.sql<\/code><\/p>\n

    gdzie devilbox_mysql_1 to nazwa kontenera naszego MYSQL.<\/p>\n

     <\/p>\n","protected":false},"excerpt":{"rendered":"

    Wgranie du\u017cej bazy danych (1-2GB i wi\u0119kszej mo\u017ce by\u0107 niemo\u017cliwe do wykonania za pomoc\u0105 panelu PHPMyAdmin. Aby wykona\u0107 t\u0119 czynno\u015b\u0107 bez problemu za pomoc\u0105 Dockera<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[23,21,20,24],"class_list":["post-36","post","type-post","status-publish","format-standard","hentry","category-docker","tag-bash","tag-container","tag-docker","tag-mysql"],"_links":{"self":[{"href":"https:\/\/piotrgabriel.pl\/wiki\/wp-json\/wp\/v2\/posts\/36","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/piotrgabriel.pl\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/piotrgabriel.pl\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/piotrgabriel.pl\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/piotrgabriel.pl\/wiki\/wp-json\/wp\/v2\/comments?post=36"}],"version-history":[{"count":0,"href":"https:\/\/piotrgabriel.pl\/wiki\/wp-json\/wp\/v2\/posts\/36\/revisions"}],"wp:attachment":[{"href":"https:\/\/piotrgabriel.pl\/wiki\/wp-json\/wp\/v2\/media?parent=36"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/piotrgabriel.pl\/wiki\/wp-json\/wp\/v2\/categories?post=36"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/piotrgabriel.pl\/wiki\/wp-json\/wp\/v2\/tags?post=36"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}