Re: ERROR 1071: Specified key was too long. Max key length is 500

2005-02-01 Thread Jon Wynacht
Shawn, I tried both of those suggestions and they work well, with reducing the size of the fields being the way I'm going to go. Thanks for your help! Cheers, Jon On Feb 1, 2005, at 1:12 PM, [EMAIL PROTECTED] wrote: Jon Wynacht <[EMAIL PROTECTED]> wrote on 02/01/2005 03:33:13

ERROR 1071: Specified key was too long. Max key length is 500

2005-02-01 Thread Jon Wynacht
Hi, I'm wondering if anybody can help me decrypt what this error code is referring to: ERROR 1071: Specified key was too long. Max key length is 500 This is the offending table creation script: CREATE TABLE `APPROVAL` ( `APPROVAL_ID` mediumint(9) unsigned NOT NULL auto_increment, `APPROVAL_CU

Running Multiple Servers

2003-12-04 Thread Jon Wynacht
Hi, Has anyone on this list ever been successful in running two MySQL servers at one? I'm assuming they have ;-) I am having some issues and am hoping for some help or pointers to help. When I try to run my second server I get this error message in the log: 031204 11:35:01 mysqld started 0312