Re: MySQL Administrator Backup Issue with InnoDB
Steve Crockett <[email protected]>
| Newsgroups | gmane.comp.db.mysql.mycc |
|---|---|
| Organization | OgreTech, Inc. |
| Message-ID | <[email protected]> |
Actually, it's not called "single transaction" in version 1.0.20. In versions prior to 1.0.20 the option was called "single transaction" and worked fine. (Presumably because it issued a simple "START TRANSACTION...SELECT" command.) However, in 1.0.20 the option is called "Online backup" (with the same intent being to backup InnoDB tables in a single transaction). However, in 1.0.20 that option results in the command "START TRANSACTION WITH CONSISTENT SNAPSHOT" which only became available in MySQL 4.1.8, seemingly making it impossible to use MySQL Administrator to get a single transaction backup of an InnoDB table in my case (using MySQL 4.0.20). [Thank you to those that directed me to the mirrors for older versions. I've reverted to 1.0.19 and all is well for now.] -Steve Alfredo Kengi Kojima wrote: > > If you use the Single Transaction option, the previous method is going > to be used. > -- MySQL GUI Tools Mailing List For list archives: http://lists.mysql.com/gui-tools To unsubscribe: http://lists.mysql.com/[email protected]