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.
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.