不知道 这样符不符合你的要求,假设有一个表test(id,name),现在有10条记录,现在把这10条记录导出:select * outfile "C:/2006-8-2-1530_test_backup.txt" fields terminated by ',' enclosed by '"' lines terminated by '\r\n' from test;好了,刚刚又有100条记录写入表里,记录总数为110,现在我要把这刚增加的100新记录导出来
select * outfile "C:/2006-8-2-1534_test_backup.txt" fields terminated by ','enclosed by '"' lines terminated by '\r\n' from test where id>10;不过这样的增量备份效率不是很好。
select * outfile "C:/2006-8-2-1534_test_backup.txt" fields terminated by ','enclosed by '"' lines terminated by '\r\n' from test where id>10;不过这样的增量备份效率不是很好。
有没有什么好的办法,一下子把这个纯数据文件全导到库里面的表中???
mysql>load data infile "C:/2006-8-2-1530_test_backup.txt" into table tablename fields terminated by ',' enclosed by '"' lines terminated by '\r\n';
load data infile的效率非常高