OK I think I've found a bug with MySQL's compression support. :-/
I'm using two Java zlib implementations. One is jzlib 1.0.7 and the other
is java.io.DeflateOutputStream . Both of these are referenced by the zlib
implementation as being compatible.
I can compress/uncompress locally WITHOU
> -Original Message-
> From: Hannu Krosing [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 11, 2007 10:43 PM
> To: Larry McGhaw
> Cc: Tom Lane; Alvaro Herrera; Dann Corbit; Gregory Stark; Martijn van
> Oosterhout; [EMAIL PROTECTED]
> Subject: Re: [HACKERS] Selecting a constant question
>
>
Thanks All for your help!
If someone from MySQL team is looking at this mail thread, we request to
include this feature in future release.
Cheers,
Rajan
On 6/11/07, Michael Dykman <[EMAIL PROTECTED]> wrote:
no, there is nothing else. There are cleaner interfaces to this
information but, for P
Baron Schwartz wrote:
Kemin Zhou wrote:
Hi All,
I have one of the toughest problem to solve now. I have not been
able to sleep well in the last three days.
There is a simple query
insert into table foo (column1, column2, column5)
select $col
from bar
If I run this query by hand whatever th
On 6/11/07, kalin mintchev <[EMAIL PROTECTED]> wrote:
hi all...
from http://dev.mysql.com/doc/refman/5.0/en/features.html:
"Handles large databases. We use MySQL Server with databases that contain
50 million records. We also know of users who use MySQL Server with 60,000
tables and about 5,000
At 5:53p -0400 on 11 Jun 2007, Gordan Bobic wrote:
I don't understand this never-ending fascination with re-inventing
a square wheel for an application for which the standard round type
has already been kindly provided since year dot.
I imagine the reason for this "never-ending fascination .
> The answer depends upon the actual queries and/or how much data is being
> returned.
there is ALWAYS only one record found/returned per query it's like
looking up one unique id it's like checking if number 5893786 is there
in row number one... or something like number 5893786 - a uniqu
hi all...
from http://dev.mysql.com/doc/refman/5.0/en/features.html:
"Handles large databases. We use MySQL Server with databases that contain
50 million records. We also know of users who use MySQL Server with 60,000
tables and about 5,000,000,000 rows."
that's cool but i assume this is distrib
Having just tried building MySQL 6.0 SRPM on CentOS/RHEL 5, it would
appear that it doesn't even build cleanly with the default settings with
GCC! Has anyone got any information as to why this might be? It seems to
build OK, but then all the tests (mysql-test-run) seem to fail.
Is this known not t
Oh dear... Without getting into any religious arguments, if you have to
use it, PHP already provides a perfectly good interface for preventing
any SQL injections - ever. Use MySQLi and bound parameters. And if
somebody manages to invent some quasi-valid reason for not using MySQLi
(e.g. version of
Yes, you are correct. In a cruel, ironic twist, that actually bit me in
the ass, as it turns out we tried to import some "HTML" output from MS
Word, which adds all kinds of crazy XHTML comment tag thingys that look
like:
Etc.
*sigh*
> -Original Message-
> From: Yves Goergen [mailto:[E
Rolando!
Yes, that worked! I did have to log into mysql as root, however...
BTW, for some odd reason someone's symantec virus checker is sending
me denied e-mail responses from Italy, whenever I try to post to the
MySQL mailing list.
Many, many thanks,
Unnsse
On Jun 11, 2007, at 1:41 PM,
Don't you mean this ?
grant all privileges on *.* to 'untz'@'localhost' identified by 'maddog';
- Original Message -
From: "untz" <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Monday, June 11, 2007 4:36:33 PM (GMT-0500) America/New_York
Subject: Re: Access Denied When Trying to Crea
Gerald,
I tried this and it still didn't work!
Raven:~ untz$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 223 to server version: 5.0.16-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> grant
untz wrote:
Gerald,
I tried this and still got an error!
mysql> grant all privileges on *.* to 'untz'@'localhost' identified by
'maddog';
ERROR 1045 (28000): Access denied for user 'untz'@'localhost' (using
password: YES)
mysql>
Can anyone please help me? I am unable to use MySQL at all,
I get this everytime I post to the mysql mailing list?
On Jun 11, 2007, at 1:26 PM, <[EMAIL PROTECTED]> wrote:
Subject of the message: Re: Access Denied When Trying to Create
Database
Recipient of the message: "mysql@lists.mysql.com"
--
MySQL General Mailing List
For list archives: http:
Mikhail,
I just tried what you suggested and got this:
mysql> grant super privileges on *.* to 'untz'@'localhost' identified
by 'maddog';
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use nea
Gerald,
I tried this and still got an error!
mysql> grant all privileges on *.* to 'untz'@'localhost' identified
by 'maddog';
ERROR 1045 (28000): Access denied for user 'untz'@'localhost' (using
password: YES)
mysql>
Can anyone please help me? I am unable to use MySQL at all, at this
po
Looks like words "privileges on" are missing from GRANT statement you
used
Should be "grant super privileges on *.* to 'untz'@'localhost'
identified by 'password';
Not "grant super *.* to 'untz'@'localhost' identified by 'password';"
Regards,
Mikhail Berman
-Original Message-
From: unt
untz wrote:
Ananda,
Thank you for responding!
I just tried this and got the following:
mysql> grant super *.* to 'untz'@'localhost' identified by 'password';
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
Ananda,
Thank you for responding!
I just tried this and got the following:
mysql> grant super *.* to 'untz'@'localhost' identified by 'password';
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to
2007/6/11, Ananda Kumar <[EMAIL PROTECTED]>:
try mysqladmin shutdown
I've tried but nothing is happens: the "mysqld_safe" process
is always to 100%
--
Scripts: http://www.spacemarc.it
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Just speaking as a newbie who has no idea what he is talking about ...
If nobody suggests anything better ...
I've noticed that there is a clear correspondence between table names and
the files that MySQL keeps, i.e.
[EMAIL PROTECTED] dashley]# ls -al /var/lib/mysql/fboprimedevel/
total 7832
dr
On 6/11/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hi,
Hamish Allan wrote:
> Hi,
>
> Is it possible to insert values into two tables simultaneously and
> have the value of one of the columns in the second table be the
> auto_increment value from inserting into the first?
No, because you can
Hi,
Hamish Allan wrote:
Hi,
Is it possible to insert values into two tables simultaneously and
have the value of one of the columns in the second table be the
auto_increment value from inserting into the first?
No, because you can only insert into one table at a time. But you can write a sto
Yes, you are right! mysql_info() is not most useful. It does give me number
of rows matched but will involve complications of parsing the string.
Is there no other way to this? How can this be missed? I am not so
convinienced on mysql_info()!
On 6/11/07, Jerry Schwartz <[EMAIL PROTECTED]> wrot
Hi,
Is it possible to insert values into two tables simultaneously and
have the value of one of the columns in the second table be the
auto_increment value from inserting into the first?
E.g. if table1 has an auto_increment column c1, the logic I'm looking
for would be something like:
INSERT IN
I have inherited database servers from a group whose main job was not working
on mysql. I am not certain if all the tables on the databases are being used.
Is there some efficient way of determining if a table is being accessed or when
the last time it was accessed?
Thanks,
Keith
--
Keith
On Mon, 11 Jun 2007, Mahmoud Badreddine wrote:
> Hello,
> I am trying to revoke all privileges from a user on a certain table in a
> database.
> I want the user to continue to have all his/her privileges intact for the
> other tables though.
>
> I used the statement "REVOKE ALL PRIVILEGES on dbNa
Hello,
I am trying to revoke all privileges from a user on a certain table in a
database.
I want the user to continue to have all his/her privileges intact for the
other tables though.
I used the statement "REVOKE ALL PRIVILEGES on dbName.tableName from
thisUser";
But that doesn't seem to change
Have you looked at mysql_info()? The format of the return value might not be
the most useful, but it should give you what you need.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.
On Mon, 11 Jun 2007, Dave Shariff Yadallee - System Administrator a.k.a. The
Root of the Problem wrote:
> REcently my mysql server has been overload with a lot
> of connections; in fact losing the mysql.user table and
> one whole database.
Define "losing". You lost access, or the tables got co
Hi,
I'm trying to build the RPMs with ICC, but I'm not having a lot of luck. I
saw the documentation for what paremeters are used to combile the tar
balled binaries, but can anyone give me some guidance on how to get the
RPMs to build?
The distributions I want to build for are CentOS 5.0 / x86
REcently my mysql server has been overload with a lot
of connections; in fact losing the mysql.user table and
one whole database.
How can this be prevented?
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailin
ok...That I know but I need it to check in my code...
On 6/11/07, ViSolve DB Team <[EMAIL PROTECTED]> wrote:
Hi
Simple.. The query "feedback" will depict the matched & changed numbers.
mysql> update test set roll = 1, s = 'new' where roll = 1;
Query OK, 0 rows affected (0.00 sec)
* Rows matc
Hi
Simple.. The query "feedback" will depict the matched & changed numbers.
mysql> update test set roll = 1, s = 'new' where roll = 1;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
Thanks
ViSolve DB Team.
- Original Message -
From: "Ace" <[EMAIL PROTECT
Hi,
I think you need to log in as root and grant yourself some privileges then. If you
have lost the root password or root doesn't have privileges anymore either, there is a
chapter in the manual on how to do this: http://dev.mysql.com/
Cheers
Baron
untz wrote:
Baron & Prathima,
Thank for
Is this a user "untz" going to do even the "create procedure", if yes then
you need to grant "super" previliege to this user.
grant super on *.* to 'untz'@'localhost' identified by 'password';
regards
anandkl
On 6/11/07, untz <[EMAIL PROTECTED]> wrote:
Baron & Prathima,
Thank for the informa
Ok..thanks! But my problem here is how to check if there were any matched
rows when no rows were changed. mysql_affected_rows() will tell me the
affected rows. Simmly, is there any routine using which one can know if
there were any matched rows?
Cheers,
Rajan
On 6/11/07, ViSolve DB Team <[EMAIL
On 10 jun 2007, at 20.47, tAndRead wrote:
Hi all,
when I try to add a foreign text from the keyboard in the mysql
client,
keystrokes are ignored! unless they are numbers, commas etc
(using kde-konsole with the the DeJaVu international font)
I believe this has to do something with the co
Hi
AFAIK, before changing data, the old values are saved in the rollback
segment.
On saving the updated values, from the Buffer to the rollback segment/data
files,
--- it checks if there is any matched row that matches the condition. If
found, then flags "Matched".
---after filtering out the
try mysqladmin shutdown
On 6/11/07, spacemarc <[EMAIL PROTECTED]> wrote:
Hi
when I stop mysql server with "sudo /etc/init.d/mysql stop" the
"mysqld_safe" process go to 100% of CPU and I must to kill it
manually.
What's happens? Ho can I stop it without killing?
--
Scripts: http://www.spacemar
Hi
when I stop mysql server with "sudo /etc/init.d/mysql stop" the
"mysqld_safe" process go to 100% of CPU and I must to kill it
manually.
What's happens? Ho can I stop it without killing?
--
Scripts: http://www.spacemarc.it
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
43 matches
Mail list logo
