Like all data, MySQL data must be backed up regularly. As MySQL databases are disk-based files, normal backup systems and routines can back up MySQL data. However, as those files are always open and in use, normal file copy backup may not always work. Here are possible solutions to this problem:
Tip Flush Unwritten Data First To ensure that all data is written to disk (including any index data) you might need to use a FLUSH TABLES statement before performing your backup. |