[LUNI] MySQL partial backup
larry at garfieldtech.com
Sun Dec 5 23:57:52 CST 2010
That sounds great for handling the rotation logic. Unfortunately it doesn't
help with the structure-for-some-tables-only issue.
On Sunday, December 05, 2010 6:19:22 pm Gene Jannece wrote:
> Check out : http://sourceforge.net/projects/automysqlbackup/
> I use it a bunch.
> On Dec 5, 2010, at 5:26 PM, Larry Garfield <larry at garfieldtech.com> wrote:
> > Hi folks. I want to setup a backup script for a MySQL database, as such
> > things are generally regarded as Good. mysqldump is the standard tool
> > there, but as near as I can tell there is no way to export only the
> > structure of certain tables. It's all-or-nothing. Easily half the data
> > in my database is active session records, logs, cache tables, and other
> > such volatile data that has no business being in a routine backup, but
> > I've yet to figure out from the mysqldump man page how to only get the
> > structure of those tables instead of the full data.
> > Has anyone else done that? Any links to recommend, or alternate
> > approaches?
> > The database is of a size that I'll want to compress the backups as well
> > and ideally rotate them. I don't know how do to proper rotation to
> > clear out old backups yet, but I figure one step at a time. (Pointers
> > for that would be great, too, though.)
More information about the LUNI