Recovering INNODB table

2011-03-11 Thread CLOSE Dave
Using RT 3.8.7 on Fedora 8 with data in MySQL ("Ver 14.12 Distrib 5.0.45"). RT was working correctly for several months, though with only casual use. Approximately three weeks ago, two MySQL tables started reporting corruption. This was coincident with installation of NagiosQL, which created a

Can other mysql-using progs interefere with config?

2011-03-11 Thread jo01_je02
Adobe's Photoshop and Bridge also reside on my WinXP machine. Could they be the cause of failure to config? During the config process I see a msg that "other" progs are using port 3306. Then the config stops--announcing that mysqld has a problem. Details are: szAppName : mysqld.exe szAp

Re: trigger-dumping

2011-03-11 Thread Peter Brawley
any idea how to really purge my Vista machine for a really fresh start? How about installing a different OS :-) , or failing that a different version of Windows? I'm sorry, we declined to install Vista on any of our boxes. We've had no trouble upgrading to 5.5 from 5.1 on other Windows boxe

Re: trigger-dumping

2011-03-11 Thread S�ndor Hal�sz
2011/03/10 23:03 -0600, Peter Brawley On 3/10/2011 8:10 PM, h...@tbbs.net wrote: >MYSQLDUMP.EXE (Ver 10.13 Distrib 5.5.8, for Win32 (x86)) has flags for >trigger-dumping; the help that I downloaded for this version says it dumps >triggers--but it does not. Now what? Works here in 5.5.8

Re: Table Records Deleted by anonymous user!

2011-03-11 Thread Vikram A
Sir, Ok sir, thank you for your advise. We shall keep the logs in another Disk/Drive. From: Johan De Meersman To: Vikram A Cc: MY SQL Mailing list Sent: Fri, 11 March, 2011 2:43:33 PM Subject: Re: Table Records Deleted by anonymous user! From: "Vikram A

Re: Table Records Deleted by anonymous user!

2011-03-11 Thread Johan De Meersman
> From: "Vikram A" > Thank you for info. Now we enabled the logs. The DB administrator > itself made a mistake that he restored the back up This may be obvious, but keep your logs on separate disks if you can - full query logs take quite a bit of I/O away, so if you have them on the same disks