mysql批量导出导入脚本

mysqldump script

有点尴尬，写反了，现在已经更正了v0.2

####### mysqldump script
#version 0.2
#update 2020-07-03
#autor：chunk

DATABASE=abc_msg_1


array=(t_msg_message_history_201901.sql  t_msg_message_history_201902.sql t_msg_message_history_201903.sql t_msg_message_history_201904.sql t_msg_message_history_201905.sql t_msg_message_history_201906.sql t_msg_message_history_201907.sql t_msg_message_history_201908.sql t_msg_message_history_201909.sql t_msg_message_history_201910.sql t_msg_message_history_201911.sql t_msg_message_history_201912.sql  t_msg_message_history_202001.sql  t_msg_message_history_202002.sql  t_msg_message_history_202003.sql t_msg_message_history_202004.sql  t_msg_message_history_202005.sql  t_msg_message_history_202006.sql)


### ${SQL%%.sql}表示截取 .sql 左边的所有字符。 ex: ${DATABASE}_t_msg_message_history_202006
for SQL in ${array[@]}; do mysqldump -uroot -p3123456 -h127.0.0.1   ${DATABASE} ${SQL%%.sql} > ${SQL}; done

mysql restore script

########### mysql restore script
#version 0.2
#update 2020-07-03
#autor：chunk
DATABASE=abc_msg_1
#RE_DATABASE=abc_msg_1_bak

array=(t_msg_message_history_201901.sql  t_msg_message_history_201902.sql t_msg_message_history_201903.sql t_msg_message_history_201904.sql t_msg_message_history_201905.sql t_msg_message_history_201906.sql t_msg_message_history_201907.sql t_msg_message_history_201908.sql t_msg_message_history_201909.sql t_msg_message_history_201910.sql t_msg_message_history_201911.sql t_msg_message_history_201912.sql  t_msg_message_history_202001.sql  t_msg_message_history_202002.sql  t_msg_message_history_202003.sql t_msg_message_history_202004.sql  t_msg_message_history_202005.sql  t_msg_message_history_202006.sql)

for SQL in ${array[@]}; do mysql -uroot -p123456 -h127.0.0.1 --database=${DATABASE}_bak < ${DATABASE}_$SQL; done