Sorry, I see what you are doing with the link. I misunderstood. Larry S. Brown Dimension Networks, Inc. (727) 723-8388
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Larry Brown Sent: Thursday, February 27, 2003 8:46 PM To: [EMAIL PROTECTED] Subject: RE: MySQL vs. PostgreSQL I just shut down mysql and copy the directory to a folder that is backed up on the regular backup so the database down time is about a minute. The only problem with this is if you have set up your user access rights in the mysql database which is the one used by mysql to grant rights/permissions and lost that db, when you restore the db directory it will only be accessible by root until you re-create your users. You should be able to copy the mysql folder as well and get a backup of everything you need. Just make sure the mysqld is stopped. Why would you need to break the sym link? Or is it a hard link? If you mean a hard link you might want to check with the mysql list and find out if that presents a problem. I would think it could. Larry S. Brown Dimension Networks, Inc. (727) 723-8388 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ryurick M. Hristev Sent: Thursday, February 27, 2003 5:57 PM To: [EMAIL PROTECTED] Subject: Re: MySQL vs. PostgreSQL On Wed, 26 Feb 2003, Joe Giles wrote: > 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... Pray very hard to God that you never need those "backups". Maybe you can get lucky with MySQL but as a general rule those backups are worthless. There is a reason why each serious database have its own backup mechanism. Cheers, -- Ryurick M. Hristev mailto:[EMAIL PROTECTED] Computer Systems Manager University of Canterbury, Physics & Astronomy Dept., New Zealand -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list
