{"id":111010,"date":"2025-05-29T01:38:16","date_gmt":"2025-05-28T21:08:16","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/%d9%86%d8%ad%d9%88%d9%87-%d8%aa%d9%86%d8%b8%db%8c%d9%85-%db%8c%da%a9-dev-db-%d8%a8%d8%b1%d8%a7%db%8c-%d8%aa%d9%88%d8%b3%d8%b9%d9%87-symfony-%da%a9%d9%87-%d8%af%d8%b1-%d8%a2%d9%86-%d8%a7%d8%b2-%d8%a7\/"},"modified":"2025-05-29T01:38:16","modified_gmt":"2025-05-28T21:08:16","slug":"%d9%86%d8%ad%d9%88%d9%87-%d8%aa%d9%86%d8%b8%db%8c%d9%85-%db%8c%da%a9-dev-db-%d8%a8%d8%b1%d8%a7%db%8c-%d8%aa%d9%88%d8%b3%d8%b9%d9%87-symfony-%da%a9%d9%87-%d8%af%d8%b1-%d8%a2%d9%86-%d8%a7%d8%b2-%d8%a7","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/%d9%86%d8%ad%d9%88%d9%87-%d8%aa%d9%86%d8%b8%db%8c%d9%85-%db%8c%da%a9-dev-db-%d8%a8%d8%b1%d8%a7%db%8c-%d8%aa%d9%88%d8%b3%d8%b9%d9%87-symfony-%da%a9%d9%87-%d8%af%d8%b1-%d8%a2%d9%86-%d8%a7%d8%b2-%d8%a7\/","title":{"rendered":"\u0646\u062d\u0648\u0647 \u062a\u0646\u0638\u06cc\u0645 \u06cc\u06a9 DEV DB \u0628\u0631\u0627\u06cc \u062a\u0648\u0633\u0639\u0647 Symfony \u06a9\u0647 \u062f\u0631 \u0622\u0646 \u0627\u0632 \u0627\u0633\u06a9\u0631\u06cc\u067e\u062a \u0647\u0627\u06cc \u0645\u0647\u0627\u062c\u0631\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0646\u0645\u06cc \u0634\u0648\u062f."},"content":{"rendered":"<div data-article-id=\"2538452\" id=\"article-body\">\n<p>\u062f\u0631 \u06a9\u0627\u0631 \u0645\u0646 \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 Symfony \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u0645. \u0637\u0628\u0642 \u0645\u0639\u0645\u0648\u0644 \u060c \u0627\u0633\u06a9\u0631\u06cc\u067e\u062a \u0647\u0627\u06cc \u0645\u0647\u0627\u062c\u0631\u062a \u0645\u062a\u0631\u0648\u06a9\u0647 \u0647\u0633\u062a\u0646\u062f \u0648 \u0645\u0646 \u0647\u06cc\u0686 \u0631\u0627\u0647\u06cc \u0622\u0633\u0627\u0646 \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 MySQL \u062a\u0648\u0633\u0639\u0647 \u062f\u0631 \u062f\u0633\u062a\u06af\u0627\u0647 \u062e\u0648\u062f \u0628\u0631\u0627\u06cc \u062a\u0648\u0633\u0639\u0647 \u0645\u062d\u0644\u06cc \u0646\u062f\u0627\u0631\u0645.<\/p>\n<p>\u0627\u0645\u0627 \u0645\u0646 \u06cc\u06a9 \u0631\u0627\u0647 \u062d\u0644 \u0622\u0633\u0627\u0646 \u0628\u0631\u0627\u06cc \u062a\u0646\u0638\u06cc\u0645 DB Shema \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0645. <\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nabfollower.com\/blog\/%d9%86%d8%ad%d9%88%d9%87-%d8%aa%d9%86%d8%b8%db%8c%d9%85-%db%8c%da%a9-dev-db-%d8%a8%d8%b1%d8%a7%db%8c-%d8%aa%d9%88%d8%b3%d8%b9%d9%87-symfony-%da%a9%d9%87-%d8%af%d8%b1-%d8%a2%d9%86-%d8%a7%d8%b2-%d8%a7\/#%D9%85%D8%B1%D8%AD%D9%84%D9%87_1_%DB%8C%DA%A9_%D9%BE%D8%A7%DB%8C%DA%AF%D8%A7%D9%87_%D8%AF%D8%A7%D8%AF%D9%87_DB_Dump_%E2%80%93_Initialise_%D8%B1%D8%A7_%D9%88%D8%A7%D8%B1%D8%AF_%DA%A9%D9%86%DB%8C%D8%AF\" >\u0645\u0631\u062d\u0644\u0647 1 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 DB Dump &#8211; Initialise \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nabfollower.com\/blog\/%d9%86%d8%ad%d9%88%d9%87-%d8%aa%d9%86%d8%b8%db%8c%d9%85-%db%8c%da%a9-dev-db-%d8%a8%d8%b1%d8%a7%db%8c-%d8%aa%d9%88%d8%b3%d8%b9%d9%87-symfony-%da%a9%d9%87-%d8%af%d8%b1-%d8%a2%d9%86-%d8%a7%d8%b2-%d8%a7\/#%D9%85%D8%B1%D8%AD%D9%84%D9%87_2_%D8%B7%D8%B1%D8%AD%D9%88%D8%A7%D8%B1%D9%87\" >\u0645\u0631\u062d\u0644\u0647 2 \u0637\u0631\u062d\u0648\u0627\u0631\u0647<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/%d9%86%d8%ad%d9%88%d9%87-%d8%aa%d9%86%d8%b8%db%8c%d9%85-%db%8c%da%a9-dev-db-%d8%a8%d8%b1%d8%a7%db%8c-%d8%aa%d9%88%d8%b3%d8%b9%d9%87-symfony-%da%a9%d9%87-%d8%af%d8%b1-%d8%a2%d9%86-%d8%a7%d8%b2-%d8%a7\/#1_%D8%A8%D9%87_%D8%B1%D9%88%D8%B2%D8%B1%D8%B3%D8%A7%D9%86%DB%8C_%D8%B7%D8%B1%D8%AD%D9%88%D8%A7%D8%B1%D9%87_SQL\" >1 \u0628\u0647 \u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0637\u0631\u062d\u0648\u0627\u0631\u0647 SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nabfollower.com\/blog\/%d9%86%d8%ad%d9%88%d9%87-%d8%aa%d9%86%d8%b8%db%8c%d9%85-%db%8c%da%a9-dev-db-%d8%a8%d8%b1%d8%a7%db%8c-%d8%aa%d9%88%d8%b3%d8%b9%d9%87-symfony-%da%a9%d9%87-%d8%af%d8%b1-%d8%a2%d9%86-%d8%a7%d8%b2-%d8%a7\/#2_SQL_%D9%BE%D8%B3_%D8%A7%D8%B2_%D9%BE%D8%B1%D8%AF%D8%A7%D8%B2%D8%B4_%D8%A8%D8%A7_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%D8%A7%D8%B2_AWK\" >2 SQL \u067e\u0633 \u0627\u0632 \u067e\u0631\u062f\u0627\u0632\u0634 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 AWK<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/nabfollower.com\/blog\/%d9%86%d8%ad%d9%88%d9%87-%d8%aa%d9%86%d8%b8%db%8c%d9%85-%db%8c%da%a9-dev-db-%d8%a8%d8%b1%d8%a7%db%8c-%d8%aa%d9%88%d8%b3%d8%b9%d9%87-symfony-%da%a9%d9%87-%d8%af%d8%b1-%d8%a2%d9%86-%d8%a7%d8%b2-%d8%a7\/#3_%DA%86%D8%A7%D9%BE_%D8%B1%D9%88%DB%8C_%DA%A9%D9%86%D8%B3%D9%88%D9%84\" >3 \u0686\u0627\u067e \u0631\u0648\u06cc \u06a9\u0646\u0633\u0648\u0644<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/nabfollower.com\/blog\/%d9%86%d8%ad%d9%88%d9%87-%d8%aa%d9%86%d8%b8%db%8c%d9%85-%db%8c%da%a9-dev-db-%d8%a8%d8%b1%d8%a7%db%8c-%d8%aa%d9%88%d8%b3%d8%b9%d9%87-symfony-%da%a9%d9%87-%d8%af%d8%b1-%d8%a2%d9%86-%d8%a7%d8%b2-%d8%a7\/#4_%D8%A8%DB%8C%D8%A7%D9%86%DB%8C%D9%87_SQL_%D8%B1%D8%A7_%D8%A7%D8%AC%D8%B1%D8%A7_%DA%A9%D9%86%DB%8C%D8%AF\" >4 \u0628\u06cc\u0627\u0646\u06cc\u0647 SQL \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/nabfollower.com\/blog\/%d9%86%d8%ad%d9%88%d9%87-%d8%aa%d9%86%d8%b8%db%8c%d9%85-%db%8c%da%a9-dev-db-%d8%a8%d8%b1%d8%a7%db%8c-%d8%aa%d9%88%d8%b3%d8%b9%d9%87-symfony-%da%a9%d9%87-%d8%af%d8%b1-%d8%a2%d9%86-%d8%a7%d8%b2-%d8%a7\/#%D8%A7%D8%AD%D8%AA%DB%8C%D8%A7%D8%B7\" >\u0627\u062d\u062a\u06cc\u0627\u0637<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/nabfollower.com\/blog\/%d9%86%d8%ad%d9%88%d9%87-%d8%aa%d9%86%d8%b8%db%8c%d9%85-%db%8c%da%a9-dev-db-%d8%a8%d8%b1%d8%a7%db%8c-%d8%aa%d9%88%d8%b3%d8%b9%d9%87-symfony-%da%a9%d9%87-%d8%af%d8%b1-%d8%a2%d9%86-%d8%a7%d8%b2-%d8%a7\/#%DA%86%DB%8C%D8%B2%D9%87%D8%A7%DB%8C_%D8%AE%D9%88%D8%A8_%D8%AF%D8%B1_%D9%85%D9%88%D8%B1%D8%AF_%D8%A7%DB%8C%D9%86_%D8%B1%D9%88%D8%B4\" >\u0686\u06cc\u0632\u0647\u0627\u06cc \u062e\u0648\u0628 \u062f\u0631 \u0645\u0648\u0631\u062f \u0627\u06cc\u0646 \u0631\u0648\u0634<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D9%85%D8%B1%D8%AD%D9%84%D9%87_1_%DB%8C%DA%A9_%D9%BE%D8%A7%DB%8C%DA%AF%D8%A7%D9%87_%D8%AF%D8%A7%D8%AF%D9%87_DB_Dump_%E2%80%93_Initialise_%D8%B1%D8%A7_%D9%88%D8%A7%D8%B1%D8%AF_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  \u0645\u0631\u062d\u0644\u0647 1 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 DB Dump &#8211; Initialise \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062f\u0631 \u0645\u0631\u062d\u0644\u0647 \u0627\u0648\u0644 \u060c \u0634\u0645\u0627 \u0628\u0627\u06cc\u062f \u06cc\u06a9 db \u062a\u0648\u0633\u0639\u0647 \u0631\u0627 \u0628\u062f\u0633\u062a \u0622\u0648\u0631\u06cc\u062f \u0648 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 MySQL \u0622\u0646 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f. \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0628\u0627\u06cc\u062f \u0647\u0631 \u0628\u0627\u0631 \u06a9\u0647 \u06cc\u06a9 \u0646\u0645\u0648\u0646\u0647 DB \u062a\u0627\u0632\u0647 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u06cc\u062f \u0627\u062c\u0631\u0627 \u0634\u0648\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>mysql -h 127.0.0.1 -u dbusr -pXXXX somedb &lt; dump.sql\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0647\u0631 \u0628\u0627\u0631 \u06a9\u0647 DB \u0631\u0627 \u0631\u0647\u0627 \u0648 \u0628\u0627\u0632\u0622\u0641\u0631\u06cc\u0646\u06cc \u0645\u06cc \u06a9\u0646\u06cc\u062f \u060c \u0632\u0628\u0627\u0644\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f \u060c \u0627\u06cc\u062f\u0647 \u062e\u0648\u0628\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0622\u0646 \u0631\u0627 \u0628\u0631 \u0631\u0648\u06cc \u062f\u06cc\u0633\u06a9 \u0633\u062e\u062a \u062e\u0648\u062f \u0646\u06af\u0647 \u062f\u0627\u0631\u06cc\u062f.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D9%85%D8%B1%D8%AD%D9%84%D9%87_2_%D8%B7%D8%B1%D8%AD%D9%88%D8%A7%D8%B1%D9%87\"><\/span>\n<p>  \u0645\u0631\u062d\u0644\u0647 2 \u0637\u0631\u062d\u0648\u0627\u0631\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0633\u067e\u0633 \u0645\u0646 \u0627\u0632 Symfony \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u0645 <code>shema:update<\/code> \u0648 \u0645\u0646 \u0622\u0646 \u0631\u0627 \u067e\u0633 \u0627\u0632 \u067e\u0631\u062f\u0627\u0632\u0634 (\u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0631\u062e\u06cc \u0627\u0632 SQL \u0646\u0627\u062e\u0648\u0627\u0633\u062a\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u062f):<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>php bin\/console doctrine:schema:update --dump-sql | \\\nawk '\/^ALTER TABLE\/ {\n    gsub(\/,$\/, \"\", $0);\n    table=$3;\n    sub(\/^ALTER TABLE [^ ]+ \/, \"\", $0);\n    n=split($0, parts, \/, *\/);\n    for (i=1; i&lt;=n; i++) {\n        print \"ALTER TABLE \" table \" \" parts[i] \";\"\n    }\n    next\n}\n{ print }\n' | \\\ntee \/dev\/tty | mysql -h 127.0.0.1 -u dbusr -pXXXX somedb \n\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0628\u06af\u0630\u0627\u0631\u06cc\u062f \u0627\u06cc\u0646 \u0647\u06cc\u0648\u0644\u0627\u06cc\u06cc \u0631\u0627 \u06a9\u0647 \u062f\u0631 \u0628\u0627\u0644\u0627 \u062a\u0627\u06cc\u067e \u06a9\u0631\u062f\u0645 \u062a\u0648\u0636\u06cc\u062d \u062f\u0647\u0645:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_%D8%A8%D9%87_%D8%B1%D9%88%D8%B2%D8%B1%D8%B3%D8%A7%D9%86%DB%8C_%D8%B7%D8%B1%D8%AD%D9%88%D8%A7%D8%B1%D9%87_SQL\"><\/span>\n<p>  1 \u0628\u0647 \u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0637\u0631\u062d\u0648\u0627\u0631\u0647 SQL<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>php bin\/console doctrine:schema:update --dump-sql\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0628\u0627 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 SQL \u0631\u0627 \u0627\u0632 <code>doctrine:schema:update<\/code> \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 <code>--dump-sql<\/code><\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_SQL_%D9%BE%D8%B3_%D8%A7%D8%B2_%D9%BE%D8%B1%D8%AF%D8%A7%D8%B2%D8%B4_%D8%A8%D8%A7_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%D8%A7%D8%B2_AWK\"><\/span>\n<p>  2 SQL \u067e\u0633 \u0627\u0632 \u067e\u0631\u062f\u0627\u0632\u0634 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 AWK<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>awk '\/^ALTER TABLE\/ {\n    gsub(\/,$\/, \"\", $0);\n    table=$3;\n    sub(\/^ALTER TABLE [^ ]+ \/, \"\", $0);\n    n=split($0, parts, \/, *\/);\n    for (i=1; i&lt;=n; i++) {\n        print \"ALTER TABLE \" table \" \" parts[i] \";\"\n    }\n    next\n}\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 AWK \u0645\u0646 \u062a\u0642\u0633\u06cc\u0645 \u0645\u06cc \u06a9\u0646\u0645 <code>ALTER TABLE<\/code> \u0628\u06cc\u0627\u0646\u06cc\u0647 SQL \u0628\u0647 \u0645\u0648\u0627\u0631\u062f \u06a9\u0648\u0686\u06a9\u062a\u0631. \u0645\u0646 \u0627\u0632 AWK \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u0645 \u0632\u06cc\u0631\u0627 \u0627\u06af\u0631 <code>ALTER TABLE<\/code> \u0628\u06cc\u0627\u0646\u06cc\u0647 \u0686\u0646\u062f\u06cc\u0646 \u0631\u0646\u06af \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u0645\u06cc \u062f\u0647\u062f \u06a9\u0647 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0634\u06a9\u0633\u062a \u0628\u062e\u0648\u0631\u062f. <\/p>\n<p>\u0645\u0646 \u0647\u0631\u06a9\u062f\u0627\u0645 \u0631\u0627 \u0645\u06cc \u062e\u0648\u0627\u0633\u062a\u0645 <code>ALTER TABLE<\/code> \u062c\u0645\u0644\u0647 \u0627\u06cc \u0628\u0631\u0627\u06cc \u0627\u0641\u0632\u0648\u062f\u0646 \u060c \u062a\u063a\u06cc\u06cc\u0631 \u06cc\u0627 \u0631\u0647\u0627 \u06a9\u0631\u062f\u0646 \u0641\u0642\u0637 \u06cc\u06a9 \u0633\u062a\u0648\u0646 \u062f\u0631 \u06cc\u06a9 \u0632\u0645\u0627\u0646 \u060c \u0627\u0641\u0632\u0627\u06cc\u0634 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0628\u0647 \u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0647\u0627 \u0628\u0631\u0627\u06cc \u0645\u0648\u0641\u0642\u06cc\u062a \u062f\u0631 DB.<\/p>\n<p>\u0627\u06cc\u0646 \u0628\u0647 \u0645\u0646 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc \u062f\u0647\u062f \u062a\u0627 \u062f\u0631 \u0632\u0645\u0627\u0646 \u062e\u0648\u062f\u0645 \u0647\u0631\u06af\u0648\u0646\u0647 \u0645\u0634\u06a9\u0644 \u0631\u0627 \u0628\u0631\u0637\u0631\u0641 \u06a9\u0646\u0645.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_%DA%86%D8%A7%D9%BE_%D8%B1%D9%88%DB%8C_%DA%A9%D9%86%D8%B3%D9%88%D9%84\"><\/span>\n<p>  3 \u0686\u0627\u067e \u0631\u0648\u06cc \u06a9\u0646\u0633\u0648\u0644<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>tee \/dev\/tty \n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0628\u0627 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u060c \u0645\u0646 \u0645\u06cc \u062e\u0648\u0627\u0633\u062a\u0645 \u0646\u0634\u0627\u0646 \u062f\u0647\u0645 \u06a9\u0647 \u0627\u0638\u0647\u0627\u0631\u0627\u062a SQL \u0628\u0631 \u0631\u0648\u06cc DB \u0627\u062c\u0631\u0627 \u0645\u06cc \u0634\u0648\u062f \u060c \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 \u0645\u0646 \u0622\u0646 \u0631\u0627 \u0628\u0647 \u062f\u0633\u062a\u0648\u0631 MySQL \u0646\u06cc\u0632 \u0645\u0646\u062a\u0642\u0644 \u0645\u06cc \u06a9\u0646\u0645:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_%D8%A8%DB%8C%D8%A7%D9%86%DB%8C%D9%87_SQL_%D8%B1%D8%A7_%D8%A7%D8%AC%D8%B1%D8%A7_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  4 \u0628\u06cc\u0627\u0646\u06cc\u0647 SQL \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>mysql --force -h 127.0.0.1 -u dbusr -pXXXX somedb \n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0633\u0631\u0627\u0646\u062c\u0627\u0645 \u060c \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 MySQL \u060c \u0628\u06cc\u0627\u0646\u06cc\u0647 \u0647\u0627\u06cc\u06cc \u0631\u0627 \u06a9\u0647 \u0628\u0631 \u0631\u0648\u06cc DB \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u0634\u0648\u062f \u0627\u062c\u0631\u0627 \u0645\u06cc \u06a9\u0646\u0645. \u0645\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u0645 <code>--force<\/code> \u06af\u0632\u06cc\u0646\u0647 \u0632\u06cc\u0631\u0627 \u0627\u06af\u0631 ommited \u0648 \u06cc\u06a9 \u0628\u06cc\u0627\u0646\u06cc\u0647 SQL \u0628\u0627 \u0634\u06a9\u0633\u062a \u0645\u0648\u0627\u062c\u0647 \u0634\u0648\u062f \u060c \u062f\u06cc\u06af\u0631 \u0628\u0631 \u0631\u0648\u06cc DB \u0627\u062c\u0631\u0627 \u0646\u0645\u06cc \u0634\u0648\u062f. <\/p>\n<p>\u0622\u0646\u0686\u0647 \u0645\u0646 \u0645\u06cc \u062e\u0648\u0627\u0633\u062a\u0645 \u0627\u06cc\u0646 \u0628\u0648\u062f \u06a9\u0647 \u0647\u0631 \u062c\u0645\u0644\u0647 SQL \u0631\u0627 \u06a9\u0647 \u0637\u0631\u062d DB \u0631\u0627 \u0628\u0647 \u0631\u0648\u0632 \u06a9\u0631\u062f \u060c \u0627\u062c\u0631\u0627 \u06a9\u0646\u0645.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D8%A7%D8%AD%D8%AA%DB%8C%D8%A7%D8%B7\"><\/span>\n<p>  \u0627\u062d\u062a\u06cc\u0627\u0637<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0627\u06cc\u0646 \u0631\u0648\u0634 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u0633\u06a9\u0631\u06cc\u067e\u062a \u0647\u0627\u06cc \u0645\u0647\u0627\u062c\u0631\u062a DB \u0627\u0633\u062a. \u0627\u0645\u0627 \u0628\u0633\u06cc\u0627\u0631\u06cc \u0627\u0632 \u0645\u0648\u0627\u0631\u062f \u06a9\u0647 \u0628\u0647 \u062f\u0644\u0627\u06cc\u0644 \u0645\u062e\u062a\u0644\u0641 \u0645\u0647\u0627\u062c\u0631\u062a DB \u0628\u0647 \u062f\u0631\u0633\u062a\u06cc \u062d\u0641\u0638 \u0646\u0645\u06cc \u0634\u0648\u062f (\u06a9\u0645\u0628\u0648\u062f \u0648\u0642\u062a \u06cc\u0627 \u062f\u0627\u0646\u0634) \u0627\u06cc\u0646 \u0628\u0647\u062a\u0631\u06cc\u0646 \u0686\u06cc\u0632 \u0628\u0639\u062f\u06cc \u0627\u0633\u062a.<\/p>\n<p>\u0627\u06af\u0631 \u0627\u0632 \u0645\u0647\u0627\u062c\u0631\u062a \u0647\u0627\u06cc DB \u062a\u06cc\u0645 \u062e\u0648\u062f \u0628\u0647 \u062f\u0631\u0633\u062a\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f \u060c \u0628\u0627\u06cc\u062f \u0627\u0632 \u0627\u06cc\u0646 \u0631\u0648\u0634 \u062c\u0644\u0648\u06af\u06cc\u0631\u06cc \u0634\u0648\u062f \u0648 \u0627\u0632 \u0627\u0633\u06a9\u0631\u06cc\u067e\u062a \u0647\u0627\u06cc \u0645\u0647\u0627\u062c\u0631\u062a \u0628\u0631\u0627\u06cc \u062a\u0646\u0638\u06cc\u0645 DB \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n<p>\u0647\u0645\u0686\u0646\u06cc\u0646 \u0627\u06cc\u0646 \u0631\u0648\u0634 \u0647\u0631 \u062c\u0645\u0644\u0647 SQL \u0631\u0627 \u0645\u062c\u0628\u0648\u0631 \u0645\u06cc \u06a9\u0646\u062f \u0628\u062f\u0648\u0646 \u0647\u06cc\u0686 \u0646\u0648\u0639 \u06a9\u0646\u062a\u0631\u0644 \u06cc\u0627 \u0622\u0632\u0645\u0627\u06cc\u0634 \u0628\u0631 \u0631\u0648\u06cc DB \u0627\u062c\u0631\u0627 \u0634\u0648\u062f. \u0628\u0631\u062e\u06cc \u0627\u0632 \u0622\u0646\u0647\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u062e\u0637\u0631\u0646\u0627\u06a9 \u0628\u0627\u0634\u0646\u062f \u06a9\u0647 \u0622\u0633\u06cc\u0628 \u0647\u0627\u06cc \u0628\u0631\u06af\u0634\u062a \u0646\u0627\u067e\u0630\u06cc\u0631 \u0628\u0647 \u0637\u0631\u062d DB \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u0646\u062f. \u0639\u0644\u0627\u0648\u0647 \u0628\u0631 \u0627\u06cc\u0646 \u060c \u06cc\u06a9 \u062a\u0646\u0638\u06cc\u0645 DB \u06cc\u0627 \u0645\u0647\u0627\u062c\u0631\u062a \u0646\u06cc\u0632 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0645\u0647\u0627\u062c\u0631\u062a \u062f\u0627\u062f\u0647 \u0647\u0627 \u0646\u06cc\u0632 \u062f\u0627\u0631\u062f \u06a9\u0647 \u0627\u06cc\u0646 \u0631\u0648\u0634 \u0627\u0631\u0627\u0626\u0647 \u0646\u0645\u06cc \u062f\u0647\u062f. <\/p>\n<p>\u0627\u06cc\u0646 \u0631\u0648\u0634 \u0628\u0631\u0627\u06cc a \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc \u0634\u0648\u062f <strong>\u062a\u0646\u0638\u06cc\u0645 DB \u0645\u062d\u0644\u06cc<\/strong> \u062f\u0631 \u062d\u06cc\u0646 \u062a\u0648\u0633\u0639\u0647 \u0648 \u0628\u0627\u06cc\u062f \u0628\u0627\u0634\u062f <strong>\u0627\u062c\u062a\u0646\u0627\u0628 \u0634\u062f\u0647<\/strong> \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0642\u0631\u0627\u0631 \u0628\u0631\u0646\u0627\u0645\u0647<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%DA%86%DB%8C%D8%B2%D9%87%D8%A7%DB%8C_%D8%AE%D9%88%D8%A8_%D8%AF%D8%B1_%D9%85%D9%88%D8%B1%D8%AF_%D8%A7%DB%8C%D9%86_%D8%B1%D9%88%D8%B4\"><\/span>\n<p>  \u0686\u06cc\u0632\u0647\u0627\u06cc \u062e\u0648\u0628 \u062f\u0631 \u0645\u0648\u0631\u062f \u0627\u06cc\u0646 \u0631\u0648\u0634<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0627\u06cc\u0646 \u0631\u0648\u0634 \u0627\u06af\u0631\u0686\u0647 \u0645\u0631\u0627\u062d\u0644 \u062b\u0627\u0628\u062a \u0631\u0627 \u0628\u0631\u0627\u06cc \u062a\u0646\u0638\u06cc\u0645 \u0648 \u0628\u0647 \u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062a\u0648\u0633\u0639\u0647 \u062f\u0631 \u0647\u0631 \u0644\u062d\u0638\u0647 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f. \u0645\u0646 \u0634\u062e\u0635\u0627\u064b 2 \u0627\u0633\u06a9\u0631\u06cc\u067e\u062a bash \u062f\u0631\u0633\u062a \u06a9\u0631\u062f\u0645:<\/p>\n<p>\u0645\u0648\u0631\u062f\u06cc \u06a9\u0647 \u0627\u0632 \u06cc\u06a9 \u0632\u0628\u0627\u0644\u0647 db (\u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u062f\u0631 \u0645\u0631\u062d\u0644\u0647 1 \u0630\u06a9\u0631 \u0634\u062f) \u06cc\u06a9 db \u062a\u0627\u0632\u0647 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f \u0648 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>#!\/usr\/bin\/env bash\n\nmysql -h 127.0.0.1 -u dbusr -pXXXX -e \"DROP DATABASE app_db\"\nmysql -h 127.0.0.1 -u dbusr -pXXXX somedb -e \"CREATE DATABASE app_db\"\n\n# Init\nmysql -h 127.0.0.1 -u dbusr -pXXXX somedb &lt; dump.sql\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0648 \u06cc\u06a9\u06cc \u06a9\u0647 \u0637\u0631\u062d \u0631\u0627 \u0628\u0647 \u0631\u0648\u0632 \u0645\u06cc \u06a9\u0646\u062f (\u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u062f\u0631 \u0645\u0631\u062d\u0644\u0647 2 \u0630\u06a9\u0631 \u0634\u062f)<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>#!\/usr\/bin\/env bash\n\nphp bin\/console doctrine:schema:update --dump-sql | \\\nawk '\/^ALTER TABLE\/ {\n    gsub(\/,$\/, \"\", $0);\n    table=$3;\n    sub(\/^ALTER TABLE [^ ]+ \/, \"\", $0);\n    n=split($0, parts, \/, *\/);\n    for (i=1; i&lt;=n; i++) {\n        print \"ALTER TABLE \" table \" \" parts[i] \";\"\n    }\n    next\n}\n{ print }\n' | \\\ntee \/dev\/tty | mysql -h 127.0.0.1 -u dbusr -pXXXX somedb \n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0645\u0648\u0627\u0631\u062f \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644 \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0631\u062f \u0627\u06af\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 PHP \u0627\u0632 \u0637\u0631\u06cc\u0642 \u06cc\u06a9 \u0638\u0631\u0641 Docker \u0628\u0647 \u0646\u0627\u0645 \u0627\u062c\u0631\u0627 \u0634\u0648\u062f <code>php<\/code>:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>#!\/usr\/bin\/env bash\n\ndocker exec -u www-data php php bin\/console doctrine:schema:update --dump-sql  | \\\nawk '\/^ALTER TABLE\/ {\n    gsub(\/,$\/, \"\", $0);\n    table=$3;\n    sub(\/^ALTER TABLE [^ ]+ \/, \"\", $0);\n    n=split($0, parts, \/, *\/);\n    for (i=1; i&lt;=n; i++) {\n        print \"ALTER TABLE \" table \" \" parts[i] \";\"\n    }\n    next\n}\n{ print }\n' | \\\ntee \/dev\/tty | mysql -h 127.0.0.1 -u dbusr -pXXXX somedb \n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u0645\u06cc\u062f\u0648\u0627\u0631\u0645 \u0627\u06cc\u0646 \u0645\u0648\u0631\u062f \u0645\u0641\u06cc\u062f \u0628\u0627\u0634\u062f.<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u062f\u0631 \u06a9\u0627\u0631 \u0645\u0646 \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 Symfony \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u0645. \u0637\u0628\u0642 \u0645\u0639\u0645\u0648\u0644 \u060c \u0627\u0633\u06a9\u0631\u06cc\u067e\u062a \u0647\u0627\u06cc \u0645\u0647\u0627\u062c\u0631\u062a \u0645\u062a\u0631\u0648\u06a9\u0647 \u0647\u0633\u062a\u0646\u062f \u0648 \u0645\u0646 \u0647\u06cc\u0686 \u0631\u0627\u0647\u06cc \u0622\u0633\u0627\u0646 \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 MySQL \u062a\u0648\u0633\u0639\u0647 \u062f\u0631 \u062f\u0633\u062a\u06af\u0627\u0647 \u062e\u0648\u062f \u0628\u0631\u0627\u06cc \u062a\u0648\u0633\u0639\u0647 \u0645\u062d\u0644\u06cc \u0646\u062f\u0627\u0631\u0645. \u0627\u0645\u0627 \u0645\u0646 \u06cc\u06a9 \u0631\u0627\u0647 \u062d\u0644 \u0622\u0633\u0627\u0646 \u0628\u0631\u0627\u06cc \u062a\u0646\u0638\u06cc\u0645 DB Shema \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0645. \u0645\u0631\u062d\u0644\u0647 1 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 DB Dump &hellip;<\/p>\n","protected":false},"author":2,"featured_media":111011,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/media2.dev.to\/dynamic\/image\/width=1000,height=500,fit=cover,gravity=auto,format=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fbvyxogzu5gdcgn7yvtwc.png","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-111010","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/111010","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=111010"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/111010\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/111011"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=111010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=111010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=111010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}