At 12:14 +1000 8/18/04, Jens Porup wrote:
G'day,
Trying to get a dump of a production database in mysql 3.23.54, mysqldump
version 8.22.
This is what I'm getting:
rack002:~# mysqldump -u root -p rt2 > rt2.dump
Enter password:
mysqldump: Error 2020: Got packet bigger than
'max_allowed_packet' wh
Mike Blazer wrote:
In addition to my previous posting - on this machine I have glibc.2.3.2
which was installed using the Gentoo emerge native installer. Dunno, the
mysql manual says a lot about various bugs and patches for glibc (that
influence the threads behavior) but it is all up to 2.2.2. Not
Hi Victor,
My server's connections seem never time out. Please tell me how to fix it.
The following is my.cnf:
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port= 3306
socket = /var/lib/mysql/mysql.sock
# Here follows e
G'day,
A different tack on my problem.
mysqldump is giving me the following error:
rack002:~# mysqldump -u root -p rt2 > rt2.dump
Enter password:
mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' when dumping
table 'Attachments' at row: 36763
Ho
G'day,
Trying to get a dump of a production database in mysql 3.23.54, mysqldump
version 8.22.
This is what I'm getting:
rack002:~# mysqldump -u root -p rt2 > rt2.dump
Enter password:
mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' when dumping
Just been using mysql for a couple of days, so this is possibly old ground,
but i have searched and can't find any solution. i'm sure it must have come
up before.
The project is to allow resources to be shared amongst community groups
throughout uk. there are a number of attributes that can be se
ROFLMAO -- Yep! It's been one of _those_ days!!!
Shawn
Michael Stassen <[EMAIL PROTECTED]> wrote on 08/17/2004 05:10:46
PM:
> Just a minor quibble: You don't need DISTINCT here, because the GROUP
BY
> will ensure distinct results. Probably just another fast-typing
symptom.
>
> Michael
>
Just a minor quibble: You don't need DISTINCT here, because the GROUP BY
will ensure distinct results. Probably just another fast-typing symptom.
Michael
[EMAIL PROTECTED] wrote:
oops! - typing too fast for my own good. The fixed query should have been:
SELECT DISTINCT E.Title, E.ID, max(C.Date
Eve,
Best to keep threads on the list. Others may have better ideas, and future
readers may benefit.
The comparison
candidate.Location IN ('CA', 'California')
will match 'CA' and 'California', but will not match 'Cupertino, CA' because
it isn't either of those strings. To match that row as w
On Fri, Jul 23, 2004 at 05:37:08PM +0200, crandler wrote:
> Hello,
>
> the following problem occurs when I want to configure MySQL 4.1:
>
> Building aclocal.m4
> Running autoheader to build config.hin
> Running autoconf to build configure
> 645046
> 644916
> Building RPC client/server files
> Bui
Thanks, that did the trick.
On Aug 17, 2004, at 12:34 PM, [EMAIL PROTECTED] wrote:
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have the same problem. I have an open bug report here:
http://bugs.mysql.com/?id=4761
I can't figure out why my management server can not see my ndb
servers. Perhaps I should try to down the secondary interface on all
the servers?
On Tue, 17 Aug 2004 15:54:29 -0400, Wheeler, Alex <[EMAIL PROT
Hi list, I am still very much a newbie so here goesI am still a bit
shaky on how to connect to dbs and general concepts so please excuse any
glaringly wrong statements..
If an application is developed in Oracle is there a special language for
development with Oracle dbs?
I understand tha
Sean,
Your diagnosis (paragraph 4) is correct, despite your efforts to talk
yourself out of it. DBI is independent, but DBD::mysql needs the mysql
client library. While you have upgraded to the latest DBI/DBD, you are
still using the mysql 4.0.2 client library which can't authenticate to your
Hello, guys!
I'm just migrating to the new Quad AMD64 machine with Gentoo 2.6 kernel,
so I installed the standard 4.0.20 distribution for AMD64.
Everything is fine except /proc/stat shows that all threads use just
cpu0.
The server is under a valuable load - 'mysqladmin status' says 800
queries/sec.
oops! - typing too fast for my own good. The fixed query should have been:
SELECT DISTINCT E.Title, E.ID, max(C.DateAdded) as maxdate
FROM Entries E, Comments C
WHERE C.EntryID = E.ID
GROUP BY E.Title, E.ID
ORDER BY maxdate desc
LIMIT 10
8-D
Shawn
[EMAIL PROTECTED] wrote on 08/17/2004 03:26:53
I don't think the engine is messing up here. I think you are getting
exactly what you asked for and I will explain why I think that.
You are asking for 3 things from 2 tables:
Entries.ID
, Entries.Title
, Comments.DateAdded.
If Entry #1 was called "My First Thread" and h
Ron Gilbert wrote:
I am trying to run this query...
select distinct E.Title, E.ID, C.DateAdded from
Entries E, Comments C
where C.EntryID = E.ID
order by C.DateAdded desc
limit 10
...to get the last 10 entries that had comments added to them, but the
DISTINCT is not returning distinct results. Wh
Im having some difficulty with the perl DBI/DBD in conjunction with a MySQL
upgrade. Here's the situation:
On the DB server machine, i have MySQL 4.1.3beta running for testing
upgrading, but MySQL 4.0.2 is also running (production).
I can connect locally on the DB server through various client
Eve,
From your earlier post, I see it should be
resume.Candidate_ID = candidate.Candidate_ID
===
I should also point out that there are several problems with your Location
matching. You have
candidate.Location LIKE '%CA%' OR 'California'
First, this evaluates as
(candidate.Location
I am trying to run this query...
select distinct E.Title, E.ID, C.DateAdded from
Entries E, Comments C
where C.EntryID = E.ID
order by C.DateAdded desc
limit 10
...to get the last 10 entries that had comments added to them, but the
DISTINCT is not returning distinct results. What I get is 10 entr
- Original Message -
From: "Chip Wiegand" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 17, 2004 12:29 PM
Subject: I can delete, add, but not update
> I don't know for sure, but I think I may have something wrong with
> permissions in MySQL. I have some web forms fro
Hi Eve,
You have made a very common mistake while using the "comma-join" method. I
think if I translate your implicit inner join to an explicit inner join
you will spot your own mistake:
SELECT resume.Section_Value, candidate.Location
FROM resume
INNER JOIN candidate
WHERE resume.Section_ID
You have a cartesian join because you do not have join criteria between the
resume and candidate tables.
-Original Message-
From: Eve Atley
To: [EMAIL PROTECTED]
Sent: 8/17/04 12:22 PM
Subject: Assistance with SQL syntax: pulling duplicates back
I think this is an easy question...I've s
These server settings are independent of one another. Query cache size
should not effect your *_timeout values. Can you post the my.cnf section
where these values are intialized?
-Original Message-
From: Linda
To: [EMAIL PROTECTED]
Sent: 8/17/04 10:10 AM
Subject: query_cache_size will impa
You are joining two tables, resume and candidate. Without a join condition,
you get a Cartesian product, each row of the first table paired with each
and every row of the second table. (Some on this list would go so far as to
say that's not even a join.) You need to specify how rows in resume
Hi,
MySQL 4.0.16 running on Red Hat Linux release 8.0
with 4 Intel XEON 2.40 GHz with InnoDB tables.
This is the stack trace :
0x81077c6 handle_segfault + 474
0x4002a929 _end + 935891041
0x8272ff8 sync_array_print_long_waits + 580
0x81a7328 srv_error_monitor_thread + 96
0x40024ada _end + 935866898
Are there any errors being caught by the web form or being logged to the
MySQL error log?
-Original Message-
From: Chip Wiegand
To: [EMAIL PROTECTED]
Sent: 8/17/04 11:29 AM
Subject: I can delete, add, but not update
I don't know for sure, but I think I may have something wrong with
perm
The following behavior occurs in MySQL 4.0.20 with both InnoDB and
MyISAM tables. It happens on the prmary-key index as well as other
indexed columns. The behavior does NOT occur in 3.23.56 and 3.23.58.
This is just setup...
mysql> select @x := 1;
mysql> explain SELECT @x := IF(MAX(id) > @x, MA
I think this is an easy question...I've set up a SQL statement like so:
SELECT resume.Section_Value, candidate.Location FROM resume, candidate WHERE
resume.Section_ID = '1' AND MATCH (resume.Section_Value) AGAINST ('html')
AND candidate.Location LIKE '%CA%' OR 'California'
--
And
I don't know for sure, but I think I may have something wrong with
permissions in MySQL. I have some web forms from which I can add new data
and delete data. But when I try to do an update of existing data the data
is not actually changed. Is it possible that the permissions are not set
up corr
Paul,
Interesting: I just tested your DSN-Less connection info. (including
port 3307) from my web server to another machine running mysql and it
connected fine - but only the first time. I used the IP address for my
SERVER variable. Then I changed it to the FQDN and it failed with the
same message
You'll probably want to have a look at section 5.10 in the manual:
http://dev.mysql.com/doc/mysql/en/Multiple_servers.html
Also, the mysqld_multi documentation may come in handy:
http://dev.mysql.com/doc/mysql/en/mysqld_multi.html
Cheers,
--V
Lou Olsten wrote:
We have successfully (and easily) inst
We have successfully (and easily) installed multiple versions of MySQL on
Windows and are now trying to do the same on Linux.
We have a Fedora machine successfully running 4.1, but we want to add 5.0 to
it as well. We installed 4.1 with RPM, so it put a bunch of MySQL files all
over the place.
I
Martijn Tonies wrote:
Re: Migration tools/plan from oracle 7.3 to Mysql 4.0With "application code", I meant
that you:
- have to change your queries so that they include the full VIEW sql,
because MySQL doesn't have an alternative
- have to recreate your stored procedures in application code and
Why did you quote an unrelated message?
Both GROUP BYs will produce one row for each unique combination of the
chosen columns. That is, the contents of the results will be identical.
MySQL automatically orders results by the grouped columns, so the ordering
of the resulting rows will differ bet
Hi,
I found out if I set "query_cache_size = 32M" to enable Query Cache,
interactive_timeout and wait_timeout will not be effected. It makes the connections
too many if the connections never timeout. How can I fix it?
Linda
How about
INSERT INTO original_table
SELECT MAX(f1), f2, f3 FROM new_table GROUP BY f2, f3;
Michael
Stephen E. Bacher wrote:
I had a similar problem, but my criteria for selecting the
value of "f1" was different; it's a date field and I wanted
only the rows with the most recent date value in th
Hi everyone,
I have recently downloaded mysql version 4.0.20 for Windows and I'm trying
to develop a client application in c++ using Microsoft Visual Studio 6.0. I
am having a few issues. Note, neither of these problems occur if I install
on RedHat Linux 7.3:
1) My client will not compile becaus
I can't tell you how to combine these results into one long list but you
can use MS query to link an Excel worksheet (through an ODBC or OLEDB
driver) to a database. After you set up all of your links (each link is
database-specific and requires a query from you), all you would have to do
is to
If you are using MyISAM tables you can create a fulltext index. This index
should give you better performance over a wildcarded like search provided
that no more than fifty percent of your rows do not contain the word or
words you will be searching for.
-Original Message-
From: Eve Atley
T
> and how is a foreign key displayed? as KEY or FOREIGN KEY???
No, not at all - it's shown in the CREATE TABLE statement - have
a try at it yourself.
You need to parse the info from the text. You can also not create a
FK by name, InnoDB will assign a name to it. Changing an attribute
on your con
Still no solution on this
anybody have any ideas?
It's not network, or hard drive, it's got to be some type of bug in my
config files, attached in original email
The master is on 4.0.20a and the slave is on 4.0.20a
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
I had a similar problem, but my criteria for selecting the
value of "f1" was different; it's a date field and I wanted
only the rows with the most recent date value in that field,
so only the "latest" of otherwise identical entries got inserted.
I ended up doing something like this:
create tempor
and how is a foreign key displayed? as KEY or FOREIGN KEY???
Martijn Tonies schrieb am 17.08.2004 12:24:
Hi,
how can i get all the foreign keys from a database? i used SHOW INNODB
STATUS; but i get an unknown error!
You can only get them on a per-table basis with a
SHOW CREATE TABLE statem
Re: Migration tools/plan from oracle 7.3 to Mysql 4.0Hi Narasimha,
Please reply to the MySQL list instead of me personally only.
> How we can write the equivalent code for triggers of
>oracle in Mysql?. Shall we do it by using User Defined
>Functions?. Can we use database queries inside the user
Re: Migration tools/plan from oracle 7.3 to Mysql 4.0With "application code", I meant
that you:
- have to change your queries so that they include the full VIEW sql, because MySQL
doesn't have an alternative
- have to recreate your stored procedures in application code and do you work at the
cl
Hi,
> how can i get all the foreign keys from a database? i used SHOW INNODB
> STATUS; but i get an unknown error!
You can only get them on a per-table basis with a
SHOW CREATE TABLE statement.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS
> Thank you for your response. Could any one give more
clarification on the alternatives for Views, Stored procedures, triggers and
contraints of oracle in Mysql 4.0 classic, as MySql 4.0 classic wonot
support the InnoDB storage engine.
>
Well, what other alternative do you have but appl
Hi,
Thank you for your response. Could any one give more clarification on the
alternatives for Views, Stored procedures, triggers and contraints of oracle in Mysql
4.0 classic, as MySql 4.0 classic wonot support the InnoDB storage engine.
Thanks,
Narasimha
-Original Mes
Oropeza Querejeta, Alejandro wrote:
Hi,
I have one table that is presenting strange behaviour, we set the
varchar field for not allow nulls so, on 5% of the records the
application is inserting blanks but when we select the value and we set
the condition ="" it returns the same as " " and "
hi!
how can i get all the foreign keys from a database? i used SHOW INNODB
STATUS; but i get an unknown error!
thanks!
--
G & H Softwareentwicklung GmbH Tel.: +49(0)7451/53706-20
Robert-Bosch-Str. 23 Fax: +49(0)7451/53706-90
D-72160 Horb a.N. http://www.guh-sof
First: please don't hijack threads... And don't quote them completely
if you do.
> I am new to MySql. Could you please let me know the different
migration tools avialable for the migration of oracle 7.3 database to mysql
4.0 classic version.
You could try the Schema Migrator tool in Data
53 matches
Mail list logo