Re: ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist
It sounds like InnoDB itself might have failed to start, but there is not enough information to know for sure. Please check the server's error log. On Thu, Mar 15, 2012 at 2:01 AM, Adarsh Sharma adarsh.sha...@orkash.com wrote: Dear All, Is there any way to recover data or only schema of corrupted innodb tables.My 4 innodb tables are coorupted in a database. mysql show tables; +-+ | Tables_in_ois | +-+ | acos | | aros | | aros_acos | | categories | | groups | | metadata | | page_content | | projects | | results | | users | | website_internalurl | +-+ 12 rows in set (0.00 sec) mysql show create table metadata; ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist I backup my all remaining tables as I not able to backup corruted tables. Thanks in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql -- Baron Schwartz Win free MySQL conference tickets! http://goo.gl/mvZ4W -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist
. Thanks Baron Schwartz wrote: It sounds like InnoDB itself might have failed to start, but there is not enough information to know for sure. Please check the server's error log. On Thu, Mar 15, 2012 at 2:01 AM, Adarsh Sharma adarsh.sha...@orkash.com wrote: Dear All, Is there any way to recover data or only schema of corrupted innodb tables.My 4 innodb tables are coorupted in a database. mysql show tables; +-+ | Tables_in_ois | +-+ | acos| | aros| | aros_acos | | categories | | groups | | metadata| | page_content| | projects| | results | | users | | website_internalurl | +-+ 12 rows in set (0.00 sec) mysql show create table metadata; ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist I backup my all remaining tables as I not able to backup corruted tables. Thanks in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist
-troubleshooting.html how you can resolve the problem. 120315 17:17:52 [ERROR] Cannot find or open table ois/website_internalurl from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database? or, the table contains indexes that this version of the engine doesn't support. See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html how you can resolve the problem. I read the links Is there any way whether my table is orphaned or not. I need that table structure only , and it might be good that I get my data back it is not mandatory. Thanks Baron Schwartz wrote: It sounds like InnoDB itself might have failed to start, but there is not enough information to know for sure. Please check the server's error log. On Thu, Mar 15, 2012 at 2:01 AM, Adarsh Sharma adarsh.sha...@orkash.com mailto:adarsh.sha...@orkash.com wrote: Dear All, Is there any way to recover data or only schema of corrupted innodb tables.My 4 innodb tables are coorupted in a database. mysql show tables; +-+ | Tables_in_ois | +-+ | acos| | aros| | aros_acos | | categories | | groups | | metadata| | page_content| | projects| | results | | users | | website_internalurl | +-+ 12 rows in set (0.00 sec) mysql show create table metadata; ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist I backup my all remaining tables as I not able to backup corruted tables. Thanks in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist
Dear All, Is there any way to recover data or only schema of corrupted innodb tables.My 4 innodb tables are coorupted in a database. mysql show tables; +-+ | Tables_in_ois | +-+ | acos| | aros| | aros_acos | | categories | | groups | | metadata| | page_content| | projects| | results | | users | | website_internalurl | +-+ 12 rows in set (0.00 sec) mysql show create table metadata; ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist I backup my all remaining tables as I not able to backup corruted tables. Thanks in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ERROR 1146 (42S02): Table doesn't exist
Dear all, Today I changed my database name from abc to abc1 by the below commands :- 1. Go to data dir : cd /hdd2-1/mysql_data/ 2. mv abc abc1 But when I go to the mysql prompt try to use the tables in abc database , below error occurs: ERROR 1146 (42S02): Table 'abc1.job_queue' doesn't exist I also check the permissions in data dir they are : 2 -rw-rw 1 mysql mysql 9227 Mar 17 2010 job_queue.frm I tried to roll back my procedure by mv abc1 abc but still problem occurs. Thanks in Advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: ERROR 1146 (42S02): Table doesn't exist
- Original Message - From: Adarsh Sharma adarsh.sha...@orkash.com 1. Go to data dir : cd /hdd2-1/mysql_data/ 2. mv abc abc1 Whatever gave you the idea that it's a good plan to start messing with the files of a service whose inner workings you have no clue about? ERROR 1146 (42S02): Table 'abc1.job_queue' doesn't exist Fancy, isn't it? I tried to roll back my procedure by mv abc1 abc but still problem occurs. Yeps. That's the wonderful world of metadata caching for you. Restart your MySQL daemon and pray to whatever you believe in that your tables aren't *too* much corrupted. In the future, stay inside MySQL. Create a new database named to your liking, and repeat RENAME TABLE old-database.tablename TO new-database.tablename for every table in the database. Don't forget to update the relevant users' permissions, too. No, there is no RENAME DATABASE command for various reasons, some of which are explained in the quite excellent online documentation which, incidentally, would have told you that you were going to mess up your database. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
error 1146 X.1 does not exist
Can someone point me in the right direction. I had 4.1 running and all was well with my little program. I decided to test the code with the newer 5.0.18. I updated my DB and then tried to access it using the MYSQl Control Centre - 0.9.4-Beta and query browser 1.0.4 alpha. The Administrator allows me to view table structure but not to add any numerical columns. Using the Control centre, If I double click on the table I wish to view data I get two lines in the message area Empty set (0.00) sec [local] ERROR 1146: Table 'llcopy.1' doesn't exist llcopy being my test database name. These messages are got no matter what the table content is. I do note that the error message on this app is different numerically to the previous Also my insert program now fails to insert data. So I extracted one of the SQL insert commands that worked with 4.1 and manually run it using the mysql.exe command interface. This is the manual command. INSERT INTO BanksC (Bank,BankName,AccountNo,Balance,PMClosingBalance,EOMTempBalance,STTS) VALUES (C1,Client Bank,NONE,0.00,0.00,0.00,C); The error was ERROR 1054 (42S22): Unknown column 'C1' in 'field list' The settings of the table are char(2), char(20), char(12), decimal(12,2),decimal(12,2),decimal(12,2),char(1) respectively. This is driving me crazy. I am obviously doing something stupid but I have got so close to the problem I can't see the wood for the trees. Kerry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: error 1146 X.1 does not exist
I have seen the problem with the INSERT syntax. The new version doesn't like the use of 's to surround text and prefers single quotes. I still don't see where the dbname.1 error is from Kerry -Original Message- From: Kerry Frater [mailto:[EMAIL PROTECTED] Sent: 02 February 2006 10:05 To: mysql@lists.mysql.com Subject: error 1146 X.1 does not exist Can someone point me in the right direction. I had 4.1 running and all was well with my little program. I decided to test the code with the newer 5.0.18. I updated my DB and then tried to access it using the MYSQl Control Centre - 0.9.4-Beta and query browser 1.0.4 alpha. The Administrator allows me to view table structure but not to add any numerical columns. Using the Control centre, If I double click on the table I wish to view data I get two lines in the message area Empty set (0.00) sec [local] ERROR 1146: Table 'llcopy.1' doesn't exist llcopy being my test database name. These messages are got no matter what the table content is. I do note that the error message on this app is different numerically to the previous Also my insert program now fails to insert data. So I extracted one of the SQL insert commands that worked with 4.1 and manually run it using the mysql.exe command interface. This is the manual command. INSERT INTO BanksC (Bank,BankName,AccountNo,Balance,PMClosingBalance,EOMTempBalance,STTS) VALUES (C1,Client Bank,NONE,0.00,0.00,0.00,C); The error was ERROR 1054 (42S22): Unknown column 'C1' in 'field list' The settings of the table are char(2), char(20), char(12), decimal(12,2),decimal(12,2),decimal(12,2),char(1) respectively. This is driving me crazy. I am obviously doing something stupid but I have got so close to the problem I can't see the wood for the trees. Kerry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error 1146 X.1 does not exist
Hello. MySQL CC is not supported now, and could have some problems with a fresh versions of MySQL. If error doesn't appear in latest MySQL Administrator then everything is ok. [local] ERROR 1146: Table 'llcopy.1' doesn't exist Have a look here: http://dev.mysql.com/doc/refman/5.0/en/cannot-find-table.html The error was ERROR 1054 (42S22): Unknown column 'C1' in 'field list' Check if the sql_mode has ANSI_QUOTES enabled. See: http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html Kerry Frater wrote: Can someone point me in the right direction. I had 4.1 running and all was well with my little program. I decided to test the code with the newer 5.0.18. I updated my DB and then tried to access it using the MYSQl Control Centre - 0.9.4-Beta and query browser 1.0.4 alpha. The Administrator allows me to view table structure but not to add any numerical columns. Using the Control centre, If I double click on the table I wish to view data I get two lines in the message area Empty set (0.00) sec [local] ERROR 1146: Table 'llcopy.1' doesn't exist llcopy being my test database name. These messages are got no matter what the table content is. I do note that the error message on this app is different numerically to the previous Also my insert program now fails to insert data. So I extracted one of the SQL insert commands that worked with 4.1 and manually run it using the mysql.exe command interface. This is the manual command. INSERT INTO BanksC (Bank,BankName,AccountNo,Balance,PMClosingBalance,EOMTempBalance,STTS) VALUES (C1,Client Bank,NONE,0.00,0.00,0.00,C); The error was ERROR 1054 (42S22): Unknown column 'C1' in 'field list' The settings of the table are char(2), char(20), char(12), decimal(12,2),decimal(12,2),decimal(12,2),char(1) respectively. This is driving me crazy. I am obviously doing something stupid but I have got so close to the problem I can't see the wood for the trees. Kerry -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Error: 1146 in Egroupware
Hi, I am using egroupware and in the calendar on a specific day and event I click on the link but MySQL gives me the following error Database error: Invalid SQL: SELECT * FROM phpgw_links WHERE (link_app1 = 'calendar' AND link_id1 = '5') OR (link_app2 = 'calendar' AND link_id2 = '5') ORDER BY link_lastmod DESC mysql Error: 1146 (Table 'egroupware.phpgw_links' doesn't exist) File: /var/www/html/egroupware/infolog/inc/class.solink.inc.php Line: 132 Function: calendar.uicalendar.view 3.23.58 I am using php 4.2.2 and MySQL, also have no background of php and Mysql, Please help!! Thank you, SShahzad
Re: MySQL Error: 1146 in Egroupware
On Thursday 20 January 2005 13:47, Shahzad, Saleem might have typed: Hi, I am using egroupware and in the calendar on a specific day and event I click on the link but MySQL gives me the following error Database error: Invalid SQL: SELECT * FROM phpgw_links WHERE (link_app1 = 'calendar' AND link_id1 = '5') OR (link_app2 = 'calendar' AND link_id2 = '5') ORDER BY link_lastmod DESC mysql Error: 1146 (Table 'egroupware.phpgw_links' doesn't exist) This is nothing to do with MySQL - you installed eGroupware incorrectly by the looks. Suggest RTM of the eGroupware install docs again. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error: 1146 in Egroupware
Database error: Invalid SQL: SELECT * FROM phpgw_links WHERE (link_app1 = 'calendar' AND link_id1 = '5') OR (link_app2 = 'calendar' AND link_id2 = '5') ORDER BY link_lastmod DESC mysql Error: 1146 (Table 'egroupware.phpgw_links' doesn't exist) That would indicate to me 2 possibilities: 1) Database 'egroupware' has a different name or does not exist, or 2) Table phpgw_links has a different name or does not exist As Duncan said, maybe the EGW install was incorrect... cheers Chris Ramsay - Web Developer - The Danwood Group Ltd. T: +44 (0) 1522 834482 F: +44 (0) 1522 884488 e: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] w: http://www.danwood.co.uk - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1146
I don't see 'caldata.resource' anywhere in the statement you posted. Are you sure you are sending the correct string to MySQL for execution as you didn't post what MySQL tried to execute (based on its error message) for us to look at. This may be a variable name typo issue. One very simple technique you can use to debug many SQL issues like these is to add to your code commands to write your SQL statements into your output just before you execute them. (I have found *SO* many finger flubs, missing spaces, and data type mismatches that way!!) If you wrap your debugging echo commands with conditional statements you will be able to turn them on and off with great ease by just adjusting a single variable at the top of your code. This is just a good practice to get into while developing new applications. You could strategically strip them out again later when you take your code into production or you can (I think should) leave them in for the rare cases when you need that information again. Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine Jeff Blasius [EMAIL PROTECTED]To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] rs.com cc: Fax to: 07/13/2004 05:45 Subject: Error 1146 PM I am trying to do an INSERT ... SELECT statement. When using MySQLcc everything is fine. However when I try to execute the command using PHP I get error 1146: Table 'caldata.resource' doesn't exist. Following is my query statement. I am trying to combine a bunch of tables together and I don't think the MERGE method will work very well for me. The table 'job' already exists with all of the necessary fields. There is a primary key setup in 'job' called 'id'. I appreciate any help. INSERT INTO job (CustomerName, ModelNumber, SerialNumber, CertificateNumber, AverageFluidViscosity, JobNumber, SystemID) SELECT CustomerName, ModelNumber, SerialNumber, CertificateNumber, AverageFluidViscosity, JobNumber, SystemID FROM 50041_job Jeff Blasius mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error 1146
I am trying to do an INSERT ... SELECT statement. When using MySQLcc everything is fine. However when I try to execute the command using PHP I get error 1146: Table 'caldata.resource' doesn't exist. Following is my query statement. I am trying to combine a bunch of tables together and I don't think the MERGE method will work very well for me. The table 'job' already exists with all of the necessary fields. There is a primary key setup in 'job' called 'id'. I appreciate any help. INSERT INTO job (CustomerName, ModelNumber, SerialNumber, CertificateNumber, AverageFluidViscosity, JobNumber, SystemID) SELECT CustomerName, ModelNumber, SerialNumber, CertificateNumber, AverageFluidViscosity, JobNumber, SystemID FROM 50041_job Jeff Blasius mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Error 1146 Table mysql.proc doesn't exist
Hi! I'm using mysql-max-nt, Version 5, running on Windows 2000. While inserting rows into a table from a perl script, i get error 1146: table mysql.proc doesn't exist. The application ran without any error with mysql, version 4. Any ideas? best regards, Kai Bungarz Wissenschaftliches Institut der AOK (WIdO) Kortrijker Straße 1 53177 Bonn Tel.: 0228/843-142 (Sekr.: -393) Fax: 0228/843-144 Email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1146 Table mysql.proc doesn't exist
On Tue, 1 Jun 2004 14:50:11 +0200 Bungarz, Kai [EMAIL PROTECTED] wrote: Hi! I'm using mysql-max-nt, Version 5, running on Windows 2000. While inserting rows into a table from a perl script, i get error 1146:table mysql.proc doesn't exist. The application ran without any error with mysql, version 4. Any ideas? Yes, if you are running version 5.0 - a development release, make sure you CAREFULLY read the documentation so you know what you are getting into. You need to fix the grant tables: http://dev.mysql.com/doc/mysql/en/Upgrading-grant-tables.html Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help: Error 1146: Table test.1 doesn't exist
Hi, When I enter this query select * from books, it gives me this error message: Error 1146: Table test.1 doesn't exist. What does that mean? This is MySQL 5.0 and I just installed today. How can I solve this problem? Thanks in advance. Jacklty The best thing to hit the internet in years - NetZero HiSpeed! Surf the web up to FIVE TIMES FASTER! Only $14.95/ month -visit www.netzero.com to sign up today! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
Thank you, I am comparing the two \mysql\data\mysql directories, finding that many files are simply missing in my installation. I had another mysql version previously, which I removed, I also have a different operating system. win2k Pasta de c:\mysql\data\mysql 07/01/2004 11:39DIR . 07/01/2004 11:39DIR .. 22/12/2003 21:03 8.820 columns_priv.frm 22/12/2003 21:03 0 columns_priv.MYD 22/12/2003 21:03 1.024 columns_priv.MYI 22/12/2003 21:03 9.178 db.frm 22/12/2003 21:03 306 db.MYD 22/12/2003 21:03 3.072 db.MYI 22/12/2003 21:03 8.665 func.frm 22/12/2003 21:03 0 func.MYD 22/12/2003 21:03 1.024 func.MYI 22/12/2003 21:03 8.700 help_category.frm 22/12/2003 21:0320 help_category.MYD 22/12/2003 21:03 3.072 help_category.MYI 22/12/2003 21:03 8.612 help_keyword.frm 22/12/2003 21:03 0 help_keyword.MYD 22/12/2003 21:03 1.024 help_keyword.MYI 22/12/2003 21:03 8.630 help_relation.frm 22/12/2003 21:03 0 help_relation.MYD 22/12/2003 21:03 1.024 help_relation.MYI 22/12/2003 21:03 8.770 help_topic.frm 22/12/2003 21:03 0 help_topic.MYD 22/12/2003 21:03 1.024 help_topic.MYI 22/12/2003 21:03 9.148 host.frm 22/12/2003 21:03 0 host.MYD 22/12/2003 21:03 1.024 host.MYI 22/12/2003 21:03 9.470 proc.frm 07/01/2004 13:33 156 proc.MYD 07/01/2004 13:33 2.048 proc.MYI 22/12/2003 21:03 8.925 tables_priv.frm 22/12/2003 21:03 0 tables_priv.MYD 22/12/2003 21:03 1.024 tables_priv.MYI 22/12/2003 21:03 9.992 user.frm 22/12/2003 21:03 160 user.MYD 22/12/2003 21:03 2.048 user.MYI 33 arquivo(s)116.960 bytes Here is my \data\mysql\ directory Directory of I:\mysql\data\mysql 05/01/2004 20:44 DIR . 05/01/2004 20:44 DIR .. 22/12/2003 21:038,820 columns_priv.frm 22/12/2003 21:030 columns_priv.MYD 22/12/2003 21:031,024 columns_priv.MYI 22/12/2003 21:039,178 db.frm 22/12/2003 21:03 306 db.MYD 22/12/2003 21:033,072 db.MYI 22/12/2003 21:038,665 func.frm 22/12/2003 21:030 func.MYD 22/12/2003 21:031,024 func.MYI ## no help_category keyword relation topic 22/12/2003 21:039,148 host.frm 22/12/2003 21:030 host.MYD 22/12/2003 21:031,024 host.MYI ## no proc.form .MYD .MYI 22/12/2003 21:038,925 tables_priv.frm 22/12/2003 21:030 tables_priv.MYD 22/12/2003 21:031,024 tables_priv.MYI 22/12/2003 21:039,992 user.frm 08/01/2004 04:27 576 user.MYD 08/01/2004 04:542,048 user.MYI 18 File(s) 64,826 bytes 2 Dir(s) 3,904,598,016 bytes free Obviously some files are missing, what can I do, install again ? I could unzip the mysql-5.0.0-alpha-win.zip without a problem, and mysql actually runs, under windows 2000, Perhaps another version of MySQL 5.0 is required for win 2k ? Has anyone tried mysql-5.0.0-alpha under win2k ? Please ? Yours Sincerely Morten Gulbrandsen - Original Message - From: miguel solorzano [EMAIL PROTECTED] To: Morten Gulbrandsen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 08, 2004 6:42 AM Subject: Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist At 05:26 8/1/2004 +0100, Morten Gulbrandsen wrote: Hi, I wasn't able to repeat: Microsoft Windows XP [versão 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. c:\cd\mysql\bin C:\mysql\binmysql -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.0.0-alpha-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql CREATE TABLE A ( - SSN CHAR(9) NOT NULL, - SUPERSSN CHAR(9), - DNO INT NOT NULL DEFAULT 1, - PRIMARY KEY (SSN), - INDEX (SUPERSSN), - INDEX (DNO) - )TYPE = INNODB; Query OK, 0 rows affected, 1 warning (0.11 sec) mysql DESCRIBE A; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | SSN | char(9) | | PRI | | | | SUPERSSN | char(9) | YES | MUL | NULL| | | DNO | int(11) | | MUL | 1 | | +--+-+--+-+-+---+ 3 rows in set (0.00 sec) mysql ALTER TABLE A - ADD FOREIGN KEY (SUPERSSN) REFERENCES A(SSN
Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
At 14:40 8/1/2004 +0100, Morten Gulbrandsen wrote: Hi, Thank you, I am comparing the two \mysql\data\mysql directories, finding that many files are simply missing in my installation. I had another mysql version previously, which I removed, I also have a different operating system. win2k MySQL 5.0 should install and run on any Win32 OS, then I guess that some installation's steps/options has failed for to add the missed files. It is important for us to know what exactly is failing, my guess is that you tried to install 5.0 over existing installation and the whole Grant Tables group it isn't installed, then in this case the solution should be to install in new directory. -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.556 / Virus Database: 348 - Release Date: 26/12/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
Miguel Angel Solórzano MySQL 5.0 should install and run on any Win32 OS, then I guess that some installation's steps/options has failed for to add the missed files. Morten Gulbrandsen Interesting, obviously something is missing, anyway 5.0.0.a is present. I could try that, Miguel Angel Solórzano It is important for us to know what exactly is failing, my guess is that you tried to install 5.0 over existing installation and the whole Grant Tables group it isn't installed, then in this case the solution should be to install in new directory. Morten Gulbrandsen This is true, I had another version 4.0.x alpha running, installed in the same directory. But I removed all of it, except my own sql files. some traces of it could make problems, I'd prefer not to format my hard disk in order to get completely rid of mysql. 4 ;-) I used the uninstaller from control panel, which also renamed a my.cnf file. The environment variable I believe is correct. Miguel Angel Solórzano installed, then in this case the solution should be to install in new directory. Morten Gulbrandsen OK, I can do that, and then I can copy the missing stuff back into the correct directory. however I got no warnings or error messages, that files already were present or options which asked me to choose between overwrite or replace. I simply can't see why another installation which is simply a file copying procedure, fails if I somehow uninstall older MySQL versions. Since I renamed the other directory a clash with older installation is impossible, I created a new mysql directory with nothing, before I installed again. ERROR 1146 at line 24: Table 'mysql.proc' doesn't exist the same error again, I did the following, C:\Documents and Settings\Administratornet stop mysql The MySql service is stopping.. The MySql service was stopped successfully. then I renamed the old directory to mysql_old, I did not remove it just in order to compare, I installed again , selected custom and verified that all stuff was checked, then I did C:\Documents and Settings\Administratornet start mysql The MySql service is starting. The MySql service was started successfully. took my file and ran it, I:\mysql\binmysql -u root -vvv testtest.sql -- DROP TABLE IF EXISTS A -- ## Table was nonexistent. Query OK, 0 rows affected, 1 warning (0.06 sec) -- CREATE TABLE A ( SSN CHAR(9) NOT NULL, SUPERSSN CHAR(9), DNO INT NOT NULL DEFAULT 1, PRIMARY KEY (SSN), INDEX (SUPERSSN), INDEX (DNO) )TYPE = INNODB -- ## please why this warning ? can I have more details ? Query OK, 0 rows affected, 1 warning (0.13 sec) -- DESCRIBE A -- +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | SSN | char(9) | | PRI | | | | SUPERSSN | char(9) | YES | MUL | NULL| | | DNO | int(11) | | MUL | 1 | | +--+-+--+-+-+---+ 3 rows in set (0.02 sec) -- ALTER TABLE A ADD FOREIGN KEY (SUPERSSN) REFERENCES A(SSN) ON DELETE SET NULL ON UPDATE CASCADE -- ERROR 1146 at line 24: Table 'mysql.proc' doesn't exist Bye I:\mysql\data\mysqldir Volume in drive I is Application program files Volume Serial Number is 906C-357F Directory of I:\mysql\data\mysql 08/01/2004 19:01 DIR . 08/01/2004 19:01 DIR .. 22/12/2003 21:038,820 columns_priv.frm 22/12/2003 21:030 columns_priv.MYD 22/12/2003 21:031,024 columns_priv.MYI 22/12/2003 21:039,178 db.frm 22/12/2003 21:03 306 db.MYD 22/12/2003 21:033,072 db.MYI 22/12/2003 21:038,665 func.frm 22/12/2003 21:030 func.MYD 22/12/2003 21:031,024 func.MYI 22/12/2003 21:039,148 host.frm 22/12/2003 21:030 host.MYD 22/12/2003 21:031,024 host.MYI 22/12/2003 21:038,925 tables_priv.frm 22/12/2003 21:030 tables_priv.MYD 22/12/2003 21:031,024 tables_priv.MYI 22/12/2003 21:039,992 user.frm 22/12/2003 21:03 160 user.MYD 22/12/2003 21:032,048 user.MYI 18 File(s) 64,410 bytes 2 Dir(s) 3,870,883,840 bytes free The same 18 files, nothing could have prevented the missing files to be correctly written. first installation was typical, second installation was custom with all checkboxes, in fact even during the typical installation it was impossible to uncheck two of the options, one of the mandatory options was something with grant tables. It is ok for me to know that this problem is not known under win XP, What about Linux
Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
At 20:02 8/1/2004 +0100, Morten Gulbrandsen wrote: hi, Well I will test that on my win2k server machine is now down running instead Suse 9.0. Anyway you have the option for to download the package without installer, then is just an issue to unzip the files in the right place. You should this option package in our web site in the same place of one you have already downloaded one line below. -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.556 / Virus Database: 348 - Release Date: 26/12/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
Miguel Angel Solórzano Well I will test that on my win2k server machine is now down running instead Suse 9.0. Morten Gulbrandsen Thanks, If I know that it runs satisfactorily under suse, I'm satisfied, I have suse 8.2, but I can go for suse 9.0 If necessary. Miguel Angel Solórzano Anyway you have the option for to download the package without installer, then is just an issue to unzip the files in the right place. You should this option package in our web site in the same place of one you have already downloaded one line below. Morten Gulbrandsen This could be the reason, I saw the package without installer, I'll go for it, I understand the distributions with and without installer are not quite the same, Did you use the win distribution without the installer ? Anyway it is an alpha version and I'd like to test the features I need. Previously the linux version was slightly ahead of the same windows version. So I believe that you primarily target the linux users. Yours Sincerely Morten Gulbrandsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
MySQL 5.0.0-alpha-max-nt under win2k a small problem: If I have a foreign key with reference to the same table, I get an error, ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist what can I do ? Yours Sincerely Morten Gulbrandsen USE test; DROP TABLE IF EXISTS A; CREATE TABLE A ( SSN CHAR(9) NOT NULL, SUPERSSN CHAR(9), DNOINT NOT NULL DEFAULT 1, PRIMARY KEY (SSN), INDEX (SUPERSSN), INDEX (DNO) )TYPE = INNODB; DESCRIBE A; ALTER TABLE A # line 42 here is the buggy code ADD FOREIGN KEY (SUPERSSN) REFERENCES A(SSN) ON DELETE SET NULL ON UPDATE CASCADE; #ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist mysql select version(); ++ | version() | ++ | 5.0.0-alpha-max-nt | ++ 1 row in set (0.00 sec) Microsoft Windows 2000 [Version 5.00.2195] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
At 05:26 8/1/2004 +0100, Morten Gulbrandsen wrote: Hi, I wasn't able to repeat: Microsoft Windows XP [versão 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. c:\cd\mysql\bin C:\mysql\binmysql -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.0.0-alpha-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql CREATE TABLE A ( - SSN CHAR(9) NOT NULL, - SUPERSSN CHAR(9), - DNO INT NOT NULL DEFAULT 1, - PRIMARY KEY (SSN), - INDEX (SUPERSSN), - INDEX (DNO) - )TYPE = INNODB; Query OK, 0 rows affected, 1 warning (0.11 sec) mysql DESCRIBE A; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | SSN | char(9) | | PRI | | | | SUPERSSN | char(9) | YES | MUL | NULL| | | DNO | int(11) | | MUL | 1 | | +--+-+--+-+-+---+ 3 rows in set (0.00 sec) mysql ALTER TABLE A - ADD FOREIGN KEY (SUPERSSN) REFERENCES A(SSN) - ON DELETE SET NULL - ON UPDATE CASCADE; Query OK, 0 rows affected (0.27 sec) Records: 0 Duplicates: 0 Warnings: 0 Please verify if your MySQL stuff has all the below files: C:\mysql\bindir c:\mysql\data\mysql O volume na unidade C é Disk 1 Partition 1 O número de série do volume é - Pasta de c:\mysql\data\mysql 07/01/2004 11:39DIR . 07/01/2004 11:39DIR .. 22/12/2003 21:03 8.820 columns_priv.frm 22/12/2003 21:03 0 columns_priv.MYD 22/12/2003 21:03 1.024 columns_priv.MYI 22/12/2003 21:03 9.178 db.frm 22/12/2003 21:03 306 db.MYD 22/12/2003 21:03 3.072 db.MYI 22/12/2003 21:03 8.665 func.frm 22/12/2003 21:03 0 func.MYD 22/12/2003 21:03 1.024 func.MYI 22/12/2003 21:03 8.700 help_category.frm 22/12/2003 21:0320 help_category.MYD 22/12/2003 21:03 3.072 help_category.MYI 22/12/2003 21:03 8.612 help_keyword.frm 22/12/2003 21:03 0 help_keyword.MYD 22/12/2003 21:03 1.024 help_keyword.MYI 22/12/2003 21:03 8.630 help_relation.frm 22/12/2003 21:03 0 help_relation.MYD 22/12/2003 21:03 1.024 help_relation.MYI 22/12/2003 21:03 8.770 help_topic.frm 22/12/2003 21:03 0 help_topic.MYD 22/12/2003 21:03 1.024 help_topic.MYI 22/12/2003 21:03 9.148 host.frm 22/12/2003 21:03 0 host.MYD 22/12/2003 21:03 1.024 host.MYI 22/12/2003 21:03 9.470 proc.frm 07/01/2004 13:33 156 proc.MYD 07/01/2004 13:33 2.048 proc.MYI 22/12/2003 21:03 8.925 tables_priv.frm 22/12/2003 21:03 0 tables_priv.MYD 22/12/2003 21:03 1.024 tables_priv.MYI 22/12/2003 21:03 9.992 user.frm 22/12/2003 21:03 160 user.MYD 22/12/2003 21:03 2.048 user.MYI 33 arquivo(s)116.960 bytes MySQL 5.0.0-alpha-max-nt under win2k a small problem: If I have a foreign key with reference to the same table, I get an error, ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist what can I do ? Yours Sincerely Morten Gulbrandsen USE test; DROP TABLE IF EXISTS A; CREATE TABLE A ( SSN CHAR(9) NOT NULL, SUPERSSN CHAR(9), DNOINT NOT NULL DEFAULT 1, PRIMARY KEY (SSN), INDEX (SUPERSSN), INDEX (DNO) )TYPE = INNODB; DESCRIBE A; ALTER TABLE A # line 42 here is the buggy code ADD FOREIGN KEY (SUPERSSN) REFERENCES A(SSN) ON DELETE SET NULL ON UPDATE CASCADE; #ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist mysql select version(); ++ | version() | ++ | 5.0.0-alpha-max-nt | ++ 1 row in set (0.00 sec) Microsoft Windows 2000 [Version 5.00.2195] -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.556 / Virus Database: 348 - Release Date: 26/12/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 1146
hi list, trying to do my first steps with mysql, i have done the following : mysql USE mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql INSERT INTO mysql VALUES(localhost, sample_db, 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); ERROR 1146: Table 'mysql.mysql' doesn't exist hmm - what I have done wrong here ? or do I have to do something before ? these steps are a piece of description in a mysql-book mysql in 21 days and thanks for helping bye hans - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1146
hans schneidhofer wrote: hi list, trying to do my first steps with mysql, i have done the following : mysql USE mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql INSERT INTO mysql VALUES(localhost, sample_db, 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); ERROR 1146: Table 'mysql.mysql' doesn't exist With 'use' you're changing *databases*. You need to create a *table* to insert data (see 'CREATE TABLE...'). Max - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: ERROR 1146
hans, Sunday, September 22, 2002, 3:48:33 PM, you wrote: hs trying to do my first steps with mysql, i have done the following : hs mysql USE mysql; hs Reading table information for completion of table and column names hs You can turn off this feature to get a quicker startup with -A hs Database changed hs mysql INSERT INTO mysql VALUES(localhost, sample_db, hs 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); hs ERROR 1146: Table 'mysql.mysql' doesn't exist hs hmm - what I have done wrong here ? or do I have to do something before hs ? There is no table 'mysql' in the database 'mysql': http://www.mysql.com/doc/en/Privileges.html BTW: GRANT is more recommended to use: http://www.mysql.com/doc/en/GRANT.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 1146
hi list, trying to do my first steps with mysql, i have done the following : mysql USE mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql INSERT INTO mysql VALUES(localhost, sample_db, 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); ERROR 1146: Table 'mysql.mysql' doesn't exist hmm - what I have done wrong here ? or do I have to do something before ? these steps are a piece of description in a mysql-book mysql in 21 days and thanks for helping bye hans - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 1146: Table 'test.test' doesn't exist - Why is mysql adding a postfix to my USE request?
Why is mysql adding a postfix to my USE request? I know that test.test doesn't exist, i don't want it to, i'm not asking for anything.anything why will it append this suffix to my request? mysql show databases; +--+ | Database | +--+ | mysql| | test | +--+ 2 rows in set (0.00 sec) mysql use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql select * from test; ERROR 1146: Table 'test.test' doesn't exist mysql use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql select * from mysql - ; ERROR 1146: Table 'mysql.mysql' doesn't exist The database directories do exist and are populated: /var/lib/mysql/mysql /var/lib/mysql/test I have searched the mysql site for a listing for error 1146 with no luck, probably an oversight on my part but any insight is appreciated. -david - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1146: Table 'test.test' doesn't exist - Why is mysql adding a postfix to my USE request?
What are you trying to do here? MySQL is giving this error because the table 'test' does not exist in the 'test' database. Are you mistaking database for tables? I think perhaps you need to take a look more carefully at the manual about creating tables. Mike - Original Message - From: david [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 10, 2002 8:42 PM Subject: ERROR 1146: Table 'test.test' doesn't exist - Why is mysql adding a postfix to my USE request? Why is mysql adding a postfix to my USE request? I know that test.test doesn't exist, i don't want it to, i'm not asking for anything.anything why will it append this suffix to my request? mysql show databases; +--+ | Database | +--+ | mysql| | test | +--+ 2 rows in set (0.00 sec) mysql use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql select * from test; ERROR 1146: Table 'test.test' doesn't exist mysql use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql select * from mysql - ; ERROR 1146: Table 'mysql.mysql' doesn't exist The database directories do exist and are populated: /var/lib/mysql/mysql /var/lib/mysql/test I have searched the mysql site for a listing for error 1146 with no luck, probably an oversight on my part but any insight is appreciated. -david - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ERROR 1146: Table 'test.test' doesn't exist - Why is mysql adding a postfix to my USE request?
From: david [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 10, 2002 1:42 PM Subject: ERROR 1146: Table 'test.test' doesn't exist - Why is mysql adding a postfix to my USE request? Why is mysql adding a postfix to my USE request? I know that test.test doesn't exist, i don't want it to, i'm not asking for anything.anything why will it append this suffix to my request? Mysql is using the full syntax for accessing a table, which is database.table. So for the database xx , accessing the table yy, it would be xx.yy. From the commands used below, the reason you're getting an error is probably because you really don't have a table called 'test' in the 'test' database. As you note, you have the database directory for both test and mySQL, but I'd bet you don't have a table file called 'test' under the 'test' directory. Essentially you're trying to select from a non existent table, and mySQL is showing you how it's interpreted the table you wanted from your SQL query, in this case test.test. mysql show databases; +--+ | Database | +--+ | mysql| | test | +--+ 2 rows in set (0.00 sec) mysql use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql select * from test; ERROR 1146: Table 'test.test' doesn't exist mysql use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql select * from mysql - ; ERROR 1146: Table 'mysql.mysql' doesn't exist The database directories do exist and are populated: /var/lib/mysql/mysql /var/lib/mysql/test - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php