ANN: DAC for MySQL 2.8.1 is out!

2013-02-03 Thread Aleksander Andreev
DAC for MySQL is direct access components for MySQL, EnterpriseDB. It allows you to create Delphi/C++Builder applications with direct access to DAC for MySQL/EnterpriseDB without BDE and ODBC. *What’s new in v2.8.1:* Several minor improvements and bug fixes. *Full changelog:* [!] Support for De

Re: file level encryption on mysql

2013-02-03 Thread Reindl Harald
Am 03.02.2013 18:52, schrieb Mike Franon: > Hi, > > I was wondering what type of encryption for linux would you recommend > to encrypt the database files on the OS level? I had a hard time > starting the database after I moved it to a partiton with encryptFS > > I only need 3 tables encrypted a

Re: log sequence number InnoDB: is in the future!?

2013-02-03 Thread Reindl Harald
Am 03.02.2013 15:30, schrieb Larry Martell: > We also ended up dropping the database and restoring from dumps. > However all recent dumps ended up having a similar corruption and we > were still getting the same errors. We had to go back to an October > dump before it would come up cleanly. And o

Re: log sequence number InnoDB: is in the future!?

2013-02-03 Thread Larry Martell
On Sun, Feb 3, 2013 at 7:23 AM, walter harms wrote: > > > Am 02.02.2013 01:34, schrieb Larry Martell: >> On Mon, Jan 28, 2013 at 5:01 AM, walter harms wrote: >>> hi list, >>> >>> i am using mysql 5.1.53. >>> after a crash i have the follwing error in my log: >>> >>> 130128 10:45:25 InnoDB: Error

Re: log sequence number InnoDB: is in the future!?

2013-02-03 Thread walter harms
Am 02.02.2013 01:34, schrieb Larry Martell: > On Mon, Jan 28, 2013 at 5:01 AM, walter harms wrote: >> hi list, >> >> i am using mysql 5.1.53. >> after a crash i have the follwing error in my log: >> >> 130128 10:45:25 InnoDB: Error: page 61 log sequence number 0 2871649158 >> InnoDB: is in the

Re: Complex MySQL Select Statement Help

2013-02-03 Thread hsv
2013/02/02 12:58 -0600, Peter Brawley On 2013-02-01 10:18 PM, h...@tbbs.net wrote: >2013/01/31 22:24 -0600, Peter Brawley >Is this what you mean? > >Select, >pricelist >If( !IsNull(specialprice) And specialprice < unitprice And CurDate() Between >startingDate And endingDate, >sp