博客

mysqldump备份

mysqldump -u root -p gateway > /home/mysqlBack/gateway.sql

mysqldump导入

进入 mysql
create database uimpx_sewage_treatment;
use uimpx_sewage_treatment;
source /home/mysqlBack/uimpx_sewage_treatment.sql;

转载：
https://www.jb51.net/article/49589.htm

大文件切割

csplit uimpx_receive.sql /INSERT/+10 -n 20000 -s {*} -f uimpx_receive_ -b "%02d.sql"

csplit uimpx_sewage_treatment.sql /INSERT/+10 -n 20000 -s {*} -f uimpx_sewage_treatment_ -b "%02d.sql"

文件合并

cat 文件1 文件2 新的文件名