Re: database backup ???

["nate" <debian-user@aphroland.org>]

<quote who="Michael D. Schleif">
>
> Yes, I've read recent posts on backups and that tar is my friend ;>
>
> However, I'm interested in what debian users are doing to backup
> databases, such as mysql and postgresql?
>
> How to deal with open file issues?
>
> What do you think?

with mysql i use mysqldump which is like postgres's dump. only downside
is it is pretty processor intensive for big databases, if your db is
small(under 100MB) its fast..but backing up a 500MB database on something
like my dual p3-650 1GB ram is pretty slow(but still acceptable)

i setup a mysql user called dumpuser with SELECT access to all databases,
and have it do a dump each night called from a script, then if its
sunday, it saves it as a weekly backup, so i should have at least a
backup from the most recent sunday as well as the previous day. of
course this user can only connect from localhost :)

of course if you have a really really big db and are running 2.2
kernel(like me) you may have trouble with mysqldump if you hit the
2gig file limit. my biggest db is about 150mb though

i haven't used postgres at all yet so i don't know how it compares..

nate



-- 
To UNSUBSCRIBE, email to debian-user-request@lists.debian.org 
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org