MYSQL 备份与恢复

<strong><span style="font-size: 15px"><span class="cm-comment">//1.备份 demo下的 test表</span></span></strong>

<strong><span style="font-size: 15px"><span class="cm-variable">mysqldump <span class="cm-operator">-<span class="cm-variable">uroot <span class="cm-operator">-<span class="cm-variable">p <span class="cm-variable">demo <span class="cm-variable">test <span class="cm-operator">><span class="cm-variable">E:<span class="cm-string-2">/test.sql<br><br><br></span></span></span></span></span></span></span></span></span></span></span></strong>

<strong><span style="font-size: 15px"><span class="cm-comment">//2.多张表备份</span></span></strong>

<strong><span style="font-size: 15px"><span class="cm-variable">mysqldump <span class="cm-operator">-<span class="cm-variable">uroot <span class="cm-operator">-<span class="cm-variable">p <span class="cm-variable">demo <span class="cm-variable">test <span class="cm-variable">account<span class="cm-operator">><span class="cm-variable">E:<span class="cm-string-2">/db.sql<br><br><br></span></span></span></span></span></span></span></span></span></span></span></span></strong>

<strong><span style="font-size: 15px"><span class="cm-comment">//3.备份一个数据库</span></span></strong>

<strong><span style="font-size: 15px"><span class="cm-variable">mysqldump <span class="cm-operator">-<span class="cm-variable">uroot <span class="cm-operator">-<span class="cm-variable">p <span class="cm-variable">demo <span class="cm-operator">><span class="cm-variable">E:<span class="cm-string-2">/demo.sql<br><br><br></span></span></span></span></span></span></span></span></span></span></strong>

<strong><span style="font-size: 15px"><span class="cm-comment">//4.备份多个数据库  必须告诉服务器 我后面是数据库</span></span></strong>

<strong><span style="font-size: 15px"><span class="cm-variable">mysqldump <span class="cm-operator">-<span class="cm-variable">uroot <span class="cm-operator">-<span class="cm-variable">p <span class="cm-operator">-<span class="cm-variable">B <span class="cm-variable">demo <span class="cm-variable">demo2<span class="cm-operator">><span class="cm-variable">E:<span class="cm-string-2">/all.sql<br><br><br></span></span></span></span></span></span></span></span></span></span></span></span></span></strong>

<strong><span style="font-size: 15px"><span class="cm-comment">//命令行下 恢复多个数据库</span></span></strong>

<strong><span style="font-size: 15px"><span class="cm-variable">mysql <span class="cm-operator">-<span class="cm-variable">uroot <span class="cm-operator">-<span class="cm-variable">p <span class="cm-operator">< <span class="cm-variable">E:<span class="cm-string-2">/all.sql<br><br><br></span></span></span></span></span></span></span></span></span></strong>

<strong><span style="font-size: 15px"><span class="cm-comment">//命令行下恢复表格 </span></span></strong>

<strong><span style="font-size: 15px"><span class="cm-variable">mysql <span class="cm-operator">-<span class="cm-variable">uroot <span class="cm-operator">-<span class="cm-variable">p <span class="cm-variable">demo<span class="cm-operator">< <span class="cm-variable">E:<span class="cm-string-2">/test.sql<br><br><br></span></span></span></span></span></span></span></span></span></span></strong>

<strong><span style="font-size: 15px"><span class="cm-comment">//mysql 下恢复表格 </span></span></strong>

<strong><span style="font-size: 15px"><span class="cm-variable">在mysql下 </span></span></strong>

<strong><span style="font-size: 15px"><span class="cm-variable">use <span class="cm-variable">demo2;</span></span></span></strong>

<strong><span style="font-size: 15px"><span class="cm-variable">mysql<span class="cm-operator">> <span class="cm-variable">source <span class="cm-variable">E:<span class="cm-string-2">/test.sql<br><br><br></span></span></span></span></span></span></strong>

<strong><span style="font-size: 15px"><span class="cm-comment">//mysql 下恢复多个数据库</span></span></strong>

<strong><span style="font-size: 15px"><span class="cm-variable">mysql<span class="cm-operator">> <span class="cm-variable">source <span class="cm-variable">E:<span class="cm-string-2">/test.sql</span></span></span></span></span></span></strong>

MYSQL 备份与恢复

标签：-o   mysq   line   命令   variable   备份与恢复   str   blog   operator