Database didn't transfer one table

[musashi39]

Error in Query:

CREATE TABLE `cms_module_templates` ( `module_name` varchar(200) default NULL, `template_name` varchar(200) default NULL, `content` text, `create_date` datetime default NULL, `modified_date` datetime default NULL, KEY `module_name` (`module_name`,`template_name`) ) TYPE=MyISAM;
MySQL says:

Couldn't create table: cms_module_templates

I just recently switched servers and I've tried backing up and restoring with myphpadmin and with mysqldumber. they both give me this message. I was thinking that maybe I could manually enter the table???? But I don't know how to do this and my php admin says it's not such a good idea. The site is down

[Pierre M.]

Please inform at least with System Info, old hosting context and new hosting context, steps/how to reproduce. Otherwise nobody can guess the combinaison you are facing.

BTW, I don't know mysqldumber.

Pierre M.

[HMTKSteve]

Change the VARCHAR entries from 200 to 150 and it will work.

[blast2007]

Change the VARCHAR entries from 200 to 150 and it will work.

Thanks HMTKSteve.

@Pierre M.
This is a FAQ, asked many and many and manytimes.
Do you think it should be added to the official FAQ, or instead we could ask developers to reduce varchar size in the core to prevent these errors while transfering db?

regards
blast

[alby]

Do you think it should be added to the official FAQ, or instead we could ask developers to reduce varchar size in the core to prevent these errors while transfering db?

In 1.5 will be 165 

Alby

[Pierre M.]

The wiki (hence the FAQ) is open to all for improvements.

Pierre M.