Count records (My SQL)

[Guest_imported]

MySQL.
I want to insert 1500 records but it's inserted only 1000 records. Why? I write "load data infile 'file.txt' into table t1" where file.txt consist of more than 1000 records. Why aren't others inserted? I hope somebody find a bit of time to answer me. Sorry for my English. Thanks.

 

[sleipnir214]

I would have to guess tha 500 of your records are badly formatted for one reason or another and MySQL throws them out. ______________________________________________________________________
TANSTAAFL!

 

[enterume]

do your execute your file via WEB? it could be cause the server timeout to execute the page? if so, may be you can extend your Apache server time out.


THnaks
Louis

 

[piti]

try mysqlimport command to insert the data
the result, if everything goes fine, should be something like this:

dbname.tablename: Records: 1229 Deleted: 0 Skipped: 0 Warnings: 0

if you receive some non-zero values you have an error in your file as sleipnir214 said