Re: Questions about backups, InnoDB tables, etc.

2005-07-25 Thread SGreen
Ryan Stille [EMAIL PROTECTED] wrote on 07/21/2005 05:47:28 PM: I'm trying to get a handle on MySQL backups and hot backups using MyISAM and InnoDB tables together. We plan to switch from SQL Server to MySQL soon. How are you guys handling full-backups of databases with mixed MyISAM and

Re: Questions about backups, InnoDB tables, etc.

2005-07-25 Thread Michael Monashev
Hello JT Did you try that link? When I follow it, I get a search results page JT saying Search Results for backup Showing 1-30 of 53 found.. Too JT bad it doesn't actually show the search results Sorry. Try this links http://solutions.mysql.com/search.php?pc=4%2C86q=backuplevel=0

RE: Questions about backups, InnoDB tables, etc.

2005-07-22 Thread John Trammell
5:45 PM To: Ryan Stille; mysql@lists.mysql.com Subject: Re: Questions about backups, InnoDB tables, etc. Hello RS I'm trying to get a handle on MySQL backups and hot backups using MyISAM RS and InnoDB tables together. We plan to switch from SQL Server to MySQL RS soon. Did you see

RE: Questions about backups, InnoDB tables, etc.

2005-07-22 Thread andy.lawton
. Can't comment on how well it works, but might be worth investigating. Seems a bit pricey though, compared to the Windows version... Cheers Andy -Original Message- From: Ryan Stille [mailto:[EMAIL PROTECTED] Sent: 21 July 2005 22:47 To: mysql@lists.mysql.com Subject: Questions about backups

Questions about backups, InnoDB tables, etc.

2005-07-21 Thread Ryan Stille
I'm trying to get a handle on MySQL backups and hot backups using MyISAM and InnoDB tables together. We plan to switch from SQL Server to MySQL soon. How are you guys handling full-backups of databases with mixed MyISAM and InnoDB tables? From what I've read (and I've been reading a lot), if we

Re: Questions about backups, InnoDB tables, etc.

2005-07-21 Thread Michael Monashev
Hello RS I'm trying to get a handle on MySQL backups and hot backups using MyISAM RS and InnoDB tables together. We plan to switch from SQL Server to MySQL RS soon. Did you see it: http://solutions.mysql.com/search.php?pc=0%2C0q=backuplevel=0 ? Sincerely, Michael, http://xoib.com/

Re: Questions about backups, InnoDB tables, etc.

2005-07-21 Thread Devananda
Ryan Stille wrote: I've been doing some testing and came across something I don't understand. I filled my test InnoDB formatted table with a lot of data so mysqldump will take a while to complete. Then I start mysqldump on this database with the --single-transaction option. While that is