Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

2 Answers 2

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?

share|improve this answer
    
Thank You. Yes, We have large amount of BLOBS data in our database, May be 100GB of data. I do not know, Whether this is huge amount or not. Some basic error we can avoid by setting some flag variable in mysql parameter, I have read in the documentation. But I am talking about server slowdown , huge data(allocation of buffer size) as well as timeout exceptions. –  Ravi Dec 15 '09 at 5:29

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.

Best wishes,
Fabian

share|improve this answer
    
Thank You, I heard that, Large records back up would take some couple of hours. While backup, mysql server may be slow down and mysql automatically recover itself. Isn't it?. At this time what about mysqldump status? whether mysqldump is automatically recover itself or not? –  Ravi Dec 15 '09 at 5:24

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.