Home >Database >Mysql Tutorial >MySQL数据库备份和还原的常用命令_MySQL

MySQL数据库备份和还原的常用命令_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:50:341062browse

bitsCN.com

   备份MySQL数据库的命令

<ol class="dp-xml"><li class="alt">mysqldump -hhostname -uusername -ppassword databasename > backupfile.sql </li></ol>

  备份MySQL数据库为带删除表的格式

  备份MySQL数据库为带删除表的格式,能够让该备份覆盖已有数据库而不需要手动删除原有数据库。

<ol class="dp-xml"><li class="alt">mysqldump -–add-drop-table -uusername -ppassword databasename > backupfile.sql </li></ol>

  直接将MySQL数据库压缩备份

<ol class="dp-xml"><li class="alt">mysqldump -hhostname -uusername -ppassword databasename | gzip > backupfile.sql.gz </li></ol>

  备份MySQL数据库某个(些)表

<ol class="dp-xml"><li class="alt">mysqldump -hhostname -uusername -ppassword databasename specific_table1 specific_table2 > backupfile.sql </li></ol>

  同时备份多个MySQL数据库

<ol class="dp-xml"><li class="alt">mysqldump -hhostname -uusername -ppassword –databases databasename1 databasename2 databasename3 > multibackupfile.sql </li></ol>

  仅仅备份数据库结构

<ol class="dp-xml"><li class="alt">mysqldump –no-data –databases databasename1 databasename2 databasename3 > structurebackupfile.sql </li></ol>

  备份服务器上所有数据库

<ol class="dp-xml"><li class="alt">mysqldump –all-databases > allbackupfile.sql </li></ol>

  还原MySQL数据库的命令

<ol class="dp-xml"><li class="alt">mysql -hhostname -uusername -ppassword databasename </li></ol>

  还原压缩的MySQL数据库

<ol class="dp-xml"><li class="alt">gunzip </li></ol>

  将数据库转移到新服务器

<ol class="dp-xml"><li class="alt">mysqldump -uusername -ppassword databasename | mysql –host=*.*.*.* -C databasename </li></ol>

  Thanks, Ivan

bitsCN.com
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn