Hi!
- Original Message -
From: ""Sp.Raja"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, July 27, 2004 5:52 PM
Subject: Re: Innodb assertion failure after binary backup-restore
> Thanks for your replies.
>
> Now I have three ways to go
>
> 1. replication=20
I have upgraded MySQL from version 3.32 to 4.0 and am trying to upgrade
the privilege tables by running the subject script.
Regardless of what I set in the "bindir=" line of the script file I get
errors from lines 100, 115, 132, and others that either %bindir%/mysql:
No such file or directory or %
Cameron,
Take a look in the data directory for a .err file. This error log
will almost certainly contain the reason why Mysql failed to load and
will make fixing it much easier.
Richard
On Wed, 28 Jul 2004 13:15:34 -0600, Cameron Roe <[EMAIL PROTECTED]> wrote:
> Thanks Rory,
>
> I did go throu
At 1:58 + 7/29/04, [EMAIL PROTECTED] wrote:
-- Original message from Tiago Serafim : --
Hi,
Try the following:
WHERE not (field like '%c%' or field like'%C%')
Cheers,
I think since LIKE is case insensitive, unless the keyword BINARY is present,
Close, but not quite.
Hello.
Sorry for lack of information.
Any client applications or programming langueges do like that.
PHP mysql_connect() function , MySQL's mysql command tool, etc.
- Original Message -
From: "Frederick R. Doncillo" <[EMAIL PROTECTED]>
To: "Heo, Jungsu" <[EMAIL PROTECTED]>
Cc: <[EMAIL
Is there any way within mysql to have the slaves not stop replicating on
an error. For some reason, my application is trying to insert duplicate
keys. This fails and the slaves stop replicating from the master.
Ideally, the command that failed would just be skipped automatically and
the whole
> I think since LIKE is case insensitive, unless the keyword BINARY is present, and
> the parser would have to collapse the extraneous parentheses "WHERE NOT LIKE '%c%'"
> would be slightly more efficient.
> applicable manual page --
> http://dev.mysql.com/doc/mysql/en/String_comparison_function
Hello,
It should select * from table where field not like '%c%';
or to be safe;
select * from table where field not like 'c%' and field not like '%c'
and field not like '%c%';
Fred.
Tiago Serafim wrote:
Hi,
Try the following:
WHERE not (field like '%c%' or field like'%C%')
Cheers,
On Wed,
Hello Jungsu,
What are the tools you're using to connect? Any client applications?
Fred.
Heo, Jungsu wrote:
>Hello.
>
>I'm using MySQL 4.1.2 on Linux(Fedora Core 2) and Window 2003 Server.
>
>When connect from Linux to Windows, or from Window to Linux connection time is very
>slow.
>( it take
Hello,
I'd like to ask for some help on a problem which have prevented my mysql
server to run since I updated it from 4.0 to 4.1
Anyway, even if in the idea it's an update, in the facts it's a fresh install,
from sources.
Sources were configure'd with "./configure --prefix=/usr/local/mysql".
Aft
-- Original message from Tiago Serafim : --
> Hi,
>
> Try the following:
>
> WHERE not (field like '%c%' or field like'%C%')
>
> Cheers,
>
I think since LIKE is case insensitive, unless the keyword BINARY is present, and the
parser would have to collapse the ext
Hi,
Try the following:
WHERE not (field like '%c%' or field like'%C%')
Cheers,
On Wed, 28 Jul 2004 22:23:40 +0100, John Berman
<[EMAIL PROTECTED]> wrote:
> Hi
>
> Sure this is easy
>
> Im trying to create a simple select query but I want to return records
> unless a field contains a C or c
Hello.
I'm using MySQL 4.1.2 on Linux(Fedora Core 2) and Window 2003 Server.
When connect from Linux to Windows, or from Window to Linux connection time is very
slow.
( it takes about 6 seconds)
But Linux to Linux or Windows to Windows Fast.
Anybody has an Idea?
Thank you for advanced answer!
Check out the LIMIT function in the documentation
> -Ursprüngliche Nachricht-
> Von: Kamal Ahmed [mailto:[EMAIL PROTECTED]
> Gesendet: Mittwoch, 28. Juli 2004 20:39
> An: [EMAIL PROTECTED]
> Betreff: TOP
>
> Hi,
> Does anyone know how to do a TOP function in MySQL ?
>
> Thanks,
>
> -Ka
Keith:
I don't know if it's the same problem, but I recently had issues where
I had a similar setup with only two MySQL servers, one 4.0.20, the
other 4.1.3, same usernames/passwords on each.
My solution, and I don't remember where in the manual I saw this
(possibly the FAQ), was to do an updat
I have a mysql connection problem that I'm trying to understand.
The three servers and the version of mysql they are running (all under
Solaris9) are:
db1 - 4.0.16
db2 - 4.0.17
db3 - 4.1.3
All three systems have the same mysql user and passwords setup. I'll
use the mythical user "xx" with
The problem was /etc/hosts, but not for localhost. My issue was that
whomever setup /etc/hosts swapped the fields:
Old busted:
IP blah blah.1.2.3.net
Working:
IP blah.1.2.3.net blah
Oh well...Thank for every one's time.
Drew
On Wed, 2004-07-28 at 17:33, Victor Pendleton wrote:
> My
This is a local connection.
Thanks again!
Drew
On Wed, 2004-07-28 at 17:33, Victor Pendleton wrote:
> My apologies I was reading an ip address. Have you tried logging in from the
> server itself? Since this is the initial install I think root needs to log
> in from the localhost.
>
> -Origi
Our customers are running MySQL 4.0.17 on QNX 6.2.1.
We are currently using a flash drive to store our database but we want
to store it in a RAM disk to prolong the life of the drive. We want to
install the database on the RAM disk on startup and save it to flash on
shutdown.
There are two datab
Okay, now I'm even /more/ confused. I whittled everything
down like so:
CREATE INDEX reporting_t ON a (timestamp);
CREATE INDEX reporting_t_id ON a (timestamp, a_id);
CREATE INDEX reporting_id_t ON a (a_id, timestamp);
EXPLAIN
SELECT *
FROM a, b
WHERE
a.a_id = b.a_id AND
a.timestamp BETWEEN 20040
Rick Dwyer wrote:
>> Assuming its not a super-high performance situation, I would put
>> everything on the RAID 1 volume.
>
> Richard, what would you define as super-high performance? This MySQL
> database server will serve as the backend for a Lasso/ OS X Apache
> webserver handling thousands of
My apologies I was reading an ip address. Have you tried logging in from the
server itself? Since this is the initial install I think root needs to log
in from the localhost.
-Original Message-
From: Andrew Hall
To: Victor Pendleton
Cc: '[EMAIL PROTECTED] '
Sent: 7/28/04 4:35 PM
Subject: R
Yes I have. The hostname of the box returned with 'hostname' is the
fqdn and is in the format of blah.1.2.3.net.
Drew
On Wed, 2004-07-28 at 17:16, Victor Pendleton wrote:
> Can you check the host name again? You have a five segment address.
>
> -Original Message-
> From: Andrew Hall
Hi
Sure this is easy
Im trying to create a simple select query but I want to return records
unless a field contains a C or c so would it be something like
where field <> 'c' or 'C'
Regards
John B
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
Can you check the host name again? You have a five segment address.
-Original Message-
From: Andrew Hall
To: [EMAIL PROTECTED]
Sent: 7/28/04 3:55 PM
Subject: connection problems
Greetings,
I have what I hope is an easy problem. I have installed mysql 4.0.20
and when I execute mysqladmi
I'm trying to figure out how to get the table FUNDED_INFO to return all
rows, even if there is no row(s) in the two other tables, STOCK &
CUSTOMERS. This one doesn't really work 'cause either one of the two
tables, STOCK and CUSTOMERS doesn't have a row which would cause a row
from FUNDED_INFO not
Greetings,
I have what I hope is an easy problem. I have installed mysql 4.0.20
and when I execute mysqladmin to set the root password using the -h flag
my hostname is truncated, and I get a connection refused message.
The hostname on this box is a fqdn like blah.1.2.3.net. My command line
is
Assuming its not a super-high performance situation, I would put
everything on the RAID 1 volume.
Richard, what would you define as super-high performance? This MySQL
database server will serve as the backend for a Lasso/ OS X Apache
webserver handling thousands of hits per day. Will installing
Hi Sp,
The best advice I can give you is to implement a replication slave,
and perform hot backups using the innodb ibbackup tool from the slave
server. This ensures that you maintain high availability and
disaster recovery in case of catastrophic failure.
The ibbackup tool from innodb (http://w
Rick Dwyer wrote:
> Hello all.
> I want to install MySQL on a RAID mirror drive using two ATA 125GB
> for the mirror. I know in a webserver config, it's best to put the
> boot OS on one drive and the shared serving folder on the RAID mirror
> drive. Under a MySQL server, if I install the OS and M
Hello all.
I want to install MySQL on a RAID mirror drive using two ATA 125GB
for the mirror. I know in a webserver config, it's best to put the
boot OS on one drive and the shared serving folder on the RAID mirror
drive. Under a MySQL server, if I install the OS and MySQL all on
the mirror d
Hello all.
I want to install MySQL on a RAID mirror drive using two ATA 125GB
for the mirror. I know in a webserver config, it's best to put the
boot OS on one drive and the shared serving folder on the RAID mirror
drive. Under a MySQL server, if I install the OS and MySQL all on
the mirror d
Thanks Rory,
I did go through (as per the manual)and set the permissions
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
shell> ln -s full-path-to-mysql-VERSION-OS mysql
shell> cd mysql
shell> scripts/mysql_ins
YAHOOO Shawn Green you were absolutely right, I basically just took
your 6 union query from below, modified it to add back my specific data
and fixed my index to only include the 2 fields that I needed and VOILA`
it worked like a champ.
My query times went from 1:05 to 0.32 seconds, thanks fo
TOP is a microsoft SQL extension.
MySQL uses the LIMIT clause.
for instance, the following is a rather typical "top 10" sql query:
select some_column, sum(another_column) total
from some_table
group by some_column
order by total desc
LIMIT 10
On Wed, 28 Jul 2004 14:39:11 -0400, Kamal Ahmed
<
In MS SQL Server (T-SQL) you say
SELECT TOP n
In MySQL you use:
SELECT LIMIT n
(http://dev.mysql.com/doc/mysql/en/SELECT.html)
There is no direct equivalent to SELECT TOP n PERCENT
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Kamal Ahmed" <[EMA
Hi,
Does anyone know how to do a TOP function in MySQL ?
Thanks,
-Kamal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sorry, but I send an e-mail to sales two month ago but none replies me.
The question is very simple:
Can I buy 2 licenses and transfer them to an hardware reseller that
will transfer them to the customer?
Thank you.
Santino Cusimano
--
MySQL General Mailing List
For list archives: http://lists.m
Scott,
I am glad that you understand what I meant but I still don't think you
understand what you can do with MySQL. You are killing your query
performance by trying to convert things on the fly. YOU DON'T NEED TO
DO THAT WITH MYSQL. Maybe you did in DB2 but not here.
So you can stop Goo
Cam wrote:
So I'm a little confused here
I've installed mysql-standard-4.0.20-pc-linux-i686.tar to
/usr/local/mysql and then ran the scripts/mysql_install_db with
seemingly no errors.
After reading section 5.1 'the MySQL Server and Server Startup Scripts'
I figured that
cd /usr/local/mysql
bin/my
So I'm a little confused here
I've installed mysql-standard-4.0.20-pc-linux-i686.tar to
/usr/local/mysql and then ran the scripts/mysql_install_db with
seemingly no errors.
After reading section 5.1 'the MySQL Server and Server Startup Scripts'
I figured that
cd /usr/local/mysql
bin/mysqld_safe
Without using a subquery, you have to do it in two steps. First you need
to collect the MAX(col2) values for each col1 value:
CREATE TEMPORARY TABLE tmpMaxes
SELECT col1, max(col2)
from test_table
GROUP BY col1
Then you want to get the rows where the col2 value is the maximum for each
col1 val
i have one MySQL dB that is currently about 26Gb, properly indexed
searches are very quick
- hcir
On Jul 28, 2004, at 4:23 AM, matt ryan wrote:
>Should I even attempt this using mysql?
>Has anyone played with this much data in mysql?
I've got two 100 gig databases in mysql, and slave replication
Hi,
I'm using MySQL 4.0.18 on Win2k Server. I have a table similar to the
following:
col1col2col3
A 1 this
A 2 is
A 3 a
B 1 test
B 2 table
What I would like to get with one query is the following result:
col1
If you have an auto_increment or other unique recno you can do:
select a.* from file a , file b where a.timefield = b.timefield and
a.recno != b.recno
Robert Reed wrote:
No worries mate, that is exactly what I need, and the
number I've got are 32 and when I subtract the ones
more than a year old
I'm using UTF-8 in my newsboard, too, and I have no major problems with
it. UTF-8 doesn't need to be handled as binary, I believe, since all
characters should be in a range over the control characters. Anyone
please correct me, if that's wrong...
Sorting will not work as expected, special chara
Paul,
> >> >From the MySQL doc :
> >>
> >> The ENGINE and TYPE options specify the storage engine for the table.
> >> ENGINE was added in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1). It is
the
> >> preferred option name as of those versions, and TYPE has become
> >> deprecated. TYPE will be su
Scott,
I really don't understand your need to convert your string values to some
kind of numeric equivalent. When it comes to sorting strings it all
depends on the collation sequence for the characterset you are using.
For example, my STATUS; command tells me:
mysql Ver 14.3 Distrib 4.1.1a-al
Hi, all. I think I'm misunderstanding something basic about
indexes. I have a SELECT like so:
SELECT *
FROM a
LEFT JOIN b ON a.a_id = b.a_id
JOIN c ON a.c_id = c.c_id
JOIN d ON c.d_id = d.d_id
JOIN e ON c.e_id = e.e_id
WHERE a.timestamp BETWEEN 2004010100 AND 20040101235959
GROUP BY c.d_id, c.
Hi!
On Jul 28, Ben Ricker wrote:
>
> Our security guy ran across an exploit in all MySQL versions before the
> June releases. I am trying to find information on how to patch to fix this
> vulnerability but I cannot find anything on MySQL's site! It is kind of
> ridiculous. I searched for "check_s
No worries mate, that is exactly what I need, and the
number I've got are 32 and when I subtract the ones
more than a year old I've less than 10. I can do the
legwork. :)
Thanks.
--- Mike Johnson <[EMAIL PROTECTED]> wrote:
> From: Mike Johnson
>
> > From: Robert Reed [mailto:[EMAIL PROTECTED]
I forgot to mention in the previous post that the replay-log server_c failed
to find (./server_b-relay-bin.05) does exist on server_b, (this
is while setting up server_c as slave) but is only 4 bytes in length.
040728 5:15:13 Failed to open the relay log './server_b-relay-bin.05'
(rela
Just curious if I have got something wrong with my eyes or fingers:
[EMAIL PROTECTED] mysql-max-4.0.20-unknown-linux-x86_64]# ldd bin/mysqld
librt.so.1 => /lib64/tls/librt.so.1 (0x003c71f0)
libdl.so.2 => /lib64/libdl.so.2 (0x003c7190)
libpthread.so.0 => /lib
At 14:36 +0200 7/28/04, Martijn Tonies wrote:
Hi Jocelyn,
>From the MySQL doc :
The ENGINE and TYPE options specify the storage engine for the table.
ENGINE was added in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1). It is the
preferred option name as of those versions, and TYPE has become
deprec
From: Mike Johnson
> From: Robert Reed [mailto:[EMAIL PROTECTED]
>
> > This seems like it should be easy, and I'd be happy
> > for a simple reference to where in the manual or in
> > Paul's book I can find the answer. I am wanting to
> > find basically the inverse of a SELECT DISTINCT
> > opera
From: Robert Reed [mailto:[EMAIL PROTECTED]
> This seems like it should be easy, and I'd be happy
> for a simple reference to where in the manual or in
> Paul's book I can find the answer. I am wanting to
> find basically the inverse of a SELECT DISTINCT
> operation. I have a table with a column
This seems like it should be easy, and I'd be happy
for a simple reference to where in the manual or in
Paul's book I can find the answer. I am wanting to
find basically the inverse of a SELECT DISTINCT
operation. I have a table with a column labled
date_created. I know that some records (about
In the last episode (Jul 28), [EMAIL PROTECTED] said:
> I think the UNION is the right way to handle this, in fact, I would be
> tempted to break it into 6 UNIONS... more on that later.
I think his 2 original unions should suffice. Unions are great for
overcoming mysql's "one index per table" lim
In the last episode (Jul 28), Martijn Tonies said:
> Hi Jocelyn,
> > >From the MySQL doc :
> >
> > The ENGINE and TYPE options specify the storage engine for the table.
> > ENGINE was added in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1). It is
> > the preferred option name as of those versions, and
Brent,
I humbly disagree with your analysis. I believe that it is well
established in this list and other places
(http://dev.mysql.com/doc/mysql/en/EXPLAIN.html) that the query engine
only uses at most 1 index of the available indexes on any table involved
in the query. It has also been shown
thank you again Paul, I did miss that one altogether, but that does not
appear to be the whole problem.
having added 'log-slave-updates' to all my.cnf of all the servers (just
to be paranoid) I found no difference in the results. I still get the
same errors message upon 'CHANGE MASTER TO ...' and
Our security guy ran across an exploit in all MySQL versions before the
June releases. I am trying to find information on how to patch to fix this
vulnerability but I cannot find anything on MySQL's site! It is kind of
ridiculous. I searched for "check_scramble", "zero-length comparison" and
e
thanks, but some of the tables have to be in MyIsam format, and i cannot see
a workaround for them. (actually I discovered that the integrity of the data
exported is just fine, but it seems that the server hangs trying to close
the file handle.
- Original Message -
From: "Nickolai Nielsen"
Let me quote a little bit from the docs
(http://dev.mysql.com/doc/mysql/en/String_functions.html):
CHAR() interprets the arguments as integers and returns a string
consisting of the characters given by the code values of those integers.
NULL values are skipped.
mysql> SELECT CHAR(77,1
I think the UNION is the right way to handle this, in fact, I would be
tempted to break it into 6 UNIONS... more on that later.
You really should concentrate mostly on coverage for fields used in your
WHERE clauses, in this case: Framed_IP_Address and Date. Additional fields
can be used to get
Update on this, I found that when the slave stops, all I have to do is
start the slave and it's good again
Here's what the log shows.. the only thing I did was "start slave" and
it picked right back up
040728 9:25:13 Error reading packet from server: binlog truncated in
the middle of event (
Your problem is that you created a single index. An index is just a
presorted list of the data. The first column in the index is the most
relevant, being sorted by that column first. If you have an index on
State+County+Town, how would you quickly find a town? You can't if you
don't know the S
That error suggests that `status` exists in both tmpupdateme and dCopy (it
probably doesn't, but that's what it means). We should be able to cure
this by specifically referencing the column by adding its table's alias
before the field name. That changes the update statement to be :
update dCOPY
I hope you have already tried just plain-old "ORDER BY field_name" in your
query. What is wrong with the default order presented? Can you show an
example of how the ORDER BY did not solve your problem along with an
example of what it should have been for your situation?
Thanks in advance,
Shaw
One of my slaves has decided to stop replicating
every time I reset it, I get this
040728 8:46:46 Error reading packet from server: binlog truncated in
the middle of event (server_errno=1236)
040728 8:46:46 Got fatal error 1236: 'binlog truncated in the middle
of event' from master when readi
Hi Jocelyn,
> >From the MySQL doc :
>
> The ENGINE and TYPE options specify the storage engine for the table.
> ENGINE was added in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1). It is the
> preferred option name as of those versions, and TYPE has become
> deprecated. TYPE will be supported throughou
Hi,
>I received the same. I concluded from the typos that the message is a
hoax.
I got two more today.
And yeah I believe its a hoax. Of course the only way that
we'd be sure is if said list manager were to pipe up
here and state that with certainty. My guess is that
its a harvester address that
Ok, I will be the first to say that I am learning about indexes, however
it is my understanding that if I have a database with MANY rows and I
wish my queries to be faster I should index my database. With that being
said, I have 2 tables in my database that are being queried with a
single query usi
>Should I even attempt this using mysql?
>Has anyone played with this much data in mysql?
I've got two 100 gig databases in mysql, and slave replication on both
of them, the only time I have a problem is table scans, that much data
will be slow.
--
MySQL General Mailing List
For list archives: h
Hi all,
I just noticed that the MySQL 4.1.latest version handles
a SHOW TABLE STATUS different from 4.1.1!
Instead of a field "Type" that holds the table type, it's
now "Engine".
Just a quick question: who makes up these changes in
a minor minor (x.x.x) release What do they expect
from third
Michael Stassen wrote:
> Paul DuBois wrote:
>
>> At 15:57 -0400 7/27/04, Michael Stassen wrote:
>>
>>> First, I should point out that I've never used mysql on Windows.
>>>
>>> The manual makes no mention that I can see of system not being
>>> supported on the Windows mysql client. On the other
>Description:
The mysql_install_db script in mysql-max-4.1.3-beta-sgi-irix6.5-mips
crashes with a bus error:
Installing all prepared tables
scripts/mysql_install_db[218]: 1352683 Bus error
Installation of system tables failed!
No files were present in ./data other than empty
Richard,
I received the same. I concluded from the typos that the message is a hoax.
Regards,
Heikki
- Original Message -
From: ""Richard Mixon (qwest)"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, July 28, 2004 7:16 AM
Subject: OT, but real: Hoax or legit
Hi All,
I have been asked to provide a searchable electoral roll.
This data comprises of first name, surname, address for every person
over 18 in the UK. Approximately 30 GB
The data is to be used to find people in a certain area.
EG
All John Smith in London.
All Sarah Dean in St Johns Road, Manc
Michael Dykman wrote:
could someone please tell me which versions of mysql support SSL
connections for both clients and replication slaves?
As far as I understand SSL was introduced in 4.0 and SSL-replication was
introduced in 4.1.1.
http://dev.mysql.com/doc/mysql/en/SSL_options.html
http://dev
80 matches
Mail list logo
