Question
error when trying to get database online (intermedia)
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...
AdChoices