LOAD DATA INFILE doesn't load all my data
I have 1048 rows of csv data I need to read in. The data looks like this:

    \N,Olenevka,Оленевка,2596
    \N,Urzuf,Урзуф,2904
    \N,Lebedyn,ЛЕБЕДИН,27695
    \N,Staryy Dobrotvor,Staryy Dobrotvor,6436

Here is the table:

    +------------+------------------+------+-----+---------+----------------+
    | Field      | Type             | Null | Key | Default | Extra          |
    +------------+------------------+------+-----+---------+----------------+
    | city_id    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
    | name       | text             | YES  |     | NULL    |                |
    | alt_name   | text             | YES  |     | NULL    |                |
    | population | int(10) unsigned | NO   |     | NULL    |                |
    +------------+------------------+------+-----+---------+----------------+

Here is the code:

    db.query(""" 
        LOAD DATA INFILE '%s' 
        INTO TABLE %s 
        CHARACTER SET utf8
        FIELDS TERMINATED BY ',' 
        (@skip, name, alt_name, population) 
        """ % (temp_file, table))

    class Database(object):
        def __init__(self, database):
            self.database = database
        def query(self, cmd):
            return subprocess.call(['mysql -u root -e "%s" %s' % (cmd, self.database)], shell=True)

When I issue the command from python, I only get 1025 rows into the table. But if I issue the same command from the mysql prompt, I get all 1028.

What's going on?
LOAD DATA INFILE doesn't load all my data
===

I have 1048 rows of csv data I need to read in. The data looks like this:

    \N,Olenevka,Оленевка,2596
    \N,Urzuf,Урзуф,2904
    \N,Lebedyn,ЛЕБЕДИН,27695
    \N,Staryy Dobrotvor,Staryy Dobrotvor,6436

Here is the table:

    +------------+------------------+------+-----+---------+----------------+
    | Field      | Type             | Null | Key | Default | Extra          |
    +------------+------------------+------+-----+---------+----------------+
    | city_id    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
    | name       | text             | YES  |     | NULL    |                |
    | alt_name   | text             | YES  |     | NULL    |                |
    | population | int(10) unsigned | NO   |     | NULL    |                |
    +------------+------------------+------+-----+---------+----------------+

Here is the code:

    db.query(""" 
        LOAD DATA INFILE '%s' 
        INTO TABLE %s 
        CHARACTER SET utf8
        FIELDS TERMINATED BY ',' 
        (@skip, name, alt_name, population) 
        """ % (temp_file, table))

    class Database(object):
        def __init__(self, database):
            self.database = database
        def query(self, cmd):
            return subprocess.call(['mysql -u root -e "%s" %s' % (cmd, self.database)], shell=True)

When I issue the command from python, I only get 1025 rows into the table. But if I issue the same command from the mysql prompt, I get all 1028.

What's going on?