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

mysql -hhostname -uusername -ppassword –default-character-set=utf8 databasename < backup.sql

mysqldump -u username -p -all-databases > BackupName.sql

导数据结构：mysqldump -u username -p dbname table1 table2 …-> BackupName.sql

导结构：mysqldump -u username -p  -d dbname table1 table2 …-> BackupName.sql

mysqldump –single-transaction –ignore-table=db_name.t1 –ignore-table=db_name.t2 -uroot -pxxxxxxx db_name > db_name.sql

#!/bin/bash

source /etc/profile

backupdir=/work/backup

time=` date +%Y%m%d%H%M `

mysqldump gzserv | gzip > ${backupdir}/${time}_gzserv.sql.gz

find /work/backup -mtime +10 -name “*_gzserv.sql.gz” -exec rm -r {} \;