Mysql Error Could Not Fetch Schema Table Status
Status: Duplicate Impact on me: None Category:MySQL Server Severity:S2 (Serious) Version: OS:Microsoft Windows (XP sp2) Assigned to: View Add Comment Files Developer Edit Submission View Progress Log Contributions [27 Apr 2007 17:02] A Campa Description: Hi there, when trying to access the databases trough the MYSQL Administrator I get the following error: mysql could not fetch schema table status I can access my databases using the command prompt no problem. I have uninstalled and reinstalled the Mysql server 5.0. and Mysql Administrator but I keep receiving the same error message. Any suggestions? How to repeat: Click on Catalogs then click on any of the available databases, you should receive the error message. [27 Apr 2007 19:58] Valerii Kravchuk Thank you for a problem report. What exact version of MySQL server and MySQL Administrator do you use? [28 Apr 2007 16:46] A Campa The MySql version is: MySQL 5.0.37-community-nt via TCP/IP and the MYSQL Administrator is version 1.2.11. [29 Apr 2007 11:42] Valerii Kravchuk Have you tried to login as root in MySQL Administrator? Do you have this problem for any database, including mysql? [30 Apr 2007 13:11] A Campa I have only logged in as root the server host is localhost. I have four databases. information_schema mysql test dvdrentals I created the last one. I can work on dvdrentals using the command prompt. [2 May 2007 16:06] Miguel Solorzano Thank you for the feedback. I was not able to repeat either on XP or Vista. Could you please, stop the service service, edit the my.ini file adding the general query log: [mysqld] # The TCP/IP Port the MySQL Server will listen on port=3307 log then start the service again, test the issue reported with MA and then stop the server and print here the contain od computer_name.log file, something like: C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.37-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3307, Named Pipe: (null) Time Id Command Argument 070502 12:56:46 1 Connect root@localhost on 1 Query SELECT @@sql_mode 1 Query SET SESSION sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' 1 Query SET NAMES utf8 2 Connect root@localhost on 2 Query SELECT @@sql_mode 2 Query SET SESSION sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' 2 Query SET NAMES utf8 2 Quit 070502 12:56:48 1 Query show databases 070502 12:56:50 1 Init DB mysql 1 Query SHOW TABLE STATUS 070502 12:56:51 1 Query SHOW INDEX FROM `columns_priv` 1 Query DESCRIBE `columns_pri
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: MySQL Administrator :: Error: Could Not Fetch Schema Table Status New Topic Advanced Search Error: Could Not Fetch Schema Table Status Posted by: Joan Nunez () Date: August 28, 2007 10:44AM Hi, i'm getting this error every time i try to see any schema with MySQL ADMINISTRATOR.. a similar error occurs with MySQL BROWSER Error MySQL ADMINISTRATOR: Could Not Fetch Schema Table Status Error MySQL BROWSER: Could Not Fetch Columns Can someone Help me with this... Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written https://bugs.mysql.com/bug.php?id=28140 By Posted Error: Could Not Fetch Schema Table Status Joan Nunez 08/28/2007 10:44AM Re: Error: Could Not Fetch Schema Table Status Joan Nunez 08/28/2007 12:44PM Re: Error: Could Not Fetch Schema Table Status Frank Albrecht 09/11/2007 05:15AM Re: Error: Could Not Fetch Schema Table Status Steve Betts 03/11/2008 09:43PM Re: Error: Could Not Fetch Schema Table Status Steve Betts 03/11/2008 09:50PM Re: Error: http://forums.mysql.com/read.php?34,169966,169966 Could Not Fetch Schema Table Status Julio Ferrari 04/16/2008 12:42PM Re: Error: Could Not Fetch Schema Table Status Steve Parker 08/01/2008 12:13PM Re: Error: Could Not Fetch Schema Table Status Vesa Nieminen 08/13/2008 11:14PM Re: Error: Could Not Fetch Schema Table Status Linus Gustafsson 10/16/2008 02:27AM Re: Error: Could Not Fetch Schema Table Status Michelle Inzunza 04/01/2009 10:01AM Sorry, you can't reply to this topic. It has been closed. powered by phorum Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party. Contact Sales USA: +1-866-221-0634 Canada: +1-866-221-0634 Germany: +49 89 143 01280 France: +33 1 57 60 83 57 Italy: +39 02 249 59 120 UK: +44 207 553 8447 Japan: 0120-065556 China: 10800-811-0823 India: 0008001005870 More Countries» Contact Us Online» Products MySQL Enterprise Edition MySQL Standard Edition MySQL Classic Edition MySQL Cluster CGE MySQL Embedded (OEM/ISV) Services Training Certification Consulting Support Downloads MySQL Community Server MySQL Cluster MySQL Fabric MySQL Utilities MySQL Workbench About MySQL Contact Us How to Buy Part
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 http://stackoverflow.com/questions/942609/error-mysql-could-not-fetch-schema-table-status 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 “mysql could not fetch schema table status” up vote 0 down vote favorite The error mysql could not fetch schema table status occurs when I try backup mysql error or list database tables using MySql Administrator. I did some research on MySql Bugs (id=28140) and also MySql Forums (http://forums.mysql.com/read.php?34,169966,170024#msg-170024). Their solution talks about McFee. Actually I rent a Windows 2003 VPS host and I don't have any anti-virus installed. Do you know exactly what is it? mysql host share|improve this question asked Jun 3 '09 at 0:47 Eduardo Xavier 9311526 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted The mysql mysql error could bug 28140 has two solutions, actually; one of them deals with McAffee, but the other says that it can occur if your TEMP or TMP environment variables point to a non-existent directory, or one that mysql does not have access to write to. Have you tried that? share|improve this answer answered Jun 3 '09 at 1:56 Todd Gardner 10.2k2142 Thanks Todd, I tried a non-existent directory such as c:\Temp\mysql2 and the server couldn't be started. I denied permission for SYSTEm on c:\Temp\mysql and the server couldn't be started. –Eduardo Xavier Jun 3 '09 at 2:15 My host provider did install McAfee on the hardware node. It caused the problem and I'm asking them to make an exception scan on the folder c:\Temp\mysql. Thanks anyway! –Eduardo Xavier Jun 5 '09 at 13:17 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 host or ask your own question. asked 7 years ago viewed 2572 times active 7 years ago Related 335MySQL Error 1093 - Can't specify target table for update