There is a case that two same simultaneous connections access the same file.
Before the one connection finishes uploading, second connection downloads the incomplete file and deletes them.

You can prevent this situation by using HiddenStor and HideFiles options if you are using proftpd ftp server.

In your /etc/proftpd.conf ,

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

<Global>
  AllowOverwrite                yes
  #slee:using .in.$filename convention and block other connection to download
  #must work with  HideFiles
  HiddenStor on
 
  <Limit ALL SITE_CHMOD>
    AllowAll
  </Limit>
</Global>
 
<Directory /*>
  #HideFiles (\.conf|passwd)$
  HideFiles (\.in.*)$
</Directory>

By defining the correct options, you can effectively block the unfinished uploading files to be shown in the directory listing.

input file:

1. tablename.txt
2. Tab deliminated by default
3. use full path with all the parent path readable by mysql user

$> mysqlimport -u user -p dbname /path/to/input/tablename.txt

Also if there is autoincrement field , use number 0.