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
