Home ยป Content

Backups Video Now Downloadable

The Google Video for the MySQL Backups presentation stops after about 13 minutes, so I've put it up as a download at:

http://www.technocation.org/videos/BostonMySQLMeetupJanuary-mp4.mov

Many of the questions brought up by the discussion of the summary slide are answered in the presentation.

As always, I encourage feedback -- both technical as well as presentational (ie, the slides were not understandable, you talk to fast, etc).

The slides are up at:

http://sheeri.net/presentations/MySQLbackups.swf -- 125 Kb flash
or
http://sheeri.net/presentations/MySQLbackups.pdf -- 2 Mb PDF

Help! The backup

Help!
The backup presentation on Google ends at about 13 minutes (out of 51),
and the .mov file linked on your web page is a 404.

I simply MUST know how to backup InnoDB by file copy. I have the option set to save individual .ibd in the databases dirs, but I have read that you cannot just move these files to another machine/database because there is some data stored in the central InnoDB files.

Is there a way to "encapsulate" InnoDB tables to allow OS copy? I can stop the database, and snapshot the LV, then copy the files, but I don't want to waste the time on my 24 million row table if I'm barking up the wrong tree.
Thanks!

  • By Terry Kellum (not verified) at 06/29/2007 - 15:40
  • reply