Anyone ever have a problem with phpMyAdmin's row count? I have just imported a 60,000 row CSV file into my MySQL database using mysqlimport.
When I look at this database from phpMyAdmin it returns a random number of entries (usually around 55,000 to 65,000) even though it states that the next auto increment ID should be 60,001 (the correct number of rows plus one).
Now when I print out the number of rows using mysql_num_rows() it also gives me the correct number of rows each time.
Any ideas?
Its never happened to me although I usually dont have tables with that many records. You may want to report it as a Bug over at PHPMyAdmin and wait for a developers response.
I think it might have something to do with when I imported the CSV with mysqlimport. It inserted all the 60,000 entries, but it gave me around 5,000 warnings... which seems like the error range that phpMyAdmin is presenting me with.
From what I understand, I can't print out these warnings from mysqlimport can I?
Cheers!
Then this isnt really a PHPMyAdmin Error. I dont use mysqlimport, but no I dont think there is the option to give errors, for more reading MySQL Import Program
Turns out these warnings happen with accents (like "á" or "ão"). Since many portuguese words have accents, 5.000 entries presented warnings (they were actually cut off when using mysqlimport). I still haven't looked into this, but I'm gonna have to import the CSV file again.
UPDATE: I saved the CSV as UTF-8 and now the accents went it right. Mysqlimport only presented me with 1 warning this time, but phpMyAdmin still gives me random total rows each time I browse the table. My application is working fine, since when I retrieve the row numbers through PHP everything is ok.
Cheers!