views:

211

answers:

3

Hi all,

I've been playing with mysqlimport and I've run into the restriction where the filename has to be the same as the table name. Is there any way to work round this?

I can't rename the file as it is used by other processes and I don't want to copy the file as there will be many of them, some being very large.

I want to use mysqlimport not LOAD INFILE.

EDIT: Unfortunately this needs to run on windows so no tricks with symbolic links I'm afraid.

A: 

Have you tried using the alias command, assuming you are on a Linux system?

Chris McCall
A: 

Just create a symbolic link:

ln -s /tmp/real_file.txt /tmp/your_table_name.txt
Ike Walker
+2  A: 

You didn't say what platform you are on. On unix you can create a symbolic link to the file:

ln -s filename.txt tablename.txt

Then use that in the mysqlimport command.

But mysqlimport is just a command line interface to LOAD INFILE so you could also do this on the command line:

mysql -e "load data infile 'filename' into table TBL_NAME" dbname
Craig
Afraid I'm on windows.
Mike Q