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