开发者

mysqlimport without mysql installation?

开发者 https://www.devze.com 2023-03-26 08:35 出处:网络
I\'m trying to use mysqlimport to import text files to a mysql database.The problem is that the linux box I am importing the text files from will not have an installation of mysql and I am importing t

I'm trying to use mysqlimport to import text files to a mysql database. The problem is that the linux box I am importing the text files from will not have an installation of mysql and I am importing these files to a databa开发者_JAVA技巧se on a different server. Does mysqlimport need to have a full installation of mysql to work? Can I just bring over the mysqlimport exe and some libraries? Cheers, Kaiser


Yes, you can use it standalone, among the options described here you can specify host to connect to, and the user and password to use. No need for the box where mysqlimport is to have the server installed.

I believe you need nothing more that the RPM Package Client Utilities.


As long as you can connect to the database server from the client you are running on, it is fully enough to have a MySQL client installation.

mysqlimport -h host -p port [options] db_name textfile1 textfile2

Compare the MySQL reference manual or execute

mysqlimport --help
0

精彩评论

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

关注公众号