MySQL Insert Error - Continue?

[ToddW]

Hey guys, I`m wondering if it's possible or feasable to continue entering rows of data if one row causes an error.

For instance if I am trying to enter 5k rows of data, and for some reason one raw causes an error is it possible to tell the script to STOP goto next line and continue? And of course write the errored row to an error log??

Or would it best to just say "error importing on line #" ?

The script will be used to import ~3-5k rows per-day so it's not a one time thing..

Thanks

[WhSox21]

Try adding a @ in front of the mysql_query() function.

[ToddW]

I think I should mention the data is coming from an Array from phps' fgetcsv function.

I have inserted over 50k rows at once with no errors either but I want to be prepared.. Right now I have it halting, and telling me which line caused the error. However if possible I`d like it to skip to the next item in the array and write the "errored" data to an error log.

Thanks again.

[ToddW]

Try adding a @ in front of the mysql_query() function.

I`m not sure but wont that just surpress the error message, and the error still occurs.. meaning it could technicaly halt the script in its' tracks. ???

I would of course use @ however I want to continue with the import by going to the next row... And recording the mysql errors and row error occured and row value to an error log.

[WhSox21]

Try adding php's function: addslashes() to the area where it is coming with an error. Most likely you're getting some type of error because of that.

[stereofrog]

If your data is comma (and whatever) separated, it would be probably cleaner and faster to use LOAD DATA instead of bunch of INSERTS.