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

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

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-01 13:50:34
Original
1061 people have browsed it

bitsCN.com

   备份MySQL数据库的命令

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

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

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

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

  直接将MySQL数据库压缩备份

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

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

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

  同时备份多个MySQL数据库

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

  仅仅备份数据库结构

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

  备份服务器上所有数据库

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

  还原MySQL数据库的命令

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

  还原压缩的MySQL数据库

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

  将数据库转移到新服务器

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

  Thanks, Ivan

bitsCN.com
Related labels:
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template