Re: MySQL 5 Application Error

Mulugeta Maru [EMAIL PROTECTED] wrote: I am using MySQL 5 issuing the following query when the application died on me three times.Query: Select name, year_of_birth from players where year_of_birth = ALL(select year_of_birth from players) Note: If I only use the first part of the query (i.e.

Replication broken after upgrade from 4 to 4.1

Hi everybody, I have three mysql servers doing a circular replication. They (still) run Redhat 7.3. I started with Mysql 3.23, upgraded to 4 and yesterday I tried 4.1. I'm using official mysql rpms. Now the replication is broken. One server always says Connecting to master. The error log says:

Re: sub-query

Lorderon [EMAIL PROTECTED] wrote: Since I don't use MySQL 4.1, is this query OK? SELECT SQL_CALC_FOUND_ROWS * FROM ((SELECT * FROM t1 WHERE id100 GROUP BY country) UNION ALL (SELECT * FROM t2 WHERE id150 GROUP BY country) LIMIT 0,10); I want this to return all the

An doubt about mysql version 4.0.x agains 4.1.x

Dear Friend an friend of mine told that the follow line bellow dont work with mysql version 4.0.x * Support for subqueries and derived tables This mean query like : SELECT A.* FROM (SELECT * FROM TESTE WHERE X = Y) A WHERE COL1 = 3 is this true, or mysql version 4.0.x work properly with this

locking issues

Hi Group, A question about locking. In my code (delphi but that doesn't much matter) I fire ad-hoc queries (select). Before the query i fire a locking query (read) for that particular tables. Something like this: lock tables tab1 a read, tab2 b read (execute) select * from tab1 a, tab2 b

Re: An doubt about mysql version 4.0.x agains 4.1.x

Luiz Rafael Culik Guimaraes [EMAIL PROTECTED] wrote: Dear Friend an friend of mine told that the follow line bellow dont work with mysql version 4.0.x * Support for subqueries and derived tables This mean query like : SELECT A.* FROM (SELECT * FROM TESTE WHERE X = Y) A WHERE COL1 = 3

Re: msSQL - MySQL (exhanging data between the two)

I haven't tried, but it seems quite difficult, for one thing, both sql engines are very differents. So the short answer would be a plain no. Now trying something exotic would be making a odbc bridge between the two dbs and then use some scripted solution it would be possible, something like java

Re: Drop and Add Functions in Mysql 4

You could try MySQL 5(it is in alpha state), which comes with stored procedures, mixing stored procedures and prepered statements could be a possibility. About Sybex's book, haven't read it, but Paul's book (Oreilly's) is very nice. IMHO Best Regards On Thu, 2004-03-04 at 23:23, [EMAIL

Re: Innodb table space getting filled up without any increase in actual rows!!

Thanks for your valuable suggestions. I'm committing transactions, but not all. Only the transactions which do insert/delete, commit and not all. So I think the better solution for me is to switch to Read Committed isolation mode, since I don't require Repeatable Read Isolation for my

SV: Querying serveral databases (Views?)

No I did not. Thank you very much! Regards Daniel -Ursprungligt meddelande- Från: Jeff Mathis [mailto:[EMAIL PROTECTED] Skickat: den 5 mars 2004 00:48 Till: Daniel Ek Kopia: [EMAIL PROTECTED] Ämne: Re: Querying serveral databases (Views?) in case someone hasn't answered you yet.. do

Re: Innodb table space getting filled up without any increase in actual rows!!

Sp. Raja, - Alkuperäinen viesti - Lähettäjä: Sp.Raja [EMAIL PROTECTED] Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED] Kopio: mysql [EMAIL PROTECTED] Lähetetty: Friday, March 05, 2004 2:28 PM Aihe: Re: Innodb table space getting filled up without any increase in actual rows!! Thanks for

RE: MySQL 5 Application Error

Yes. I tried it at least three times and MySQL crashes i.e. I get disconnected. I do use Windows 2000 to run MySQL. -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Friday, March 05, 2004 5:02 AM To: [EMAIL PROTECTED] Subject: Re: MySQL 5 Application Error

Partial Replication ?

Hello, I have a database which is flushed every four hours, and I want to replicate it without replicating the delete queries . Is this possible ? (sorry for my awful english) Rémy BONNET. Yahoo! Mail : votre e-mail personnel et gratuit qui vous suit

maintaining logs...

hi, i m using mysqld Ver 4.0.17-standard for pc-linux on i686 (Official MySQL RPM) and i want to maintain trace logs and debug logs to see what my mysql server is doing and what error it encounters, if any. help will be highly appreciated. bye Abubakr

OT:select in mysql

Hi, i've a little problem with query. I have two tables where Table1 id desc Table2 id desc I want a list of table1.id not included in Table2 but i don't find the solution! Example Table1: --- id ! Desc --- 1! xx 2! Xx 3

MySQL Administrator

Hello list I have download the MySQL Administrator twice and when trying to gzip It collapse. Does anybody know how and why? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: OT:select in mysql

I want a list of table1.id not included in Table2 but i don't find the solution! I _*think*_ this will work for you. If I'm wrong, I'm sure someone will come behind and correct me: select table1.id from table1 left outer join table2 on table1.id = table2.id where table2.id = NULL; Chris

Re: OT:select in mysql

select table1.id from table1 left outer join table2 on table1.id = table2.id where table2.id = NULL; Sorry, that last should be where table2.id IS NULL; Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

ibdata1

I lost my ibdata1 file, I don't have backup, and now my tables InnoDB don't open. MySQL error: 1016 (Can't open the file: 'table.InnoDB') please, give me a solutions. Are 27 tables. please. Wilker Azevedo __ Acabe com

Re: OT:select in mysql

I want a list of table1.id not included in Table2 but i don't find the solution! SELECT * FROM table1 LEFT JOIN table2 USING (id) WHERE table2.id IS NULL PB

Re: MySQL 5 Application Error

Maru, Mulugeta [EMAIL PROTECTED] wrote: Yes. I tried it at least three times and MySQL crashes i.e. I get disconn= ected. I do use Windows 2000 to run MySQL.=20 Could you provide structure of table 'players'? (Output of SHOW CREATE TABLE statement or mysqldump program) -Original

4.1.1 Problem with SELECT INTO OUTFILE

It seems that each time we select into an OUTFILE that already exists (re-use a name) the server crashes. Anyone have any ideas if this is a setting or just a bug? Thanks. Chris.

4.0.18 or 4.1.1-alpha?

I have to install MySQL in our web servers. I don't know if choosing 4.0.18 stable version or 4.1.1-alpha. I'd prefer the first one, but in this case I'd lose some important features. What do you suggest me? Thank's Samuele ca2000 padova (italy) -- MySQL General Mailing List For list archives:

table name is lower case if there is an index on it (4.0.18 )

Hi, I have a problem with mysql 4.0.18 on WindowsXP I set the lower_case_table_names=2 as it is mentioned for windows at the mysql website. (before I'm using version 4.0.15 and had set it to 0) so the tablenames should be stored in this case as I wrote it. So I create a table in Java

RE: BOM Select statement

-Original Message- From: Wesley Baker [mailto:[EMAIL PROTECTED] What I want is to know how to build a SELECT statement which will return all components of mynewpc and navigate down the bill-of-materials and also return all the components for the case, the powersupply and even

SET PASSWORD troubles on mysql 4.0.12 (ERROR 1044)

Hello, All users should be able to change their own password on any mysql. I have trouble to allow this feature on mysql 4.0.12, on mysql 3.23.56 it works. Let me demonstrate it: on mysql 3.23.56: as root: mysql create database test_dummy; Query OK, 0 rows affected (0.00 sec) mysql

Re: SET PASSWORD troubles on mysql 4.0.12 (ERROR 1044)

At 18:10 +0100 3/5/04, Bogdan Lobodzinski wrote: Hello, All users should be able to change their own password on any mysql. I have trouble to allow this feature on mysql 4.0.12, on mysql 3.23.56 it works. Let me demonstrate it: on mysql 3.23.56: as root: mysql create database

Re: 4.0.18 or 4.1.1-alpha?

If it's going to be a full production environment where stability is crucial, use 4.0.18. If it is going to be for a development proyect, you can use 4.1.1 and enjoy the new features. Anyway, 4.1.1 seems to be quite stable if you ask me. But it might depend on how much are you willing to risk

mysqldump of UTF8 db

Hi all, I was just testing if my utf8 table would restore properly. When I execute mysqldump -umysqladmin -pmysqladmin test C:\mysql\bin\test-bp.sql No tables are created. Instead I what get in my DOS console (WinXpPro) is the beginning and end of the dump file (having skipped all the

DROP tables question(s)?

Howdy -- How can I drop all tables in a databases? How can I drop tables beginning with foo_ Note, I don't have permissons to just drop the db. TX, David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SET PASSWORD troubles on mysql 4.0.12 (ERROR 1044)

On Fri, 5 Mar 2004, Paul DuBois wrote: At 18:10 +0100 3/5/04, Bogdan Lobodzinski wrote: Hello, All users should be able to change their own password on any mysql. I have trouble to allow this feature on mysql 4.0.12, on mysql 3.23.56 it works. Let me demonstrate it: on mysql 3.23.56:

Re: 4.0.18 or 4.1.1-alpha?

Hi, If you use any 3rd party clients like EMS mysql manager. Check that they have updated their binaries to support changes in 4.1, if they have not, you won't be able to connect to 4.1. That was a big pain for me. I wanted to start using 4.1 on a backup server part time. But we use EMS a

Re: 4.0.18 or 4.1.1-alpha?

If you use the old-password settings in your server, ems should connect with out a hitch Best Regards! On Fri, 2004-03-05 at 13:41, Eric wrote: Hi, If you use any 3rd party clients like EMS mysql manager. Check that they have updated their binaries to support changes in 4.1, if they have

Re: Major problem converting MyISAM to InnoDB

Cliff, I do not think this is a threading issue. This looks now more like a wrong .frm file problem. Please use innodb_table_monitor as I suggested earlier, and compare the table definition inside InnoDB to what SHOW CREATE TABLE says. Best regards, Heikki Innobase Oy InnoDB - transactions, row

Re: SET PASSWORD troubles on mysql 4.0.12 (ERROR 1044)

At 18:38 +0100 3/5/04, Bogdan Lobodzinski wrote: On Fri, 5 Mar 2004, Paul DuBois wrote: At 18:10 +0100 3/5/04, Bogdan Lobodzinski wrote: Hello, All users should be able to change their own password on any mysql. I have trouble to allow this feature on mysql 4.0.12, on mysql 3.23.56 it

MySQL Dump Command Does Not Consider Foreign Key Dependencies

Description: The current mysqldump utility does an alphabetical dump of the tables as well as a row by row dump of the data following each table declaration. This is adequate enough for most databases; however, if there are strict foreign key constraints, the

Re: Major problem converting MyISAM to InnoDB

Cliff wrote: I think I may have gotten closer to the root of the problem. It seems that the field named 'comments' is the one that crashes the server when it is selected. Here is the output of the logs when I do 'select comments from allusa': 040304 23:14:52 mysqld restarted 040304 23:14:53

Re: How can I disable 'max_connect_errors'?

Daevid Vincent wrote: Is there a way to disable this 'max_connect_errors' thing? http://www.mysql.com/doc/en/Blocked_host.html Tried max_connect_errors=0 but then it shows up as max_connect_errors=1 What is the 'max' that this value can be in case? We have it set to 10,000 now, but that only

Re: Replication broken after upgrade from 4 to 4.1

Stefan Kuhn wrote: Hi everybody, I have three mysql servers doing a circular replication. They (still) run Redhat 7.3. I started with Mysql 3.23, upgraded to 4 and yesterday I tried 4.1. I'm using official mysql rpms. Now the replication is broken. One server always says Connecting to master.

Re: slave hotbackup question

Mark, http://www.innodb.com/manual.php#advanced.slave describes how to set up a new slave from a hot backup of a master. If you take a hot backup of a slave, and want to use it to set up a new slave, then the important coordinate is the MASTER binlog position that mysqld prints when you start

Please help with join issue

I need help with rewriting a sql query. Nested queries that work in MS databases apparently do not work in MySQL databases. Here is what I need in MS query pseudo code: SELECT table1.myfield1, table2.myfield2 FROM table1, table2 WHERE table1.key=table2.key AND myfield1=something AND

lire des fichiers windev5

Bonjour, La possibilité de lire directement les fichiers windev5 au format hyperfile pour exploiter les données ou les migrer sous mysql existe-t-elle? Merci. Pierre Marcotte -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: 4.0.18 or 4.1.1-alpha?

Hi, hmm, mysql support needed to know that a few weeks ago! :) Thanks, Eric At 09:58 AM 3/5/2004, Victor Medina wrote: If you use the old-password settings in your server, ems should connect with out a hitch Best Regards! On Fri, 2004-03-05 at 13:41, Eric wrote: Hi, If you use any 3rd

Re: Hitting max_connections - safe to raise this?

Alex Greg wrote: Hi, Our main database server is a 2 x PIII 1.2Ghz with 1.5GB RAM and a 73GB SCSI RAID-5 made up of 3 36GB disks. It does between 300 and 1200 queries per second. The read to write ratio is about 4:1. My problem is that we're hitting our max_connections more and more frequently.

Iterating thru FullText Index

Is there any way to iterate thru the keys in a fulltext index? This issue does not come up for other indexes since ORDER BY can achieve this: For example if table t is indexed on part_id SELECT DISTINCT part_id FROM t ORDER by part_id; will return all keys in index order Is there a way to

Re: lire des fichiers windev5

Bonjour Pierre, Non mysql ne support pas un format hyperfile. C'est un format propriétaire. S'il il est possible d'exporter les donnees en format ASCII ça pouvait marcher avec un mysqlimport ou load data commande. Voici le doc en français: http://www.mysql.com/doc/fr/mysqlimport.html En plus

How long should I keep binary logs?

Two INNODB/mysql/Win questions from a new user: [1] How long should I keep around copies of binarylog? (They're used to recover in case of failure, yes? (I'm also shutting down the databases and dumping them each night to a large text file as backup, too.) [2] Can anyone offer advice (or links

RE: MySQL Dump Command Does Not Consider Foreign Key Dependencies

i turn off the checks before a dump in order to restore it properly. In my scripts looks like: echo SET FOREIGN_KEY_CHECKS=0; ${mysql_backup_directory}/${2}/${database_filename} mysqldump --opt -h $2 -P $3 -u $db_username --password=$db_password $1

Re: MySQL Dump Command Does Not Consider Foreign Key Dependencies

Stephen, in = 4.0, you should put SET FOREIGN_KEY_CHECKS=0; at the start of the dump file. In 4.1, mysqldump knows to add to a dump file a line /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0*/ to disable foreign key checks in the dump file. Best regards,

Re: mysqlbinlog: unknown command errors

Hi Sasha, Thanks for getting back to me on this. I was hoping to use the binlogs as an alternative to rollback.commit in the event that someone for example hoses a table by doing an update and forgetting the where clause. I want to be able to load a snapshot, dump the binlogs out and find and

The index handles accented UTF-8 chars badly

I have a problem with index on a UTF-8 based db/table and mySQL 4.1 (I have tried 5.0 too). I run the mysqld with the --default-character-set=utf8 flag and I'm certain that it's UTF-8 data that I'm putting into the database. To reproduce, follow these simple steps.

Re: DROP tables question(s)?

David Jackson [EMAIL PROTECTED] wrote: Howdy -- How can I drop all tables in a databases? Get list of table names with SHOW TABLES FROM db_name and compose DROP TABLE statement. How can I drop tables beginning with foo_ In this case you can use SHOW TABLES .. LIKE 'foo\_%' statement to get

Index continues to fail on large database

On February 5, I posted this message to the list describing my problem: http://archives.neohapsis.com/archives/mysql/2004-q1/2398.html I received the following response and posted a reply to this response, respectively reply: http://archives.neohapsis.com/archives/mysql/2004-q1/2426.html

Re: 4.1.1 Problem with SELECT INTO OUTFILE

Chris Fossenier [EMAIL PROTECTED] wrote: It seems that each time we select into an OUTFILE that already exists (re-use a name) the server crashes. Anyone have any ideas if this is a setting or just a bug? It's known bug: http://bugs.mysql.com/bug.php?id=2123 -- For technical

Re: Partial Replication ?

Bonnet R?my [EMAIL PROTECTED] wrote: Hello, I have a database which is flushed every four hours, and I want to replicate it without replicating the delete queries . Is this possible ? (sorry for my awful english) With mysqlbinlog utility or with SHOW BINLOG EVENTS statement find needed

Re: mysql_get_metadata with SHOW queries

Nate Blanchard [EMAIL PROTECTED] wrote: According to the C API docs on mysql_get_metadata: If a statement passed to mysql_prepare() is one that produces a result set, mysql_get_metadata() returns the result set metadata in the form of a pointer to a MYSQL_RES structure that can be used to

You are dismissed

-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SET PASSWORD troubles on mysql 4.0.12 (ERROR 1044)

On Fri, 5 Mar 2004, Paul DuBois wrote: At 18:38 +0100 3/5/04, Bogdan Lobodzinski wrote: On Fri, 5 Mar 2004, Paul DuBois wrote: At 18:10 +0100 3/5/04, Bogdan Lobodzinski wrote: Hello, All users should be able to change their own password on any mysql. I have trouble to allow

Re: Please help with join issue

Erica L Ridley [EMAIL PROTECTED] wrote: I need help with rewriting a sql query. Nested queries that work in MS databases apparently do not work in MySQL databases. Here is what I need in MS query pseudo code: SELECT table1.myfield1, table2.myfield2 FROM table1, table2 WHERE

What causes a crashed table?

Hi, I ran into a slight problem this morning where MySQL suddenly wouldn't recognize a table anymore. After doing a myisamchk on it, it listed the table as having crashed. myisamchk -r on the table fixed the problem, but I am concerned that this error happened in the first place. I've tried to

Relationship between libz and libmysqlclient libraries

I notice that, while building C applications that use the libmysqlclient library, I sometimes need to link with libz library, depending on which system I am compiling on. The different systems have different mysql versions installed, so is this due to the difference in the versions? Can

MySQL C API license

Folks, What license does the MySQL C API fall under? I am looking to add client support to a game that I am creating, but need to know the terms of the license etc. -Ron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: The index handles accented UTF-8 chars badly

Hi! On Mar 05, Rikard Bogren wrote: I have a problem with index on a UTF-8 based db/table and mySQL 4.1 (I have tried 5.0 too). I run the mysqld with the --default-character-set=utf8 flag and I'm certain that it's UTF-8 data that I'm putting into the database. To reproduce, follow these

Re: Iterating thru FullText Index

Hi! On Mar 05, Todd Burke wrote: Is there any way to iterate thru the keys in a fulltext index? This issue does not come up for other indexes since ORDER BY can achieve this: For example if table t is indexed on part_id SELECT DISTINCT part_id FROM t ORDER by part_id; will return

Re: MySQL C API license

To my knowledge it is GPL. Bernard On Friday 05 March 2004 17:52, Ronald J. Yacketta wrote: Folks, What license does the MySQL C API fall under? I am looking to add client support to a game that I am creating, but need to know the terms of the license etc. -Ron -- MySQL General

MySQL 5 Application Error

Table structure: CREATE TABLE `players` ( `PLAYERNO` smallint(6) NOT NULL default '0', `NAME` char(15) NOT NULL default '', `INITIALS` char(3) default NULL, `YEAR_OF_BIRTH` smallint(6) default NULL, `SEX` char(1) default NULL, `YEAR_JOINED` smallint(6) NOT NULL default '0', `STREET`

query date ranges

I have been trying this is several ways, currently I have a mess MySQL 4.1.1 PHP as the interface I have a table of with a date range called seasons. in it I have two date ranges and an amount to be charged for each day in the range 2004-01-01 00:00:00 2004-06-01 00:00:0044 2004-06-02

Re: Relationship between libz and libmysqlclient libraries

At 14:17 -0800 3/5/04, John Ling wrote: I notice that, while building C applications that use the libmysqlclient library, I sometimes need to link with libz library, depending on which system I am compiling on. The different systems have different mysql versions installed, so is this due to

Re: MySQL 5 Application Error

At 19:44 -0600 3/5/04, Mulugeta Maru wrote: Table structure: CREATE TABLE `players` ( `PLAYERNO` smallint(6) NOT NULL default '0', `NAME` char(15) NOT NULL default '', `INITIALS` char(3) default NULL, `YEAR_OF_BIRTH` smallint(6) default NULL, `SEX` char(1) default NULL, `YEAR_JOINED`

Problems with Mysql 4.0.15+Tomcat 4.0

Hi, i m using mysql 4.0.15 and tomcat 4 as a webserver on linux 8 machine, now the problem that i am facing is that while testing my web application when i send too many refresh requests to the web page, the server's CPU utilization reaches to 100% for a very long duration of time and on

Can my.cnf actually lessen performance?

OS X 10.3 and mysql 4.x, I have a situation where after time certain queries get really slow, in the area of 30 seconds. I seem to have pinned it down to my use of my-large.cnf. If I remove this file and let just the mysql defaults in, then I seem to not have the trouble, at least, I have 8