I know that I cannot use mysqlhotcopy or table lock if I use innodb. ;) I asked how I can backup db file when I choose to use raw filesystem regardless of table type. It need not be a hot backup. I think it's a little silly to use dump method in order to make backup.
-- Chung Ha-nyung <alita@[neowiz.com|kldp.org]> SayClub <http://www.sayclub.com> NeoWiz <http://www.neowiz.com> > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of Harald Fuchs > Sent: Tuesday, October 15, 2002 7:37 PM > To: [EMAIL PROTECTED] > Subject: Re: What is the best suited file system for MySQL w/ InnoDB? > > > In article > <[EMAIL PROTECTED]>, > "Chung Ha-nyung" <[EMAIL PROTECTED]> writes: > > > I've considered raw filesystem, but it seems a bit > difficult, or even > > impossible, to > > copy db file to other servers, especially when making replication > > slave servers. > > Any not bad means to backup MySQL db using raw filesystem? > > You can't use mysqlhotcopy (or anything else which copies data files > directly) for InnoDB, regardless of using a raw device or not. Either > use mysqldump, or ask Heikki Tuuri about his (non-free) InnoDB hot > backup tool. > > Regarding replication: I don't see any reason why raw devices > shouldn't work with master/slave servers. > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
