Submitted by Hal9000 on Fri, 04/29/2011 - 09:11
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
Submitted by andreychek on Fri, 04/29/2011 - 09:19 Comment #1
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?
log into mysql and try:
mysql> DISABLE FORMATTING
Submitted by Hal9000 on Fri, 04/29/2011 - 11:20 Comment #3
thank you. btw i managed to restart the broken server, so i dont need this anymore.
Submitted by Hal9000 on Fri, 04/29/2011 - 11:21 Comment #4
thank you. btw i managed to restart the broken server, so i dont need this anymore.
Submitted by Hal9000 on Fri, 05/11/2012 - 02:25 Comment #5