mysqldump 導入導出資料庫

grant lock tables on $database.* to '$user'@'localhost';
                          # 導入導出資料庫的權限

mysqldump -ueisc -p  --databases eisc > eisc.sql
                          # 導出資料庫 eisc
                       
mysqldump -ueisc -peisc.cn eisc --tables bbb  > eisc.bbb.sql 
                          # 導出從資料庫eisc中指定表 bbb

yum -y install holland-mysqldump.noarch   # 安裝mysqldump導入導出工具


use eisc; SELECT now();DROP  TABLE eisc ;create table eisc(id int,name varchar(225),password varchar(255),xingqi varchar(255),city varchar(255));insert into eisc(id,name,password,xingqi,city) values('1','aaa','qqqqq','xingqiyi','ssss'),('2','bbb','qqqqq','xingqier','ddddafweaafe'),('3','ccc','qqqqq','xingqisan','hrgzsaedg');select * from `eisc` ;
# 進入資料庫 eisc ； 删除eisc表，建立表，插入表，查詢表内容

 mysqldump -ueisc -peisc.cn eisc > /root/eisc.sql
将資料庫eisc導出為eisc.sql 檔案

mysql -ueisc -peisc.cn -e "use eisc;delete from eisc where 'password' ='qqqqq' order by id limit 2;select * from eisc;source /root/eisc.sql;show tables;select * from eisc;"
# 進入資料庫eisc，删除表中資料庫password是qqqqq的，将id列 排序前兩列，
# 查詢表，source 導入資料庫，列出表檢視表。


mysqldump --skip-lock-tables  -ueisc -peisccn@eisc eisc --tables bbb  > eisc.bbb.sql
怎麼避免鎖表:在使用參數--skip-opt的時候，忽略了此參數AUTO_INCREMENT，導緻恢複後資料沒有自增id。


mysqldump --opt -d -ueisc -peisccn@eisc eisc  > eisc.bbb.sql
# 不備份任何資料，隻導出資料庫表結構。