[LUNI] MySQL partial backup
larry at garfieldtech.com
Sun Dec 5 23:52:01 CST 2010
Maybe I wasn't clear enough. I want a structural backup only on about a half-
dozen tables. I want a complete dump on the rest of them. It's just the
cache tables and such that I see no reason to bother backing up the data for
(but do want structure). That's the part I'm having trouble with.
On Sunday, December 05, 2010 7:41:03 pm Samir Faci wrote:
> Hmmmm.. I've done a structure dump before. But then I'm not sure why you'd
> need to do a periodic structure dump. Is your DB schema changing that
> regularly that you'd need
> an incremental backup of that?
> I can't remember the exact syntax.. but I presume that a
> -d, --no-data would do what you want.
> (google confirmed my presumption)
> mysqldump --no-data -u someuser -p mydatabase
> PS. am I misunderstanding your question.. it seems fairly trivial to
> do using the existing tools.
> On Sun, Dec 5, 2010 at 6:19 PM, Gene Jannece <ewjannece at gmail.com> wrote:
> > Check out : http://sourceforge.net/projects/automysqlbackup/
> > I use it a bunch.
> > Gene
> > 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
> >> http://luni.org/mailman/listinfo/luni
> > --
> > Linux Users Of Northern Illinois (Chicago) - Technical Discussion
> > http://luni.org/mailman/listinfo/luni
More information about the LUNI