mysqlimport without mysql installation?

问题:

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 database 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

回答1:

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.

回答2:

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