MySQL Dump/Import fails

[Robin Mannering]

Hello,

I'm wondering if anybody can shed any light on the following problem :

Having export tables, views and function/procedures (using Navicat), I am unable to import the functions exported from our dev database into our production database.

Dev Database : MySQL 5.1.51-community
Production Database : MySQL 5.0.19-standard

Here is an example of a function, followed by the error reported.



DROP PROCEDURE IF EXISTS `updateGuestBasic`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `updateGuestBasic`(IN `in_firstName` varchar(50),IN `in_lastName` varchar(50),IN `in_primaryEmail` varchar(100),IN `in_mobileTel` varchar(100),IN `in_guestID` int)
BEGIN
UPDATE guest
SET firstName = in_firstName,
lastName = in_lastName,
primaryEmail = in_primaryEmail,
mobileTel = in_mobileTel
WHERE guestID = in_guestID;
END
;;
DELIMITER ;


And the resultant error :


[Msg] [Dtf] DataTransfer started
[Msg] [Dtf] Getting procedures properties
[Msg] [Dtf] Drop procedure: updateGuestBasic
[Msg] [Dtf] Create procedure: updateGuestBasic
[Err] [Dtf] 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 'PROCEDURE `updateGuestBasic`(IN `in_firstName` varchar(50),IN `in_lastName` varc' at line 1
[Err] [Dtf] Finished - Unsuccessfully
--------------------------------------------------