URGENT: error restoring backups!

Hello! I have a severe problem. My server went bust and i am restoring all the domain backups on a new machine. However, restoration of mysql dbs fails with this message: " load failed! ERROR 1064 (42000) at line 1: 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 'hosts=localhost' at line 1" what can i do to fix this?

Status: 
Closed (fixed)

Comments

Hmm, that's an unusual problem!

What version of MySQL had you been using on the previous server?

Also, is it all Virtual Servers that fail to restore, or just one of them?

ronald's picture
Submitted by ronald on Fri, 04/29/2011 - 11:15 Pro Licensee

log into mysql and try:
mysql> DISABLE FORMATTING

thank you. btw i managed to restart the broken server, so i dont need this anymore.

thank you. btw i managed to restart the broken server, so i dont need this anymore.