Re: Table doesn't exist from stored function

2007-03-11 Thread Peter Brawley
Imre, You may have found a stored function bug--the server tries to evaluate the SELECT statement within the IF block when IF condition is false. PB - Shawn Green wrote: Hello Imre, Imre Palik wrote: Hi, When I try to run this function, I receive ERROR 1146 (42S02): Table 'gi2.meta'

Re: Table doesn't exist from stored function

2007-03-11 Thread Shawn Green
Hello Imre, Imre Palik wrote: Hi, When I try to run this function, I receive ERROR 1146 (42S02): Table 'gi2.meta' doesn't exist CREATE FUNCTION get_version() RETURNS INT UNSIGNED BEGIN DECLARE exist_ TINYINT; SELECT COUNT(*) INTO exist_ FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA =

RE: Table doesn't exist?

2006-03-28 Thread Sara Woglom
006 4:24 AM To: Sara Woglom Cc: mysql@lists.mysql.com Subject: Re: Table doesn't exist? Hi, Better suggestion is you would have backed your ibdata1 and alo the log file because that is the data files which contains your precouse data. If you have your backup try to import the l

RE: Table doesn't exist?

2006-03-27 Thread Sara Woglom
I can't run the chown command. I'm on a Windows 2003 Server machine. -Original Message- From: Ing. Edwin Cruz [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 3:01 PM To: 'Sara Woglom' Subject: RE: Table doesn't exist? Are the permissions corect

RE: Table doesn't exist?

2006-03-27 Thread Ing. Edwin Cruz
Are the permissions corectly to that file??? Chown mysql:mysql /mysql/data/dbname/tablename.* -Mensaje original- De: Sara Woglom [mailto:[EMAIL PROTECTED] Enviado el: Lunes, 27 de Marzo de 2006 01:47 p.m. Para: mysql@lists.mysql.com Asunto: Table doesn't exist? I had to shut down m

Re: Table doesn't exist on query replication problem...

2004-10-06 Thread Bismarck Rojas
Hello, I suggest to you have the same version of mysql in both servers. regards El Miércoles, 6 de Octubre de 2004 13:07, Bill Thomason escribió: > Hi, > > I have a mysql 4.0.21 master and a 4.0.18 slave. > > I am trying to maintain a replication of a DB named masterdb. > > My goal is to have