I would like to back up our mysql database. We have huge records in the database. What are the errors can occur and possible while running mysqldump.? Mysql official site did not mention the specific error and error codes for mysqldump, They just commonly put the error and error codes. I am expecting some mysql expert can help me out. I would like to take some action in case any error happen for that I want know possible error and errocodes. Thank You
I can say that once in a whilte with BLOBS (binary large objects) and obnoxiously long insert sections, (read lots of inserts on the same table), have given way to errors. I, whether good or bad, check the "ignore errors" box when importing again later.
And how huge are we talking?
What error do you expect to happen from a simple mysqldump? There are no errors I'm aware of and none I ever heard about.