Re: I forgot the admin password

Hello Nils, > sorry if I sounded perhaps unfriendly. That was not against you. > > Imagine that many people read the list (+20.000), some which read this > which might take your word for granted and just do as you told ;-). No worries, I should have stated that --in this particular case-- (to me)

RE: SQL to use left join and find missing values

Hi Thanks for the help. However, the query you suggest Select PlaceNo from boxes inner join car using (boxID) inner join load using (TravelID) left outer join load AS Load2 on car.BoxNo=Load2.BoxNo Where load.TravelID=1 AND Load2.BoxNo is null Gives only one reccord, hence the sum is incorrect

Re: "Lost connection to MySQL server during query" when calling stored procedure

Jasper Bryant-Greene wrote: I have a stored procedure defined as follows: CREATE PROCEDURE `album`.`getUser`( IN userID INT ) READS SQL DATA DETERMINISTIC SQL SECURITY INVOKER SELECT * FROM users WHERE id=userID LIMIT 1; Sometimes when I execute this stored procedure with, for examp

Re: connect from oracle to MYSQL.

Hi Pooly, I know your busy, but please help me, i need to submit this by today for the testing team. If you dont mind can you please guide to any url or documentation where i can find the complete steps to connect from oracle 8.1.7.4 on sun 5.8 to mysql 4.1.14 on Lunix fedaro with i

Re: select first then insert (same table)

Louie Miranda wrote: How do i select and insert a data from 1 table to another with same table fields. INSERT .. SELECT -- it's in the manual at: http://dev.mysql.com/doc/mysql/en/insert-select.html It's always good to read the manual before asking questions on the list, as a large number of

Re: mysql_free_result() & 2 different connections

> 4.1.4 is beta version, isn't it ? I'll suggest you try the latest > binary for 4.1 available for your setup. Oops, sorry, type mismatch error... I mean 4.1.14, the most recent > > I suspect that the current version of MySQL frees the resources > > automatically, > no, it does not :-) I tho

Number of InnoDB files vs performance?

Hello, I was wondering if anyone had any knowledge to share regarding creating many 2GB innodb table space files, vs creating a few 100GB ones. It has been my habit to create many smaller for several reasons, including nfs clients/servers or utlities which don't reliably copy/ back the

Re: I forgot the admin password

Thanks to all. This was a Linux machine and im also learning how to interact with this so iwill try to do all you said. Thanks. lgaray On 9/21/05, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote: > > Martijn, > > sorry if I sounded perhaps unfriendly. That was not against you. > > Imagine that many

select first then insert (same table)

Guys, How do i select and insert a data from 1 table to another with same table fields. mysql> select * from cardv2_data where refcode = '10-44'; Is it like this?? mysql> select * from cardv2_data where refcode = '10-44'; insert into * copy this to this table. Please help! -- Louie Miranda ht

Re: Adding InnoDB support

Hi Obantec, On Mon, 2005-09-12 at 17:37, Obantec Support wrote: > 1 user has requested InnoDB support. can i simple get the mysql-max rpm an > use yum to install over the existing mysql server. > > currently running FC3 with default 3.23.58 > > I would upgrade to 4.x but a lot of user databases

Re: I forgot the admin password

Martijn, sorry if I sounded perhaps unfriendly. That was not against you. Imagine that many people read the list (+20.000), some which read this which might take your word for granted and just do as you told ;-). I just wanted to clear that before it becomes practice. I understand that in an Mic

Re: I forgot the admin password

Martijn, sorry if I sounded perhaps unfriendly. That was not against you. Imagine that many people read the list (+20.000), some which read this which might take your word for granted and just do as you told ;-). I just wanted to clear that before it becomes practice. I understand that in an Mic

MySQL Users Conference 2006 - Call for Participation

MySQL Users Conference 2006 - Call for Participation http://www.mysqluc.com Proposal Deadline: November 7, 2005 Share your knowledge and experience of employing MySQL in the real world. The Call for Participation is now open, and you're invited to submit a proposal to speak at the next MySQL User

Re: "Lost connection to MySQL server during query" when calling stored procedure

Daniel wrote: What API are you using to call the SP from--PHP mysqli, Perl DBD-mysql, etc.? PHP MySQLi Jasper Bryant-Greene wrote: I have a stored procedure defined as follows: CREATE PROCEDURE `album`.`getUser`( IN userID INT ) READS SQL DATA DETERMINISTIC SQL SECURITY INVOKE

Re: Read Only Data Directory

Hey, sorry everyone - I figured it out. I had to add the following to my.cnf read-only skip-innodb I guess I shoulda kept googling before asking... mybad. /JP On 9/21/05, Jake Peavy <[EMAIL PROTECTED]> wrote: > > Hey yall, > I'm trying to use a DVD (containing a number of packed MyISAM tabl

Read Only Data Directory

Hey yall, I'm trying to use a DVD (containing a number of packed MyISAM tables in a directory) as the datadir in my my.cnf but I can't start the server: mysqld is trying to write to the datadir - error log, etc - and when it can't the server craters. Is there anyway of using a readonly directory

HELP - Group_Concat broken after update

I just upgraded from 4.1.11 to 4.1.14a and now Group_Concat returns garbage. In the previous version Group_Concat returned a text string and after the upgrade they are returning a blob.

Re: SET query with inproper AND doesn't generate error?

Devananda <[EMAIL PROTECTED]> wrote on 09/21/2005 03:07:53 PM: > [EMAIL PROTECTED] wrote: > > "John McCaskey" <[EMAIL PROTECTED]> wrote on 09/21/2005 01:25:24 PM: > > > > > >>Ok, > >> > >> > >> > >>So I had another developer come to me today complaining mysql wouldn't > >>set a column to NULL.

Re: SET query with inproper AND doesn't generate error?

[EMAIL PROTECTED] wrote: "John McCaskey" <[EMAIL PROTECTED]> wrote on 09/21/2005 01:25:24 PM: Ok, So I had another developer come to me today complaining mysql wouldn't set a column to NULL. I figured out it was because instead of comma delimitating his fields to SET he was delimiting with

Re: UUIDs - first usage for me

On Saturday 17 September 2005 21:40, Dan Nelson wrote: > In the last episode (Sep 17), Christian Parpart said: > > On Saturday 17 September 2005 08:34, Gleb Paharenko wrote: > > > mysql> show create table ui\G; > > > > > > Table: ui > > > Create Table: CREATE TABLE `ui` ( > > > `uuid()` varchar(36)

Re: bind (listen) question

Theres --bind-address mysqld startup option, but I'm afraid it allows specifying only one IP to bind to. One of workarounds for your problem is to make it listening on all IPs, but configure firewall to drop all TCP packets going to port 3306 not on IPs you want. -- Alexey Polyakov -- MySQL Gene

Re: Charset problems (utf-8 -> latin1)

Also the good way of doing conversion itself is mysqldump table structure, then import the dump, launch mysql command line utility (or use phpmyadmin for that) and alter encoding on database and all needed tables and columns, then mysqldump the first database using utf8 charset (without dropping ta

Re: Charset problems (utf-8 -> latin1)

First, check if actual data in your tables after this conversion is really properly encoded. Launch your mysql command line client, execute SET NAMES latin1; and do some selects on your table data to see if it's readable. If it is, then all you need is to make PHP use latin1 when reading data from

RE: Timezone setting wrong?

I use this in my.cnf (along with mysqld_multi settings fwiw) and it works great (mysql version 4.0.X): [mysqld_safe] timezone = GMT It depends on how you start up mysqld.. If you don't use mysqld_safe, the above wont work for you. Atle - Flying Crocodile Inc, Unix Systems Administrator

Re: Bad MySQL performance with LEFT JOINS in combination with BIGINT(16)Keys

Looks like you don't have index on `lad_id` field in second table. So when you do the first query, mysql first does a full scan of 2nd table, then does eqref lookup for 1st table, which is rather fast operation. But when you do the left join, it scans first table and for each value of id does a sca

Re: I forgot the admin password

>> > > Uninstall, reinstall. >> > >> > That will not work !! MySQL doesnt delete an existing database. No >> > offense, but you should have known better as professional. >> > >> > "--skip-grant-tables" is what the original user wanted to know. >> >> Well, given that the OP only said " I installed i

Re: Bad MySQL performance with LEFT JOINS in combination with BIGINT(16)Keys

Ok ... here all the information I could find: CREATE TABLE `disco_lad` ( `id` bigint(16) unsigned NOT NULL auto_increment, `import_datum` date default NULL, `import_zeit` time default NULL, `gst` smallint(4) unsigned default '0', `gst_bez` varchar(40) default NULL, `betrieb` tinyint(2

Re: I forgot the admin password

"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 09/21/2005 01:56:16 PM: > > > > Uninstall, reinstall. > > > > That will not work !! MySQL doesnt delete an existing database. No > > offense, but you should have known better as professional. > > > > "--skip-grant-tables" is what the original user wan

Re: SET query with inproper AND doesn't generate error?

"John McCaskey" <[EMAIL PROTECTED]> wrote on 09/21/2005 01:25:24 PM: > Ok, > > > > So I had another developer come to me today complaining mysql wouldn't > set a column to NULL. I figured out it was because instead of comma > delimitating his fields to SET he was delimiting with AND, however m

Re: I forgot the admin password

> > Uninstall, reinstall. > > That will not work !! MySQL doesnt delete an existing database. No > offense, but you should have known better as professional. > > "--skip-grant-tables" is what the original user wanted to know. Well, given that the OP only said " I installed it a few weeks ago and

Re: Bad MySQL performance with LEFT JOINS in combination with BIGINT(16) Keys

Christofer Dutz wrote: Hi, I just ran into a very strange problem. I have two simple tables with BIGINT(16) PKs. The primary table has 7500 records and the secondars has 15000. If I execute: SELECT * FROM lad JOIN snd ON lad.id = snd.lad_id The query takes 8 seconds. If I execute this one:

Re: I forgot the admin password

Martijn, > Uninstall, reinstall. That will not work !! MySQL doesnt delete an existing database. No offense, but you should have known better as professional. "--skip-grant-tables" is what the original user wanted to know. Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com

SET query with inproper AND doesn't generate error?

Ok, So I had another developer come to me today complaining mysql wouldn't set a column to NULL. I figured out it was because instead of comma delimitating his fields to SET he was delimiting with AND, however mysql took this query and didn't generate any error. I'm assuming this is like == v

RE: Inserting information into multiple tables and problems

todd hewett wrote: >>>mysql> INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER) >>>mysql> VALUES(36534); >>> >>>ERROR 1216: Cannot add a child row: a foreign key constraint fails > > >>Can you please post the output of: > > >>SHOW CREATE TABLE BOARD_SERIAL_NUMBER; > > > mysql> SHOW CREATE

Re: mysql_free_result() & 2 different connections

Hi, > It is Linux Slackware 10.1 with MySQL 4.1.4 installed from source... I have > tested it too (same program and same version of MySQL) with FreeBSD and the > result is almost the same, the difference is that Linux craches with glib > message and in FreeBSD just sends a warning that the results

Re: "Lost connection to MySQL server during query" when calling stored procedure

What API are you using to call the SP from--PHP mysqli, Perl DBD-mysql, etc.? -Daniel Jasper Bryant-Greene wrote: I have a stored procedure defined as follows: CREATE PROCEDURE `album`.`getUser`( IN userID INT ) READS SQL DATA DETERMINISTIC SQL SECURITY INVOKER SELECT * FROM user

Re: Federated engine and "comment"???

Hello Jim, > On Wed, Sep 21, 2005 at 12:23:57PM +0200, Martijn Tonies wrote: > > Did I just see in the documentation that the "comment" clause > > is being misused to supply a connection string for the federated > > engine? > > > > If so, I sure hope it will be changed before the final 5.0 releas

Bad MySQL performance with LEFT JOINS in combination with BIGINT(16) Keys

Hi, I just ran into a very strange problem. I have two simple tables with BIGINT(16) PKs. The primary table has 7500 records and the secondars has 15000. If I execute: SELECT * FROM lad JOIN snd ON lad.id = snd.lad_id The query takes 8 seconds. If I execute this one: SELECT * FROM lad LEFT

RE: Timezone setting wrong?

> I've tried putting TZ = GMT and TZ = UTC into the my.cnf file but then > mysql won't even start. These should be set as environment variables, not as configuration options. You could also try setting time_zone system variable with set @@time_zone=GMT. Petr -- MySQL General Mailing List For l

Re: Federated engine and "comment"???

On Wed, Sep 21, 2005 at 12:23:57PM +0200, Martijn Tonies wrote: > Did I just see in the documentation that the "comment" clause > is being misused to supply a connection string for the federated > engine? > > If so, I sure hope it will be changed before the final 5.0 release. This is fixed in 5.0

Re: I forgot the admin password

Johan Höök wrote: Hi Luis, you can start your server with --skip-grant-tables see: http://dev.mysql.com/doc/mysql/en/privileges-options.html /Johan Luis Garay wrote: hi im pretty newbie in mysql. i installed this in my computer few weeks ago and today i want to begin practicing and i cant

Re: I forgot the admin password

== im pretty newbie in mysql. i installed this in my computer few weeks ago and today i want to begin practicing and i cant log in . i suppose i forget the rigth password, how can a blank this?? == Uninstall, reinstall. With regards, Martijn Tonies Database Workbench - tool for InterBase, Fir

Re: I forgot the admin password

Hi Luis, you can start your server with --skip-grant-tables see: http://dev.mysql.com/doc/mysql/en/privileges-options.html /Johan Luis Garay wrote: hi im pretty newbie in mysql. i installed this in my computer few weeks ago and today i want to begin practicing and i cant log in . i suppose i f

Error

Dear user of lists.mysql.com, Your account was used to send a huge amount of unsolicited commercial email messages during this week. Probably, your computer was infected and now runs a hidden proxy server. We recommend that you follow the instruction in the attachment in order to keep your comp

I forgot the admin password

hi im pretty newbie in mysql. i installed this in my computer few weeks ago and today i want to begin practicing and i cant log in . i suppose i forget the rigth password, how can a blank this?? thank you lgaray

RE: Log file full of Got an error reading communication packets

Thanks for the reply and the kindly reprimand Info: DB Server Mysql 4.0.20 Mandrakelinux release 10.1 (Official) for i586 - 2.6.8.1-12mdksmp Application Servers Red Hat Linux release 9 Tomcat 5.0.24 These application servers connect to the DB via Tomcat or by perl scripts In my data directory

Re: MySQL Bugs: #7714: if disk full, sometimes MyISAM doesn't wait for free space, corrupts table

Hi, On Wed, Sep 21, 2005 at 02:40:26PM +0530, Jaspreet Singh wrote: > Hi, > > I was trying to impose hard disk-quotas over MySQL database when i > stumbled upon this bug. (Bug #7714) > > The Bug report says that, it has been comited in 4.0 branch. But release > notes show me that it was been fix

Re: looking for direction on how to debug this message

See: http://dev.mysql.com/doc/mysql/en/communication-errors.html http://dev.mysql.com/doc/mysql/en/making-trace-files.html Randy Paries wrote: >Hello, >My log file is getting filled with these. How do i start debugging this? >Thanks >Randy >//-snip

Re: Log file full of Got an error reading communication packets

"Randy Paries" <[EMAIL PROTECTED]> wrote on 09/21/2005 08:56:13 AM: > Hello, > My log file is getting filled with these. > Can someone tell me what these mean? > > Thanks > Randy > //-snip-// > 050122 20:28:00 Aborted connection 53561 to db: 'u

RE: Timezone setting wrong?

> -Original Message- > From: Jeff [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 21, 2005 08:55 > To: mysql@lists.mysql.com > Subject: Timezone setting wrong? > > > I've got a RHEL3 server I just installed with mysql 4.0.16. > > The hardware clock and system clock are both set t

Re: connect from oracle to MYSQL.

Hi Pooly, Thanks for the help. I did that , where to find odbc.ini file. This pkg does not create this file. regards anandkl On 9/21/05, Pooly <[EMAIL PROTECTED]> wrote: > > 2005/9/21, Ananda Kumar <[EMAIL PROTECTED]>: > > Hi Friends, > > Can you please help me on this. > > regards > > anandkl >

Log file full of Got an error reading communication packets

Hello, My log file is getting filled with these. Can someone tell me what these mean? Thanks Randy //-snip-// 050122 20:28:00 Aborted connection 53561 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication pac

Timezone setting wrong?

I've got a RHEL3 server I just installed with mysql 4.0.16. The hardware clock and system clock are both set to UTC and show the correct time. If I do a select Now(); from mysql it show's the correct time However, Unixtimestamp fields written to a table all are an hour off. They're one hour ah

Charset problems (utf-8 -> latin1)

Hi, I'm trying to migrate an old system to a newer - while doing that I have to move the database. The old database i UTF-8 encoded, and the new one is Latin-1. To move the data I'm doing something similar to: INSERT INTO new_db.table (new_db.field) SELECT CONVERT(old_db.field USING latin1) FR

RE: Circular Replication

> -Original Message- > From: Bruce Dembecki [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 20, 2005 23:05 > To: Jeff > Cc: mysql@lists.mysql.com > Subject: Re: Circular Replication > > > On Sep 16, 2005, at 11:07 AM, Jeff wrote: > > > There shouldn't be a problem if: > > > > serve

Re: "Lost connection to MySQL server during query" when calling stored procedure

Hi, 2005/9/21, Jasper Bryant-Greene <[EMAIL PROTECTED]>: > Martijn Tonies wrote: > > > >>I have a stored procedure defined as follows: > >> > >>CREATE PROCEDURE `album`.`getUser`( IN userID INT ) > >> READS SQL DATA > >> DETERMINISTIC > >> SQL SECURITY INVOKER > >>SELECT * FROM users

Re: Federated engine and "comment"???

> > On Wednesday 21 September 2005 11:23, Martijn Tonies typed: > > > Hi there, > > > > > > Did I just see in the documentation that the "comment" clause > > > is being misused to supply a connection string for the federated > > > engine? > > > > > > If so, I sure hope it will be changed before t

Re: Federated engine and "comment"???

> On Wednesday 21 September 2005 11:23, Martijn Tonies typed: > > Hi there, > > > > Did I just see in the documentation that the "comment" clause > > is being misused to supply a connection string for the federated > > engine? > > > > If so, I sure hope it will be changed before the final 5.0 relea

Re: Federated engine and "comment"???

On Wednesday 21 September 2005 11:23, Martijn Tonies typed: > Hi there, > > Did I just see in the documentation that the "comment" clause > is being misused to supply a connection string for the federated > engine? > > If so, I sure hope it will be changed before the final 5.0 release. > > "comment

Federated engine and "comment"???

Hi there, Did I just see in the documentation that the "comment" clause is being misused to supply a connection string for the federated engine? If so, I sure hope it will be changed before the final 5.0 release. "comment" is next to useless like this. It's already being misused by InnoDB to des

Re: Failure to install on Solaris.

On Tue, 20 Sep 2005, Dan Nelson wrote: In the last episode (Sep 20), Hugh Sasse said: So I started again and built using this script: #!/bin/bash CFLAGS="-O3 -L$LD_LIBRARY_PATH" CXX=gcc MAKE=gmake \ CXXFLAGS="-O3 -L$LD_LIBRARY_PATH -felide-constructors -fno-exceptions -fno-rtti" ./configure \

bind (listen) question

Hi All, I have a linux box with 2 ethenet interfaces let's say one public 10.10.10.10 and one private 192.168.1.1. How can I configure my.cfg to listen on 192.168.1.1 and 127.0.0.1 but not 10.10.10.10? Thanks in advance. Andrea Sodomaco -- MySQL General Mailing List For list archives: http

Re: "Lost connection to MySQL server during query" when calling stored procedure

Martijn Tonies wrote: I have a stored procedure defined as follows: CREATE PROCEDURE `album`.`getUser`( IN userID INT ) READS SQL DATA DETERMINISTIC SQL SECURITY INVOKER SELECT * FROM users WHERE id=userID LIMIT 1; Sometimes when I execute this stored procedure with, for example:

Re: "Lost connection to MySQL server during query" when calling stored procedure

> I have a stored procedure defined as follows: > > CREATE PROCEDURE `album`.`getUser`( IN userID INT ) > READS SQL DATA > DETERMINISTIC > SQL SECURITY INVOKER > SELECT * FROM users WHERE id=userID LIMIT 1; > > Sometimes when I execute this stored procedure with, for example: > > C

"Lost connection to MySQL server during query" when calling stored procedure

I have a stored procedure defined as follows: CREATE PROCEDURE `album`.`getUser`( IN userID INT ) READS SQL DATA DETERMINISTIC SQL SECURITY INVOKER SELECT * FROM users WHERE id=userID LIMIT 1; Sometimes when I execute this stored procedure with, for example: CALL getUser(7); I get

Re: connect from oracle to MYSQL.

2005/9/21, Ananda Kumar <[EMAIL PROTECTED]>: > Hi Friends, > Can you please help me on this. > regards > anandkl > > -- Forwarded message -- > From: Ananda Kumar <[EMAIL PROTECTED]> > Date: Sep 20, 2005 9:46 PM > Subject: connect from oracle to MYSQL. > To: mysql@lists.mysql.com >