开发者

What's the difference between mysqlimport and mysql < dbfile.sql

开发者 https://www.devze.com 2022-12-15 17:19 出处:网络
It\'s basically this - I was used to using mysql < dbfile.sql to restore a database dump created with mysqldump. Then I 开发者_Python百科saw there is mysqlimport, with no reference to the other way

It's basically this - I was used to using mysql < dbfile.sql to restore a database dump created with mysqldump. Then I 开发者_Python百科saw there is mysqlimport, with no reference to the other way. The arguments of both CLIs look similar. So, what's the actual difference? (And is there any)


My understanding is that mysqlimport is the equivalent of LOAD DATA INFILE, so the data to be loaded must be e.g. in CSV format, not the usual output of mysqldump.

0

精彩评论

暂无评论...
验证码 换一张
取 消