MYSQL error when moving servers

[DannyMilner]

I have done vbulletin server moves before, but I am having a problem.

This is a very new forum (It was set up yesterday) but we are needing to move due to server problems.

Anyway when I run the sql in phpmyadmin it gives me this...


Error

SQL query:

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;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 6

I would be very greatful is someone could fix me a fix.

Kind regards,
Danny

[calorie]

http://www.vbulletin.com/forum/showthread.php?t=187472 :)

[DannyMilner]

I backed the mysql up via the admincp using "Database Backup"

I am trying to run this sql file in phpmyadmin, is there anyway of editing the sql file to make this work (without using ssh)?

Kind regards

Danny

[calorie]

Try a backup from phpMyAdmin, see http://www.vbulletin.com/forum/showthread.php?t=172971

[Paul M]

Try removing the "DEFAULT CHARSET = latin1" bit from the query, and the semi-colon.

[DannyMilner]

I am unable to backup from phpmyadmin because that’s the reason we are moving servers (no support and phpmyadmin config is not correct so you want get on phpmyadmin)

I have tried using cpanels mysql backup feature but still errors. I am totally lost. Do you know if I could fix this just by editing the sql I am running.

Thanks

Danny

[calorie]

See what Paul wrote, in post five. ;)

[Zachery]

You need to remove the mysql 4.1 specific formating, namely the character encoding.

[DannyMilner]

Thank you very much for your help!

I have sorted it out, took me a while to do all the edits.

Big thanks!