Adarsh Sharma ERROR 1307 (HY000) at line 31: Failed to CREATE PROCEDURE
Jan 02, 2012; 15:47
Adarsh Sharma
ERROR 1307 (HY000) at line 31: Failed to CREATE PROCEDURE
Dear all,
I am running Mysql on a Linux System ( Caos ). Today when I am trying to create a procedure in it, I m facing the below issue :
ERROR 1307 (HY000) at line 31: Failed to CREATE PROCEDURE
My OS version is : Systemr-5:~ # cat /etc/issue Welcome to SUSE Linux Enterprise Server 10 SP1 (x86_64) - Kernel \r (\l).
Kernel Version is : Server-5:~ # uname -a Linux 5 2.6.16.46-0.12-smp #1 SMP Thu May 17 14:00:09 UTC 2007 x86_64 x86_64 x86_64 GNU/Linux
Mysql Version is very old : System-5:~ # mysql --version mysql Ver 14.12 Distrib 5.0.45, for unknown-linux-gnu (x86_64) using readline 5.0
After some research ,I know this error occurs due to loading mysql data in previous version of mysql from new one. I had this issue in the past & I solved the issue by mysql_upgrade command but this time the issue still persists.
Any suggestions for solving the issue.
Thanks in Advance.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Jan 02
Hal?sz S?ndor Re: ERROR 1307 (HY000) at line 31: Failed to CREATE PROCEDURE
Jan 02, 2012; 12:49
Hal?sz S?ndor
Re: ERROR 1307 (HY000) at line 31: Failed to CREATE PROCEDURE
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!