Using mysqlimport on a WinNT machine to connect to MySQL running on a Linux RedHat machine
- Both versions are 3.23.20. Sorry for not using MySQL bug script, but this is a problem
for me on NT.
mysqlimport -p -L -h xxx.eskom.co.za --fields-terminated-by=, -u realsecure realsecure
EventData.csv
Enter password: ********
mysqlimport: Error: Table 'realsecure.eventdata' doesn't exist, when using table
: eventdata
The filename which translates to the tablename under NT is silently converted to
lowercase. Unix is case sensitive and this causes the table not to be found. The case of
the tablename should be preserved.
While we are with mysqlimport, the help screen has the following line:
-d, --delete Deletes first all rows from table.
This is incorrect English. The correct term should be "First delete all rows from table."
--
Richard Ellerbrock
richarde@stripped