grace5

hey this was not solved,I have never replied as last poster did not (or was not clear) on what my happen if I "DROP index"

DROP INDEX description thats the info I need to keep...

how do I do that? (sorry I am really not trying to be humble,I really don't know much about MySQL myphpadmin) could this be it? CREATE TABLE jade_sites ( id smallint(6) NOT NULL auto_increment, title varchar(100) NOT NULL default '0', url varchar(255) NOT NULL default '', dateadd datetime NOT NULL default '0000-00-00 00:00:00', id_cat smallint(6) NOT NULL default '0', description varchar(255) NOT NULL default '',

how exactly is that done?

I get the same error: Error SQL query: ALTER TABLE `jade_sites` CHANGE `description` `description` TEXT NOT NULL MySQL said: #1170 - BLOB/TEXT column 'description' used in key specification without a key length

I know very little about MySQL I am trying to alter a table for descriptions from a varchar(255) to a TEXT as I want more space for description lenght. I have tried this: SQL query: ALTER TABLE jade_sites CHANGE description description TEXT NOT NULL MySQL said: #1170 - BLOB/TEXT column 'description' used in key specification without a key length if I try to edit thru phpMyAdmin I get this error: ALTER TABLE `jade_sites` CHANGE `description` `description` TEXT CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL MySQL said: #1170 - BLOB/TEXT column 'description' used in key specification without a key length any help would be thankfully received!

How can I use an existing MySQL DBs data in another MySQL DB that does not contain the same fields? I have several hundreds of URLs in a DB that I want to move to another directory that has not the same structure /fields. (I hope this makes sense as I am a dummie with MySQL)