error when trying to get database online (intermedia)

[wycks]

Someone here recommended using intermedia for coldfusion hosting, and I'm relatively happy with them, but they can't offer support for the problem I"m having.  I'm trying to get my mySQL database online, but I get this error:

Cannot restore database from backup 'mymindsnotrighttest.sql' (Error  occurred while evaling command (errStr = [error] [2010-08-17 13:16:24]  main::Imedia::HP::Mysql::

restoreDatabaseFromBackup: Cannot restore database from backup 'mymindsnotrighttest.sql' ([error]  Imedia::HP::Mysql::Imedia::Admin::BackupManager::Mysql::restore: Cannot restore backup to 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) at line 102: 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 'USING BTREE )  ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT' at line 12 cat:  write error: Broken pipe)),errCode = -1))

Everything works fine when I'm using localhost.  The support guy for intermedia told me that he "reviewed your SQL File and it does not appear to have a problem"  So I don't know where to go from here...

[wycks]

ok, I went back and made a new database but changed the character set / collation... aside from that change, everything is the same, but I get an error saying that the datasource could not be found when I can see all the tables in intermedia's phpmyadmin page... would changing the character set / collation cause this error?