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

mysqldump -hhostname -uusername -ppassword databasename > backupfile.sql

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

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

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

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 -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

mysqldump  | gzip > outputfile.sql.gz

gunzip 

mysqldump  | bzip2 > outputfile.sql.bz2

bunzip2