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
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]
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:
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,
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
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
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 =
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
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 =
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
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:
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
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)
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)
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
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
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)
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
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
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
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
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
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
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
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
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.
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
27 matches
Mail list logo