数据库备份还原相关备忘

数据库备份

shell> mysqldump --quick db_name | gzip > db_name.contents.gz	shell> gunzip < db_name.contents.gz | mysql db_name
mysql -uroot -ppassword -e "select * into outfile '/home/mysql/out.sql' from dataabase.table where id = NUMBER" scp /home/mysql/out.sql	mysql -uroot -ppassword -e "load data local infile '/home/mysql/out.sql' into database.table"
mysqldump -uroot -pintel123  database table > table_bak.sql	mysql> source  /../../table_bak.sql  (table_bak.sql can contains multi lines of 'sourrce xx.sql')

备份 存储过程：

        mysqldump --skip-opt -t -d -R -uroot -pintel123 cv2> cv2_pro.sql