标签存档: backup

关于备份数据库的一些命令

backup & restore: mysqldump -uroot -p1234 –no-create-db taobao awang_activity_link awang_shorturl awang_activity awang_channel awang_user_question | gzip > awang_activity_link.$(date +’%Y%m%d%H’).sql.gz mysqldump -hhostname -uusername -ppassword db > backupfile.sql mysqldump –add-drop-table -uusername -ppassword db > backupfile.sql mysqldump … | gzip > backupfile.sql.gz mysqldump … …

继续阅读 »