Error with moving hosts

[S2S-Robert]

When moving hosts I get the following error with some of the databases (not all strangely...)

mysql error: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)

Any thoughts?

 

[S2S-Robert]

It has something to do with the fact that I moved the files from a mysql 4.1 server to a 4.0.17 server, cause I also get errors importing.

Seems something is wrong with:

DROP TABLE IF EXISTS `access`;
CREATE TABLE `access` (
  `userid` int(10) unsigned NOT NULL default '0',
  `forumid` smallint(5) unsigned NOT NULL default '0',
  `accessmask` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`userid`,`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Especially with CHARSET=latin1. If I do an ls on the old server I get several XML files, while on the DA server I get conf files in the charset folder mentioned above.

 

[jmstacey]

Correct, MySQL 4.1 included more character set information.

See: http://dev.mysql.com/doc/mysql/en/downgrading-to-4-0.html

It appears that there is a process that you must go through to safely and confidently donwgrade from 4.1 to 4.0