Created With Different MySQL?
 

I'm getting this message on about 10 different tables after importing to new dedicated server. Both servers ran MySQL 5.0. Any suggestions?



Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT COUNT(*) AS count
FROM forum
WHERE childlist = '';

MySQL Error : Table './rantrave_tsanders/forum' was created with a different version of MySQL and cannot be read
Error Number : 1033
Date : Wednesday, May 31st 2006 @ 11:49:17 AM
Script : http://70.87.90.170/~rantrave/forums/admincp/tools.php
Referrer :
IP Address : 71.1.43.248
Username :
Classname : vb_database

Here's another one:


Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT languageid,
phrasegroup_holiday AS phrasegroup_holiday,
phrasegroup_global AS phrasegroup_global,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Table './rantrave_tsanders/language' was created with a different version of MySQL and cannot be read
Error Number : 1033
Date : Wednesday, May 31st 2006 @ 11:48:55 AM
Script : http://70.87.90.170/~rantrave/forums/index.php
Referrer :
IP Address : 71.1.43.248
Username :
Classname : vb_database

First off from the looks of that error message you are using a different version of MySQL, did you recently upgrade to a new version of MySQL?

What did you do, manually move the mysql files to the new server instead of dumping them?

I have 5.0 on the old server, and I set the current server up with 5.0 (using 4.1 password hash)

Basically moved them in binary format into database

Yea, thats a problem, you shouldn't ever really do that.