mysqldump fails when using --lock-tables with thousands of tables

2002-01-01 Thread anders
Description: When dumping a database with mysqldump using the --opt parameters, certain databases fail being dumped: /usr/bin/mysqldump: Got error: 1017: Can't find file: './db33862090/CKNPRJ.frm' (errno: 24) when using LOCK TABLES By replacing --opt with

how can i check if table user1 exist in c ??

2002-01-01 Thread Barak Dotan
Hi. i tried (without any success to check if the table user1 was allready created in the SQL database. can you please send me a function (or a little code in c) that check this issue thanx allot Dotan Barak Tel: +972-(0)4-8321303 Email : [EMAIL PROTECTED]

Re: Multiples instances of MySQL

2002-01-01 Thread Heikki Tuuri
Hi! Ok, the appropriate parameter mysqld --defaults-file=your_path_to_my_cnf already exists with which you can explicitly specify what my.cnf file mysqld reads in. Regards, Heikki Date: Sun, 30 Dec 2001 23:23:18 To: [EMAIL PROTECTED] From: Heikki Tuuri [EMAIL PROTECTED] Subject: Re:

Re: how can i check if table user1 exist in c ??

2002-01-01 Thread Martijn Bakker
On Tue, Jan 01, 2002 at 04:49:29PM +0200, Barak Dotan wrote: Hi. hey! i tried (without any success to check if the table user1 was allready created in the SQL database. you can do a show tables query, and see if table user1 is one of the results. grtz, Tijn -- 4:25PM up 104 days,

Re: Perl problem

2002-01-01 Thread Durga_Prasad
The $dbh connect code should be like this: $dbh=DBI-connect(DBI:mysql:datrtabase=radio';host=localhost,root,password, {RaiseError=1}); If there is an error, you can catch it using, die statement. Placed At : John Mayson [EMAIL PROTECTED] on

Re: Execute Error

2002-01-01 Thread Durga_Prasad
You are executing, $dbobj the database object. You should execute the statement handle. The code should be: $query = SELECT UserID,Name FROM test; $sdb = $dbobj-prepare($query); $sdb-execute(); Placed At : Clinton Hesse [EMAIL PROTECTED] on

Re: unable call database

2002-01-01 Thread David J Jackson
Here's what I use it should tell you exactly what your problem is: Also check out tutorial on http://www.porlmonks.org. -- David Jackson use DBI; use diagnostics; use strict; my ($dbh,$sth); my ($dbname)=dataase_name; my ($login)=login_name; my ($password) =your_pasword; my (@ary); # $dbh =

Re: (WOT) Re: Perl problem

2002-01-01 Thread David J Jackson
Here's what I use: use DBI; use diagnostics; use strict; my ($dbh,$sth); my ($dbname)=pickle; my ($login)=picklesql; my ($password) =pi56fb; my (@ary); # $dbh = DBI-connect(DBI:mysql:$dbname,$login,$password) or die Can't connect to $dbh: $dbh-errstr\n; $sth = $dbh-prepare(SELECT * FROM

Re: Perl problem

2002-01-01 Thread David J Jackson
Here's what I use (a little different): use DBI; use diagnostics; use strict; my ($dbh,$sth); my ($dbname)=pickle; my ($login)=picklesql; my ($password) =pi56fb; my (@ary); # $dbh = DBI-connect(DBI:mysql:$dbname,$login,$password) or die Can't connect to $dbh: $dbh-errstr\n; $sth =

List BUG? Unsuscribe info appaears in replies

2002-01-01 Thread David J Jackson
database,mysql,sql ALL -- For reason unknown I seeing the unsubscribe information, for any email I read or reply, here's what I'm talking about: NOTE: I don't have this problem on the other list I subscribe to? Thanks, David Before posting, please check: http://www.mysql.com/manual.php

Append queries

2002-01-01 Thread David J Jackson
Is there a why to append a feild in mysql as apposed to updating? For event log table for a datacenter. Or is this something that would be better handled at the script level? Thanks David - Before posting, please check:

Feature (Was: Re: List BUG? Unsuscribe info appaears in replies)

2002-01-01 Thread Van
David J Jackson wrote: database,mysql,sql ALL -- For reason unknown I seeing the unsubscribe information, for any email I read or reply, here's what I'm talking about: NOTE: I don't have this problem on the other list I subscribe to? Thanks, David David: This behavior is by

Re: A bug somewhere in the list manager

2002-01-01 Thread David Yahoo
Hello I receive message from : the 31/12/2002 and then from the 01/01/2003 and now seems to works from the 01/01/2002. ? sql - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Equivalent Query in MySQL

2002-01-01 Thread Mr. psm996
Would anyone know how the query below could be written to support MySQL? my $stmt = qq{select distinct p.symbol, i.name from portfolio p, stockinfo i where p.symbol = i.symbol }; $stmt .= qq{and p.symbol in (select distinct symbol from portfolio where $res)

mysql start

2002-01-01 Thread richard.odic
Hi folks, I am still new in the mysql world. I have just installed mysql but it when I try to start it (/usr/local/mysql/bin/safe_mysql ) I get the following error massages in the linux.err file: 020101 19:51:58 mysqld started ^G/usr/local/mysql/libexec/mysqld: File './linux-bin.1' not found

Re: mysql start

2002-01-01 Thread David J Jackson
Richard -- Did you set the --prefix=/usr/local/mysql when you ran config? If not Your bin are located in /usr/local/bin maybe /usr/local/sbin? The start script is saying the either the programs not ther or you have a permissions problem? Did you create user and group mysql, Install as above

Mysql reconnect hang

2002-01-01 Thread Peter Zaitsev
Hello mysql, I've found the following problem often happens to me: Then mysqld restarted unclear (sigsegv or server reset) the mysql client library may hang during the automatic reconnect. The backtrace is similar to this and does not changes other time (at least 2 hours is not enough for it)

Re: where

2002-01-01 Thread David J Jackson
Julian -- There is the generic WHERE keyords ='%string%', but more to the point here the link to the docs for regrex goodies: http://www.mysql.com/doc/manual.php?search_query=regular+expressionsubmit=S earchdepth=0 David Hi, I have recently gained access to mysql (new isp), and am

Re: Equivalent Query in MySQL

2002-01-01 Thread David J Jackson
psm 996 -- The real question is: Does MySQL support sub query, the short answer is 3.x.x does not, 4.x.x is supposed to. The longer answer(and work arounds) to the 3.x.x question can be found here: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html David

Re: How can run Mysql program from different user (NOT only root) ?

2002-01-01 Thread Jaime Teng
Hi, Wasnt MySQL supposed to run as SU or ROOT or Administrator and then create users within MySQL with restrictions? What you trying to do was give RUN MySQL rights to your unix users. What if 3 unix users tried running mysql independently of each other and each mySQL process were trying to

Q: Stored Procedures

2002-01-01 Thread Dennis Salguero
My question pertains to the implementation of stored procedures in MySQL. According to the MySQL documentation, this is scheduled for the 4.1 release. Is this still accurate? When will we be seeing the first downloads of 4.1 available? Thanks, Dennis

Do not understand a method without sub-selects

2002-01-01 Thread PPSlim
I have one single table, logging site activity as a security precaution. I want to generate a report, including items of a certain type, but only if a seperate type has not taken place after the timestamp within the first type. log_data_sig

New Comer

2002-01-01 Thread Ardian
Dear All, I'm new comer, I want to ask about Installation MySQL for Windows Family. Thanks Ardian __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com

question on selects in multiple tables

2002-01-01 Thread Cindy
OK... let's say I have two tables. Let's say one is an inventory table, a bunch of items. One of the fields is for the inventory items that have been sold, and are keys to the second table, which is a list of customers; names addresses. So let's say I want to pull out all inventory items

Re: How can run Mysql program from different user (NOT only root) ?

2002-01-01 Thread Kevin Chan
Hi Jaime and all, Thanks Jaime to reply me message so fast ! I would like to set 2 different user to maintance MySQL machine. 1st user can maintance the Unix box and MYSQL program 2nd user ONLY can maintance the MySQL program That's why I need to set another user to run MySQL program ( Now

Re: New Comer

2002-01-01 Thread Sundara Pandian
v.v.simple download the window binary of version of mysql(latest) and go next,next,next..:-) only thing if install on anywhere else other than C:\mysql you'll have to place a file called my.cnf in you C:\ directory, there'll be a line there asking you to pint to the installation directory.

Re: question on selects in multiple tables

2002-01-01 Thread Oliver Heinisch
At 01.01.2002 23:12, you wrote: OK... let's say I have two tables. Let's say one is an inventory table, a bunch of items. One of the fields is for the inventory items that have been sold, and are keys to the second table, which is a list of customers; names addresses. So let's say I want to