Re: MySQL partial backup
Samir Faci <[email protected]>
| Newsgroups | gmane.org.user-groups.luni.tech |
|---|---|
| Message-ID | <[email protected]> |
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 -- Samir 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 <[email protected]> wrote: > Check out : http://sourceforge.net/projects/automysqlbackup/ > > I use it a bunch. > > Gene > > On Dec 5, 2010, at 5:26 PM, Larry Garfield <[email protected]> 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 > -- -- Samir Faci *insert title* fortune | cowsay -f /usr/share/cows/tux.cow -- Linux Users Of Northern Illinois (Chicago) - Technical Discussion http://luni.org/mailman/listinfo/luni