Well, I stated that for redundancy I created sym links. That isn't the
proper wording I should have used. What I meant to say was I created sym
links from one file system to another for space reasons. I ran out of
space on the /var part. so I linked the databases to another fs. Sorry
for the misunderstanding. So, what I simply did is 
ln -s /var/lib/mysql/<data base> /storage/database/<database> .

Then, when I upgraded, I break the link. Then relink when the upgrade is
done. Not sure if I even need to, but someone told be awhile ago that I
should disconnect the link so I don't loose any data. Again, I'm not in
any way a guru on this, I was simply asking if it was a wise way to do
it or even if its needed (Unlinking for an upgrade).

Also, I will look at your backup strategy and see if I can implement it
into my system.

Thanks

Joe

On Wed, 2003-02-26 at 22:42, nate wrote:
> Joe Giles said:
> > Question about backing up...
> >
> > Sorry if this is not on the lines of what you guys are talking about, but
> > I set up MySQL and I sym link the database from one file system to another
> > for redundancy purposes. So, when I upgrade, I just break the link and
> > upgrade, then re link. It has worked so far (well, only one upgrade as of
> > yet). Is this a BAD idea? Was I just lucky?
> >
> > When I backup, I just backup the dir that pertains to the database. I have
> > not had to restore anything yet...
> >
> > I appreciate the comments good or bad so I don't get stuck in the
> > future...
> 
> I don't really understand ...you do understand that a symlink is just
> a pointer right? it contains no data. I think you were just lucky though
> I have never had any issues with upgrading mysql(only from 3.23.x -> 3.23.x
> is all that I've tried)
> 
> for backing up I have a script that runs nightly, connects as a user
> which has dump rights and dumps the databases to a file and compresses
> them..the password is stored in /root/.my.cnf
> 
> DATABASES="mysql demarc"
> WEEKLY_BACKUP=Friday
> PATH=/usr/local/mysql/bin:/bin:/usr/bin
> 
> cd /home/backup
> 
> if [ "`date +%A`" = $WEEKLY_BACKUP ];then
> for db in `echo $DATABASES`
> do
> echo "[Database: $db] - Doing Weekly Backup.."
> /usr/local/mysql/bin/mysqldump -l -u dumpuser $db >weekly.db
> rm `echo $db`DB-Weekly*.sql.bz2 >&/dev/null
> bzip2 weekly.db
> mv weekly.db.bz2 "`echo $db`DB-Weekly`date +%U`.sql.bz2"
> done
> else
> for db in `echo $DATABASES`
> do
> echo "[Database: $db] - Doing Daily Backup..."
> /usr/local/mysql/bin/mysqldump -l -u dumpuser $db >daily.db
> rm `echo $db`DB-Daily*.sql.bz2
> bzip2 daily.db
> mv daily.db.bz2 "`echo $db`DB-Daily`date +%m-%d-%Y`.sql.bz2"
> done
> exit 0
> fi
> chmod 600 /home/backup/*
> /usr/sbin/chown root.wheel /home/backup/*
> 
> (this is from my freebsd system)
> 
> nate
> 
> 
> 
> 



-- 
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]
https://listman.redhat.com/mailman/listinfo/redhat-list

Reply via email to