1、查看数据库into outfile 路径;show variables like '%secure%';
2、如果该参数为null或者没有值,需要在配置文件中指定一下(/etc/my.cnf;注意:此参数一定要加到mysqld下)
3、配置完后,重启下mysql,查看参数配置是否生效
4、备份
导出(备份):
select * into outfile '/home/mysql/datafile/1218_bak.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' from jssdb.core_host;
导入(恢复):
load data infile '/home/mysql/datafile/1218_bak.txt' into table jssdb.core1 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
//以下参数也可以不添加(不添加则是按照默认方式备份)
FIELDS TERMINATED BY ',' 字段间分割符
OPTIONALLY ENCLOSED BY '"' 将字段包围 对数值型无效
LINES TERMINATED BY '\n' 换行符