四时宝库

导出

# 导出整个库
mysqldump -h192.168.10.4 -uroot -p --opt dbname > backup_full20181005.sql
# 单表导出
mysqldump -h192.168.10.4 -uroot -p --opt --databases dbname --tables tablename1 > backup_20181005_dbname1.sql
# 导出多张表(只有数据)
mysqldump -h192.168.10.4 -uroot -p --no-create-info --opt dbname tablename1 tablename2 tablename3 tablename4 > backup_table1234_20181005.sql
# 只要结构的话使用参数 --no-datada
# where 条件导出
mysqldump -h192.168.10.4 -uroot -p --opt --databases dbname --tables tablename -w "column_name < '2018-06-01 00:00:00'" > backup20181005_tablename.sql

导入

# 控制台登录mysql
mysql -uroot -p
use dbname;
set names utf8;
source backup_full20181005.sql;
# 或者无控制台输出的
mysql -uroot -p database_name_here < dump_file_name_here.sql

大文件拆分合并

# 拆分
split -b 2G backup_full20181005.zip backup_full20181005.zip.
# 合并
cat backup_full20181005.zip.* > backup_full20181005.zip