{"id":190,"date":"2016-03-22T09:07:34","date_gmt":"2016-03-22T06:07:34","guid":{"rendered":"https:\/\/skilx.cc\/unlix\/?p=190"},"modified":"2019-10-24T05:15:50","modified_gmt":"2019-10-24T02:15:50","slug":"%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql","status":"publish","type":"post","link":"https:\/\/skilx.cc\/unlix\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\/","title":{"rendered":"\u0411\u044d\u043a\u0430\u043f\u0438\u043c \u0431\u0430\u0437\u044b MySQL"},"content":{"rendered":"<p style=\"text-align: justify;\"><!--more-->\u0414\u0435\u043b\u0430\u0435\u043c \u0431\u0435\u043a\u0430\u043f<br \/>\n<code>mysqldump -u USER -pPASSWORD DATABASE &gt; \/path\/to\/file\/dump.sql<\/code><\/p>\n<p>\u0421\u043e\u0437\u0434\u0430\u0451\u043c \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0443 \u0431\u0430\u0437\u044b \u0431\u0435\u0437 \u0434\u0430\u043d\u043d\u044b\u0445<br \/>\n<code>mysqldump --no-data - u USER -pPASSWORD DATABASE &gt; \/path\/to\/file\/schema.sql<\/code><\/p>\n<p>\u0415\u0441\u043b\u0438 \u043d\u0443\u0436\u043d\u043e \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u0434\u0430\u043c\u043f \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0434\u043d\u043e\u0439 \u0438\u043b\u0438 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445 \u0442\u0430\u0431\u043b\u0438\u0446<br \/>\n<code>mysqldump -u USER -pPASSWORD DATABASE TABLE1 TABLE2 TABLE3 &gt; \/path\/to\/file\/dump_table.sql<\/code><\/p>\n<p>\u0421\u043e\u0437\u0434\u0430\u0451\u043c \u0431\u0435\u043a\u0430\u043f \u0438 \u0441\u0440\u0430\u0437\u0443 \u0435\u0433\u043e \u0430\u0440\u0445\u0438\u0432\u0438\u0440\u0443\u0435\u043c<br \/>\n<code>mysqldump -u USER -pPASSWORD DATABASE | gzip &gt; \/path\/to\/outputfile.sql.gz<\/code><\/p>\n<p>\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0431\u0435\u043a\u0430\u043f\u0430 \u0441 \u0443\u043a\u0430\u0437\u0430\u043d\u0438\u0435\u043c \u0435\u0433\u043e \u0434\u0430\u0442\u044b<br \/>\n<code>mysqldump -u USER -pPASSWORD DATABASE | gzip &gt; `date +\/path\/to\/outputfile.sql.%Y%m%d.%H%M%S.gz`<\/code><\/p>\n<p>\u0417\u0430\u043b\u0438\u0432\u0430\u0435\u043c \u0431\u0435\u043a\u0430\u043f \u0432 \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445<br \/>\n<code>mysql -u USER -pPASSWORD DATABASE &lt; \/path\/to\/dump.sql<\/code><\/p>\n<p>\u0417\u0430\u043b\u0438\u0432\u0430\u0435\u043c \u0430\u0440\u0445\u0438\u0432 \u0431\u0435\u043a\u0430\u043f\u0430 \u0432 \u0431\u0430\u0437\u0443<br \/>\n<code>gunzip &lt; \/path\/to\/outputfile.sql.gz | mysql -u USER -pPASSWORD DATABASE<\/code><br \/>\n\u0438\u043b\u0438 \u0442\u0430\u043a<br \/>\n<code>zcat \/path\/to\/outputfile.sql.gz | mysql -u USER -pPASSWORD DATABASE<\/code><\/p>\n<p>\u0421\u043e\u0437\u0434\u0430\u0451\u043c \u043d\u043e\u0432\u0443\u044e \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445<br \/>\n<code>mysqladmin -u USER -pPASSWORD create NEWDATABASE<\/code><\/p>\n<p>\u0423\u0434\u043e\u0431\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0431\u0435\u043a\u0430\u043f \u0441 \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u043c\u0438 \u043e\u043f\u0446\u0438\u044f\u043c\u0438 <code>-Q -c -e<\/code>, \u0442.\u0435.<br \/>\n<code>mysqldump -Q -c -e -u USER -pPASSWORD DATABASE &gt; \/path\/to\/file\/dump.sql<\/code>, \u0433\u0434\u0435:<\/p>\n<ul style=\"text-align: justify;\">\n<li><b>-Q<\/b> \u043e\u0431\u043e\u0440\u0430\u0447\u0438\u0432\u0430\u0435\u0442 \u0438\u043c\u0435\u043d\u0430 \u043e\u0431\u0440\u0430\u0442\u043d\u044b\u043c\u0438 \u043a\u0430\u0432\u044b\u0447\u043a\u0430\u043c\u0438<\/li>\n<li><b>-c<\/b> \u0434\u0435\u043b\u0430\u0435\u0442 \u043f\u043e\u043b\u043d\u0443\u044e \u0432\u0441\u0442\u0430\u0432\u043a\u0443, \u0432\u043a\u043b\u044e\u0447\u0430\u044f \u0438\u043c\u0435\u043d\u0430 \u043a\u043e\u043b\u043e\u043d\u043e\u043a<\/li>\n<li><b>-e<\/b> \u0434\u0435\u043b\u0430\u0435\u0442 \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u043d\u0443\u044e \u0432\u0441\u0442\u0430\u0432\u043a\u0443. \u0418\u0442\u043e\u0433\u043e\u0432\u044b\u0439 \u0444\u0430\u0439\u043b \u043f\u043e\u043b\u0443\u0447\u0430\u0435\u0442\u0441\u044f \u043c\u0435\u043d\u044c\u0448\u0435 \u0438 \u0434\u0435\u043b\u0430\u0435\u0442\u0441\u044f \u043e\u043d \u0447\u0443\u0442\u044c \u0431\u044b\u0441\u0442\u0440\u0435\u0435<\/li>\n<\/ul>\n<p>\u0414\u043b\u044f \u043f\u0440\u043e\u0441\u043c\u043e\u0442\u0440\u0430 \u0441\u043f\u0438\u0441\u043a\u0430 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 \u043c\u043e\u0436\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u043a\u043e\u043c\u0430\u043d\u0434\u0443:<br \/>\n<code>mysqlshow -u USER -pPASSWORD<\/code><\/p>\n<p>\u0410 \u0442\u0430\u043a \u0436\u0435 \u043c\u043e\u0436\u043d\u043e \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u0441\u043f\u0438\u0441\u043e\u043a \u0442\u0430\u0431\u043b\u0438\u0446 \u0431\u0430\u0437\u044b:<br \/>\n<code>mysqlshow -u USER -pPASSWORD DATABASE<\/code><\/p>\n<p>\u0414\u043b\u044f \u0442\u0430\u0431\u043b\u0438\u0446 InnoDB \u043d\u0430\u0434\u043e \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0442\u044c <b>&#8212;single-transaction<\/b>, \u044d\u0442\u043e \u0433\u0430\u0440\u0430\u043d\u0442\u0438\u0440\u0443\u0435\u0442 \u0446\u0435\u043b\u043e\u0441\u0442\u043d\u043e\u0441\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0445 \u0431\u0435\u043a\u0430\u043f\u0430.<br \/>\n\u0414\u043b\u044f \u0442\u0430\u0431\u043b\u0438\u0446 MyISAN \u044d\u0442\u043e \u043d\u0435 \u0430\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u043e, \u0438\u0431\u043e \u043e\u043d\u0438 \u043d\u0435 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u044e\u0442 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u043e\u043d\u043d\u043e\u0441\u0442\u044c.<\/p>\n<h3>\u041f\u0440\u0438\u0432\u0435\u0434\u0443 \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043c\u043e\u0433\u0443\u0442 \u043f\u043e\u043d\u0430\u0434\u043e\u0431\u0438\u0442\u0441\u044f \u043f\u0440\u0438 \u0440\u0430\u0431\u043e\u0442\u0435 \u0441 \u0443\u0442\u0438\u043b\u0438\u0442\u043e\u0439\u00a0<strong>mysqldump:<\/strong><\/h3>\n<p><b>&#8212;add-drop-database<\/b><\/p>\n<dl>\n<dd>\u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u0442 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 <b>DROP DATABASE<\/b> \u043f\u0435\u0440\u0435\u0434 \u043a\u0430\u0436\u0434\u044b\u043c \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u043e\u043c <b>CREATE DATABASE<\/b>.<\/dd>\n<\/dl>\n<p><b>&#8212;add-drop-table<\/b><\/p>\n<dl>\n<dd>\u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u0442 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 <b>DROP TABLE<\/b> \u043f\u0435\u0440\u0435\u0434 \u043a\u0430\u0436\u0434\u044b\u043c \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u043e\u043c <b>CREATE TABLE<\/b>.<\/dd>\n<\/dl>\n<p><b>&#8212;add-locks<\/b><\/p>\n<dl>\n<dd>\u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u0442 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 <b>LOCK TABLES<\/b> \u043f\u0435\u0440\u0435\u0434 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435\u043c \u0438 <b>UNLOCK TABLE<\/b> \u043f\u043e\u0441\u043b\u0435 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u043a\u0430\u0436\u0434\u043e\u0433\u043e \u0434\u0430\u043c\u043f\u0430 \u0442\u0430\u0431\u043b\u0438\u0446\u044b (\u0434\u043b\u044f \u0443\u0441\u043a\u043e\u0440\u0435\u043d\u0438\u044f \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u043a MySQL).<\/dd>\n<\/dl>\n<p><b>&#8212;all-databases, -A<\/b><\/p>\n<dl>\n<dd>\u0421\u043e\u0445\u0440\u0430\u043d\u044f\u0435\u0442 \u0432\u0441\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0438\u0437 \u0432\u0441\u0435\u0445 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043d\u0430\u0445\u043e\u0434\u044f\u0442\u0441\u044f \u043f\u043e\u0434 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435\u043c \u0442\u0435\u043a\u0443\u0449\u0435\u0433\u043e \u0441\u0435\u0440\u0432\u0435\u0440\u0430.<\/dd>\n<\/dl>\n<p><b>&#8212;allow-keywords<\/b><\/p>\n<dl>\n<dd>\u0420\u0430\u0437\u0440\u0435\u0448\u0438\u0442\u044c \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c \u0438\u043c\u0435\u043d\u0430 \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0441\u043e\u0432\u043f\u0430\u0434\u0430\u044e\u0442 \u0441 \u043a\u043b\u044e\u0447\u0435\u0432\u044b\u043c\u0438 \u0441\u043b\u043e\u0432\u0430\u043c\u0438. \u041e\u0442\u0441\u0443\u0442\u0441\u0442\u0432\u0438\u0435 \u043a\u043e\u043d\u0444\u043b\u0438\u043a\u0442\u043e\u0432 \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u0435\u0442\u0441\u044f \u043f\u0440\u0438\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435\u043c \u0438\u043c\u0435\u043d\u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0432 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u043f\u0440\u0435\u0444\u0438\u043a\u0441\u0430 \u043a \u0438\u043c\u0435\u043d\u0438 \u043a\u0430\u0436\u0434\u043e\u0433\u043e \u0441\u0442\u043e\u043b\u0431\u0446\u0430.<\/dd>\n<\/dl>\n<p><b>&#8212;comments, -i<\/b><\/p>\n<dl>\n<dd>\u0414\u0430\u043d\u043d\u044b\u0439 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u0432 \u0434\u0430\u043c\u043f \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u0443\u044e \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e, \u0442\u0430\u043a\u0443\u044e, \u043a\u0430\u043a \u0432\u0435\u0440\u0441\u0438\u044f <strong>mysqldump<\/strong>, \u0432\u0435\u0440\u0441\u0438\u044f MySQL, \u0438\u043c\u044f \u0445\u043e\u0441\u0442\u0430, \u043d\u0430 \u043a\u043e\u0442\u043e\u0440\u043e\u043c \u0440\u0430\u0441\u043f\u043e\u043b\u043e\u0436\u0435\u043d \u0441\u0435\u0440\u0432\u0435\u0440 MySQL.<\/dd>\n<\/dl>\n<p><b>&#8212;compact<\/b><\/p>\n<dl>\n<dd>\u0414\u0430\u043d\u043d\u044b\u0439 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0442\u0440\u0435\u0431\u0443\u0435\u0442 \u043e\u0442 <strong>mysqldump<\/strong> \u0441\u043e\u0437\u0434\u0430\u0442\u044c \u0434\u0430\u043c\u043f, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u043a\u0430\u043a \u043c\u043e\u0436\u043d\u043e \u0431\u043e\u043b\u0435\u0435 \u043a\u043e\u043c\u043f\u0430\u043a\u0442\u043d\u044b\u0439 \u0444\u043e\u0440\u043c\u0430\u0442. \u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u043f\u0440\u043e\u0442\u0438\u0432\u043e\u043f\u043e\u043b\u043e\u0436\u043d\u044b\u043c <strong>&#8212;comments<\/strong>.<\/dd>\n<\/dl>\n<p><b>&#8212;compatible=name<\/b><\/p>\n<dl>\n<dd>\u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 \u0432\u044b\u0432\u043e\u0434, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c \u0441 \u0434\u0440\u0443\u0433\u0438\u043c\u0438 \u0421\u0423\u0411\u0414 \u0438\u043b\u0438 \u0431\u043e\u043b\u0435\u0435 \u0441\u0442\u0430\u0440\u044b\u043c\u0438 \u0432\u0435\u0440\u0441\u0438\u044f\u043c\u0438 MySQL. \u0412\u043c\u0435\u0441\u0442\u043e \u043a\u043b\u044e\u0447\u0435\u0432\u043e\u0433\u043e \u0441\u043b\u043e\u0432\u0430 <strong>name<\/strong> \u043c\u043e\u0436\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c:<em>&#171;ansi&#187;, &#171;mysql323&#187;, &#171;mysql40&#187;, &#171;postgresql&#187;, &#171;oracle&#187;, &#171;mssql&#187;, &#171;db2&#187;, &#171;maxdb&#187;, &#171;no_key_options&#187;, &#171;no_table_options&#187;, &#171;no_field_options&#187;<\/em>. \u041c\u043e\u0436\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439, \u0440\u0430\u0437\u0434\u0435\u043b\u0438\u0432 \u0438\u0445 \u0437\u0430\u043f\u044f\u0442\u044b\u043c\u0438.<\/dd>\n<\/dl>\n<p><b>&#8212;complete-insert, -c<\/b><\/p>\n<dl>\n<dd>\u0418\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u043f\u043e\u043b\u043d\u0430\u044f \u0444\u043e\u0440\u043c\u0430 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0430 <b>INSERT<\/b> (\u0441 \u0438\u043c\u0435\u043d\u0430\u043c\u0438 \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432).<\/dd>\n<\/dl>\n<p><b>&#8212;create-options<\/b><\/p>\n<dl>\n<dd>\u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u0442 \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u0443\u044e \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e \u0432 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u044b <b>CREATE TABLE<\/b>. \u042d\u0442\u043e \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u0442\u0438\u043f \u0442\u0430\u0431\u043b\u0438\u0446\u044b, \u043d\u0430\u0447\u0430\u043b\u044c\u043d\u043e\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 <b>AUTO_INCREMENT<\/b> \u0438 \u0434\u0440\u0443\u0433\u0438\u0435 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b.<\/dd>\n<\/dl>\n<p><b>&#8212;databases, -B<\/b><\/p>\n<dl>\n<dd>\u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0443\u043a\u0430\u0437\u0430\u0442\u044c \u0438\u043c\u0435\u043d\u0430 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445, \u0434\u043b\u044f \u043a\u043e\u0442\u043e\u0440\u044b\u0445 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0441\u043e\u0437\u0434\u0430\u0442\u044c \u0434\u0430\u043c\u043f.<\/dd>\n<\/dl>\n<p><b>&#8212;delayed<\/b><\/p>\n<dl>\n<dd>\u0418\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u043a\u043e\u043c\u0430\u043d\u0434\u0443 <b>INSERT DELAYED<\/b> \u043f\u0440\u0438 \u0432\u0441\u0442\u0430\u0432\u043a\u0435 \u0441\u0442\u0440\u043e\u043a.<\/dd>\n<\/dl>\n<p><b>&#8212;delete-master-logs<\/b><\/p>\n<dl>\n<dd>\u041d\u0430 \u0433\u043b\u0430\u0432\u043d\u043e\u043c \u0441\u0435\u0440\u0432\u0435\u0440\u0435 \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0438 \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438 \u0443\u0434\u0430\u043b\u044f\u044e\u0442\u0441\u044f \u0431\u0438\u043d\u0430\u0440\u043d\u044b\u0435 \u043b\u043e\u0433\u0438 (logbin) \u043f\u043e\u0441\u043b\u0435 \u0442\u043e\u0433\u043e, \u043a\u0430\u043a \u0434\u0430\u043c\u043f \u0431\u044b\u043b \u0443\u0441\u043f\u0435\u0448\u043d\u043e \u0441\u043e\u0437\u0434\u0430\u043d \u043f\u0440\u0438 \u043f\u043e\u043c\u043e\u0449\u0438 mysqldump. \u042d\u0442\u043e\u0442 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438 \u0432\u043a\u043b\u044e\u0447\u0430\u0435\u0442 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 &#171;&#8212;master-data&#187;.<\/dd>\n<\/dl>\n<p><b>&#8212;disable-keys, -K<\/b><\/p>\n<dl>\n<dd>\u0414\u043b\u044f \u043a\u0430\u0436\u0434\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u044b, \u043e\u043a\u0440\u0443\u0436\u0430\u0435\u0442 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 <b>INSERT<\/b> \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f\u043c\u0438 <b>\/*!40000 ALTER TABLE tbl_name DISABLE KEYS *\/;<\/b> \u0438 <b>\/*!40000 ALTER TABLE tbl_name ENABLE KEYS *\/;<\/b> \u0432 \u0432\u044b\u0432\u043e\u0434\u0435 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0430 \u0434\u0430\u043c\u043f\u0430. \u042d\u0442\u043e \u0443\u0441\u043a\u043e\u0440\u0438\u0442 \u0437\u0430\u0433\u0440\u0443\u0437\u043a\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 \u043d\u0430 \u0441\u0435\u0440\u0432\u0435\u0440 \u0434\u043b\u044f \u0442\u0430\u0431\u043b\u0438\u0446 \u0442\u0438\u043f\u0430 <b>MyISAM<\/b>, \u0442\u0430\u043a \u043a\u0430\u043a \u0438\u043d\u0434\u0435\u043a\u0441\u044b \u0441\u043e\u0437\u0434\u0430\u044e\u0442\u0441\u044f \u043f\u043e\u0441\u043b\u0435 \u0432\u043d\u0435\u0441\u0435\u043d\u0438\u044f \u0432\u0441\u0435\u0445 \u0434\u0430\u043d\u043d\u044b\u0445.<\/dd>\n<\/dl>\n<p><b>&#8212;extended-insert, -e<\/b><\/p>\n<dl>\n<dd>\u0418\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u043a\u043e\u043c\u0430\u043d\u0434\u0443 <b>INSERT<\/b> \u0441 \u043d\u043e\u0432\u044b\u043c \u043c\u043d\u043e\u0433\u043e\u0441\u0442\u0440\u043e\u0447\u043d\u044b\u043c \u0441\u0438\u043d\u0442\u0430\u043a\u0441\u0438\u0441\u043e\u043c (\u043f\u043e\u0432\u044b\u0448\u0430\u0435\u0442 \u043a\u043e\u043c\u043f\u0430\u043a\u0442\u043d\u043e\u0441\u0442\u044c \u0438 \u0431\u044b\u0441\u0442\u0440\u043e\u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0435 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u043e\u0432 \u0432\u0432\u043e\u0434\u0430).<\/dd>\n<\/dl>\n<p><b>&#8212;flush-logs, -F<\/b><\/p>\n<dl>\n<dd>\u0417\u0430\u043f\u0438\u0441\u0430\u0442\u044c \u043d\u0430 \u0434\u0438\u0441\u043a \u0434\u0430\u043d\u043d\u044b\u0435 \u0441\u0438\u0441\u0442\u0435\u043c\u043d\u043e\u0433\u043e \u0436\u0443\u0440\u043d\u0430\u043b\u0430 \u0438\u0437 \u0431\u0443\u0444\u0435\u0440\u0430 MySQL-\u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u043f\u0435\u0440\u0435\u0434 \u043d\u0430\u0447\u0430\u043b\u043e\u043c \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0434\u0430\u043c\u043f\u0430.<\/dd>\n<\/dl>\n<p><b>&#8212;force, -f<\/b><\/p>\n<dl>\n<dd>\u041f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u0442\u044c \u0434\u0430\u0436\u0435 \u0435\u0441\u043b\u0438 \u0432 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0435 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0434\u0430\u043c\u043f\u0430 \u043f\u0440\u043e\u0438\u0437\u043e\u0448\u043b\u0430 \u043e\u0448\u0438\u0431\u043a\u0430.<\/dd>\n<\/dl>\n<p><b>&#8212;hex-blob<\/b><\/p>\n<dl>\n<dd>\u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u0438\u0442\u044c \u0431\u0438\u043d\u0430\u0440\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u0432 \u043f\u043e\u043b\u044f\u0445 \u0442\u0438\u043f\u0430 <b>BINARY, VARBINARY, BLOB \u0438 BIT<\/b> \u0432 \u0448\u0435\u0441\u0442\u043d\u0430\u0434\u0446\u0430\u0442\u0435\u0440\u0438\u0447\u043d\u043e\u043c \u0444\u043e\u0440\u043c\u0430\u0442\u0435. \u0422\u0430\u043a \u043f\u043e\u0441\u043b\u0435\u0434\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c &#171;abc&#187; \u0431\u0443\u0434\u0435\u0442 \u0437\u0430\u043c\u0435\u043d\u0435\u043d\u0430 \u043d\u0430 0x616263.<\/dd>\n<\/dl>\n<p><b>&#8212;ignore-table=db_name.tbl_name<\/b><\/p>\n<dl>\n<dd>\u041f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0438\u0433\u043d\u043e\u0440\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0442\u0430\u0431\u043b\u0438\u0446\u0443 <b>tbl_name<\/b> \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 <b>db_name<\/b> \u043f\u0440\u0438 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0438 \u0434\u0430\u043c\u043f\u0430. \u0415\u0441\u043b\u0438 \u0438\u0437 \u0434\u0430\u043c\u043f\u0430 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0438\u0441\u043a\u043b\u044e\u0447\u0438\u0442\u044c \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0442\u0430\u0431\u043b\u0438\u0446, \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432 &#171;&#8212;ignore-table&#187;, \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u044f \u043f\u043e \u043e\u0434\u043d\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 \u0432 \u043a\u0430\u0436\u0434\u043e\u043c \u0438\u0437 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432.<\/dd>\n<\/dl>\n<p><b>&#8212;insert-ignore<\/b><\/p>\n<dl>\n<dd>\u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u0442 \u043a\u043b\u044e\u0447\u0435\u0432\u043e\u0435 \u0441\u043b\u043e\u0432\u043e <b>IGNORE<\/b> \u0432 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 <b>INSERT<\/b>.<\/dd>\n<\/dl>\n<p><b>&#8212;lock-all-tables, -x<\/b><\/p>\n<dl>\n<dd>\u0423\u043a\u0430\u0437\u0430\u043d\u0438\u0435 \u044d\u0442\u043e\u0433\u043e \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430 \u043f\u0440\u0438\u0432\u043e\u0434\u0438\u0442 \u043a \u0431\u043b\u043e\u043a\u0438\u0440\u043e\u0432\u043a\u0435 \u0432\u0441\u0435\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 \u0432\u043e \u0432\u0441\u0435\u0445 \u0431\u0430\u0437\u0430\u0445 \u0434\u0430\u043d\u043d\u044b\u0445 \u043d\u0430 \u0432\u0440\u0435\u043c\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u043f\u043e\u043b\u043d\u043e\u0433\u043e \u0434\u0430\u043c\u043f\u0430 \u0432\u0441\u0435\u0445 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445.<\/dd>\n<\/dl>\n<p><b>&#8212;lock-tables, -l<\/b><\/p>\n<dl>\n<dd>\u0423\u043a\u0430\u0437\u0430\u043d\u0438\u0435 \u044d\u0442\u043e\u0433\u043e \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430 \u043f\u0440\u0438\u0432\u043e\u0434\u0438\u0442 \u043a \u0431\u043b\u043e\u043a\u0438\u0440\u043e\u0432\u043a\u0435 \u0442\u0430\u0431\u043b\u0438\u0446 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445, \u0434\u043b\u044f \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u0441\u043e\u0437\u0434\u0430\u0435\u0442\u0441\u044f \u0434\u0430\u043c\u043f.<\/dd>\n<\/dl>\n<p><b>&#8212;no-autocommit<\/b><\/p>\n<dl>\n<dd>\u0412\u043a\u043b\u044e\u0447\u0430\u0435\u0442 \u0432\u0441\u0435 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u044b <b>INSERT<\/b>, \u043e\u0442\u043d\u043e\u0441\u044f\u0449\u0438\u0435\u0441\u044f \u043a \u043e\u0434\u043d\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u0435, \u0432 \u043e\u0434\u043d\u0443 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044e, \u0447\u0442\u043e \u043f\u0440\u0438\u0432\u043e\u0434\u0438\u0442 \u043a \u0443\u0432\u0435\u043b\u0438\u0447\u0435\u043d\u0438\u044e \u0441\u043a\u043e\u0440\u043e\u0441\u0442\u0438 \u0437\u0430\u0433\u0440\u0443\u0437\u043a\u0438 \u0434\u0430\u043d\u043d\u044b\u0445.<\/dd>\n<\/dl>\n<p><b>&#8212;no-create-db, -n<\/b><\/p>\n<dl>\n<dd>\u041f\u043e\u0434\u0430\u0432\u043b\u044f\u0435\u0442 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0432 \u0434\u0430\u043c\u043f\u0435 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u043e\u0432 <b>CREATE DATABASE<\/b>, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438 \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u044e\u0442\u0441\u044f \u043f\u0440\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0438 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432 <b>&#8212;databases<\/b> \u0438 <b>&#8212;all-databases<\/b>.<\/dd>\n<\/dl>\n<p><b>&#8212;no-data, -d<\/b><\/p>\n<dl>\n<dd>\u041f\u043e\u0434\u0430\u0432\u043b\u044f\u0435\u0442 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u043e\u0432 <b>INSERT<\/b> \u0432 \u0434\u0430\u043c\u043f\u0435, \u0447\u0442\u043e \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043f\u043e\u043b\u0435\u0437\u043d\u043e \u043f\u0440\u0438 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0438 \u0434\u0430\u043c\u043f\u0430 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0431\u0435\u0437 \u0441\u0430\u043c\u0438\u0445 \u0434\u0430\u043d\u043d\u044b\u0445.<\/dd>\n<\/dl>\n<p><b>&#8212;opt<\/b><\/p>\n<dl>\n<dd>\u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u043f\u0440\u0435\u0434\u043d\u0430\u0437\u043d\u0430\u0447\u0435\u043d \u0434\u043b\u044f \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u0441\u043a\u043e\u0440\u043e\u0441\u0442\u0438 \u0440\u0435\u0437\u0435\u0440\u0432\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445 \u0438 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0441\u043e\u043a\u0440\u0430\u0449\u0435\u043d\u0438\u0435\u043c, \u0432\u043a\u043b\u044e\u0447\u0430\u044e\u0449\u0438\u043c \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u043e\u043f\u0446\u0438\u0438: <b>&#8212;quick &#8212;add-drop-table &#8212;add-locks &#8212;create-options &#8212;disable-keys &#8212;extended-insert &#8212;lock-tables &#8212;set-charset<\/b>. \u041d\u0430\u0447\u0438\u043d\u0430\u044f \u0441 MySQL 4.1, \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 <b>&#8212;opt<\/b> \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u043f\u043e \u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e, \u0442.\u0435. \u0432\u0441\u0435 \u0432\u044b\u0448\u0435\u043f\u0435\u0440\u0435\u0447\u0438\u0441\u043b\u0435\u043d\u043d\u044b\u0435 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b \u0432\u043a\u043b\u044e\u0447\u0430\u044e\u0442\u0441\u044f \u043f\u043e \u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e, \u0434\u0430\u0436\u0435 \u0435\u0441\u043b\u0438 \u043e\u043d\u0438 \u043d\u0435 \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u044e\u0442\u0441\u044f. \u0414\u043b\u044f \u0442\u043e\u0433\u043e \u0447\u0442\u043e\u0431\u044b \u0438\u0441\u043a\u043b\u044e\u0447\u0438\u0442\u044c \u0442\u0430\u043a\u043e\u0435 \u043f\u043e\u0432\u0435\u0434\u0435\u043d\u0438\u0435, \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0432\u043e\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c\u0441\u044f \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432 <b>&#8212;skip-opt<\/b><\/dd>\n<\/dl>\n<p><b>&#8212;order-by-primary<\/b><\/p>\n<dl>\n<dd>\u0423\u043a\u0430\u0437\u0430\u043d\u0438\u0435 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430 \u043f\u0440\u0438\u0432\u043e\u0434\u0438\u0442 \u043a \u0442\u043e\u043c\u0443. \u0447\u0442\u043e \u043a\u0430\u0436\u0434\u0430\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u0430 \u0441\u043e\u0440\u0442\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u043f\u043e \u043f\u0435\u0440\u0432\u0438\u0447\u043d\u043e\u043c\u0443 \u043a\u043b\u044e\u0447\u0443 \u0438\u043b\u0438 \u043f\u0435\u0440\u0432\u043e\u043c\u0443 \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u043e\u043c\u0443 \u0438\u043d\u0434\u0435\u043a\u0441\u0443.<\/dd>\n<\/dl>\n<p><b>&#8212;port, -P<\/b><\/p>\n<dl>\n<dd>\u041d\u043e\u043c\u0435\u0440 TCP \u043f\u043e\u0440\u0442\u0430, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u043c\u043e\u0433\u043e \u0434\u043b\u044f \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f \u043a \u0445\u043e\u0441\u0442\u0443.<\/dd>\n<\/dl>\n<p><b>&#8212;protocol={TCP|SOCKET|PIPE|MEMORY}<\/b><\/p>\n<dl>\n<dd>\u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0437\u0430\u0434\u0430\u0442\u044c \u043f\u0440\u043e\u0442\u043e\u043a\u043e\u043b \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f \u043a \u0441\u0435\u0440\u0432\u0435\u0440\u0443.<\/dd>\n<\/dl>\n<p><b>&#8212;quick, -q<\/b><\/p>\n<dl>\n<dd>\u041f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u043d\u0430\u0447\u0430\u0442\u044c \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0434\u0430\u043c\u043f\u0430, \u043d\u0435 \u0434\u043e\u0436\u0438\u0434\u0430\u044f\u0441\u044c \u043f\u043e\u043b\u043d\u043e\u0439 \u0437\u0430\u0433\u0440\u0443\u0437\u043a\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u0441 \u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u0438 \u044d\u043a\u043e\u043d\u043e\u043c\u044f \u0442\u0435\u043c \u0441\u0430\u043c\u044b\u043c \u043f\u0430\u043c\u044f\u0442\u044c.<\/dd>\n<\/dl>\n<p><b>&#8212;quote-names, -Q<\/b><\/p>\n<dl>\n<dd>\u041f\u043e\u043c\u0435\u0449\u0430\u0435\u0442 \u0438\u043c\u0435\u043d\u0430 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445, \u0442\u0430\u0431\u043b\u0438\u0446 \u0438 \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432 \u0432 \u043e\u0431\u0440\u0430\u0442\u043d\u044b\u0435 \u0430\u043f\u043e\u0441\u0442\u0440\u043e\u0444\u044b <b>`<\/b>. \u041d\u0430\u0447\u0438\u043d\u0430\u044f \u0441 MySQL 4.1, \u0434\u0430\u043d\u043d\u044b\u0439 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0432\u043a\u043b\u044e\u0447\u0435\u043d \u043f\u043e \u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e.<\/dd>\n<\/dl>\n<p><b>&#8212;replace<\/b><\/p>\n<dl>\n<dd>\u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u0442 \u043a\u043b\u044e\u0447\u0435\u0432\u043e\u0435 \u0441\u043b\u043e\u0432\u043e <b>REPLACE<\/b> \u0432 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 <b>INSERT<\/b>. \u0414\u0430\u043d\u043d\u044b\u0439 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0432\u043f\u0435\u0440\u0432\u044b\u0435 \u043f\u043e\u044f\u0432\u0438\u043b\u0441\u044f \u0432 MySQL 5.1.3.<\/dd>\n<\/dl>\n<p><b>&#8212;result-file=\/path\/to\/file, -r \/path\/to\/file<\/b><\/p>\n<dl>\n<dd>\u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u043d\u0430\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u0442 \u0434\u0430\u043c\u043f \u0432 \u0444\u0430\u0439\u043b <b>file<\/b>. \u042d\u0442\u043e\u0442 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e \u0443\u0434\u043e\u0431\u0435\u043d \u0432<b>Windows<\/b>, \u0431\u0435\u0437 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f \u043a\u043e\u043c\u0430\u043d\u0434\u043d\u043e\u0439 \u0441\u0442\u0440\u043e\u043a\u0438. \u043a\u043e\u0433\u0434\u0430 \u043c\u043e\u0436\u043d\u043e \u043f\u0435\u0440\u0435\u043d\u0430\u043f\u0440\u0430\u0432\u0438\u0442\u044c \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0432 \u0444\u0430\u0439\u043b \u043f\u0440\u0438 \u043f\u043e\u043c\u043e\u0449\u0438 \u043f\u043e\u0441\u043b\u0435\u0434\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0435\u0439 <b>&gt;<\/b> \u0438 <b>&gt;&gt;<\/b>.<\/dd>\n<\/dl>\n<p><b>&#8212;routines, -R<\/b><\/p>\n<dl>\n<dd>\u0414\u0430\u043d\u043d\u044b\u0439 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0441\u043e\u0437\u0434\u0430\u0435\u0442 \u0434\u0430\u043c\u043f \u0445\u0440\u0430\u043d\u0438\u043c\u044b\u0445 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440 \u0438 \u0444\u0443\u043d\u043a\u0446\u0438\u0439. \u0414\u043e\u0441\u0442\u0443\u043f\u0435\u043d \u0441 MySQL 5.1.2.<\/dd>\n<\/dl>\n<p><b>&#8212;single-transaction<\/b><\/p>\n<dl>\n<dd>\u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0441\u043e\u0437\u0434\u0430\u0435\u0442 \u0434\u0430\u043c\u043f \u0432 \u0432\u0438\u0434\u0435 \u043e\u0434\u043d\u043e\u0439 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438.<\/dd>\n<\/dl>\n<p><b>&#8212;skip-comments<\/b><\/p>\n<dl>\n<dd>\u0414\u0430\u043d\u043d\u044b\u0439 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u043f\u043e\u0434\u0430\u0432\u0438\u0442\u044c \u0432\u044b\u0432\u043e\u0434 \u0432 \u0434\u0430\u043c\u043f \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0439 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0438.<\/dd>\n<\/dl>\n<p><b>&#8212;socket=\/path\/to\/socket, -S \/path\/to\/socket<\/b><\/p>\n<dl>\n<dd>\u0424\u0430\u0439\u043b \u0441\u043e\u043a\u0435\u0442\u0430 \u0434\u043b\u044f \u043f\u043e\u0434\u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u044f \u043a <b>localhost<\/b>.<\/dd>\n<\/dl>\n<p><b>&#8212;tab=\/path\/, -T \/path\/<\/b><\/p>\n<dl>\n<dd>\u041f\u0440\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0438 \u044d\u0442\u043e\u0433\u043e \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430 \u0432 \u043a\u0430\u0442\u0430\u043b\u043e\u0433\u0435 <b>path<\/b> \u0434\u043b\u044f \u043a\u0430\u0436\u0434\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0441\u043e\u0437\u0434\u0430\u044e\u0442\u0441\u044f \u0434\u0432\u0430 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u044b\u0445 \u0444\u0430\u0439\u043b\u0430: <b>tbl_name.sql<\/b>, \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0449\u0438\u0439 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 <b>CREATE TABLE<\/b>, \u0438<b>tbl_name.txt<\/b>, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u0442 \u0434\u0430\u043d\u043d\u044b\u0435 \u0442\u0430\u0431\u043b\u0438\u0446, \u0440\u0430\u0437\u0434\u0435\u043b\u0435\u043d\u043d\u044b\u0435 \u0441\u0438\u043c\u0432\u043e\u043b\u043e\u043c \u0442\u0430\u0431\u0443\u043b\u044f\u0446\u0438\u0438. \u0424\u043e\u0440\u043c\u0430\u0442 \u0434\u0430\u043d\u043d\u044b\u0445 \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043f\u0435\u0440\u0435\u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d \u044f\u0432\u043d\u043e \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432 <b>&#8212;fields-xxx \u0438 &#8212;lines-xxx<\/b>.<\/dd>\n<\/dl>\n<p><b>&#8212;tables<\/b><\/p>\n<dl>\n<dd>\u041f\u0435\u0440\u0435\u043a\u0440\u044b\u0432\u0430\u0435\u0442 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430 <b>&#8212;databases (-B)<\/b>. \u0412\u0441\u0435 \u0430\u0440\u0433\u0443\u043c\u0435\u043d\u0442\u044b, \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u0437\u0430 \u044d\u0442\u0438\u043c \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u043c, \u0442\u0440\u0430\u043a\u0442\u0443\u044e\u0442\u0441\u044f \u043a\u0430\u043a \u0438\u043c\u0435\u043d\u0430 \u0442\u0430\u0431\u043b\u0438\u0446.<\/dd>\n<\/dl>\n<p><b>&#8212;triggers<\/b><\/p>\n<dl>\n<dd>\u0421\u043e\u0437\u0434\u0430\u0435\u0442\u0441\u044f \u0434\u0430\u043c\u043f \u0442\u0440\u0438\u0433\u0433\u0435\u0440\u043e\u0432. \u042d\u0442\u043e\u0442 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0432\u043a\u043b\u044e\u0447\u0435\u043d \u043f\u043e \u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e. \u0434\u043b\u044f \u0435\u0433\u043e \u043e\u0442\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f \u0441\u043b\u0435\u0434\u0443\u0435\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 <b>&#8212;skip-triggers<\/b>.<\/dd>\n<\/dl>\n<p><b>&#8212;events, -E<\/b><\/p>\n<dl>\n<dd>\u0421\u043e\u0437\u0434\u0430\u0435\u0442\u0441\u044f \u0434\u0430\u043c\u043f \u0441\u043e\u0431\u044b\u0442\u0438\u0439. \u0421\u043c\u043e\u0442\u0440\u0438\u0442\u0435 <a href=\"http:\/\/adw0rd.com\/2009\/mysql-event-sheduler\/\">MySQL Event Scheduler \u0438\u043b\u0438 \u0432\u0441\u0442\u0440\u043e\u0435\u043d\u043d\u044b\u0439 \u0434\u0438\u0441\u043f\u0435\u0442\u0447\u0435\u0440 \u0441\u043e\u0431\u044b\u0442\u0438\u0439 \u0432 MySQL<\/a>.<\/dd>\n<\/dl>\n<p><b>&#8212;tz-utc<\/b><\/p>\n<dl>\n<dd>\u043f\u0440\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0438 \u0434\u0430\u043d\u043d\u043e\u0433\u043e \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430 \u0432 \u0434\u0430\u043c\u043f \u0431\u0443\u0434\u0435\u0442 \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 \u0432\u0438\u0434\u0430 <b>SET TIME_ZONE=&#8217;+00:00&#8242;<\/b>, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043f\u043e\u0437\u0432\u043e\u043b\u0438\u0442 \u043e\u0431\u043c\u0435\u043d\u0438\u0432\u0430\u0442\u044c\u0441\u044f \u0434\u0430\u043c\u043f\u0430 \u0432 \u0440\u0430\u0437\u043b\u0438\u0447\u043d\u044b\u0445 \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0445 \u0437\u043e\u043d\u0430\u0445.<\/dd>\n<\/dl>\n<p><b>&#8212;verbose, -v<\/b><\/p>\n<dl>\n<dd>\u0420\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u043d\u044b\u0439 \u0440\u0435\u0436\u0438\u043c \u0432\u044b\u0432\u043e\u0434\u0430. \u0412\u044b\u0432\u043e\u0434 \u0431\u043e\u043b\u0435\u0435 \u0434\u0435\u0442\u0430\u043b\u044c\u043d\u043e\u0439 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0438 \u043e \u0440\u0430\u0431\u043e\u0442\u0435 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u044b.<\/dd>\n<\/dl>\n<p><b>&#8212;version, -V<\/b><\/p>\n<dl>\n<dd>\u0412\u044b\u0432\u0435\u0441\u0442\u0438 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e \u043e \u0432\u0435\u0440\u0441\u0438\u0438 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u044b.<\/dd>\n<\/dl>\n<p><b>&#8212;where=&#8217;where-condition&#8217;, -w &#8216;where-condition&#8217;<\/b><\/p>\n<dl>\n<dd>\u0412\u044b\u043f\u043e\u043b\u043d\u0438\u0442\u044c \u0434\u0430\u043c\u043f \u0442\u043e\u043b\u044c\u043a\u043e \u0432\u044b\u0431\u0440\u0430\u043d\u043d\u044b\u0445 \u0437\u0430\u043f\u0438\u0441\u0435\u0439. \u041e\u0431\u0440\u0430\u0442\u0438\u0442\u0435 \u0432\u043d\u0438\u043c\u0430\u043d\u0438\u0435, \u0447\u0442\u043e \u043a\u0430\u0432\u044b\u0447\u043a\u0438 \u043e\u0431\u044f\u0437\u0430\u0442\u0435\u043b\u044c\u043d\u044b.<\/dd>\n<\/dl>\n<p><b>&#8212;xml, -X<\/b><\/p>\n<dl>\n<dd>\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u0434\u0430\u043c\u043f \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0432\u0438\u0434\u0435 XML.<\/dd>\n<\/dl>\n<p><b>&#8212;first-slave, -x<\/b><\/p>\n<dl>\n<dd>\u0411\u043b\u043e\u043a\u0438\u0440\u0443\u0435\u0442 \u0432\u0441\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0432\u043e \u0432\u0441\u0435\u0445 \u0431\u0430\u0437\u0430\u0445 \u0434\u0430\u043d\u043d\u044b\u0445.<\/dd>\n<\/dl>\n<p><b>&#8212;debug=&#8230;, -#<\/b><\/p>\n<dl>\n<dd>\u041e\u0442\u0441\u043b\u0435\u0436\u0438\u0432\u0430\u0442\u044c \u043f\u0440\u043e\u0445\u043e\u0436\u0434\u0435\u043d\u0438\u0435 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u044b (\u0434\u043b\u044f \u043e\u0442\u043b\u0430\u0434\u043a\u0438).<\/dd>\n<\/dl>\n<p><b>&#8212;help<\/b><\/p>\n<dl>\n<dd>\u0412\u044b\u0432\u0435\u0441\u0442\u0438 \u0441\u043f\u0440\u0430\u0432\u043e\u0447\u043d\u0443\u044e \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e \u0438 \u0432\u044b\u0439\u0442\u0438 \u0438\u0437 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u044b.<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":191,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[140,3,67,77,39,141,2,142,143],"class_list":["post-190","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-backup","tag-linux","tag-mysql","tag-mysqldump","tag-39","tag-141","tag-2","tag-142","tag-143"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0414\u0435\u043b\u0430\u0435\u043c \u0431\u0435\u043a\u0430\u043f mysqldump -u USER -pPASSWORD DATABASE &gt; \/path\/to\/file\/dump.sql \u0421\u043e\u0437\u0434\u0430\u0451\u043c \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0443 \u0431\u0430\u0437\u044b \u0431\u0435\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 mysqldump --no-data - u USER -pPASSWORD DATABASE &gt; \/path\/to\/file\/schema.sql \u0415\u0441\u043b\u0438 \u043d\u0443\u0436\u043d\u043e \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u0434\u0430\u043c\u043f \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0434\u043d\u043e\u0439 \u0438\u043b\u0438 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 mysqldump -u USER -pPASSWORD DATABASE TABLE1 TABLE2 TABLE3 &gt; \/path\/to\/file\/dump_table.sql \u0421\u043e\u0437\u0434\u0430\u0451\u043c \u0431\u0435\u043a\u0430\u043f \u0438 \u0441\u0440\u0430\u0437\u0443 \u0435\u0433\u043e \u0430\u0440\u0445\u0438\u0432\u0438\u0440\u0443\u0435\u043c mysqldump -u USER -pPASSWORD DATABASE | gzip\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"UNLIX\"\/>\n\t<meta name=\"keywords\" content=\"backup,linux,mysql,mysqldump,\u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435,\u0431\u044d\u043a\u0430\u043f,\u043b\u0438\u043d\u0443\u043a\u0441,\u0440\u0435\u0437\u0435\u0440\u0432\u043d\u0430\u044f \u043a\u043e\u043f\u0438\u044f,\u0441\u0434\u0435\u043b\u0430\u0442\u044c\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/skilx.cc\/unlix\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"ru_RU\" \/>\n\t\t<meta property=\"og:site_name\" content=\"UNLIX - \u0437\u0430\u043c\u0435\u0442\u043a\u0438 \u043e UNIX \u0438 LINUX \u0441\u0438\u0441\u0442\u0435\u043c\u0430\u0445\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\u0411\u044d\u043a\u0430\u043f\u0438\u043c \u0431\u0430\u0437\u044b MySQL | UNLIX\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0414\u0435\u043b\u0430\u0435\u043c \u0431\u0435\u043a\u0430\u043f mysqldump -u USER -pPASSWORD DATABASE &gt; \/path\/to\/file\/dump.sql \u0421\u043e\u0437\u0434\u0430\u0451\u043c \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0443 \u0431\u0430\u0437\u044b \u0431\u0435\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 mysqldump --no-data - u USER -pPASSWORD DATABASE &gt; \/path\/to\/file\/schema.sql \u0415\u0441\u043b\u0438 \u043d\u0443\u0436\u043d\u043e \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u0434\u0430\u043c\u043f \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0434\u043d\u043e\u0439 \u0438\u043b\u0438 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 mysqldump -u USER -pPASSWORD DATABASE TABLE1 TABLE2 TABLE3 &gt; \/path\/to\/file\/dump_table.sql \u0421\u043e\u0437\u0434\u0430\u0451\u043c \u0431\u0435\u043a\u0430\u043f \u0438 \u0441\u0440\u0430\u0437\u0443 \u0435\u0433\u043e \u0430\u0440\u0445\u0438\u0432\u0438\u0440\u0443\u0435\u043c mysqldump -u USER -pPASSWORD DATABASE | gzip\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/skilx.cc\/unlix\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/skilx.cc\/unlix\/wp-content\/uploads\/2016\/03\/database-backup.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/skilx.cc\/unlix\/wp-content\/uploads\/2016\/03\/database-backup.png\" \/>\n\t\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t\t<meta property=\"og:image:height\" content=\"688\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2016-03-22T06:07:34+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-10-24T02:15:50+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"\u0411\u044d\u043a\u0430\u043f\u0438\u043c \u0431\u0430\u0437\u044b MySQL | UNLIX\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\u0414\u0435\u043b\u0430\u0435\u043c \u0431\u0435\u043a\u0430\u043f mysqldump -u USER -pPASSWORD DATABASE &gt; \/path\/to\/file\/dump.sql \u0421\u043e\u0437\u0434\u0430\u0451\u043c \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0443 \u0431\u0430\u0437\u044b \u0431\u0435\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 mysqldump --no-data - u USER -pPASSWORD DATABASE &gt; \/path\/to\/file\/schema.sql \u0415\u0441\u043b\u0438 \u043d\u0443\u0436\u043d\u043e \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u0434\u0430\u043c\u043f \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0434\u043d\u043e\u0439 \u0438\u043b\u0438 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 mysqldump -u USER -pPASSWORD DATABASE TABLE1 TABLE2 TABLE3 &gt; \/path\/to\/file\/dump_table.sql \u0421\u043e\u0437\u0434\u0430\u0451\u043c \u0431\u0435\u043a\u0430\u043f \u0438 \u0441\u0440\u0430\u0437\u0443 \u0435\u0433\u043e \u0430\u0440\u0445\u0438\u0432\u0438\u0440\u0443\u0435\u043c mysqldump -u USER -pPASSWORD DATABASE | gzip\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/skilx.cc\/unlix\/wp-content\/uploads\/2016\/03\/database-backup.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\\\/#article\",\"name\":\"\\u0411\\u044d\\u043a\\u0430\\u043f\\u0438\\u043c \\u0431\\u0430\\u0437\\u044b MySQL | UNLIX\",\"headline\":\"\\u0411\\u044d\\u043a\\u0430\\u043f\\u0438\\u043c \\u0431\\u0430\\u0437\\u044b MySQL\",\"author\":{\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/author\\\/admin\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/wp-content\\\/uploads\\\/2016\\\/03\\\/database-backup.png\",\"width\":800,\"height\":688},\"datePublished\":\"2016-03-22T09:07:34+03:00\",\"dateModified\":\"2019-10-24T05:15:50+03:00\",\"inLanguage\":\"ru-RU\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\\\/#webpage\"},\"articleSection\":\"MySQL, backup, linux, mysql, mysqldump, \\u0430\\u0434\\u043c\\u0438\\u043d\\u0438\\u0441\\u0442\\u0440\\u0438\\u0440\\u043e\\u0432\\u0430\\u043d\\u0438\\u0435, \\u0431\\u044d\\u043a\\u0430\\u043f, \\u043b\\u0438\\u043d\\u0443\\u043a\\u0441, \\u0440\\u0435\\u0437\\u0435\\u0440\\u0432\\u043d\\u0430\\u044f \\u043a\\u043e\\u043f\\u0438\\u044f, \\u0441\\u0434\\u0435\\u043b\\u0430\\u0442\\u044c\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/skilx.cc\\\/unlix\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/category\\\/%d1%81%d0%bb%d1%83%d0%b6%d0%b1%d1%8b\\\/#listItem\",\"name\":\"\\u0421\\u043b\\u0443\\u0436\\u0431\\u044b \\u0438 \\u041f\\u0430\\u043a\\u0435\\u0442\\u044b\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/category\\\/%d1%81%d0%bb%d1%83%d0%b6%d0%b1%d1%8b\\\/#listItem\",\"position\":2,\"name\":\"\\u0421\\u043b\\u0443\\u0436\\u0431\\u044b \\u0438 \\u041f\\u0430\\u043a\\u0435\\u0442\\u044b\",\"item\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/category\\\/%d1%81%d0%bb%d1%83%d0%b6%d0%b1%d1%8b\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/category\\\/%d1%81%d0%bb%d1%83%d0%b6%d0%b1%d1%8b\\\/mysql\\\/#listItem\",\"name\":\"MySQL\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/category\\\/%d1%81%d0%bb%d1%83%d0%b6%d0%b1%d1%8b\\\/mysql\\\/#listItem\",\"position\":3,\"name\":\"MySQL\",\"item\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/category\\\/%d1%81%d0%bb%d1%83%d0%b6%d0%b1%d1%8b\\\/mysql\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\\\/#listItem\",\"name\":\"\\u0411\\u044d\\u043a\\u0430\\u043f\\u0438\\u043c \\u0431\\u0430\\u0437\\u044b MySQL\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/category\\\/%d1%81%d0%bb%d1%83%d0%b6%d0%b1%d1%8b\\\/#listItem\",\"name\":\"\\u0421\\u043b\\u0443\\u0436\\u0431\\u044b \\u0438 \\u041f\\u0430\\u043a\\u0435\\u0442\\u044b\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\\\/#listItem\",\"position\":4,\"name\":\"\\u0411\\u044d\\u043a\\u0430\\u043f\\u0438\\u043c \\u0431\\u0430\\u0437\\u044b MySQL\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/category\\\/%d1%81%d0%bb%d1%83%d0%b6%d0%b1%d1%8b\\\/mysql\\\/#listItem\",\"name\":\"MySQL\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/#organization\",\"name\":\"UNLIX\",\"description\":\"\\u0437\\u0430\\u043c\\u0435\\u0442\\u043a\\u0438 \\u043e UNIX \\u0438 LINUX \\u0441\\u0438\\u0441\\u0442\\u0435\\u043c\\u0430\\u0445\",\"url\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/author\\\/admin\\\/#author\",\"url\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/author\\\/admin\\\/\",\"name\":\"UNLIX\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/eb658ed897a5bd13cad2519cd095d49eb0268cd23e9c6ae956a0bdc37bfd9ae8?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"UNLIX\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\\\/#webpage\",\"url\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\\\/\",\"name\":\"\\u0411\\u044d\\u043a\\u0430\\u043f\\u0438\\u043c \\u0431\\u0430\\u0437\\u044b MySQL | UNLIX\",\"description\":\"\\u0414\\u0435\\u043b\\u0430\\u0435\\u043c \\u0431\\u0435\\u043a\\u0430\\u043f mysqldump -u USER -pPASSWORD DATABASE > \\\/path\\\/to\\\/file\\\/dump.sql \\u0421\\u043e\\u0437\\u0434\\u0430\\u0451\\u043c \\u0441\\u0442\\u0440\\u0443\\u043a\\u0442\\u0443\\u0440\\u0443 \\u0431\\u0430\\u0437\\u044b \\u0431\\u0435\\u0437 \\u0434\\u0430\\u043d\\u043d\\u044b\\u0445 mysqldump --no-data - u USER -pPASSWORD DATABASE > \\\/path\\\/to\\\/file\\\/schema.sql \\u0415\\u0441\\u043b\\u0438 \\u043d\\u0443\\u0436\\u043d\\u043e \\u0441\\u0434\\u0435\\u043b\\u0430\\u0442\\u044c \\u0434\\u0430\\u043c\\u043f \\u0442\\u043e\\u043b\\u044c\\u043a\\u043e \\u043e\\u0434\\u043d\\u043e\\u0439 \\u0438\\u043b\\u0438 \\u043d\\u0435\\u0441\\u043a\\u043e\\u043b\\u044c\\u043a\\u0438\\u0445 \\u0442\\u0430\\u0431\\u043b\\u0438\\u0446 mysqldump -u USER -pPASSWORD DATABASE TABLE1 TABLE2 TABLE3 > \\\/path\\\/to\\\/file\\\/dump_table.sql \\u0421\\u043e\\u0437\\u0434\\u0430\\u0451\\u043c \\u0431\\u0435\\u043a\\u0430\\u043f \\u0438 \\u0441\\u0440\\u0430\\u0437\\u0443 \\u0435\\u0433\\u043e \\u0430\\u0440\\u0445\\u0438\\u0432\\u0438\\u0440\\u0443\\u0435\\u043c mysqldump -u USER -pPASSWORD DATABASE | gzip\",\"inLanguage\":\"ru-RU\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/author\\\/admin\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/author\\\/admin\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/wp-content\\\/uploads\\\/2016\\\/03\\\/database-backup.png\",\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\\\/#mainImage\",\"width\":800,\"height\":688},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\\\/#mainImage\"},\"datePublished\":\"2016-03-22T09:07:34+03:00\",\"dateModified\":\"2019-10-24T05:15:50+03:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/#website\",\"url\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/\",\"name\":\"UNLIX\",\"description\":\"\\u0437\\u0430\\u043c\\u0435\\u0442\\u043a\\u0438 \\u043e UNIX \\u0438 LINUX \\u0441\\u0438\\u0441\\u0442\\u0435\\u043c\\u0430\\u0445\",\"inLanguage\":\"ru-RU\",\"publisher\":{\"@id\":\"https:\\\/\\\/skilx.cc\\\/unlix\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\u0411\u044d\u043a\u0430\u043f\u0438\u043c \u0431\u0430\u0437\u044b MySQL | UNLIX","description":"\u0414\u0435\u043b\u0430\u0435\u043c \u0431\u0435\u043a\u0430\u043f mysqldump -u USER -pPASSWORD DATABASE > \/path\/to\/file\/dump.sql \u0421\u043e\u0437\u0434\u0430\u0451\u043c \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0443 \u0431\u0430\u0437\u044b \u0431\u0435\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 mysqldump --no-data - u USER -pPASSWORD DATABASE > \/path\/to\/file\/schema.sql \u0415\u0441\u043b\u0438 \u043d\u0443\u0436\u043d\u043e \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u0434\u0430\u043c\u043f \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0434\u043d\u043e\u0439 \u0438\u043b\u0438 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 mysqldump -u USER -pPASSWORD DATABASE TABLE1 TABLE2 TABLE3 > \/path\/to\/file\/dump_table.sql \u0421\u043e\u0437\u0434\u0430\u0451\u043c \u0431\u0435\u043a\u0430\u043f \u0438 \u0441\u0440\u0430\u0437\u0443 \u0435\u0433\u043e \u0430\u0440\u0445\u0438\u0432\u0438\u0440\u0443\u0435\u043c mysqldump -u USER -pPASSWORD DATABASE | gzip","canonical_url":"https:\/\/skilx.cc\/unlix\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\/","robots":"max-image-preview:large","keywords":"backup,linux,mysql,mysqldump,\u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435,\u0431\u044d\u043a\u0430\u043f,\u043b\u0438\u043d\u0443\u043a\u0441,\u0440\u0435\u0437\u0435\u0440\u0432\u043d\u0430\u044f \u043a\u043e\u043f\u0438\u044f,\u0441\u0434\u0435\u043b\u0430\u0442\u044c","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/skilx.cc\/unlix\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\/#article","name":"\u0411\u044d\u043a\u0430\u043f\u0438\u043c \u0431\u0430\u0437\u044b MySQL | UNLIX","headline":"\u0411\u044d\u043a\u0430\u043f\u0438\u043c \u0431\u0430\u0437\u044b MySQL","author":{"@id":"https:\/\/skilx.cc\/unlix\/author\/admin\/#author"},"publisher":{"@id":"https:\/\/skilx.cc\/unlix\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/skilx.cc\/unlix\/wp-content\/uploads\/2016\/03\/database-backup.png","width":800,"height":688},"datePublished":"2016-03-22T09:07:34+03:00","dateModified":"2019-10-24T05:15:50+03:00","inLanguage":"ru-RU","mainEntityOfPage":{"@id":"https:\/\/skilx.cc\/unlix\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\/#webpage"},"isPartOf":{"@id":"https:\/\/skilx.cc\/unlix\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\/#webpage"},"articleSection":"MySQL, backup, linux, mysql, mysqldump, \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435, \u0431\u044d\u043a\u0430\u043f, \u043b\u0438\u043d\u0443\u043a\u0441, \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u0430\u044f \u043a\u043e\u043f\u0438\u044f, \u0441\u0434\u0435\u043b\u0430\u0442\u044c"},{"@type":"BreadcrumbList","@id":"https:\/\/skilx.cc\/unlix\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/skilx.cc\/unlix#listItem","position":1,"name":"Home","item":"https:\/\/skilx.cc\/unlix","nextItem":{"@type":"ListItem","@id":"https:\/\/skilx.cc\/unlix\/category\/%d1%81%d0%bb%d1%83%d0%b6%d0%b1%d1%8b\/#listItem","name":"\u0421\u043b\u0443\u0436\u0431\u044b \u0438 \u041f\u0430\u043a\u0435\u0442\u044b"}},{"@type":"ListItem","@id":"https:\/\/skilx.cc\/unlix\/category\/%d1%81%d0%bb%d1%83%d0%b6%d0%b1%d1%8b\/#listItem","position":2,"name":"\u0421\u043b\u0443\u0436\u0431\u044b \u0438 \u041f\u0430\u043a\u0435\u0442\u044b","item":"https:\/\/skilx.cc\/unlix\/category\/%d1%81%d0%bb%d1%83%d0%b6%d0%b1%d1%8b\/","nextItem":{"@type":"ListItem","@id":"https:\/\/skilx.cc\/unlix\/category\/%d1%81%d0%bb%d1%83%d0%b6%d0%b1%d1%8b\/mysql\/#listItem","name":"MySQL"},"previousItem":{"@type":"ListItem","@id":"https:\/\/skilx.cc\/unlix#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/skilx.cc\/unlix\/category\/%d1%81%d0%bb%d1%83%d0%b6%d0%b1%d1%8b\/mysql\/#listItem","position":3,"name":"MySQL","item":"https:\/\/skilx.cc\/unlix\/category\/%d1%81%d0%bb%d1%83%d0%b6%d0%b1%d1%8b\/mysql\/","nextItem":{"@type":"ListItem","@id":"https:\/\/skilx.cc\/unlix\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\/#listItem","name":"\u0411\u044d\u043a\u0430\u043f\u0438\u043c \u0431\u0430\u0437\u044b MySQL"},"previousItem":{"@type":"ListItem","@id":"https:\/\/skilx.cc\/unlix\/category\/%d1%81%d0%bb%d1%83%d0%b6%d0%b1%d1%8b\/#listItem","name":"\u0421\u043b\u0443\u0436\u0431\u044b \u0438 \u041f\u0430\u043a\u0435\u0442\u044b"}},{"@type":"ListItem","@id":"https:\/\/skilx.cc\/unlix\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\/#listItem","position":4,"name":"\u0411\u044d\u043a\u0430\u043f\u0438\u043c \u0431\u0430\u0437\u044b MySQL","previousItem":{"@type":"ListItem","@id":"https:\/\/skilx.cc\/unlix\/category\/%d1%81%d0%bb%d1%83%d0%b6%d0%b1%d1%8b\/mysql\/#listItem","name":"MySQL"}}]},{"@type":"Organization","@id":"https:\/\/skilx.cc\/unlix\/#organization","name":"UNLIX","description":"\u0437\u0430\u043c\u0435\u0442\u043a\u0438 \u043e UNIX \u0438 LINUX \u0441\u0438\u0441\u0442\u0435\u043c\u0430\u0445","url":"https:\/\/skilx.cc\/unlix\/"},{"@type":"Person","@id":"https:\/\/skilx.cc\/unlix\/author\/admin\/#author","url":"https:\/\/skilx.cc\/unlix\/author\/admin\/","name":"UNLIX","image":{"@type":"ImageObject","@id":"https:\/\/skilx.cc\/unlix\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/eb658ed897a5bd13cad2519cd095d49eb0268cd23e9c6ae956a0bdc37bfd9ae8?s=96&d=mm&r=g","width":96,"height":96,"caption":"UNLIX"}},{"@type":"WebPage","@id":"https:\/\/skilx.cc\/unlix\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\/#webpage","url":"https:\/\/skilx.cc\/unlix\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\/","name":"\u0411\u044d\u043a\u0430\u043f\u0438\u043c \u0431\u0430\u0437\u044b MySQL | UNLIX","description":"\u0414\u0435\u043b\u0430\u0435\u043c \u0431\u0435\u043a\u0430\u043f mysqldump -u USER -pPASSWORD DATABASE > \/path\/to\/file\/dump.sql \u0421\u043e\u0437\u0434\u0430\u0451\u043c \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0443 \u0431\u0430\u0437\u044b \u0431\u0435\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 mysqldump --no-data - u USER -pPASSWORD DATABASE > \/path\/to\/file\/schema.sql \u0415\u0441\u043b\u0438 \u043d\u0443\u0436\u043d\u043e \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u0434\u0430\u043c\u043f \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0434\u043d\u043e\u0439 \u0438\u043b\u0438 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 mysqldump -u USER -pPASSWORD DATABASE TABLE1 TABLE2 TABLE3 > \/path\/to\/file\/dump_table.sql \u0421\u043e\u0437\u0434\u0430\u0451\u043c \u0431\u0435\u043a\u0430\u043f \u0438 \u0441\u0440\u0430\u0437\u0443 \u0435\u0433\u043e \u0430\u0440\u0445\u0438\u0432\u0438\u0440\u0443\u0435\u043c mysqldump -u USER -pPASSWORD DATABASE | gzip","inLanguage":"ru-RU","isPartOf":{"@id":"https:\/\/skilx.cc\/unlix\/#website"},"breadcrumb":{"@id":"https:\/\/skilx.cc\/unlix\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\/#breadcrumblist"},"author":{"@id":"https:\/\/skilx.cc\/unlix\/author\/admin\/#author"},"creator":{"@id":"https:\/\/skilx.cc\/unlix\/author\/admin\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/skilx.cc\/unlix\/wp-content\/uploads\/2016\/03\/database-backup.png","@id":"https:\/\/skilx.cc\/unlix\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\/#mainImage","width":800,"height":688},"primaryImageOfPage":{"@id":"https:\/\/skilx.cc\/unlix\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\/#mainImage"},"datePublished":"2016-03-22T09:07:34+03:00","dateModified":"2019-10-24T05:15:50+03:00"},{"@type":"WebSite","@id":"https:\/\/skilx.cc\/unlix\/#website","url":"https:\/\/skilx.cc\/unlix\/","name":"UNLIX","description":"\u0437\u0430\u043c\u0435\u0442\u043a\u0438 \u043e UNIX \u0438 LINUX \u0441\u0438\u0441\u0442\u0435\u043c\u0430\u0445","inLanguage":"ru-RU","publisher":{"@id":"https:\/\/skilx.cc\/unlix\/#organization"}}]},"og:locale":"ru_RU","og:site_name":"UNLIX - \u0437\u0430\u043c\u0435\u0442\u043a\u0438 \u043e UNIX \u0438 LINUX \u0441\u0438\u0441\u0442\u0435\u043c\u0430\u0445","og:type":"article","og:title":"\u0411\u044d\u043a\u0430\u043f\u0438\u043c \u0431\u0430\u0437\u044b MySQL | UNLIX","og:description":"\u0414\u0435\u043b\u0430\u0435\u043c \u0431\u0435\u043a\u0430\u043f mysqldump -u USER -pPASSWORD DATABASE &gt; \/path\/to\/file\/dump.sql \u0421\u043e\u0437\u0434\u0430\u0451\u043c \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0443 \u0431\u0430\u0437\u044b \u0431\u0435\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 mysqldump --no-data - u USER -pPASSWORD DATABASE &gt; \/path\/to\/file\/schema.sql \u0415\u0441\u043b\u0438 \u043d\u0443\u0436\u043d\u043e \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u0434\u0430\u043c\u043f \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0434\u043d\u043e\u0439 \u0438\u043b\u0438 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 mysqldump -u USER -pPASSWORD DATABASE TABLE1 TABLE2 TABLE3 &gt; \/path\/to\/file\/dump_table.sql \u0421\u043e\u0437\u0434\u0430\u0451\u043c \u0431\u0435\u043a\u0430\u043f \u0438 \u0441\u0440\u0430\u0437\u0443 \u0435\u0433\u043e \u0430\u0440\u0445\u0438\u0432\u0438\u0440\u0443\u0435\u043c mysqldump -u USER -pPASSWORD DATABASE | gzip","og:url":"https:\/\/skilx.cc\/unlix\/%d0%b1%d1%8d%d0%ba%d0%b0%d0%bf%d0%b8%d0%bc-%d0%b1%d0%b0%d0%b7%d1%8b-mysql\/","og:image":"https:\/\/skilx.cc\/unlix\/wp-content\/uploads\/2016\/03\/database-backup.png","og:image:secure_url":"https:\/\/skilx.cc\/unlix\/wp-content\/uploads\/2016\/03\/database-backup.png","og:image:width":800,"og:image:height":688,"article:published_time":"2016-03-22T06:07:34+00:00","article:modified_time":"2019-10-24T02:15:50+00:00","twitter:card":"summary","twitter:title":"\u0411\u044d\u043a\u0430\u043f\u0438\u043c \u0431\u0430\u0437\u044b MySQL | UNLIX","twitter:description":"\u0414\u0435\u043b\u0430\u0435\u043c \u0431\u0435\u043a\u0430\u043f mysqldump -u USER -pPASSWORD DATABASE &gt; \/path\/to\/file\/dump.sql \u0421\u043e\u0437\u0434\u0430\u0451\u043c \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0443 \u0431\u0430\u0437\u044b \u0431\u0435\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 mysqldump --no-data - u USER -pPASSWORD DATABASE &gt; \/path\/to\/file\/schema.sql \u0415\u0441\u043b\u0438 \u043d\u0443\u0436\u043d\u043e \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u0434\u0430\u043c\u043f \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0434\u043d\u043e\u0439 \u0438\u043b\u0438 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 mysqldump -u USER -pPASSWORD DATABASE TABLE1 TABLE2 TABLE3 &gt; \/path\/to\/file\/dump_table.sql \u0421\u043e\u0437\u0434\u0430\u0451\u043c \u0431\u0435\u043a\u0430\u043f \u0438 \u0441\u0440\u0430\u0437\u0443 \u0435\u0433\u043e \u0430\u0440\u0445\u0438\u0432\u0438\u0440\u0443\u0435\u043c mysqldump -u USER -pPASSWORD DATABASE | gzip","twitter:image":"https:\/\/skilx.cc\/unlix\/wp-content\/uploads\/2016\/03\/database-backup.png"},"aioseo_meta_data":{"post_id":"190","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[],"defaultGraph":"","defaultPostTypeGraph":""},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-23 09:30:59","updated":"2026-06-08 17:58:40","seo_analyzer_scan_date":null},"_links":{"self":[{"href":"https:\/\/skilx.cc\/unlix\/wp-json\/wp\/v2\/posts\/190","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/skilx.cc\/unlix\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/skilx.cc\/unlix\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/skilx.cc\/unlix\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/skilx.cc\/unlix\/wp-json\/wp\/v2\/comments?post=190"}],"version-history":[{"count":0,"href":"https:\/\/skilx.cc\/unlix\/wp-json\/wp\/v2\/posts\/190\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/skilx.cc\/unlix\/wp-json\/wp\/v2\/media\/191"}],"wp:attachment":[{"href":"https:\/\/skilx.cc\/unlix\/wp-json\/wp\/v2\/media?parent=190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/skilx.cc\/unlix\/wp-json\/wp\/v2\/categories?post=190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/skilx.cc\/unlix\/wp-json\/wp\/v2\/tags?post=190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}