Mysql Error when restoring a server...

4 posts / 0 new

Topic locked

#1 Sat, 04/07/2007 - 22:26

JohnPenrod

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

===cut===

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

===cut===

#2 Sun, 04/08/2007 - 17:51

kcackler

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

#3 Sun, 04/08/2007 - 18:20

Joe

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

--

Check out the forum guidelines!

#4 Sun, 04/08/2007 - 18:21

Joe

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.

--

Check out the forum guidelines!

Topic locked