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 from
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
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 email is
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
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,
(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
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 I =
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
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-
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
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
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.html
--
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
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 is TABLE2.
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-mysql-p
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
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 VARCHAR. Is
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.
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
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
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`
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 bug? We are
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
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
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
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
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
-- 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 in
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 Matos
[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
is
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 ?
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
-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
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 -
?
$sql = select max(WarrantyID) from warrantycopy;
$result=mysql_query($sql) or die(Could not get the id number : .
mysql_error());
What result are you getting?
First off, I see that your HTML is possibly incorrect; should it be:
echo tdWarranty ID:/td\n;
th 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
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:
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
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/2004
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
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
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:
/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
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
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
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 tdWarranty ID:/td\n;
th is a table header.
Second, if you are expecting a
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
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:
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
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
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 updated
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:
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
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
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 line,
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]
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
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
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 query' on both machines; the output should
be the same.
4.0.1 isn't
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 feel
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
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 need
I copied the following from my coldfusion application.log
Error,2152,03/20/04,09:03:13,,ODBC Error Code = S1000 (General
error)P [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-max-nt-log]Incorrect
key file for table: 'referenceEntries'. Try to repair itPP SQL =
UPDATE referenceEntries
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 the
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)P [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-max-nt-log]Incorrect
key file for table: 'referenceEntries'. Try to repair itPP SQL
This error should be logged. Do you have a file called hostname.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)P [MySQL][ODBC 3.51
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 will
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
Hi,
i want to update couple of columns like
update tablename
set =value1
where columname=value2;
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!
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 =value1
where columname=value2;
I want to run query on mysql prompt each time and enter value1 and
value2 for diffrent columnname ?
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 be to
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
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
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
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:
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 like
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 1054: Unknown
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
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
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:
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
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
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 [EMAIL
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. /rant.
Anyhow, I was just reading on
http://www.mysql.com/doc/en/Server_system_variables.html, there's a
variable
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 in
84 matches
Mail list logo