Baffled by incomplete insert - MySQL

Input: 2308 text files, each containing 250 lines, comma-delimited fields, all ~137Kb.

Function: The script reads in the text from the files, parses it into arrays of data that correspond with the MySQL table, and then inserts them into the table one record at a time.

Output: none

It works perfectly for the first ~6,400,000 records (843 input files), and then it stops somewhere in the middle of the 844th file. The size of the database (.MYD file) is 407Mb at this point, and there are at least 700Mb free on the drive.
I know that my query is not erroneous (it inserts the first 6 million records).
I have also executed it without running the query portion, and it completes all 2308 files) - so the input and parsing are not erroneous either.

My table information (SHOW TABLE STATUS) is as follows:


Any ideas? Why does it say that 'Data free: 0'?

Thanks for any tips,

Peter

check this out...

http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html

Yeah, that's how I got the info I posted above... I'm not sure I follow...

scroll down for the explaination of each of the results. (page is formatted weird) It looks like you might be reaching the data limit on the table. at least that is how I read it.

Hm. I see - sorry about that, I did not scroll when the page came up with all that whitespace...

Well, you may be right, do you think I should increase the maximum size of the database or make the rows fixed (as opposed to dynamic)?

Thanks,

Peter

Hm. I can't seem to figure out how to increase this grr max_data_length ... do you know how it's done? where can I find 'max_rows'? It's not in my my.ini or my.cnf files... is it table-specific? Ideally I would like to increase it on the table that already has data in it because even my great script takes a few hours to insert all that data...

Thanks again,

P

Ok the manual says it's done at table creation, and can be changed using ALTER... but no example was given...

Ok I have it.

ALTER TABLE tablename MAX_ROWS = 1000000000;

Let's see what happens (I probably won't know until tomorrow)

Thanks, I've marked as resolved until I get stuck again...

Peter

Just a thought but I had a DB where I intially set the autoincrement id field to a value that seemed large enough at the time but years later was maxed out and it took me a while to realize what the problem was.

why don't you use mysql_error() to see the error you are getting. use it like so:

mysql_query($blah) or die(mysql_error());


than we wouldn't feel like we are wondering in the dark...

Lo and behold it works.

Thanks all for the input on this one!

P