MySQL Dump errors with routines v 5.5.24
Hi everybody, i've tried to do as much research on this as possible before I asked, but at last it has beaten me up enough, even to the point where I submit.
When looking around at errors regarding MySQL dumps with --routines I found most of the time the advice was to upgrade to 5.5, so I did that however I still get errors with --routines during import.
Below is the MySQL dump, and the error occurs at the first SP. Any help is welcomed!
MySQL Database Error: 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 ;
/*!50003 SET sql_mode = @saved_sql_mode */ ;
/*!50003' at line 32
-- MySQL dump 10.13 Distrib 5.5.24, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database:
-- ------------------------------------------------------
-- Server version 5.5.24-1~dotdeb.1
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Current Database: `autobackup`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `autobackup` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `autobackup`;
--
-- Dumping routines for database 'autobackup'
--
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client = latin1 */ ;
/*!50003 SET character_set_results = latin1 */ ;
/*!50003 SET collation_connection = latin1_swedish_ci */ ;
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
/*!50003 SET sql_mode = '' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`%`*/ /*!50003 PROCEDURE `Application_CreateNewPage`(
RoleNameParamParam varchar(20),
AccordionHeaderParam varchar(20),
UrlLinkParam varchar(50),
AdminDescriptionParam varchar(50),
htmldescrptionParam varchar(50),
listOrderParam int)
INSERT INTO tbluserrolepages(Service,
Role,
Link,
Description,
htmlDescription,
ListOrder)
VALUES (AccordionHeaderParam,
RoleNameParamParam,
UrlLinkParam,
AdminDescriptionParam,
htmldescrptionParam,
listOrderParam)
#select tbluserrolepages.service,
#tbluserrolepages.link,
#tbluserrolepages.htmlDescription
#FROM tblusers
#join tbluserrolepermissions on tblusers.userid = tbluserrolepermissions.userID
#join tbluserrolepages on tbluserrolepermissions.role = tbluserrolepages.role
#WHERE tblusers.userID = usernameID
#ORDER BY tbluserrolepages.service, tbluserrolepages.listorder;
#end */;;
DELIMITER ;
Edited 1 time(s). Last edit at 07/05/2012 06:45AM by Joshua Long.