OK, the scenario I've got is that I'm using MySQL 4.1, and Python (using
mysql-python to access the server).
I have a script like the following:
conn = MySQLdb.connect() # Basic parameters
cursor = conn.cursor()
cursor.execute("SET AUTOCOMMIT=0")
cursor.execute("BEGIN")
for i i
OK, first off, this website is kinda infuriating. Why can't I click on
the message thread on the web, and reply that way? I'm not even sure
this message will reach it's recipients. .
Anyhow, I was just reading on
http://www.mysql.com/doc/en/Server_system_variables.html, there's a
variable called '
mysql doesn't write any files to any directory other than its data
directory, so try:
SELECT * INTO OUTFILE 'Results.txt' FROM Answer;
and then copy it whereever you want.
HTH
Nitin
- Original Message -
From: "Rick Duley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Geoff Roy" <[E
Hello Rmck,
If your mysql uses openssl static libraries, then you must rebuild your
mysql with new openssl libraries. If mysql uses dynamic openssl libraries
then no need to rebuild your mysql.
Use "ldd" command to your mysql binaries to check the openssl library
type. If it uses dynamic
Dear All;
At oracle8i i can write this sql:
select decode(a.id,null,'NULL',2,"God',3,'Norma','Animal') from user
Then i want know ,how to write this at mysql4.1
Thanks
Hi folks
I am running MySQL 4..0.7-gamma on Red Hat Linux 7.2.
I wish to download data from my database.
I have a directory called 'Results' with permissions set to: drwxrwxrwx
I enter the command:
SELECT * INTO OUTFILE '/home/rick/Results/Results.txt' FROM Answer;
and I get:
ERROR
Hi all,
I am working on a project that uses Mysql.
My task is to provide a fault taulerant platform for it.
I would like some help to optimize the two ends of this platform.
There are few things that need to be solved.
High Availibility
Load sharing.
For HA, we are using a SAN disk to store th
Hello,
I have a redhat system that is running mysql with openssl for secure connections.
There was just a rpm update from redhat for openssl. I applied that and mysql/openssl
connections seem fine.
But my question is do I need to recomplie mysql to use the latest openssl
This was a custom
Sami Maisniemi <[EMAIL PROTECTED]> writes:
>> mysql> use mysql
>> mysql> select User,Host,Password,Select_priv from user;
>>
>> which will show basic access capabilities for user/host/password
>
>Hmmm ... did not work as you can see:
>
>mysql> select User,Host,Password,Select_priv from user;
>ERROR
>> tcp0 0 *:3307 *:* LISTEN
>
>It seems that the correct socket is used. Here is the output:
>
>unix 2 [ ACC ] STREAM LISTENING 3303 private/relay
>unix 2 [ ACC ] STREAM LISTENING 3307 public/showq
Looks
I have a problem with mysql/innodb, hopefully someone
here can offer a nice pointer.
our innodb databases got wiped out (oops), and the problem
is the .frm files dont seem to match the structure needed,
we tried working around that in the docs online, but now
we get this message:
InnoDB: Error: t
I have a problem with mysql/innodb, hopefully someone
here can offer a nice pointer.
our innodb databases got wiped out (oops), and the problem
is the .frm files dont seem to match the structure needed,
we tried working around that in the docs online, but now
we get this message:
InnoDB: Error: t
I compiles a C application which uses mysql library on two RedHat 9.0 machines.
Both machines are using the same GCC and the same MySQL 4.0.16 :
MySQL-client-4.0.16-0
MySQL-server-4.0.16-0
MySQL-devel-4.0.16-0
MySQL-shared-compat-4.0.16-0
gcc-3.2.2-5
gcc-c++-3.2.2-5
libgcc-3.2.2-5
In the MACHINE
Hello--
We're using Red Hat's cluster manager (RH AS 2.1, MySQL 4.0.16 RPM). Due
to a problem within the cluster software that we're working on with Red
Hat, the cluster fails over from one node to the other sometimes when it
shouldn't (one node will reboot, services will fail over-- at this poin
I am attempting to interface between a simple C program and MySQL client library, but
without luck.
I searched the MySQLforum archives to see if there was info specific to this problem.
While there
were other folks who had problems connecting C/C++ to MySQL, none of the issue were
similar to t
On Monday 22 March 2004 22:43, [EMAIL PROTECTED] wrote:
> >specify how to check the socket, please?
>
> Based on your ps information, the socket will likely be in the
> /usr/local/mysql/data/my.cnf file under the [mysqld] area. Another way
> to tell if there is a socket open for the server would b
As of now, there is no MySQL equivalent to PL/SQL.
On Mon, 22 Mar 2004, Seena Blace wrote:
>
> Hi,
> i want to update couple of columns like
> update tablename
> set =
> where columname=;
> I want to run query on mysql prompt each time and enter value1 and
> value2 for diffrent columnname ?
> Va
Hi,
i want to update couple of columns like
update tablename
set =
where columname=;
I want to run query on mysql prompt each time and enter value1 and value2 for diffrent
columnname ?
Value1 and value2 will be diffrent.
in oracle we use & to prompt value.
thx
Do you Yahoo!?
Yahoo! Finance Tax C
I think you need the DISTINCT operator.
Assuming you haven't seen it, it works like this. Let's say that your query
asks for a list of all the job titles in your employee table, where the job
title is one of the columns of that table. The employee table looks like
this:
EMPNO NAME JOB
1
Sami Maisniemi writes:
>I think I am using root access, but should I create another user name for
>MySQL? On the command line, I start MySQL by typing just 'MySQL'. How can I
>view the user?
from the mysql program:
mysql> use mysql
mysql> select User,Host,Password,Select_priv from user;
which
This error should be logged. Do you have a file called .err in your
directory?
On Mon, 22 Mar 2004, Daniel Gaddis wrote:
> I copied the following from my coldfusion application.log
>
> "Error","2152","03/20/04","09:03:13",,"ODBC Error Code = S1000 (General
> error) [MySQL][ODBC 3.51 Driver][mysq
At 14:33 -0600 3/22/04, Daniel Gaddis wrote:
I copied the following from my coldfusion application.log
"Error","2152","03/20/04","09:03:13",,"ODBC Error Code = S1000 (General
error) [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-max-nt-log]Incorrect
key file for table: 'referenceEntries'. Try to repair i
>It seems that mysqld is up and running (view the results below), but could
you
>specify how to check the socket, please?
Based on your ps information, the socket will likely be in the
/usr/local/mysql/data/my.cnf file under the [mysqld] area. Another way
to tell if there is a socket open for th
I copied the following from my coldfusion application.log
"Error","2152","03/20/04","09:03:13",,"ODBC Error Code = S1000 (General
error) [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-max-nt-log]Incorrect
key file for table: 'referenceEntries'. Try to repair it SQL =
""UPDATE referenceEntries
In the last episode (Mar 22), Chris Elsworth said:
> Ah, well these tables do need to be queryable and thus live; I only
> ask about packing because it'll save space and (apparently) make them
> faster; I've never actually played with packing MyISAM tables before.
>
> Happen to know if MySQL will
The master pushes data to the slave as soon as it has executed the query
itself. It is not a periodic push, but an asyncrounous push as soon as
data is ready to be sent. So the gap would only be as great as the
latency between your two servers.
If the servers are disconnected or unable to commun
At 01:30 AM 3/20/2004, you wrote:
> insert into table (username, password) values ('username', 'password')
>
> Skip out the "username=" and "password=" part. What you are ending up
> doing here is that the values portion of the insert statement, these two
You may kick my ass... Royally.
Sorry, I
Do a mysqldump -d on both machines to make sure the schema, and the
indexes in particular, are exactly the same. Run "analyze table" on
all tables. Make sure the MySQL conf files (e.g., /etc/my.cnf) are
the same. Do an 'explain ' on both machines; the output should
be the same.
4.0.1 isn't the
I'm a newbie but thought I'd try my hand and offer an extremely
inefficient query that seemed to work ...
select * from
word join
word as tw join
word as tm
where concat(word.wd, tw.wd, tm.wd) not like '%male%female%' and
concat(word.wd, tw.wd, tm.wd) not like '%female%male%'
At 22:00 22-03-2004 +0200, Sami Maisniemi wrote:
> Did you provide access to the databases as root? Is there a password
> associated with access? For instance, how do you statr mysql from the
> command line: mysql -u root -ppassword mydatabase
I think I am using root access, but should I create
Thanks a lot, Jigal and Egor - just what i searched for!
Sincerely
Victor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> Did you provide access to the databases as root? Is there a password
> associated with access? For instance, how do you statr mysql from the
> command line: mysql -u root -ppassword mydatabase
I think I am using root access, but should I create another user name for
MySQL? On the command lin
On Monday 22 March 2004 21:45, [EMAIL PROTECTED] wrote:
> This error could result from a number of possible problems. First off I
> would check to make sure the mysqld is running and attaching to the default
> socket (3306). If you have it set up otherwise, you will likely need the
> connect to c
On Monday 22 March 2004 20:36, [EMAIL PROTECTED] wrote:
> This means that your server is not up, most likely. Can you connect from
> the command line? try running
> ps -efc | grep mys
>
> do you see an entry for mysqld?
It seems that the server is up and running, because I am able to see mu
>I finally managed to install MySQL succesfully. I created a simple DB with
two
>different tables. I also created a simple PHP script to list all DBs and
>tables.
>
>However, it seems that the PHP script cannot access MySQL server, because the
>following error message is displayed:
>
>Warning: m
On Mon, Mar 22, 2004 at 01:40:29PM -0600, Dan Nelson wrote:
> In the last episode (Mar 22), Chris Elsworth said:
> > Now that's all well and good and I'm fairly sure it'll all work, but
> > another interesting idea I was wondering over was - can I myisampack
> > the tables that I know won't be upda
In the last episode (Mar 22), Chris Elsworth said:
> Now that's all well and good and I'm fairly sure it'll all work, but
> another interesting idea I was wondering over was - can I myisampack
> the tables that I know won't be updated anymore, and still MERGE
> them, with other unpacked-tables?
It
Hello,
Just a quick question to see if anyone's tried this and run into any
problems, or if it'll even work - I have a *huge* table that's just
crashed thanks to FreeBSD panicking, and the repair operation I'm
estimating is going to be another 4 hours :(
But anyway, I'm pondering over splitting t
I got MySQL replication working in master-slave configuration. It's
really cool, but how often does the master send binlog dump to the
slave. The implication is if the master crashes, what would be the
potential data gap in the slave??
--
MySQL General Mailing List
For list archives: http://
>I am trying to get a single result from a database, which works fine at
>the sql command line. I have tried several versions of code, this being
>the most recent -
...
>No matter what I do I do not get the desired max id number from the column
>WarrantyID. The same query works fine at the sql c
Thanks for the tip. Got it working.
--
Chip
"Rick Emery" <[EMAIL PROTECTED]> wrote on 03/22/2004 09:50:59 AM:
> What result are you getting?
>
> First off, I see that your HTML is possibly incorrect; should it be:
> echo "Warranty ID:\n";
>
> is a table header.
>
> Second, if you are expectin
Yeah, I want to avoid code if possible, some ideas was marking
adjectives with a class tag, and doing a group by class so only one item
in any given class would appera
e.g. good and evil would have the same class or male and female would
have the same class.
this, however, requires me to enter
I finally managed to install MySQL succesfully. I created a simple DB with
two
different tables. I also created a simple PHP script to list all DBs and
tables.
However, it seems that the PHP script cannot access MySQL server, because
the
following error message is displayed:
_
This
/var/lib/mysql/mysql.sock is created when the mysql server starts. It disappears when
mysql shuts
down.
Did you provide access to the databases as root? Is there a password associated with
access? For
instance, how do you statr mysql from the command line: mysql -u root -ppassword
mydatabas
I finally managed to install MySQL succesfully. I created a simple DB with two
different tables. I also created a simple PHP script to list all DBs and
tables.
However, it seems that the PHP script cannot access MySQL server, because the
following error message is displayed:
Warning: mysql_con
Some users' code is causing MySQL's memory use to explode. By the time
we reach about 200 simultaneous connections, the MySQL server is using
8GB of virtual memory, and then falls over (the machine is an
AlphaServer ES45 with 8 GB of physical memory, and 16 GB of swap,
although processes are c
To select random values you could use:
SELECT word FROM table ORDER BY rand() LIMIT 3
But the problem of not to select male and female together...
Well, you could LIMIT your query to 4 and in your code, if one entry is one of male
or female, you test the others not to be female or male (respec
Hi,
Assuming that you are connecting to the mysql server with success, try just changing
your query to:
$sql = "select max(WarrantyID) as WarrantyID from warrantycopy";
Hope this helps,
Diana Soares
-Original Message-
From: Chip Wiegand [mailto:[EMAIL PROTECTED]
Sent: Mon 3/22/200
I have a MySQL table with a Date column in format \"-MM-DD\" and I\'m trying to
figure out a query that would return a list of months that have an entry in the above
table. With output like:
Mar-01, Feb-01, Apr-01 etc...
I\'m still pretty new to MySQL and the date functions are still a bit
Shortly after the MySQL 4.0 line went to production, I upgraded to mysql
4.0.12. Since then my slave has been getting corrupted tables 2 to 3 times
every month. I've also seen this problem in mysql 4.0.13. When I run a
check table on the table in question it gives the following results:
+-
What result are you getting?
First off, I see that your HTML is possibly incorrect; should it be:
echo "Warranty ID:\n";
is a table header.
Second, if you are expecting a single result row, then you do not need the while()
loop. Do a
single fetch and display the result.
rick
"People will for
I am trying to get a single result from a database, which works fine at
the sql command line. I have tried several versions of code, this being
the most recent -
\n";
echo "Warranty ID:\n";
echo "$WarrantyID\n";
echo "\n";
}
?>
No matter what I do I do not get the desired max id number from the c
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Eric B. wrote:
> Hi,
>
> I'm running into a strange problem with my JVM and MySQL. I'm using
> Macromedia JRun 4 as my JVM and everytime I restart the Jrun service, my
> application runs smoothly. However, after an indeterminate amount of time
> (se
I have a table of adjectives:
++
| word |
++
| green |
| ugly |
| dark |
| evil |
| female |
| male |
| drunk |
++
and I want to select three of them randomly, but I don't want female and
male to accidentally appear together (since they are opposites).
I can't
Hi!
On Mar 21, Lorderon wrote:
> Hi,
>
> I also found that when you use JOIN with full-text, MySQL don't
> automatically sort the results by the coefficient of the full-text... when
> you use list of tables seperated by comma MySQL sorts it correctly...
What does EXPLAIN say in each case ?
Reg
[EMAIL PROTECTED] wrote:
>
> I want to CREATE a TABLE an specify a collation.
>
> If I do
> CREATE TABLE ... DEFAULT CHARACTER SET latin1 COLLATE latin1_german1_ci;
> SHOW TABLE STATUS shows me Collation: latin1_swedish_ci
> If I omit the keyword DEFAULT the requested collation latin1_german1_ci
Hi,
Is it possible to move the folder "data" where there are all databases to
another hard driver and then create a virtual link using "ln -s"? If yes,
is it just shutdown the MySQL server and then move the folder, create the
link and finally start up the server?
Thanks!
Andre
--
Andre Mato
-- Weitergeleitete Nachricht --
Subject: Re: Another Performance query
Date: Mon, 22 Mar 2004 16:13:29 +0100
From: Stefan Kuhn <[EMAIL PROTECTED]>
To: A Z <[EMAIL PROTECTED]>
Indices can never be used with like "%x" (but with like "x%). This question
won't use indeces, neither
here we go:
explain select * from properties where reference like
'%2332'
+-+
Table ¦ type ¦ possible keys ¦ key ¦ key_len ¦ ref ¦
rows ¦ Extra
+-+
Properties ¦ All ¦ NULL ¦ NULL ¦ NULL ¦ NULL ¦
I think you need to be using:
select * from clients_tb where active='on' AND first_name LIKE '%ja%' OR
middle_name LIKE '%ja%' OR last_name LIKE '%ja%'";
Your query is looking for names where the first, middle and last name
all have 'ja' in them. If you're looking for names where -any- of them
c
Hi,
I am running this (simple?) query on mysql 3.23 :
select * from clients_tb where active='on' AND first_name LIKE '%ja%' AND middle_name
LIKE '%ja%' AND last_name LIKE '%ja%'";
I know there are people in the table with:
first name James
last name James
middle name Jacob
etc
but it does not
A Z wrote:
Thanks for your replies regarding to my previous
query.
We have encountered another problem:
MySQL 4.0.14, INNODB.
A table does have an Index on Field1, this field
(Field1) is also the Primary Key. Querying on this
field takes a long time, running along with Explain
command it displays
Thanks for your replies regarding to my previous
query.
We have encountered another problem:
MySQL 4.0.14, INNODB.
A table does have an Index on Field1, this field
(Field1) is also the Primary Key. Querying on this
field takes a long time, running along with Explain
command it displays that it d
At 13:56 22.03.2004, Martijn Tonies wrote:
> > I have some problmes with MySQL. We have some CHAR columns, which after
> > CREATE or ALTER TABLE
> >
> > ALTER TABLE `traffic_stat` CHANGE `media_file_class_id`
> > `media_file_class_id` CHAR(32) NOT NULL
> >
> > will be VARCHAR. Is this an MySQL bu
thx.
At 13:43 22.03.2004, [EMAIL PROTECTED] wrote:
Rafal Kedziorski <[EMAIL PROTECTED]> wrote on 22/03/2004 12:36:33:
> hi,
>
> I have some problmes with MySQL. We have some CHAR columns, which after
> CREATE or ALTER TABLE
>
> ALTER TABLE `traffic_stat` CHANGE `media_file_class_id`
> `med
Jeremy,
I am not sure if I have seen benchmarks of this. I think the stripe size is
not very important, as long as you make it significantly bigger than the
InnoDB page size of 16 kB.
Since it is not guaranteed that the OS will align InnoDB's data pages to
stripes, having a small, 16 kB stripe si
Hi!
Looks like your Linux kernel makes the file read performed by ibbackup to
fail immediately, but does not set errno to anything. That is why ibbackup
says the errno is 0.
The support for O_DIRECT is rather new in Linux kernels.
For now the workaround is not to use O_DIRECT if you plan to use
> > I have some problmes with MySQL. We have some CHAR columns, which after
> > CREATE or ALTER TABLE
> >
> > ALTER TABLE `traffic_stat` CHANGE `media_file_class_id`
> > `media_file_class_id` CHAR(32) NOT NULL
> >
> > will be VARCHAR. Is this an MySQL bug? We are using MySQL 4.0.18.
>
> http://ww
Rafal Kedziorski <[EMAIL PROTECTED]> wrote on 22/03/2004 12:36:33:
> hi,
>
> I have some problmes with MySQL. We have some CHAR columns, which after
> CREATE or ALTER TABLE
>
> ALTER TABLE `traffic_stat` CHANGE `media_file_class_id`
> `media_file_class_id` CHAR(32) NOT NULL
>
> will be VAR
hi,
I have some problmes with MySQL. We have some CHAR columns, which after
CREATE or ALTER TABLE
ALTER TABLE `traffic_stat` CHANGE `media_file_class_id`
`media_file_class_id` CHAR(32) NOT NULL
will be VARCHAR. Is this an MySQL bug? We are using MySQL 4.0.18.
Regards,
Rafal
--
MySQL General
"Michael B Allen" <[EMAIL PROTECTED]> wrote:
> For some reason mysql is logging every sql statement. I don't recall
> turning on such a thing. Can someone tell me how to turn that down/off. It
> seems a little excessive for my wimpy vps.
>
> Thanks,
> Mike
>
> # dpkg -l | grep mys
> ii libdbd-my
Hiya peeps.
I have a table which looks something like this:
TABLE1
id, something, page1, page2, page3
1, "wibble", 1, 3, 5
TABLE2
id, name
1, "hello"
2, "world"
3, "why can't"
4, "i get"
5, "this to work"
I want to SELECT everything from TABLE1 replacing the numbers in page1, 2, 3
with the words
The continuing saga:
> Can't connect to MySQL server on '192.168.13.205' (4)
Our sysadmin has been searching in the sources of the MySQL client and came
up with this:
The errormessage (4) is probably (only place where this error could be
found) raised by this fragment in libmysql.c:
if ((soc
Egor Egorov <[EMAIL PROTECTED]> wrote:
> TO <[EMAIL PROTECTED]> wrote:
>> Does INNODB support nested transactions? If so, what version?
>
> No, InnoDB doesn't support nested transactions.
>
Well, not really. I've forgot to mention the savepoints:
http://www.mysql.com/doc/en/Savepoints.h
I am using the MX04 and PHP 4.3x to auto generate and authenticate a login
page but sessions just seem to be lost on submit???
When I call the login page this session is started;-
sess_eff5bcd126b406d7e99fee19727f85d3
and this is the contents:-
username|N;
once I have submitted the data
Hi list,
We recently installed a new MySQL server (Redhat 8, MySQL 4.0.18, same as
old machine, but with more powerful hardware) and every now and then the
following error appears in the errorlog (the result of the mysql_error()
function of PHP):
Can't connect to MySQL server on '192.168.13.20
Is it possible to use a primary key to avoid duplicates? The reaction to
duplicate rows will depend on what type of statement you are issuing.
An update/delete would update/delete all rows that are relevant, a select
would return multiple rows with the same values.
-Original Message-
From
Dear User,
the message with following attributes has not been delivered,
because contains an infected object.
Sender = [EMAIL PROTECTED] (may be forged)
Recipients = [EMAIL PROTECTED]
Subject = fake
Message-ID = <[EMAIL PROTECTED]>
Antivirus filter report:
--- Dr.Web report ---
Following viru
"Nestor Florez" <[EMAIL PROTECTED]> wrote:
>
> I have a php web application that has an admin page for inserting course =
> records and one for selecting course records=20
> and a client page for selecting course record. =20
> In the admin side I insert records with an "insert into Course_Eng" and
Hi,
(B
(BI have a table with the sales of each product by month (in the format
(Bmm).
(BFor example: (table name: ventas)
(B
(Bsale_date prod_idsales
(B200301 A20
(B200302 A16
(B200303 A18
(B200301 B12
(
TO <[EMAIL PROTECTED]> wrote:
> Does INNODB support nested transactions? If so, what version?
No, InnoDB doesn't support nested transactions.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___
Hi!
On Mar 21, Shane Allen wrote:
> I've read through the boolean mode fulltext docs, and they address all
> my questions well except how searches containing exact phrases are
> handled when there is more than one. I believe the following will work
> as I expect, but was wondering if anyone can
"Terence" <[EMAIL PROTECTED]> wrote:
> Will be fixed in 4.1.2?
Yes, it's fixed in 4.1.2.
>When can we expect that to be out? Anyone with an
> idea?
Soon. Probably in two weeks.
>
> - Original Message ---
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This em
Will be fixed in 4.1.2? When can we expect that to be out? Anyone with an
idea?
(Also facing this problem here)
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 22, 2004 3:57 PM
Subject: Re: Strange behavior, Table Level Pe
Udbhav Shah <[EMAIL PROTECTED]> wrote:
>
> Using Mysql 4.1.1-alpha release on RH9,
> I have used RPM provided on Mysql site to upgrade from
> 3.23 to 4.1.1
>
> I have a very strange behavior of mysql server,when I
> restart my server, it is not reading permission given
> to user at Table Level fr
85 matches
Mail list logo
