title: migrating a stored procedure from mysql 5.0 to 5.1.37
body: <p>I am trying to migrate my database from MYSQL 5.1.37 on my machine to MYSQL 5.0 on my hosting company. But the problem is, while I am able to migrate my tables I got errors when I try stored procedures.</p>
  
  <p>Here is one which works fine on my machine.</p>
  
  <pre><code>DELIMITER $$
  
  DROP PROCEDURE IF EXISTS `db986`.`sp_addUser`$$
  CREATE DEFINER=`tse`@`%` PROCEDURE  `db986`.`sp_addUser`(_loginid varchar(45),_password varchar(45),_email varchar(45),_accountcreateddate date,_gender char(8))
  BEGIN
  insert into login (`loginid`,`password`,`email`,`accountcreateddate`,`gender`) values (_loginid,_password,_email,_accountcreateddate,_gender);
  END $$
  
  DELIMITER ;
  </code></pre>
  
  <p>I am not sure what should I have to fix to get it running on the hosting company, I am using <em>1and1</em> as my hosting server.</p>
  
  <p>Any help.</p>