Russ, you can also use
mysqldump --single-transaction to back up InnoDB type tables. The advantage of InnoDB Hot Backup over that method is that InnoDB Hot Backup takes binary backups of the ibdata files. Restoring a binary backup is much faster than a table dump. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ ----- Original Message ----- From: "Russ" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, December 22, 2003 1:22 PM Subject: innodb questions (backup and transactions) > Hey Guys, > > I have just a couple of questions regarding the innodb database type > that I'd appreciate any advice with. I'm currently developing a custom > shopping cart / backend and, due to the nature of such a system, would > like to take advantage of transactions - so innodb seems the logical choice. > > However, I have a couple of reservations... > > I realise innodb does not have fulltext support built in - is the only > way round this to have any data that needs to be fulltext-searched in a > myISAM table? I've read that a ROLLBACK after a transaction will not > rollback the myISAM tables - so I guess some app logic is required for > these special cases. Is my thinking right on this issue? > > And secondly, I'm a bit worried about backing up innodb tables - more > specifically a live backup. I've seen a product innodb sell specifically > to do this but I can't really justify the licensing costs. Are there > any other options for a live backup? The only others means of backup > would be to shutdown the server and copy the data manually I assume? > > Any pointers to the above two queries greatly appreciated! > > Russ > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
