Moving forum and mysql to another provider

[m3power]

I have ssh access with the new provider but don't have access with the existing hostin. I used mysqldumper but that doesn't work on the restore. Perhaps I will try one of the others now.
Thanks Marco

Ok So I tried big dump and got the following error:

BigDump: Staggered MySQL Dump Importer v0.28b
Processing file: astrasriforums.sql

Starting from line: 51001

Error at the line 52156: ) ENGINE=MyISAM ;

Query: CREATE TABLE `attachment` (
`attachmentid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`filename` varchar(100) NOT NULL default '',
`filedata` mediumblob,
`visible` smallint(5) unsigned NOT NULL default '0',
`counter` int(10) unsigned NOT NULL default '0',
`postid` int(10) unsigned NOT NULL default '0',
`filesize` int(10) unsigned NOT NULL default '0',
`thumbnail` mediumblob,
`filehash` varchar(32) NOT NULL default '',
`posthash` varchar(32) NOT NULL default '',
`thumbnail_dateline` int(10) unsigned NOT NULL default '0',
`thumbnail_filesize` int(10) unsigned NOT NULL default '0',
`extension` varchar(20) character set latin1 collate latin1_bin NOT NULL default '',
PRIMARY KEY (`attachmentid`),
KEY `posthash` (`posthash`,`userid`),
KEY `postid` (`postid`),
KEY `filesize` (`filesize`),
KEY `filehash` (`filehash`),
KEY `userid` (`userid`),
KEY `visible` (`visible`)
) ENGINE=MyISAM ;

MySQL: 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 'collate latin1_bin NOT NULL default '', PRIMARY KEY (`attach

Stopped on error


it's basically the same error that happens when you you use mysql when using ssh! Ideas please?