Home > Database > Mysql Tutorial > MYSQLDUMP备份和还原MYSQL数据库_MySQL

MYSQLDUMP备份和还原MYSQL数据库_MySQL

WBOY
Release: 2016-06-01 13:41:22
Original
744 people have browsed it

mysqldump

bitsCN.com
MYSQLDUMP备份和还原MYSQL数据库 mysqldump [OPTIONS] database [tables]如果不给定任何表,整个数据库将被导出。     备份MySQL数据库的命令mysqldump -hhostname -uusername -ppassword databasename > backupfile.sql备份MySQL数据库为带删除表的格式
 备份MySQL数据库为带删除表的格式,能够让该备份覆盖已有数据库而不需要手动删除原有数据库。mysqldump -–add-drop-table -uusername -ppassword databasename > backupfile.sql直接将MySQL数据库压缩备份mysqldump -hhostname -uusername -ppassword databasename | gzip > backupfile.sql.gz备份MySQL数据库某个(些)表mysqldump -hhostname -uusername -ppassword databasename specific_table1 specific_table2 > backupfile.sql
 同时备份多个MySQL数据库mysqldump -hhostname -uusername -ppassword –databases databasename1 databasename2 databasename3 > multibackupfile.sql仅仅备份数据库结构    mysqldump –no-data –databases databasename1 databasename2 databasename3 > structurebackupfile.sql
 备份服务器上所有数据库mysqldump –all-databases > allbackupfile.sql还原MySQL数据库的命令mysql -hhostname -uusername -ppassword databasename 1" "-wuserid backup-file.sql   但是它对用来自于一个数据库的信息充实另外一个MySQL数据库也是有用的:   mysqldump --opt database | mysql --host=remote-host -C database   由于mysqldump导出的是完整的SQL语句,所以用mysql客户程序很容易就能把数据导入了:   mysqladmin create target_db_name   mysql target_db_name 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