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 <>. Too JT> bad it doesn't actually show the search results Sorry. Try this links http://solutions.mysql.com/search.php?pc=4%2C86&q=backup&level=0 http://solutions.mysql.com/software/?c=backup Since

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

RE: Questions about backups, InnoDB tables, etc.

2005-07-22 Thread andy.lawton
We are using MyISAM tables with MySQL running on Windows. We also use Acronis (www.acronis.com) to take images of the various disc partitions we have. This uses the "Volume Shadow Copy" capability of XP and Win2K. Acronis can run a command before the "snapshot" is taken and after it. It only takes

RE: Questions about backups, InnoDB tables, etc.

2005-07-22 Thread John Trammell
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 &g

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 runni

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%2C0&q=backup&level=0 ? Sincerely, Michael, http://xoib.com/ http