[LUNI] MySQL partial backup
ewjannece at gmail.com
Sun Dec 5 18:19:22 CST 2010
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.)
> Linux Users Of Northern Illinois (Chicago) - Technical Discussion
More information about the LUNI