Carlos, ----- Original Message ----- From: ""Carlos Proal"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, June 06, 2003 4:04 AM Subject: start innodb without transactions
> > Hi all > Is there any way to start mysql/innodb skipping transactions ?, i had a > crash and i cant get the database to work. > > i tried the force_recovery option level 3: > # 3 (SRV_FORCE_NO_TRX_UNDO) do not run transaction rollbacks after recovery; > > this way i can get it to work, but as the manual said i cant do any update > query while force_recovery is on and also cant do a mysqldump, so im stucked > :(. why you cannot do a mysqldump? innodb_force_recovery does not prevent SELECT queries. > any ideas ? > Im using mysql 4.0.4, solaris 8 sparc . Upgrade to 4.0.13. Also send me the .err log. Database corruption is uncommon in Solaris, interesting to see what is in the .err log. > thanx > Carlos Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
