#1064 - You have an error in your SQL syntax;

[tilenk]

Hello. I'm having a problem with restoring a mysql database for wordpress when moved to a new host. When I try to execute the following command

DELIMITER ;;
DELIMITER ;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 

i get the following error message

#1064 - 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 'DELIMITER' at line 1
 

I would really apreciate if someone would help me, as I'm not an expert in mysql...

Thank you


Tilen

[Atli]

Hi Tilen. Welcome to Bytes!

That code doesn't really make sense. For one, I'm not sure you can use ;; as a custom delimiter. I wouldn't recommend it even it if was possible.
Also, even if it does work, the line after that just resets it, nullifying the first command.
And all the other lines are commented, so only the first two are actually being executed.

What is it that you are trying to do with this code?
How are you executing it?
(Through the CLI? or via a web interface like phpMyAdmin?)

[coolsti]

Atli,

this looks a lot like the code that is auto generated when making a mysqldump.

I have also experienced some problems when migrating a database from one Linux machine to another, if the mysql versions did not match. Although the statements look like they are commented out, I got errors until I just went into my mysqldump file and deleted the lines.

Perhaps the OP is having a similar difficulty.