tags:

views:

5

answers:

0
Q: 

mysqlimport leave out last line of csv file

Hi,

is it possible to leave out the last line of a CSV file, because i have a huge file, like 300.000 records in a CSV file and at the end i have END because else we had some issues with the FTP server not giving complete files as Oracle was still writing to it.

so now I would like to import the CSV file with mysqlimport but leave out the last END line, is this possible and how?

because i don't like the overhead of copying the entire file every single minute..

Thank you so much!

related questions

Migrating mysql database - need to change max_allowed_packets without shell access
Bad Situation importing/exporting img files - mysql database
Why is MySQL auto_increment skipping numbers.
How to import a mysql dump while renaming some tables/columns and not importing others at all?
Maintain case sensitivity when importing db into windows
Cannot Successfully Export And Then ReImport A View In MySql 5
Using mysqlimport where the filename is different from the table name
How to use mysqlimport to read in result of mysqldump --databases
Importing text to MySQL: strange format
Importing text to MySQL: strange format
Can I import tab-separated files into MySQL without creating database tables first?
How to accumulate results using mysqlimport
MySqlImport - Import a date field not in the proper format
How to refresh a MySQL table without website interruption?
mysqlimport and double-quotes
On mysqlimport, line breaks, and character encoding (I think)
How do I import a whitespace-delimited text file into MySQL?