On 11/21/2013 10:32 AM, Nick Cameo wrote:
> OOoopppsss! I do mean for recovery/continual backup. I will do it
> manually, but basically get all the data on a USB disk and be able to
> recover/move it (the data) on another machine, the same machine etc..
> I hope I did not just open up a can of worms. We just went live and
> this post gave me a rude awakening. What is an effective easy to
> follow protocol for backup and recovery in mysql!
> Nick from Toronto
There are two basic types of backups, logical and physical.
Logical backups are performed by a utility that converts your database
objects into their CREATE ... commands and exports your data as INSERT
... commands (or as delimited files). These kinds of backups are quite
portable and compress well. An example of such a tool is mysqldump.
Physical backups can happen many different ways. The easiest version to
make/restore is the 'cold copy'. This is exactly what it sounds like.
Shutdown your mysqld and make a copy of everything. At the absolute
minimum you need the ibdata files, the ib_log files, and all folders
inside your --datadir location.
Warm or hot copies are provided by tools that coordinate with the server
to synchronize the state of the InnoDB data to the moment the non-InnoDB
data has been captured. One example of this is MySQL Enterprise Backup.
Additional details abound in the manual:
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN