Replication and Backup MySQL Tutorials

Sometimes problems do occur for a variety of reasons, ranging from power outages to hardware failure to improper shutdown of the MySQL server. Events such as these, many of which are beyond your control, can result in damage to database tables, typically caused by incomplete writes in the middle of a change to a table. This category describes what you can do to minimize your risks and to be ready in case disaster strikes anyway. The techniques covered here include making database backups, performing table checking and repair operations, and how to use recovery procedures in case you do lose data. The category also covers database copying procedures for transferring a database to another server, because these are often are quite similar to backup techniques.