Re: cannot alter table - solved

2009-05-21 Thread PJ
Michael Dykman wrote: > On Thu, May 21, 2009 at 11:06 PM, PJ wrote: > >> I have a seemingly impossible situation. I cannot insert values into the >> tables and I cannot alter or delete the primary key (which should not >> exist) or delete the foreign keys nor remove the constraint. G search >>

Re: cannot alter table - rather urgent

2009-05-21 Thread Peter Brawley
>I cannot insert values into the tables What is the error message? Has the smallint key run out of values? >and I cannot alter or delete the primary key (which should not exist) Eh? Without a PK, it ain't a table. >or delete the foreign keys nor remove the constraint. G search doesn't help.

Re: cannot alter table - rather urgent

2009-05-21 Thread Michael Dykman
On Thu, May 21, 2009 at 11:06 PM, PJ wrote: > I have a seemingly impossible situation. I cannot insert values into the > tables and I cannot alter or delete the primary key (which should not > exist) or delete the foreign keys nor remove the constraint. G search > doesn't help. > > CREATE TABLE `b

cannot alter table - rather urgent

2009-05-21 Thread PJ
I have a seemingly impossible situation. I cannot insert values into the tables and I cannot alter or delete the primary key (which should not exist) or delete the foreign keys nor remove the constraint. G search doesn't help. CREATE TABLE `book_categories` ( `bookID` smallint(6) unsigned NOT NUL

RE: Date Time

2009-05-21 Thread Martin Gainty
mysql> select sysdate() from DUAL; +-+ | sysdate() | +-+ | 2009-05-21 17:37:13 | +-+ i would get the proprt format is i could CONVERT_TZ to work can you get CONVERT_TZ to work ? Martin Gainty _

Date Time

2009-05-21 Thread John Meyer
Is "Thu May 21 03:15:28 + 2009" a valid date/time string? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Upgrade Mysql

2009-05-21 Thread Webmaster Studio Informatica
Thank You for all the help. I was upgrading from 4.0.x to 5.0.x The new mysql recognized the old databases without problems. Bye :)

General Question..

2009-05-21 Thread HINOJO RUELAS ARTURO
Hello all, Hope you are doing well, I have a general question creating foreign keys , I'm creating FK from catalog tables to relation tables with them, when I create a FK in innodb engine on MYSQL a new field with the same name of the FK is created, in this case if I create for example 3 FK t

RE: mySQL slave IO Running and SQL Running

2009-05-21 Thread Jerry Schwartz
I'm not running with replication, but I AM often running the CLI against the production and test environments at the same time. I found it invaluable to add the line prompt=\h > to my.ini (I'm running on Windows). That adds the host name to the prompt, and has saved my butt more than once. >

6.0.11 source

2009-05-21 Thread Alex Katebi
Anyone knows where I can download the 6.0.11 gziped source from?

Re: MySQL: large_page_size

2009-05-21 Thread Johnny Withers
I tried it on win32, it worked but the server failed under heavy load. I'd suggest running mysql on a 64 bit Linux machine instead. Jw On Thursday, May 21, 2009, Krishna Chandra Prajapati wrote: > Hi, > > How much performance improvement we can get using large_page_size in mysql > server. Is the

MySQL: large_page_size

2009-05-21 Thread Krishna Chandra Prajapati
Hi, How much performance improvement we can get using large_page_size in mysql server. Is there anybody using on productions. Thanks, Prajapati Krishna Chandra Prajapati Email-id: prajapat...@gmail.com