{"id":13148,"date":"2024-04-19T14:08:47","date_gmt":"2024-04-19T14:08:47","guid":{"rendered":"https:\/\/tech-lib.eu\/tech\/?p=13148"},"modified":"2024-04-19T14:08:47","modified_gmt":"2024-04-19T14:08:47","slug":"jak-pouzivat-vypis-mysql-komplexni-pruvodce","status":"publish","type":"post","link":"https:\/\/tech-lib.eu\/tech\/jak-pouzivat-vypis-mysql-komplexni-pruvodce\/","title":{"rendered":"Jak pou\u017e\u00edvat v\u00fdpis MySQL. Komplexn\u00ed pr\u016fvodce"},"content":{"rendered":"
\n
How to extract MySQL dump file?<\/div>\n
Exporting from MySQL<\/p>\n
    \n
  1. $ mysqldump -u my_username -p database_name > output_file_path.<\/li>\n
  2. $ mysqldump -u book_admin -p books > ~\/backup\/database\/books. sql Enter password:<\/li>\n
  3. $ mysqlimport -u book_admin -p books_production ~\/backup\/database\/books. sql Enter password:<\/li>\n<\/ol>\n<\/div>\n
    \n\t\t\t\t\t Dal\u0161\u00ed informace najdete na<\/span> chartio.com<\/a>\n\t\t\t\t<\/div>\n<\/p><\/div>\n
    \n
    <\/div>\n

    Pro ukl\u00e1d\u00e1n\u00ed a spr\u00e1vu dat mnoho lid\u00ed vyu\u017e\u00edv\u00e1 zn\u00e1m\u00fd open-source syst\u00e9m pro spr\u00e1vu rela\u010dn\u00edch datab\u00e1z\u00ed zn\u00e1m\u00fd jako MySQL. Vytv\u00e1\u0159en\u00ed z\u00e1loh datab\u00e1ze, n\u011bkdy ozna\u010dovan\u00fdch jako „dumpy“, je z\u00e1sadn\u00edm krokem p\u0159i pr\u00e1ci s MySQL. V tomto \u010dl\u00e1nku se budeme zab\u00fdvat efektivn\u00edm pou\u017eit\u00edm dumpu MySQL a \u0159adou dal\u0161\u00edch p\u0159\u00edpad\u016f pou\u017eit\u00ed, v\u010detn\u011b vytv\u00e1\u0159en\u00ed dumpu v syst\u00e9mu Linux, na\u010d\u00edt\u00e1n\u00ed a dumpu datab\u00e1z\u00ed, spou\u0161t\u011bn\u00ed dumpu v syst\u00e9mu Windows a dokonce i vytv\u00e1\u0159en\u00ed dumpu ve form\u00e1tu CSV. <\/p>\n

    <\/div>\n

    1. Jak po\u0159\u00eddit v\u00fdpis MySQL v syst\u00e9mu Linux: <\/p>\n

    <\/div>\n

    V syst\u00e9mu Linux je po\u0159\u00edzen\u00ed v\u00fdpisu MySQL jednoduch\u00fd postup. Po otev\u0159en\u00ed termin\u00e1lu pou\u017eijte n\u00e1sleduj\u00edc\u00ed p\u0159\u00edkaz: <\/p>\n

    <\/div>\n

    P\u0159\u00edkaz: <\/p>\n

    <\/div>\n

    „` <\/p>\n

    <\/div>\n

    -p [heslo] $ mysqldump -u [u\u017eivatelsk\u00e9 jm\u00e9no] N\u00e1zev datab\u00e1ze > SQL Dump File <\/p>\n

    <\/div>\n

    „` <\/p>\n

    <\/div>\n

    ‚[u\u017eivatelsk\u00e9 jm\u00e9no]‘ by m\u011blo b\u00fdt nahrazeno va\u0161\u00edm u\u017eivatelsk\u00fdm jm\u00e9nem MySQL, ‚[heslo]‘ by m\u011blo b\u00fdt nahrazeno va\u0161\u00edm heslem MySQL, ‚[n\u00e1zev_datab\u00e1ze]‘ by m\u011blo b\u00fdt nahrazeno n\u00e1zvem datab\u00e1ze, kterou chcete vypsat, a ‚[dump_file.sql]‘ by m\u011blo b\u00fdt nahrazeno n\u00e1zvem a um\u00edst\u011bn\u00edm souboru v\u00fdpisu. Po spu\u0161t\u011bn\u00ed p\u0159\u00edkazu bude vytvo\u0159en soubor SQL obsahuj\u00edc\u00ed celou strukturu a obsah datab\u00e1ze jako v\u00fdpis MySQL. <\/p>\n

    <\/div>\n

    2. Pou\u017eit\u00ed n\u00e1stroje p\u0159\u00edkazov\u00e9ho \u0159\u00e1dku’mysql‘ k na\u010dten\u00ed a v\u00fdpisu datab\u00e1ze MySQL: <\/p>\n

    <\/div>\n

    MySQL umo\u017e\u0148uje na\u010d\u00edt\u00e1n\u00ed a v\u00fdpis datab\u00e1z\u00ed. Na za\u010d\u00e1tku spus\u0165te n\u00e1sleduj\u00edc\u00ed p\u0159\u00edkaz pro vytvo\u0159en\u00ed nov\u00e9 datab\u00e1ze: <\/p>\n

    <\/div>\n

    „` <\/p>\n

    <\/div>\n

    “‘ <\/p>\n

    <\/div>\n

    “‘ $ mysql -u [u\u017eivatelsk\u00e9 jm\u00e9no] -p [heslo] -e „CREATE DATABASE [n\u00e1zev_nov\u00e9_datab\u00e1ze]“ ‚[username]‘ a ‚[password]‘ by m\u011bly b\u00fdt nahrazeny va\u0161imi p\u0159ihla\u0161ovac\u00edmi \u00fadaji do MySQL a ‚[new_database_name]‘ by m\u011blo b\u00fdt nahrazeno n\u00e1zvem, kter\u00fd chcete pro novou datab\u00e1zi pou\u017e\u00edt. Pro na\u010dten\u00ed v\u00fdpisov\u00e9ho souboru po vytvo\u0159en\u00ed datab\u00e1ze lze pou\u017e\u00edt n\u00e1sleduj\u00edc\u00ed p\u0159\u00edkaz: $ mysql -u [username] -p [password] <\/p>\n

    <\/div>\n

    “‘ [new_database_name] — [dump_file.sql] <\/p>\n

    <\/div>\n

    „` <\/p>\n

    <\/div>\n

    Op\u011bt nahra\u010fte spr\u00e1vn\u00e9 hodnoty pro „[username], „[password], „[new_database_name] a „[dump_file.sql]“. Na\u010dten\u00edm v\u00fdpisov\u00e9ho souboru do nov\u011b vytvo\u0159en\u00e9 datab\u00e1ze tento p\u0159\u00edkaz \u00fa\u010dinn\u011b obnov\u00ed data a strukturu p\u016fvodn\u00ed datab\u00e1ze. <\/p>\n

    <\/div>\n

    3. Pokyny pro spu\u0161t\u011bn\u00ed v\u00fdpisu souboru MySQL v syst\u00e9mu Windows: Postup pro spu\u0161t\u011bn\u00ed v\u00fdpisu souboru MySQL v syst\u00e9mu Windows je stejn\u00fd jako v syst\u00e9mu Linux. P\u0159ejd\u011bte do m\u00edsta, kde je nainstalov\u00e1na datab\u00e1ze MySQL, a otev\u0159ete P\u0159\u00edkazov\u00fd \u0159\u00e1dek. Spus\u0165te soubor v\u00fdpisu zad\u00e1n\u00edm n\u00e1sleduj\u00edc\u00edho p\u0159\u00edkazu: Soubor dump_file.sql] <\/p>\n

    “‘ <\/div>\n

    „` <\/p>\n

    U\u017eivatelsk\u00e9 jm\u00e9no, heslo, n\u00e1zev datab\u00e1ze a soubor dump_file.sql by m\u011bly b\u00fdt zm\u011bn\u011bny podle va\u0161eho nastaven\u00ed. Spu\u0161t\u011bn\u00edm souboru dump tato operace obnov\u00ed strukturu a obsah datab\u00e1ze. <\/div>\n

    4. Po\u0159\u00edzen\u00ed v\u00fdpisu MySQL do souboru CSV K po\u0159\u00edzen\u00ed v\u00fdpisu MySQL ve form\u00e1tu CSV lze pou\u017e\u00edt dotaz ‚SELECT… INTO OUTFILE‘. Pro spu\u0161t\u011bn\u00ed n\u00e1sleduj\u00edc\u00edho dotazu pou\u017eijte libovoln\u00e9ho klienta MySQL nebo p\u0159\u00edkazov\u00fd \u0159\u00e1dek MySQL: <\/p>\n

    <\/div>\n

    “‘ <\/p>\n

    <\/div>\n

    mysql> SELECT * FROM [n\u00e1zev_tabulky] INTO OUTFILE ‚[csv_soubor.csv]‘ FIELDS TERMINATED BY ‚,‘ OPTIONALLY ENCLOSED BY ‚“ LINES TERMINATED BY ‚n‘; <\/p>\n

    <\/div>\n

    “‘ <\/p>\n

    <\/div>\n

    ‚[csv_file.csv]‘ by m\u011bl b\u00fdt zm\u011bn\u011bn na po\u017eadovan\u00fd n\u00e1zev a um\u00edst\u011bn\u00ed CSV souboru a ‚[table_name]‘ by m\u011bl b\u00fdt zm\u011bn\u011bn na n\u00e1zev tabulky, kterou chcete vypsat. Tento dotaz s pou\u017eit\u00edm \u010d\u00e1rek jako odd\u011blova\u010d\u016f pol\u00ed, dvojit\u00fdch uvozovek jako nepovinn\u00fdch ohrani\u010den\u00ed pol\u00ed a nov\u00fdch \u0159\u00e1dk\u016f jako ukon\u010dova\u010d\u016f z\u00e1znam\u016f vyexportuje obsah tabulky do souboru CSV. <\/p>\n

    <\/div>\n

    Z\u00e1v\u011brem lze \u0159\u00edci, \u017ee spr\u00e1vci a v\u00fdvoj\u00e1\u0159i datab\u00e1z\u00ed MySQL se mus\u00ed zdokonalit v pou\u017e\u00edv\u00e1n\u00ed v\u00fdpisu MySQL. Dodan\u00e9 pokyny by v\u00e1m m\u011bly pomoci s postupem bez ohledu na to, zda pot\u0159ebujete na\u010d\u00edtat a vypisovat datab\u00e1ze, spou\u0161t\u011bt v\u00fdpisov\u00e9 soubory v syst\u00e9mu Windows, nebo dokonce exportovat data ve form\u00e1tu souboru CSV. Pravideln\u00fdm po\u0159izov\u00e1n\u00edm z\u00e1loh MySQL dump m\u016f\u017eete zajistit bezpe\u010dnost a integritu sv\u00fdch dat a usnadnit jednoduchou obnovu v p\u0159\u00edpad\u011b jak\u00fdchkoli nep\u0159edv\u00eddan\u00fdch situac\u00ed.<\/p><\/div>\n

    \n
    FAQ<\/div>\n
    \n
    Jak importovat v\u00fdpis MySQL v p\u0159\u00edkazov\u00e9m \u0159\u00e1dku?<\/div>\n

    K importu v\u00fdpisu MySQL m\u016f\u017eete pou\u017e\u00edt p\u0159\u00edkazov\u00fd \u0159\u00e1dek proveden\u00edm n\u00e1sleduj\u00edc\u00edch akc\u00ed: 1. Spus\u0165te rozhran\u00ed p\u0159\u00edkazov\u00e9ho \u0159\u00e1dku (CLI) po\u010d\u00edta\u010de. <\/p>\n

    <\/div>\n

    2. Vyhledejte adres\u00e1\u0159 obsahuj\u00edc\u00ed soubor v\u00fdpisu MySQL. K p\u0159ep\u00edn\u00e1n\u00ed adres\u00e1\u0159\u016f lze pou\u017e\u00edt p\u0159\u00edkaz „cd“. P\u0159\u00edkaz’mysql‘ lze pou\u017e\u00edt k importu v\u00fdpisu pot\u00e9, co jste ve spr\u00e1vn\u00e9m adres\u00e1\u0159i. Zde je z\u00e1kladn\u00ed syntaxe: “‘ <\/p>\n

    <\/div>\n

    “‘ <\/p>\n

    <\/div>\n

    mysql -u “‘ “‘ -p “‘ “‘ “‘ “‘ “‘ “‘ “‘ <\/p>\n

    <\/div>\n

    „` <\/p>\n

    <\/div>\n

    ‚[username]‘ by m\u011blo b\u00fdt zm\u011bn\u011bno na va\u0161e u\u017eivatelsk\u00e9 jm\u00e9no MySQL, ‚[database_name]‘ na n\u00e1zev datab\u00e1ze, do kter\u00e9 chcete importovat, a ‚[dump_file]‘ na n\u00e1zev souboru v\u00fdpisu MySQL. 4. Po spu\u0161t\u011bn\u00ed p\u0159\u00edkazu budete po\u017e\u00e1d\u00e1ni o zad\u00e1n\u00ed hesla u\u017eivatele MySQL. Po zad\u00e1n\u00ed hesla spojen\u00e9ho s po\u017eadovan\u00fdm u\u017eivatelsk\u00fdm jm\u00e9nem stiskn\u011bte kl\u00e1vesu Enter. Po importu dump souboru do ur\u010den\u00e9 datab\u00e1ze budete moci sledovat jeho pr\u016fb\u011bh. 6. Po dokon\u010den\u00ed importu se v p\u0159\u00edkazov\u00e9m \u0159\u00e1dku zobraz\u00ed potvrzovac\u00ed zpr\u00e1va. <\/p>\n

    <\/div>\n

    Chcete-li importovat v\u00fdpis do ur\u010den\u00e9 datab\u00e1ze, ujist\u011bte se, \u017ee je v provozu p\u0159\u00edslu\u0161n\u00fd server MySQL a \u017ee m\u00e1te po\u017eadovan\u00e1 pr\u00e1va. <\/p>\n<\/div>\n

    \n
    Co je p\u0159\u00edkaz MySQL dump?<\/div>\n

    Pomoc\u00ed p\u0159\u00edkazu MySQL dump m\u016f\u017eete vytvo\u0159it z\u00e1lo\u017en\u00ed kopii datab\u00e1ze MySQL nebo konkr\u00e9tn\u00edch tabulek uvnit\u0159 datab\u00e1ze. Data a struktura datab\u00e1ze se exportuj\u00ed ve form\u00e1tu, kter\u00fd lze pozd\u011bji pou\u017e\u00edt k p\u0159enosu datab\u00e1ze na jin\u00fd server nebo do jin\u00e9ho prost\u0159ed\u00ed nebo k jej\u00edmu obnoven\u00ed. P\u0159\u00edkaz dump vytvo\u0159\u00ed skript SQL s po\u017eadovan\u00fdmi p\u0159\u00edkazy SQL pro rekonstrukci datab\u00e1ze nebo tabulek a v\u0161ech dat, kter\u00e1 obsahuj\u00ed. <\/p>\n<\/div>\n

    \n
    Jak na\u010dtu datab\u00e1zi z v\u00fdpisu?<\/div>\n

    N\u00ed\u017ee uveden\u00e9 metody popisuj\u00ed, jak na\u010d\u00edst datab\u00e1zi v syst\u00e9mu MySQL z v\u00fdpisu: 1. Otev\u0159ete okno termin\u00e1lu nebo p\u0159\u00edkazov\u00fd \u0159\u00e1dek. <\/p>\n

    <\/div>\n

    2. Vyhledejte adres\u00e1\u0159 obsahuj\u00edc\u00ed spustiteln\u00fd soubor MySQL. Nap\u0159\u00edklad v\u00fdchoz\u00ed um\u00edst\u011bn\u00ed v syst\u00e9mu Windows je obvykle „C:Program FilesMySQLMySQL Serverbin“. 3. Pomoc\u00ed n\u00ed\u017ee uveden\u00e9ho p\u0159\u00edkazu na\u010dt\u011bte datab\u00e1zi ze souboru v\u00fdpisu: * “‘ * “‘ <\/p>\n

    <\/div>\n

    mysql -u [username] -p [database_name] [dump_file_path] <\/p>\n

    <\/div>\n

    „` <\/p>\n

    <\/div>\n

    ‚[username]‘ by m\u011blo b\u00fdt zm\u011bn\u011bno na va\u0161e u\u017eivatelsk\u00e9 jm\u00e9no MySQL, ‚[database_name]‘ na n\u00e1zev datab\u00e1ze, do kter\u00e9 chcete v\u00fdpis na\u010d\u00edst, a ‚[dump_file_path]‘ na um\u00edst\u011bn\u00ed v\u00fdpisov\u00e9ho souboru. <\/p>\n

    <\/div>\n

    4. Po v\u00fdzv\u011b stiskn\u011bte tla\u010d\u00edtko input a zadejte sv\u00e9 heslo MySQL. M\u011bjte na pam\u011bti, \u017ee p\u0159i zad\u00e1v\u00e1n\u00ed nebude heslo viditeln\u00e9. 5. Sledujte, zda se dokon\u010d\u00ed spu\u0161t\u011bn\u00ed p\u0159\u00edkazu. V z\u00e1vislosti na velikosti v\u00fdpisov\u00e9ho souboru to m\u016f\u017ee n\u011bjakou dobu trvat. <\/p>\n

    <\/div>\n

    Datab\u00e1ze z v\u00fdpisov\u00e9ho souboru se po \u0159\u00e1dn\u00e9m dokon\u010den\u00ed p\u0159\u00edkazu na\u010dte do va\u0161eho serveru MySQL. Z\u00edsk\u00e1n\u00edm p\u0159\u00edstupu k datab\u00e1zi a prohl\u00eddkou jej\u00edho obsahu m\u016f\u017eete tuto skute\u010dnost potvrdit.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    How to extract MySQL dump file? Exporting from MySQL $ mysqldump -u my_username -p database_name > output_file_path. $ mysqldump -u book_admin -p books > ~\/backup\/database\/books. sql Enter password: $ mysqlimport -u book_admin -p books_production ~\/backup\/database\/books. sql Enter password: Dal\u0161\u00ed informace najdete na chartio.com Pro ukl\u00e1d\u00e1n\u00ed a spr\u00e1vu dat mnoho lid\u00ed vyu\u017e\u00edv\u00e1 zn\u00e1m\u00fd open-source syst\u00e9m pro … \u010c\u00edst d\u00e1l<\/a><\/p>\n","protected":false},"author":516,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2637],"tags":[],"class_list":["post-13148","post","type-post","status-publish","format-standard","hentry","category-sprava-databaze-2"],"_links":{"self":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts\/13148","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/users\/516"}],"replies":[{"embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/comments?post=13148"}],"version-history":[{"count":1,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts\/13148\/revisions"}],"predecessor-version":[{"id":15545,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts\/13148\/revisions\/15545"}],"wp:attachment":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/media?parent=13148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/categories?post=13148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/tags?post=13148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}