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

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

WBOY
Release: 2016-06-01 13:22:39
Original
934 people have browsed it

bitsCN.com

备份MySQL数据库的命令

mysqldump -hhostname -uusername -ppassword databasename > backupfile.sql
Copy after login

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

mysqldump ---add-drop-table -uusername -ppassword databasename > backupfile.sql
Copy after login

直接将MySQL数据库压缩备份

mysqldump -hhostname -uusername -ppassword databasename | gzip > backupfile.sql.gz
Copy after login

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

mysqldump -hhostname -uusername -ppassword databasename specific_table1 specific_table2 > backupfile.sql
Copy after login

同时备份多个MySQL数据库

mysqldump -hhostname -uusername -ppassword --databases databasename1 databasename2 databasename3 > multibackupfile.sql
Copy after login

仅仅备份数据库结构

mysqldump --no-data --databases databasename1 databasename2 databasename3 > structurebackupfile.sql
Copy after login

备份服务器上所有数据库

mysqldump --all-databases  allbackupfile.sql
Copy after login

还原MySQL数据库的命令

mysql -hhostname -uusername -ppassword databasename <p><strong>还原压缩的MySQL数据库</strong></p><pre class="brush:php;toolbar:false">gunzip <p><strong>将数据库转移到新服务器</strong></p><pre class="brush:php;toolbar:false">mysqldump /-uusername /-ppassword databasename /| mysql /--host=*.*.*./* /-C databasename
Copy after login

 

压缩备份   

 

备份并用gzip压缩:

mysqldump  | gzip > outputfile.sql.gz
Copy after login

从gzip备份恢复:

gunzip 
Copy after login

备份并用bzip压缩:

mysqldump  | bzip2 > outputfile.sql.bz2
Copy after login

从bzip2备份恢复:

bunzip2  
Copy after login
bitsCN.com
Related labels:
source:php.cn
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