ERROR #1064
Posted by:
Vinay KD
Date: July 11, 2010 12:02PM
I have generated a backup through Backup option in MySql Administrator 1.2.12
Whenever I am trying to restore the database through this backup file on my hosting space (windows server) it is returning an error
===============================================================
SQL query:
DELIMITER $$ /*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER' */ $$ CREATE DEFINER=`webdbadmin`@`%` PROCEDURE `spAdd_GeneralInfo`( IN p_userid VARCHAR(40), IN p_firstname VARCHAR(250), IN p_lastname VARCHAR(250), IN p_dobmm VARCHAR(20), IN p_dobdd INTEGER, IN p_dobyr INTEGER, IN p_gender VARCHAR(6), IN p_relationshipstatus VARCHAR(45), IN p_friends INTEGER, IN p_activitypartners INTEGER, IN p_businessnetworking INTEGER, IN p_dating INTEGER, IN p_datingwith VARCHAR(45), IN p_primaryemail VARCHAR(100), IN p_secondaryemail VARCHAR(100), IN p_homephone VARCHAR(45), IN p_cellphone VARCHAR(45), IN p_addressline1 VARCHAR(500), IN p[...]
MySQL said:
#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 $$
SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_A' at line 1
===============================================================
by the time being i uploaded the file using ftp and my hosting provider restored the database,
please tell me how i can solve this issue, i am new to Mysql and not familiar with MYSQL> command line. so please give me the possible solution.
Vinay KD