Mysql Error when restoring a server...

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

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.