Mysql Error 1289
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error Code: 1289. The 'SHOW PROCEDURE|FUNCTION CODE' feature is disabled; to have it working up vote 1 down vote favorite i want to show my procedure code from mysql workbench program. i right click on any procedure and click the "alter procedure" option but didn't happen anything. and i'm try another way to show my code and alter the procedure's codes. with mysql code i want to show to the codes, this code statement follow: SHOW PROCEDURE CODE pusers but i getting this error: Error Code: 1289. The 'SHOW PROCEDURE|FUNCTION CODE' feature is disabled; to have it working My OS is MAC Lion OSX and MySQL Workbench program version are "version 5.2.47 revision 10398" and "version 5.2.45 revision 10251". There are old and new versions of this program. have u got any idea? mysql stored-procedures mysql-workbench alter share|improve this question asked Jul 2 '13 at 6:38 Mesuti 13615 with what user you created the procedure? and with what user you tried to exec SHOW PROCEDURE? my guess is that they are 2 different users –Stephan Jul 2 '13 at 7:19 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote It's by design. SHOW PROCEDURE CODE Syntax This statement is a MySQL extension that is available only for servers that have been built with debugging support. It displays a representation of the internal implementation of the named stored procedure. As the error message explicitly says if you want to be able to use this feature you need to build your MySql with --with-debug option. share|improve this answer answered Jul 3 '13 at 6:05 peterm 57.5k56277 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged mysql stored-procedur
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: InnoDB :: InnoDB problem with windows MySQL 5.0.15? New Topic Advanced Search InnoDB problem with windows MySQL 5.0.15? Posted by: bzink5 () Date: November 10, 2005 03:35PM i was trying to install gallery2 when i first noticed this problem my post on the gallery forum can be found here: http://gallery.menalto.com/node/39810 when using a command such as "create table test123 (id int not null);" i'm getting the error: "ERROR 1289 http://stackoverflow.com/questions/17418968/error-code-1289-the-show-procedurefunction-code-feature-is-disabled-to-hav (HY000): The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working" and when i type in: "show innodb status;" i receive the error "ERROR 1235 (42000): Cannot call SHOW INNODB STATUS because skip-innodb is defined" but i clearly have "skip-innodb" commented out in my.ini is there somewhere where "skip-innodb" is called other http://forums.mysql.com/read.php?22,53946,53946 than in my.ini? is there any other way to enable innodb manually? is there just a bug with the innodb with windows version of mysql 5.0.15? i am running fresh installs of the following on a windows machine: apache 2.0.55 mysql 5.0.15 php 4.4.1 (all appear to be in working order despite the above error) Navigate:Previous Message•Next Message Options:Reply•Quote Subject Views Written By Posted InnoDB problem with windows MySQL 5.0.15? 43068 bzink5 11/10/2005 03:35PM Re: InnoDB problem with windows MySQL 5.0.15? 5885 Rob Vieira 11/10/2005 04:08PM Re: InnoDB problem with windows MySQL 5.0.15? 4137 Heikki Tuuri 11/10/2005 07:50PM Re: InnoDB problem with windows MySQL 5.0.15? 3534 bzink5 11/11/2005 05:18PM Re: InnoDB problem with windows MySQL 5.0.15? 3213 Heikki Tuuri 11/11/2005 08:25PM Re: InnoDB problem with windows MySQL 5.0.15? 3031 Yariv Keinan 11/13/2005 11:47PM Re: InnoDB problem with windows MySQL 5.0.15? 2873 Wilco 11/14/2005 01:24PM Re: InnoDB problem with windows MySQL 5.0.15? 6493 Dan Prosser 11/15/2005 10:59PM Re: InnoDB problem with windows MySQL 5.0.15? 2477 Wei Wang 10/30/20
Gallery 2 and your installation log might show: ... mysqlt http://codex.galleryproject.org/MySQL:Enabling_InnoDB_on_Windows error: [1289: The 'InnoDB' feature is disabled; you need http://dba.stackexchange.com/questions/22817/show-procedure-code-in-mysql MySQL built with 'InnoDB' to have it working] This error usually occurs when running MySQL on a MS Windows server because the InnoDB engine is disabled by default. Alternatively, on FreeBSD, you could have mysql error modified your /etc/my.cnf and included skip-innodb in which case you could comment it out. You have two options: Recommended: Enable InnoDB as MySQL Engine on Windows 1. Shut down your MySQL server (stop the service) 2. Open my.ini (mysql's config file), which is mysql error 1289 located in your MySQL program folder. 3. In my.ini, find: skip-innodb 4. Replace this line with: # skip-innodb 5. Save the file 6. Start the MySQL server again Now you can try to install Gallery again (redo all installation wizard steps). Or: Use MySQL's MyISAM Engine Instead In the database setup step of the Gallery installer, pick the "MySQL (versions before v3.23)" driver. Retrieved from "http://codex.galleryproject.org/index.php?title=MySQL:Enabling_InnoDB_on_Windows&oldid=16074" Categories: Gallery 2:InstallationGallery 2:Troubleshooting Views PageDiscussionView sourceHistory Navigation Main Page Recent changes Random page Search Tools What links here Related changes Upload file Special pages Printable version advertisements This page was last modified on 20 September 2007, at 16:45. This page has been accessed 48,498 times. About Gallery Codex | Content is available under GNU FDL unless otherwise noted. | Disclaimers
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Show procedure code in MySQL up vote 5 down vote favorite 1 I've tried to show the SQL code of a stored procedure called add_pixel: mysql> SHOW PROCEDURE CODE add_pixel; ERROR 1064 (42000): 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 '' at line 1 I've made sure that the procedure exists: mysql> CALL add_pixel(); ERROR 1318 (42000): Incorrect number of arguments for PROCEDURE pixels.add_pixel; expected 3, got 0 And SHOW CREATE PROCEDURE works: mysql> SHOW CREATE PROCEDURE add_pixel; +-----------+----------+------------------+----------------------+----------------------+--------------------+ | Procedure | sql_mode | Create Procedure | character_set_client | collation_connection | Database Collation | +-----------+----------+------------------+----------------------+----------------------+--------------------+ | add_pixel | | NULL | utf8 | utf8_general_ci | utf8_unicode_ci | +-----------+----------+------------------+----------------------+----------------------+--------------------+ 1 row in set (0.00 sec) and that my MySQL ver