Re: convert table and column type - Jon Stephens - com.mysql.lists.cluster

12 messages in com.mysql.lists.clusterRe: convert table and column type

From	Sent On	Attachments
Oliver Rojo	11 Feb 2007 03:20
Andrew Hutchings	11 Feb 2007 03:24
Jon Stephens	11 Feb 2007 17:26
Oliver Rojo	11 Feb 2007 21:30
Andrew Hutchings	11 Feb 2007 23:02
Oliver Rojo	12 Feb 2007 00:27
Andrew Hutchings	12 Feb 2007 00:35
Oliver Rojo	12 Feb 2007 16:29
Benton, Kevin	12 Feb 2007 16:34
Jon Stephens	12 Feb 2007 21:05
Oliver Rojo	12 Feb 2007 21:10
Jon Stephens	13 Feb 2007 00:00

Subject:	Re: convert table and column type
From:	Jon Stephens (jo...@mysql.com)
Date:	02/12/2007 09:05:31 PM
List:	com.mysql.lists.cluster

Oliver Rojo wrote:

there's no 'index' on my dump file. The line the error points below:

DROP TABLE IF EXISTS `mos_poll_data`; CREATE TABLE `mos_poll_data` ( `id` int(11) NOT NULL auto_increment, `pollid` int(4) NOT NULL default '0', `text` text NOT NULL, `hits` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `pollid` (`pollid`,`text`(1))

^^^ That is an index on the pollid and text columns. ^^^

(And naming a column with a reserved word ("text") is IMO a Very Bad Idea.)

) ENGINE=NDBCLUSTER DEFAULT CHARSET=latin1;

On 2/12/07, * Andrew Hutchings* <in...@a-wing.co.uk <mailto:in...@a-wing.co.uk>> wrote:

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Oliver Rojo wrote: > how can I convert that?

Simply drop the index on the blob column called 'text'. If you are doing a mysqldump and insert then edit the dump and remove the index in that.

Regards Andrew - -- Andrew Hutchings - Linux Jedi - http://www.linuxjedi.co.uk/ A-Wing Internet Services - http://www.a-wing.co.uk/ <http://www.a-wing.co.uk/> Windows is the path to the darkside...Windows leads to Blue Screen. Blue Screen leads to downtime. Downtime leads to suffering...I sense much Windows in you. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFF0CbZZ+2Y3WLvbJIRAr4oAJ9CL70h5K96cpXk292nJyqtHCAiggCglNNQ iMP9wAtu0Ex92TJmkhrrCV4= =iUwR -----END PGP SIGNATURE-----