Performing backup of MySQL database is the most important activity of any database administrator but most of database administrators just neglect this activity. It is like a nightmare situation for the administrators, if database gets corrupt and there is no any backup available to recover MySQL database. At this scenario, they will realize that they have done a blunder mistake. Backup helps to handle any type of corruption strike by virus, hardware failure and other. Always try to take a proper backup because without proper backup, you will unable to restore complete database properly.