Mysql Error when restoring a server...

Any ideas why I got this? This is a base install of cent os with a new install of virtualmin…


Creating MySQL database server1-smf …
Restore failed : SQL create database server1-smf failed : 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 ‘-smf’ at line 1


This is just a shot in the dark, but are you using a different version of MySQL now than you were before? If so, you’re almost guaranteed to have issues.

Hey John,

Kevin’s right, though it usually only causes trouble if you go backward from a newer MySQL to an older one. Restoring dumps from old versions to new usually goes fine. It’s also possible (though less likely) that the backup was made on a MySQL that had extra features patched in and the new one does not (sometimes this can be particularly problematic).

BTW-It might be as simple as renaming the database. I dunno. It looks like it’s compaining about the - in your database name. Maybe MySQL now disallows this character in database names.