error when trying to get database online (intermedia)

someone here recommended using intermedia coldfusion hosting, , i'm relatively happy them, can't offer support problem i"m having.  i'm trying mysql database online, error:

 

cannot restore database backup 'mymindsnotrighttest.sql' (error  occurred while evaling command (errstr = [error] [2010-08-17 13:16:24]  main::imedia::hp::mysql::

restoredatabasefrombackup: cannot restore database backup 'mymindsnotrighttest.sql' ([error]  imedia::hp::mysql::imedia::admin::backupmanager::mysql::restore: cannot restore backup database via command 'cat /mnt/smb/backup/mysql/mikewycklendt/mymindsnotrighttest/mymindsnotrighttest.sql | mysql --user=mysql_svc --database=mymindsnotrighttest'  (exitcode=1, error=, stderr=error 1064 (42000) @ line 102: have an  error in sql syntax; check manual corresponds your  mysql server version right syntax use near 'using btree )  engine=innodb default charset=latin1 row_format=compact' @ line 12 cat:  write error: broken pipe)),errcode = -1))

 

everything works fine when i'm using localhost.  support guy intermedia told me "reviewed sql file , not appear have problem"  don't know go here...

ok, went , made new database changed character set / collation... aside change, same, error saying datasource not found when can see tables in intermedia's phpmyadmin page... changing character set / collation cause error?

More discussions in ColdFusion

adobe