MySQL partial backup

Larry Garfield <[email protected]>
Newsgroups gmane.org.user-groups.luni.tech
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.