Innodb corruption help needed!

2007-03-10 Thread Jean-Sebastien Pilon
Hello, I am running a mysql database server and we experienced a power failure. The mysql server does not want to restart because innodb is corrupted. Version info: Mysql version 4.1.11-Debian_4sarge7-log Debian sarge Reiserfs filesystem What I have tried: - Ran reiserfsck to fix corrupted fi

FW: Re: MD5()

2007-03-10 Thread Neil Tompkins
Strange the DES_ENCRYPT/DES_DECRYPT functions work with my version of mySQL 3.23 From: "Neil Tompkins" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: MD5() Date: Sat, 10 Mar 2007 18:20:43 + DES_ENCRYPT/DES_DECRYPT appears to be what we require. Thanks

Re: MD5()

2007-03-10 Thread Neil Tompkins
DES_ENCRYPT/DES_DECRYPT appears to be what we require. Thanks Neil From: "Mogens Melander" <[EMAIL PROTECTED]> To: "Neil Tompkins" <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: MD5() Date: Sat, 10 Mar 2007 12:19:53 +0100 (CET) Or you might want to take a look at DES_ENCRYPT/DE

Re: MD5()

2007-03-10 Thread Aaron Cannon
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Before you implement anything, I would do a lot of research about encryption. No offense, but from your question, it is clear that you know next to nothing about encryption. That's fine. A few years ago, I was the exact same way. However, enc

Re: MD5()

2007-03-10 Thread Mogens Melander
Or you might want to take a look at DES_ENCRYPT/DES_DECRYPT funktions in the mysql manual. On Sat, March 10, 2007 11:18, Ian P. Christian wrote: > Neil Tompkins wrote: >> I'm looking to use MD5() to encrypt credit card numbers. How do I >> unencrypt this when reading the value ? >> > > you can't.

Re: MD5()

2007-03-10 Thread Ian P. Christian
Neil Tompkins wrote: The problem I have is our mysql database version is 3.23 and we are not in a position to upgrade. Because you are unlikely to be selecting on this data directly, you could use functions of whatever language you're using to connect to the database... for example if you're

Re: MD5()

2007-03-10 Thread Neil Tompkins
The problem I have is our mysql database version is 3.23 and we are not in a position to upgrade. From: "Ian P. Christian" <[EMAIL PROTECTED]> To: Neil Tompkins <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: MD5() Date: Sat, 10 Mar 2007 10:24:45 + Neil Tompkins wrote: What d

Re: MD5()

2007-03-10 Thread Ian P. Christian
Neil Tompkins wrote: What do you recommend I use ? http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html That should help you. However... keep in mind that if your application is likely to be accessing this data all the time anyway, if someone compromises your database, chances a

Re: MD5()

2007-03-10 Thread Neil Tompkins
What do you recommend I use ? From: "Ian P. Christian" <[EMAIL PROTECTED]> To: Neil Tompkins <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: MD5() Date: Sat, 10 Mar 2007 10:18:41 + Neil Tompkins wrote: I'm looking to use MD5() to encrypt credit card numbers. How do I unencryp

Re: MD5()

2007-03-10 Thread Ian P. Christian
Neil Tompkins wrote: I'm looking to use MD5() to encrypt credit card numbers. How do I unencrypt this when reading the value ? you can't. Google for MD5, or better still look at wikipedia, I'm sure they will have something -- Ian P. Christian ~ http://pookey.co.uk -- MySQL General Mailin

Re: Int(4) or int(8)

2007-03-10 Thread Yves Goergen
On 09.03.2007 17:12 CE(S)T, Bruno Rodrigues Silva wrote: > I understand that theses values are unrelated to the range of > datatype values, however i did not saw any diference when i use > int(4) or int(8) > > Some idea? Isn't it a bit useless to specify the visual, decimal length of a numeric da

MD5()

2007-03-10 Thread Neil Tompkins
I'm looking to use MD5() to encrypt credit card numbers. How do I unencrypt this when reading the value ? Thanks, Neil _ Get Hotmail, News, Sport and Entertainment from MSN on your mobile. http://www.msn.txt4content.com/ -- M