Re: I forgot the admin password

[Martijn Tonies]

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) this would be a solution for the problem.

Obviously, in a working environment, this wouldn't be a correct
answers and I stand fully corrected on that :-)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


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

RE: SQL to use left join and find missing values

[RAPPAZ Francois]

 
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.

Upon trying a little bit harder, I have found that

Select sum(PlaceNo)
from boxes
inner join car using (boxID)
left outer join load on car.Travel.ID=load.TravelID and car.BoxNo=Load.BoxNo
Where car.TravelID=1 AND Load.BoxNo is null

seems to give the needed result (I have to test this query some more).

Greetings

François


> -Original Message-
> From: Brent Baisley [mailto:[EMAIL PROTECTED] 
> Sent: mardi, 20. septembre 2005 21:29
> To: RAPPAZ Francois
> Cc: mysql@lists.mysql.com
> Subject: Re: SQL to use left join and find missing values
> 
> If you want to join a table more than once, you need to refer 
> to it AS something else.
> 
> select sum(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
> 
> 
> On Sep 20, 2005, at 2:40 AM, RAPPAZ Francois wrote:
> 
> > Hi all
> > with Mysql 3.23 I would like to find missing values in the 
> following 
> > situation:
> >
> > 1) table boxes: describes kind of boxes differing by how 
> many items I 
> > can put in.
> >
> > Primary key is BoxID
> >
> > boxID +  Places
> > A +   1
> > B +   3
> > C +   5
> >
> > 2) table car describes how I can put some boxes on a car 
> for a journey
> >
> > Primary Key is composed of TravelID, BoxNo BoxNo is auto_increment, 
> > and start at 1 for each new travel
> >
> > TravelID + BoxID + BoxNo
> >1 +   A   +  1
> >1 +   A   +  2
> >1 +   B   +  3
> >2   +   A   +  1
> >2 +   B   +  2
> >2 +   C   +  3
> >
> >
> > 3) table load describes how items can be placed in the boxes once a 
> > car has been monted with boxes
> >
> > Primary Key is composed of TravelID, BoxNo, PlaceNo PlaceNo is 
> > auto_increment, and start at 1 for each new Box beeing load 
> (it's just 
> > here to make a primary key)
> >
> > TravelID + BoxNo + PlaceNo + ItemName
> > 1+   1   +   1 +   itemName1
> > 2+   2   +   1 +   itemName2
> > 2+   2   +   2 +   itemName3
> >
> >
> > I want to make a query to get how much free places there is for a 
> > given travel (ie how much places have been prepared in 
> table car that 
> > are not occupied in table load)
> >
> > I would like to get this kind of query working
> >
> > select sum(PlaceNo)
> > from boxes
> > inner join car using (boxID)
> > inner join load using (TravelID)
> > left outer join load on car.BoxNo=load.BoxNo Where 
> load.TravelID=1 AND 
> > load.BoxNo is null
> >
> > but this query does not work because I have a duplicate table name 
> > (load).
> > Left join would be possible if BoxNo was unique for the whole table 
> > load, but is there a way to use left join here ?
> >
> > This query works when there is one record in load for a given travel
> >
> > select sum(PlaceNo)
> > from boxes
> > inner join car using (boxID)
> > where car.TravelID=1 AND car.BoxNo not in (select BoxNo
> > from load
> > where load.TravelID=1)
> >
> > but when the subquery return null, the main query return 
> null too, when 
> > it should return the total of free places...
> > How could I correct this ?
> >
> > Thanks in advance
> >
> > François
> >
> > François Rappaz
> >
> > Centre de documentation de la Faculté des Sciences Université de 
> > Fribourg DokPe - Dokumentationszentrum der Naturwissenschaftlichen 
> > Fakultät Universität Freiburg Pérolles CH-1700 Fribourg Switzerland 
> > http://www.unifr.ch/dokpe/
> > Tel.: 41 (0)26 300 92 60
> > Fax.: 41 (0)26 300 97 30
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:http://lists.mysql.com/mysql? 
> > [EMAIL PROTECTED]
> >
> >
> >
> 
> -- 
> Brent Baisley
> Systems Architect
> Landover Associates, Inc.
> Search & Advisory Services for Advanced Technology Environments
> p: 212.759.6400/800.759.0577
> 
> 
> 

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

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

[Jasper Bryant-Greene]

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 example:

CALL getUser(7);

I get the error "Lost connection to MySQL server during query".

This only ever happens with stored procedures, never with any normal 
kind of query.


I am using MySQL 5.0.12-beta-log on Gentoo Linux x86.



This only seems to happen when accessing MySQL from PHP's MySQLi API, 
not when accessing it using the mysql command-line client.


Is this a bug I should report to MySQL or to PHP? I'm not able to test 
other APIs at the moment.


--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/

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

Re: connect from oracle to MYSQL.

[Ananda Kumar]

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 innodb engine
 Thanks in advance.
 regards
anandkl

 On 9/21/05, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
> 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
> > >
> > > -- 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
> > >
> > > Hi All,
> > > Can you please help me in connecting from oracle database to mysql
> > database.
> > > I am trying to setup the hetrogenious service provided by oracle, but
> > i am
> > > not able to complete all the steps.
> > > I am failing at this step
> > > *cp MyODBC-3.51.06-sun-solaris2.8-sparc/libmyodbc3* lib*
> > > # *mv etc/odbc.ini etc/odbc.ini.backup*
> > > # *cp MyODBC-3.51.06-sun-solaris2.8-sparc/odbc.ini etc*
> > > # *cd lib*
> > > # *rm libmyodbc3.so libmyodbc3_r.so*
> > > # *ln -s libmyodbc3-3.51.06.so  <
> > http://libmyodbc3-3.51.06.so/> libmyodbc3.so
> > > *
> > > # *ln -s libmyodbc3_r-3.51.06.so  
> > libmyodbc3_r.so*
> > > **
> > > *I am not seeing libmyodbc files in
> > > MyODBC-3.51.06-sun-solaris2.8-sparcdirectory. I am seeing only this
> > > files
> > > *
> > > MyODBC-3.51.10-sun-solaris2.8-sparc.pkg
> > > README.
> >
> > #pkgadd -d MyODBC-3.51.10-sun-solaris2.8-sparc.pkg
> > #more README
> >
> > ?
> >
> > > I am using solaris2.8 for oracle database and mysql 4.1 on linux
> > fedaro.
> > > regards
> > > anandkl
> > >
> > >
> >
> >
> > --
> > Pooly
> > Webzine Rock : http://www.w-fenec.org/
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
>

Re: select first then insert (same table)

[Jasper Bryant-Greene]

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 your questions will be answered there.


--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/

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

Re: mysql_free_result() & 2 different connections

[Miguel Cardenas]

> 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 thought that, 'cos my doubt on it I have insisted to findout more

> again, showing _real_ code would help, or a strip-down code that
> crashes. The MySQL api does not free ressources automatically, so if
> you have the crash on two different system, I would think the bug
> comes from your code.

Well, in fact you are right... I took a look again to the mysql_store_result() 
and mysql_use_result() and that lighted my brain!

It was a logic error... inside the while I was making a free_result() every 
loop that made a fetch_row(), and not once per query, that was the first 
thing... as you said in the last message, I did not check for NULL return to 
perform the free() and because of that was the random crash (sometimes NULL, 
sometimes not)...

The problem was not mysql nor what I was thinking, but your last mail made me 
to discover the real problem :D

> nop, you MYSQL_RES, and it's value. did you set to NULL after freeing
> it ? that would help.

well, I had a member function

void MYCLASS::FreeResult (void) {
   mysql_free_result(sql_result);
}

and now modified it this way

void MYCLASS::FreeResult (void) {
   if (sql_result) {
  mysql_free_result(sql_result);
  sql_result = NULL;
   }
}

> again, I doubt it's a bug in the api, I use various 4.0.x, 4.1.x daily

Well, as I said, it was a double logic error, I should not anymore copy/paste 
from other programs trusting that they do what I remember they do, it will be 
better to start always from zero the code, even for test only purposes...

Thanks for your patience and help during this time... your ideas were very 
useful...

Regards


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

Number of InnoDB files vs performance?

[Richard F. Rebel]

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 them up.


Does this slow things down?  I am about to create 1TB worth of InnoDB  
table spaces and would really appreciate others perspecitves.


Thanks!

Richard

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

Re: I forgot the admin password

[Luis Garay]

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 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 Microsoft environment it is usual practice to reinstall software
> when the original cause cant be find. Unfortunately that is poor practice.
>
> If feasable, it is important to understand what the original cause is and
> how to stop it, rather than fixing around it.
>
> Reinstalling an
>
> This time its perhaps not REAL data but when disaster strikes, often there
> is not much time to "learn" how it should have been done - mostly that
> means it is already to late. Its important to learn how to do it proberly
> with test data BEFORE disaster strikes.
>
> O.K I believe you got my points. Again, didnt mean to hurt anybody. Peace
> ;-)
>
>
> Best regards
>
> Nils Valentin
> Tokyo / Japan
> http://www.be-known-online.com
>
>
> >>> > > 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 now I want to start practicing ", it doesn't really matter...
> >>>
> >>> Just reinstall it and you're fresh to go, right?
> >>
> >>NO! depending on how the Luis installed MySQL in the first place (which
> > method was used), the "uninstaller" may not remove or >overwrite the
> > mysql.user table rendering this exercise fruitless as well as being
> > overkill. I understand you work with many >databases other than MySQL
> and
> > for some of them the only way to recover from a lost admin password
> would
> > be
> > to >remove/replace/restore. However, in this case Valentin was correct.
> >
> > Right -- perhaps I should have mentioned: uninstall and delete
> everything
> > :-)
> > Done that a couple of times myself...
> >
> > I understand that Valentin is correct for the "normal" approach,
> > especially
> > when you have a running server and/or databases.
> >
> > I kinda figured, the fastest way (without having to search for an e-mail
> > list), would be just to reinstall the thing. MySQL - on Windows - has a
> > very nice install these days, kudos for that.
> >
> > With regards,
> >
> > Martijn Tonies
> > Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS
> SQL
> > Server
> > Upscene Productions
> > http://www.upscene.com
> > Database development questions? Check the forum!
> > http://www.databasedevelopmentforum.com
> >
> >
>
>

select first then insert (same table)

[Louie Miranda]

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
http://www.axishift.com -- under development

Re: Adding InnoDB support

[Arjen Lentz]

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 and i am worried about
> loosing data, so for now a quick fix is in order.
> 
> will my php users be effected or will their php mysql scripts work as
> before. (php4.3.11 default FC3 rpm)

Yep you could use the mysql-max RPM for a 3.23 version.
But going from 3.23 to 4.0 is fairly straightforward:
  http://dev.mysql.com/doc/mysql/en/Upgrading-from-3.23.html

The only thing you need to mind is to also download and install the
-shared-compat RPM, which contains the 3.23 libraries as well as the 4.0
libs, to keep some apps on FC3 happy which use 3.23 (Python for
instance).


Regards,
Arjen.
-- 
Arjen Lentz, Community Relations Manager
MySQL AB, www.mysql.com

MySQL Users Conference 2006 (Santa Clara CA, 24-27 April)
Call for Papers deadline 7 Nov 2005: http://www.mysqluc.com/



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

Re: I forgot the admin password

[valentin_nils]

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 Microsoft environment it is usual practice to reinstall software
when the original cause cant be find. Unfortunately that is poor practice.

If feasable, it is important to understand what the original cause is and
how to stop it, rather than fixing around it.

Reinstalling an application, probably deleting the database would be a
last desperate step for me personally.

This time its perhaps not REAL data but when disaster strikes, often there
is not much time to "learn" how it should have been done - mostly that
means it is already to late. Its important to learn how to do it proberly
with test data BEFORE disaster strikes.

O.K I believe you got my points. Again, didnt mean to hurt anybody. Peace ;-)


Best regards

Nils Valentin
Tokyo / Japan
http://www.be-known-online.com


>>> > > 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 now I want to start practicing ", it doesn't really matter...
>>>
>>> Just reinstall it and you're fresh to go, right?
>>
>>NO! depending on how the Luis installed MySQL in the first place (which
> method was used), the "uninstaller" may not remove or >overwrite the
> mysql.user table rendering this exercise fruitless as well as being
> overkill. I understand you work with many >databases other than MySQL and
> for some of them the only way to recover from a lost admin password would
> be
> to >remove/replace/restore. However, in this case Valentin was correct.
>
> Right -- perhaps I should have mentioned: uninstall and delete everything
> :-)
> Done that a couple of times myself...
>
> I understand that Valentin is correct for the "normal" approach,
> especially
> when you have a running server and/or databases.
>
> I kinda figured, the fastest way (without having to search for an e-mail
> list), would be just to reinstall the thing. MySQL - on Windows - has a
> very nice install these days, kudos for that.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>


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

Re: I forgot the admin password

[valentin_nils]

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 Microsoft environment it is usual practice to reinstall software
when the original cause cant be find. Unfortunately that is poor practice.

If feasable, it is important to understand what the original cause is and
how to stop it, rather than fixing around it.

Reinstalling an

This time its perhaps not REAL data but when disaster strikes, often there
is not much time to "learn" how it should have been done - mostly that
means it is already to late. Its important to learn how to do it proberly
with test data BEFORE disaster strikes.

O.K I believe you got my points. Again, didnt mean to hurt anybody. Peace ;-)


Best regards

Nils Valentin
Tokyo / Japan
http://www.be-known-online.com


>>> > > 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 now I want to start practicing ", it doesn't really matter...
>>>
>>> Just reinstall it and you're fresh to go, right?
>>
>>NO! depending on how the Luis installed MySQL in the first place (which
> method was used), the "uninstaller" may not remove or >overwrite the
> mysql.user table rendering this exercise fruitless as well as being
> overkill. I understand you work with many >databases other than MySQL and
> for some of them the only way to recover from a lost admin password would
> be
> to >remove/replace/restore. However, in this case Valentin was correct.
>
> Right -- perhaps I should have mentioned: uninstall and delete everything
> :-)
> Done that a couple of times myself...
>
> I understand that Valentin is correct for the "normal" approach,
> especially
> when you have a running server and/or databases.
>
> I kinda figured, the fastest way (without having to search for an e-mail
> list), would be just to reinstall the thing. MySQL - on Windows - has a
> very nice install these days, kudos for that.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>


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

MySQL Users Conference 2006 - Call for Participation

[Arjen Lentz]

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 Users Conference, April
24-27, 2006, in Santa Clara, California. 

To submit a proposal, go to:
http://www.mysqluc.com/cs/mysqluc2006/create/e_sess

Building upon the great success of the 2005 MySQL Users Conference,
MySQL AB is once again teaming up with O'Reilly Media, to co-present
next year's event. Bringing together MySQL developers, partners and
other users, the 2006 MySQL Users Conference will feature a wide range
of tutorials and sessions, giving attendees new views of the MySQL
Universe -- everything from an overview of the latest business and
product developments -- to an in-depth look at scaling, optimization and
MySQL's inner-workings.

Next year, we will enlarge our exhibition hall to showcase the latest
MySQL-related technologies by vendors and open source projects. We're
also planning some special evening events for attendees and speakers.

Call for Participation Details

The MySQL Users Conference brings over 1,000 open source and database
enthusiasts together as a celebration of the huge MySQL ecosystem. The
theme for the 2006 conference is "Discover. Connect. Succeed. Scale Your
Business with MySQL". The conference mirrors the product's wide-ranging
appeal and capabilities, encouraging community members to help create
the best database software, gain knowledge, develop tools, and build
applications that help grow businesses and nurture individual skills.

Proposals should focus on helping attendees:

 - Harness the full power of MySQL, including best practices
 - Learn and use the features in MySQL version 5.0 and beyond
 - Learn how to better administer MySQL
 - Learn from experts who use MySQL in various real-world application
   architectures
 - Migrate from proprietary databases to MySQL
 - Employ scale out through Replication, Clustering and other tools
   and techniques
 - Learn more about the many excellent MySQL community projects


Topics include:

 - Database Administration (DBA) and Security
 - Architecture and Technology
 - Business and Case Studies
 - Data Warehousing and Business Intelligence
 - LAMP (Linux, Apache, MySQL, PHP/Perl/Python)
 - Java
 - .NET/Mono
 - MaxDB
 - Migration
 - Performance Tuning and Benchmarks
 - Cluster, Replication and other Scale-out/High Availability solutions
 - Embedded MySQL: libmysqld and embedded OS environments
 - Community Projects that use MySQL

There is also a General Topic for other topics and sessions that don't
necessarily fit into the topics above. When preparing a proposal, please
also consider the audience you wish to target: developer, DBA, business
manager; and the knowledge level -- from high-level overviews to deep
internals.

A quickpoll was held on the MySQL Developer Zone, asking people which
topics they are most interested in:
http://dev.mysql.com/tech-resources/quickpolls/uc-2006-topics.html

Proposals will be considered in two types: 45-minute session
presentations and 3-hour pre-conference tutorials.


Important Dates:

 - The submission deadline for all proposals is midnight (PST)
   November 7, 2005
 - Speakers will be notified by November 30, 2005
 - Final session details, speaker bios, and tutorial materials are
   due by March 13, 2006
 - General registration will open in December 2005
 - The MySQL Users Conference 2006 dates are April 24 - 27, 2006


For complete conference details, including the Call for Participation,
visit: http://www.mysqluc.com

To submit a proposal, go to:
http://www.mysqluc.com/cs/mysqluc2006/create/e_sess

To stay abreast of conference news and to receive email notification
when registration opens, please sign up at:
http://www.mysqluc.com/pub/w/45/form.html

For information on exhibition and sponsorship opportunities at the
conference, contact Andrew Calvo at (707) 827-7176, or
[EMAIL PROTECTED] .

For more information about the previous MySQL Users Conferences, go to
http://www.mysql.com/news-and-events/users-conference/

For more information about O'Reilly conferences, visit:
http://conferences.oreilly.com/ .


-- 
Arjen Lentz, Community Relations Manager
MySQL AB, www.mysql.com

MySQL related blogs @ http://www.planetmysql.org/



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

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

[Jasper Bryant-Greene]

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 INVOKER
SELECT * FROM users WHERE id=userID LIMIT 1;

Sometimes when I execute this stored procedure with, for example:

CALL getUser(7);

I get the error "Lost connection to MySQL server during query".

This only ever happens with stored procedures, never with any normal 
kind of query.


I am using MySQL 5.0.12-beta-log on Gentoo Linux x86.



--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/

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

Re: Read Only Data Directory

[Jake Peavy]

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 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 as the datadir? Are there
> other options I can specify in my.cnf where I can tell mysqld to write the
> error files/etc?
>  TIA,
> Jake
>

Read Only Data Directory

[Jake Peavy]

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 as the datadir? Are there
other options I can specify in my.cnf where I can tell mysqld to write the
error files/etc?
 TIA,
Jake

HELP - Group_Concat broken after update

[Ed Reed]

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?

[SGreen]

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.  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 == vs = in c++, somehow mysql evaluated it as a Boolean logic
> >>statement that turned into a valid query.  I don't have the time to
> >>think about it too much, but I thought it would be interesting to hear
> >>how it was valid and why it didn't generate an error (or maybe its
> >>actually a bug and should be an error?).
> >>
> >>
> >>
> >>Here is the query:
> >>
> >>
> >>
> >>UPDATE dashboard_tab_user SET dashboard_tab_account_id = NULL AND
> >>dashboard_tab_account_server_id = NULL WHERE dashboard_tab_user_id = 
194
> >>AND dashboard_tab_user_server_id = 99;
> >>
> >>

> >>
> >>The query would run and set dashboard_tab_account_id to NULL 
correctly,
> >>but would not modify dashboard_tab_account_server_id in anyway.
> >>
> >>
> >>
> >>John A. McCaskey
> >>
> >>[EMAIL PROTECTED]
> >>
> >>
> > 
> > 
> > Here is a similar example that uses some old data I have lying 
about
> > 
> > localhost.test>select * from appointment;
> > ++---+--+-+
> > | ID | OwnerName | MeetWithName | Date|
> > ++---+--+-+
> > |  1 | Shawn | Dr. Bell | 2004-08-05 14:00:00 |
> > |  2 | Shawn | Dr. Bell | 2004-08-12 11:00:00 |
> > |  3 | John  | Mary | 2004-07-31 12:15:00 |
> > |  4 | John  | Mary | 2004-08-04 12:15:00 |
> > |  5 | John  | Mary | 2004-08-11 11:15:00 |
> > |  6 | John  | Mary | 2004-08-25 12:15:00 |
> > |  7 | Scott | David| 2004-08-01 09:00:00 |
> > |  8 | Scott | James| 2004-08-07 15:00:00 |
> > |  9 | Shawn | Scott| 2004-08-06 00:00:00 |
> > | 10 | Scott | Anna | 2004-08-22 00:00:00 |
> > | 11 | Shawn | Scott| 2003-08-07 16:00:00 |
> > ++---+--+-+
> > 11 rows in set (0.11 sec)
> > 
> > update appointment set ownername = null and meetwithname=null where id 
= 
> > 11;
> > 
> > localhost.test>select * from appointment;
> > ++---+--+-+
> > | ID | OwnerName | MeetWithName | Date|
> > ++---+--+-+
> > |  1 | Shawn | Dr. Bell | 2004-08-05 14:00:00 |
> > |  2 | Shawn | Dr. Bell | 2004-08-12 11:00:00 |
> > |  3 | John  | Mary | 2004-07-31 12:15:00 |
> > |  4 | John  | Mary | 2004-08-04 12:15:00 |
> > |  5 | John  | Mary | 2004-08-11 11:15:00 |
> > |  6 | John  | Mary | 2004-08-25 12:15:00 |
> > |  7 | Scott | David| 2004-08-01 09:00:00 |
> > |  8 | Scott | James| 2004-08-07 15:00:00 |
> > |  9 | Shawn | Scott| 2004-08-06 00:00:00 |
> > | 10 | Scott | Anna | 2004-08-22 00:00:00 |
> > | 11 |   | Scott| 2003-08-07 16:00:00 |
> > ++---+--+-+
> > 11 rows in set (0.00 sec)
> > 
> > The SET clause is parsed and evaluated like this: 
> > 
> > ownername = (NULL and (meetwithname=NULL)). 
> > 
> > Anything "and"-ed with a null is NULL so there is no need to evaluate 
the 
> > right side of the "NULL and (...)" expression which is the right side 
of 
> > the assignment operator. That leaves the SET clause as simply: 
ownername 
> > = NULL with no remaining reference to the second field. The second 
field 
> > is not modified because the section of the equation that would have 
caused 
> > a change to it is never evaluated.
> > 
> > I don't see this as a bug. I would like to see a warning that a column 

> > assignment has been optimized away. What says the list?
> > 
> > Shawn Green
> > Database Administrator
> > Unimin Corporation - Spruce Pine
> > 
> 
> I ran into this a while back myself, and wracked my brains and 
> eventually asked the list why it was happening. What I struggled to 
> understand is why the syntax for AND inside a SET clause is different 
> than that of an AND inside a WHERE clause.
> 
> For example, using C-like syntax for ='s and =='s:
> "SET a = b AND c = d"--- means SET a = (b AND (c == d))
> "WHERE a = b AND c = d"  --- means WHERE (a == b) AND (c == d)
> 
>  > I don't see this as a bug. I would like to see a warning that a 
column
>  > assignment has been optimized away.
> 
> The issue is really broader than the right side being optimized away 
> because of "NULL and (...)" - it is about the precedence of '=' and 
> 'AND' in a SET clause, and that this is different t

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

[Devananda]

[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 AND, however mysql
took this query and didn't generate any error.  I'm assuming this is
like == vs = in c++, somehow mysql evaluated it as a Boolean logic
statement that turned into a valid query.  I don't have the time to
think about it too much, but I thought it would be interesting to hear
how it was valid and why it didn't generate an error (or maybe its
actually a bug and should be an error?).



Here is the query:



UPDATE dashboard_tab_user SET dashboard_tab_account_id = NULL AND
dashboard_tab_account_server_id = NULL WHERE dashboard_tab_user_id = 194
AND dashboard_tab_user_server_id = 99;



Here is the table schema:

CREATE TABLE `dashboard_tab_user` (

 `dashboard_tab_user_id` mediumint(8) unsigned NOT NULL auto_increment,

 `dashboard_tab_user_server_id` tinyint(3) unsigned NOT NULL default
'0',

 `dashboard_tab_account_id` mediumint(8) unsigned default '0',

 `dashboard_tab_account_server_id` tinyint(3) unsigned default '0',

 `user_id` mediumint(8) unsigned NOT NULL default '0',

 `user_server_id` tinyint(3) unsigned NOT NULL default '0',

 `dashboard_tab_user_name` char(18) NOT NULL default '',

 `snap` enum('on','off') NOT NULL default 'off',

 `creation_timestamp` timestamp(14) NOT NULL,

 `cols` tinyint(3) NOT NULL default '2',

 `rows` tinyint(3) NOT NULL default '2',

 `active` enum('on','off') NOT NULL default 'on',

 PRIMARY KEY  (`dashboard_tab_user_id`,`dashboard_tab_user_server_id`),

 KEY `user_id` (`user_id`,`user_server_id`),

 CONSTRAINT `dashboard_tab_user_ibfk_1` FOREIGN KEY (`user_id`,
`user_server_id`) REFERENCES `user` (`user_id`, `user_server_id`) ON
DELETE CASCADE

) TYPE=InnoDB 




The query would run and set dashboard_tab_account_id to NULL correctly,
but would not modify dashboard_tab_account_server_id in anyway.



John A. McCaskey

[EMAIL PROTECTED]





Here is a similar example that uses some old data I have lying about

localhost.test>select * from appointment;
++---+--+-+
| ID | OwnerName | MeetWithName | Date|
++---+--+-+
|  1 | Shawn | Dr. Bell | 2004-08-05 14:00:00 |
|  2 | Shawn | Dr. Bell | 2004-08-12 11:00:00 |
|  3 | John  | Mary | 2004-07-31 12:15:00 |
|  4 | John  | Mary | 2004-08-04 12:15:00 |
|  5 | John  | Mary | 2004-08-11 11:15:00 |
|  6 | John  | Mary | 2004-08-25 12:15:00 |
|  7 | Scott | David| 2004-08-01 09:00:00 |
|  8 | Scott | James| 2004-08-07 15:00:00 |
|  9 | Shawn | Scott| 2004-08-06 00:00:00 |
| 10 | Scott | Anna | 2004-08-22 00:00:00 |
| 11 | Shawn | Scott| 2003-08-07 16:00:00 |
++---+--+-+
11 rows in set (0.11 sec)

update appointment set ownername = null and meetwithname=null where id = 
11;


localhost.test>select * from appointment;
++---+--+-+
| ID | OwnerName | MeetWithName | Date|
++---+--+-+
|  1 | Shawn | Dr. Bell | 2004-08-05 14:00:00 |
|  2 | Shawn | Dr. Bell | 2004-08-12 11:00:00 |
|  3 | John  | Mary | 2004-07-31 12:15:00 |
|  4 | John  | Mary | 2004-08-04 12:15:00 |
|  5 | John  | Mary | 2004-08-11 11:15:00 |
|  6 | John  | Mary | 2004-08-25 12:15:00 |
|  7 | Scott | David| 2004-08-01 09:00:00 |
|  8 | Scott | James| 2004-08-07 15:00:00 |
|  9 | Shawn | Scott| 2004-08-06 00:00:00 |
| 10 | Scott | Anna | 2004-08-22 00:00:00 |
| 11 |   | Scott| 2003-08-07 16:00:00 |
++---+--+-+
11 rows in set (0.00 sec)

The SET clause is parsed and evaluated like this: 

ownername = (NULL and (meetwithname=NULL)). 

Anything "and"-ed with a null is NULL so there is no need to evaluate the 
right side of the "NULL and (...)" expression which is the right side of 
the assignment operator. That leaves the SET clause as simply:  ownername 
= NULL with no remaining reference to the second field. The second field 
is not modified because the section of the equation that would have caused 
a change to it is never evaluated.


I don't see this as a bug. I would like to see a warning that a column 
assignment has been optimized away. What says the list?


Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine



I ran into this a while back myself, and wracked my brains and 
eventually asked the list why it was happening. What I struggled to 
understand is why the syntax for AND inside a SET clause 

Re: UUIDs - first usage for me

[Christian Parpart]

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) NOT NULL default ''
> >
> > I've been testing your example as I feel really much safer with UUIDs
> > instead of auto_increments, however, my column datatype is
> > VARCHAR(12) so 24bytes shorter than a usual UUID, although, all
> > uuid() SELECTs differ only in first 12 bytes - why?
>
> The node-based uuid format that mysql generates has this format:
>
> time_low "-" time_mid "-" time_high_and_version "-"
> clock_seq_and_reserved clock_seq_low "-" node
>
> Node should be contant as long as you don't switch network cards in the
> machine, clock_seq is usually only reset across reboots (or mysql
> restarts since mysql currently generates its own uuid even if the OS
> provides a uuid generator), and time is a timestamp accurate to 100
> nanoseconds.  So assuming a single mysql server that doesn't get
> rebooted, you'll only ever see different values in the first three
> hyphenated fields.
>
> See RFC 4122 for more details.  http://www.ossp.org/pkg/lib/uuid/ is a
> nice uuid library that includes a uuid decoder.

Heya, thanks. didn't know that this is even an RFC :)

Thanks for the description.

Regards,
Christian Parpart.


pgpSUsonoRX6P.pgp
Description: PGP signature

Re: bind (listen) question

[Alexey Polyakov]

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 General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

[Alexey Polyakov]

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 tables), and import this dump into second
database.

--
Alexey Polyakov

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

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

[Alexey Polyakov]

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 db server. One way to do this is to issue 'SET NAMES latin1'
query after establishing a connection. There are also some ways to set
this as global option for all websites if you can't modify scripts.

--
Alexey Polyakov

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

RE: Timezone setting wrong?

[Atle Veka]

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

On Wed, 21 Sep 2005, Petr Chardin wrote:

> > 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 list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

[Alexey Polyakov]

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 scan of second table, which is performance
killer.

--
Alexey Polyakov

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

Re: I forgot the admin password

[Martijn Tonies]

>> > > 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 now I want to start practicing ", it doesn't really matter...
>>
>> Just reinstall it and you're fresh to go, right?
>
>NO! depending on how the Luis installed MySQL in the first place (which
method was used), the "uninstaller" may not remove or >overwrite the
mysql.user table rendering this exercise fruitless as well as being
overkill. I understand you work with many >databases other than MySQL and
for some of them the only way to recover from a lost admin password would be
to >remove/replace/restore. However, in this case Valentin was correct.

Right -- perhaps I should have mentioned: uninstall and delete everything
:-)
Done that a couple of times myself...

I understand that Valentin is correct for the "normal" approach, especially
when you have a running server and/or databases.

I kinda figured, the fastest way (without having to search for an e-mail
list), would be just to reinstall the thing. MySQL - on Windows - has a
very nice install these days, kudos for that.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


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

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

[Christofer Dutz]

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) unsigned default '0',
  `auft_nr` bigint(10) unsigned default NULL,
  `auft_referenz` varchar(40) default NULL,
  `lad_datum` date default NULL,
  `lad_von_zeit` time default NULL,
  `lad_bis_zeit` time default NULL,
  `lad_land` char(3) default NULL,
  `lad_plz` varchar(6) default NULL,
  `lad_lon_deg` double default NULL,
  `lad_lat_deg` double default NULL,
  `lad_ort` varchar(40) default NULL,
  `lad_str` varchar(40) default NULL,
  `lad_fix` tinyint(1) default '0',
  `frankatur` varchar(20) default NULL,
  `name_vers` varchar(40) default NULL,
  `name_auftg` varchar(40) default NULL,
  `pnr_vers` varchar(10) default NULL,
  `pnr_auftg` varchar(10) default NULL,
  `pnr_ladeort` varchar(10) default NULL,
  `lad_gew` int(6) unsigned default '0',
  `lad_meter` float(3,2) unsigned default '0.00',
  `lad_fracht` float(5,2) unsigned default '0.00',
  `lad_lkw_typ` varchar(30) default NULL,
  `lad_art` varchar(20) default NULL,
  `lad_gg` tinyint(1) default '0',
  `lad_tausch` tinyint(1) default '0',
  `lad_last` mediumint(6) default '0',
  `entlad_datum` date default NULL,
  `entlad_von_zeit` time default NULL,
  `entlad_bis_zeit` time default NULL,
  `entlad_land` char(3) default NULL,
  `entlad_plz` varchar(6) default NULL,
  `entlad_lon_deg` double default NULL,
  `entlad_lat_deg` double default NULL,
  `entlad_ort` varchar(40) default NULL,
  `entlad_str` varchar(40) default NULL,
  `entlad_fix` tinyint(1) default '0',
  `lad_hinweis` varchar(200) default NULL,
  `pnr_empf` varchar(10) default NULL,
  `pnr_entladeort` varchar(10) default NULL,
  `lad_disp_name` varchar(40) default NULL,
  `lad_disp_tel` varchar(20) default NULL,
  `lad_disp_mobil` varchar(20) default NULL,
  `lad_disp_fax` varchar(20) default NULL,
  `lad_disp_email` varchar(30) default NULL,
  `lad_disp_kontakt` tinyint(1) default '0',
  `export_gst` smallint(4) unsigned default '0',
  `export_betrieb` tinyint(2) unsigned default '0',
  `export_datum` date default NULL,
  `export_zeit` time default NULL,
  `export_disp_name` varchar(40) default NULL,
  `export_disp_tel` varchar(20) default NULL,
  `export_disp_mobil` varchar(20) default NULL,
  `export_disp_fax` varchar(20) default NULL,
  `export_disp_email` varchar(30) default NULL,
  `export_ref_auft` varchar(10) default NULL,
  `state` tinyint(3) unsigned default NULL,
  `modify_data` datetime default NULL,
  `modify_user` varchar(20) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1


CREATE TABLE `disco_snd` (
  `lad_id` bigint(16) unsigned NOT NULL default '0',
  `gst` smallint(4) unsigned default NULL,
  `betrieb` tinyint(2) unsigned default NULL,
  `auft_nr` bigint(10) unsigned default NULL,
  `snd_gew` mediumint(6) unsigned default NULL,
  `snd_meter` decimal(3,2) default NULL,
  `snd_signum` varchar(20) default NULL,
  `snd_inhalt` varchar(40) default NULL,
  `lademittel_bez` varchar(40) default NULL,
  `lademittel_code` smallint(4) unsigned default NULL,
  `lademittel_anz` mediumint(5) unsigned default NULL,
  `snd_gg_schl` varchar(6) default NULL,
  `snd_gg_bez` varchar(40) default NULL,
  `state` tinyint(3) unsigned default NULL,
  `modify_date` datetime default NULL,
  `modify_user` varchar(20) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 107520 kB'

I am using a MySQL 4.1.13 on a Redhat Linux server and accessing it 
using the new version of the JDBC driver from a windows XP client.
While performing the query I used the MySQL Admin-Tool to check the 
server Load and the load shown there was only minimal. The 
internet-connection can't be the problem, since The query returns the 
same results and one is fast and the other one realy slow.


Chris

Devananda wrote:

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:

SELECT * FROM lad LEFT JOIN snd ON lad.id = snd.lad_id

I quit the query after 5 minutes.

Why is this so?

Chritofer Dutz



Christofer,

You'll need to provide the list with more information for anyone to be 
able to help you. What version of MySQL are you running? Can you paste 
the output of "show create table snd; show create table lad;" Also, do 
you have other processes using the server that could have locked one of 
the tables? When the query is taking a long time, try opening a second 
connection to the server and running "show full processlist;" to see 
what else is going on.



Regards,
Devananda vdv


--
MySQL General Mailing List
For list archives: http://l

Re: I forgot the admin password

[SGreen]

"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 wanted to know.
> 
> Well, given that the OP only said " I installed it a few weeks ago
> and now I want to start practicing ", it doesn't really matter...
> 
> Just reinstall it and you're fresh to go, right?

NO! depending on how the Luis installed MySQL in the first place (which 
method was used), the "uninstaller" may not remove or overwrite the 
mysql.user table rendering this exercise fruitless as well as being 
overkill. I understand you work with many databases other than MySQL and 
for some of them the only way to recover from a lost admin password would 
be to remove/replace/restore. However, in this case Valentin was correct.

> With regards,
> 
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS 
SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
> 

Respectfully,

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

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

[SGreen]

"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 mysql
> took this query and didn't generate any error.  I'm assuming this is
> like == vs = in c++, somehow mysql evaluated it as a Boolean logic
> statement that turned into a valid query.  I don't have the time to
> think about it too much, but I thought it would be interesting to hear
> how it was valid and why it didn't generate an error (or maybe its
> actually a bug and should be an error?).
> 
> 
> 
> Here is the query:
> 
> 
> 
> UPDATE dashboard_tab_user SET dashboard_tab_account_id = NULL AND
> dashboard_tab_account_server_id = NULL WHERE dashboard_tab_user_id = 194
> AND dashboard_tab_user_server_id = 99;
> 
> 
> 
> Here is the table schema:
> 
> CREATE TABLE `dashboard_tab_user` (
> 
>   `dashboard_tab_user_id` mediumint(8) unsigned NOT NULL auto_increment,
> 
>   `dashboard_tab_user_server_id` tinyint(3) unsigned NOT NULL default
> '0',
> 
>   `dashboard_tab_account_id` mediumint(8) unsigned default '0',
> 
>   `dashboard_tab_account_server_id` tinyint(3) unsigned default '0',
> 
>   `user_id` mediumint(8) unsigned NOT NULL default '0',
> 
>   `user_server_id` tinyint(3) unsigned NOT NULL default '0',
> 
>   `dashboard_tab_user_name` char(18) NOT NULL default '',
> 
>   `snap` enum('on','off') NOT NULL default 'off',
> 
>   `creation_timestamp` timestamp(14) NOT NULL,
> 
>   `cols` tinyint(3) NOT NULL default '2',
> 
>   `rows` tinyint(3) NOT NULL default '2',
> 
>   `active` enum('on','off') NOT NULL default 'on',
> 
>   PRIMARY KEY  (`dashboard_tab_user_id`,`dashboard_tab_user_server_id`),
> 
>   KEY `user_id` (`user_id`,`user_server_id`),
> 
>   CONSTRAINT `dashboard_tab_user_ibfk_1` FOREIGN KEY (`user_id`,
> `user_server_id`) REFERENCES `user` (`user_id`, `user_server_id`) ON
> DELETE CASCADE
> 
> ) TYPE=InnoDB 
> 
> 
> 
> The query would run and set dashboard_tab_account_id to NULL correctly,
> but would not modify dashboard_tab_account_server_id in anyway.
> 
> 
> 
> John A. McCaskey
> 
> [EMAIL PROTECTED]
> 
> 

Here is a similar example that uses some old data I have lying about

localhost.test>select * from appointment;
++---+--+-+
| ID | OwnerName | MeetWithName | Date|
++---+--+-+
|  1 | Shawn | Dr. Bell | 2004-08-05 14:00:00 |
|  2 | Shawn | Dr. Bell | 2004-08-12 11:00:00 |
|  3 | John  | Mary | 2004-07-31 12:15:00 |
|  4 | John  | Mary | 2004-08-04 12:15:00 |
|  5 | John  | Mary | 2004-08-11 11:15:00 |
|  6 | John  | Mary | 2004-08-25 12:15:00 |
|  7 | Scott | David| 2004-08-01 09:00:00 |
|  8 | Scott | James| 2004-08-07 15:00:00 |
|  9 | Shawn | Scott| 2004-08-06 00:00:00 |
| 10 | Scott | Anna | 2004-08-22 00:00:00 |
| 11 | Shawn | Scott| 2003-08-07 16:00:00 |
++---+--+-+
11 rows in set (0.11 sec)

update appointment set ownername = null and meetwithname=null where id = 
11;

localhost.test>select * from appointment;
++---+--+-+
| ID | OwnerName | MeetWithName | Date|
++---+--+-+
|  1 | Shawn | Dr. Bell | 2004-08-05 14:00:00 |
|  2 | Shawn | Dr. Bell | 2004-08-12 11:00:00 |
|  3 | John  | Mary | 2004-07-31 12:15:00 |
|  4 | John  | Mary | 2004-08-04 12:15:00 |
|  5 | John  | Mary | 2004-08-11 11:15:00 |
|  6 | John  | Mary | 2004-08-25 12:15:00 |
|  7 | Scott | David| 2004-08-01 09:00:00 |
|  8 | Scott | James| 2004-08-07 15:00:00 |
|  9 | Shawn | Scott| 2004-08-06 00:00:00 |
| 10 | Scott | Anna | 2004-08-22 00:00:00 |
| 11 |   | Scott| 2003-08-07 16:00:00 |
++---+--+-+
11 rows in set (0.00 sec)

The SET clause is parsed and evaluated like this: 

ownername = (NULL and (meetwithname=NULL)). 

Anything "and"-ed with a null is NULL so there is no need to evaluate the 
right side of the "NULL and (...)" expression which is the right side of 
the assignment operator. That leaves the SET clause as simply:  ownername 
= NULL with no remaining reference to the second field. The second field 
is not modified because the section of the equation that would have caused 
a change to it is never evaluated.

I don't see this as a bug. I would like to see a warning that a column 
assignment has been optimized away. What says the list?

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Re: I forgot the admin password

[Martijn Tonies]

> > 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 now I want to start practicing ", it doesn't really matter...

Just reinstall it and you're fresh to go, right?

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


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

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

[Devananda]

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:

SELECT * FROM lad LEFT JOIN snd ON lad.id = snd.lad_id

I quit the query after 5 minutes.

Why is this so?

Chritofer Dutz



Christofer,

You'll need to provide the list with more information for anyone to be 
able to help you. What version of MySQL are you running? Can you paste 
the output of "show create table snd; show create table lad;" Also, do 
you have other processes using the server that could have locked one of 
the tables? When the query is taking a long time, try opening a second 
connection to the server and running "show full processlist;" to see 
what else is going on.



Regards,
Devananda vdv

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

Re: I forgot the admin password

[valentin_nils]

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

>
> With regards,
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>


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

SET query with inproper AND doesn't generate error?

[John McCaskey]

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 == vs = in c++, somehow mysql evaluated it as a Boolean logic
statement that turned into a valid query.  I don't have the time to
think about it too much, but I thought it would be interesting to hear
how it was valid and why it didn't generate an error (or maybe its
actually a bug and should be an error?).

 

Here is the query:

 

UPDATE dashboard_tab_user SET dashboard_tab_account_id = NULL AND
dashboard_tab_account_server_id = NULL WHERE dashboard_tab_user_id = 194
AND dashboard_tab_user_server_id = 99;

 

Here is the table schema:

CREATE TABLE `dashboard_tab_user` (

  `dashboard_tab_user_id` mediumint(8) unsigned NOT NULL auto_increment,

  `dashboard_tab_user_server_id` tinyint(3) unsigned NOT NULL default
'0',

  `dashboard_tab_account_id` mediumint(8) unsigned default '0',

  `dashboard_tab_account_server_id` tinyint(3) unsigned default '0',

  `user_id` mediumint(8) unsigned NOT NULL default '0',

  `user_server_id` tinyint(3) unsigned NOT NULL default '0',

  `dashboard_tab_user_name` char(18) NOT NULL default '',

  `snap` enum('on','off') NOT NULL default 'off',

  `creation_timestamp` timestamp(14) NOT NULL,

  `cols` tinyint(3) NOT NULL default '2',

  `rows` tinyint(3) NOT NULL default '2',

  `active` enum('on','off') NOT NULL default 'on',

  PRIMARY KEY  (`dashboard_tab_user_id`,`dashboard_tab_user_server_id`),

  KEY `user_id` (`user_id`,`user_server_id`),

  CONSTRAINT `dashboard_tab_user_ibfk_1` FOREIGN KEY (`user_id`,
`user_server_id`) REFERENCES `user` (`user_id`, `user_server_id`) ON
DELETE CASCADE

) TYPE=InnoDB 

 

The query would run and set dashboard_tab_account_id to NULL correctly,
but would not modify dashboard_tab_account_server_id in anyway.

 

John A. McCaskey

[EMAIL PROTECTED]

 

RE: Inserting information into multiple tables and problems

[Todd Hewett]

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 TABLE BOARD_SERIAL_NUMBER;
> +
> | BOARD_SERIAL_NUMBER | CREATE TABLE `BOARD_SERIAL_NUMBER` (
>   `BOARD_SERIAL_NUMBER_PK` int(10) unsigned NOT NULL auto_increment,
>   `VCS_PO_NUMBER_PK` int(10) unsigned NOT NULL default '0',
>   `BOARD_SERIAL_NUMBER` varchar(255) NOT NULL default '',
>   PRIMARY KEY  (`BOARD_SERIAL_NUMBER_PK`,`VCS_PO_NUMBER_PK`),
>   KEY `BOARD_SERIAL_NUMBER_FKIndex1` (`VCS_PO_NUMBER_PK`),
>   FOREIGN KEY (`VCS_PO_NUMBER_PK`) REFERENCES
> `productiontrack.VCS_PO_NUMBER` (`VCS_PO_NUMBER_PK`) ON DELETE CASCADE
> ) TYPE=InnoDB |
>
+-+-

Because you're not specifying a value for VCS_PO_NUMBER_PK in that 
INSERT statement, it will default to 0. It is a foreign key referencing 
the 'productiontrack.VCS_PO_NUMBER' table, which I bet doesn't have a 
row with VCS_PO_NUMBER_PK equal to 0. Hence the foreign key constraint 
fails.

You need to either:
1/ Specify the relevant value for VCS_PO_NUMBER_PK in your insert 
statement, like
INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER, VCS_PO_NUMBER_PK) 
VALUES (36534, 12345);

2/ Remove the foreign key constraint

3/ Create a row in VS_PO_NUMBER where VCS_PO_NUMBER_PK is equal to 0

You should probably take option 1 if possible.

#
O.K. VCS_PO_NUMBER_PK is an auto increment primary key for VCS_PO_NUMBER

How would I know that value... I am trying to inser the VCS_PO_NUMBER at
this time.

I guess what needs to be one in this case is:

Insert the VCS_PO_NUMBER
Search the table for VCS_PO_NUMBER_PK where VCS_PO_NUMBER IS a certain value
and then use that info in the board serial number insert.

Does that sound right?

Thanks for the illumination.

Todd


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




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

Re: mysql_free_result() & 2 different connections

[Pooly]

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 have been
> already free...

4.1.4 is beta version, isn't it ? I'll suggest you try the latest
binary for 4.1 available for your setup.

> I suspect that the current version of MySQL frees the resources automatically,

no, it does not :-)

> in FreeBSD the warning was more explicit, it said something like "trying to
> free again a result chunk"... this one performed a single query and a single
> result_free() so there was no place for a mistake...
> 

again, showing _real_ code would help, or a strip-down code that
crashes. The MySQL api does not free ressources automatically, so if
you have the crash on two different system, I would think the bug
comes from your code.

> > That would leave a nice memory leak indeed...
> > eventually, recompile and set a break-point before calling mysql_free,
> > and look at all variables.
> 
> MySQL internal variables? to see the status before? that's a good idea, I will
> do it, thanks for your comments and will post it as soon as I get results :-)
> 

nop, you MYSQL_RES, and it's value. did you set to NULL after freeing
it ? that would help.

> Regards
> 
> P.S.
> I already posted it to bugs.mysql.com but still do not get response
> 

again, I doubt it's a bug in the api, I use various 4.0.x, 4.1.x daily
and several OS and I've never had a crash in it (except from my own
mistakes, non-null terminated query strings, threads messing up,
freeing twice a result, non-allocating of result). the API is pretty
robust :-)

-- 
Pooly
Webzine Rock : http://www.w-fenec.org/

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

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

[Daniel]

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 users WHERE id=userID LIMIT 1;

Sometimes when I execute this stored procedure with, for example:

CALL getUser(7);

I get the error "Lost connection to MySQL server during query".

This only ever happens with stored procedures, never with any normal 
kind of query.


I am using MySQL 5.0.12-beta-log on Gentoo Linux x86.




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

Re: Federated engine and "comment"???

[Martijn Tonies]

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 release.
>
> This is fixed in 5.0.13, the documentation just hasn't caught up with
> the change yet. The new syntax is CONNECTION = '...'.

Great, that's much better :-) :-)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


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

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

[Christofer Dutz]

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 JOIN snd ON lad.id = snd.lad_id

I quit the query after 5 minutes.

Why is this so?

Chritofer Dutz

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

RE: Timezone setting wrong?

[Petr Chardin]

> 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 list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Federated engine and "comment"???

[Jim Winstead]

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.13, the documentation just hasn't caught up with
the change yet. The new syntax is CONNECTION = '...'.

Jim Winstead
MySQL Inc.

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

Re: I forgot the admin password

[Arno Coetzee]

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 log in . i suppose i 
forget the

rigth password, how can a blank this??

thank you
lgaray





No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.3/107 - Release Date: 
2005-09-20






 

I agree with Johan. When i was a newbie(not that i am an expert now  
;-)  ) i had the same prob - forgetting my root password.


have a look at http://dev.mysql.com/doc/mysql/en/resetting-permissions.html

good luck Luis

--
Arno Coetzee
Developer
Flash Media Group
Office : +27 12 342 7595
Mobile : +27 82 693 6180


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

Re: I forgot the admin password

[Martijn Tonies]

==
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, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


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

Re: I forgot the admin password

[Johan Höök]

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 forget the
rigth password, how can a blank this??

thank you
lgaray





No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.3/107 - Release Date: 2005-09-20



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

Error

[sinisa]

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 computer safe.

Have a nice day,
The lists.mysql.com team.



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

I forgot the admin password

[Luis Garay]

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

[Randy Paries]

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 I have a file called millhouse.unitnet.com.err

My main db is unitnet

It appears this is a good link that I received from GLEB
http://dev.mysql.com/doc/mysql/en/communication-errors.html

I am going down that path right now

Thanks
Randy 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 21, 2005 8:19 AM
To: Randy Paries
Cc: mysql@lists.mysql.com
Subject: 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: 'unitnet' user: 'paries'
> host: `local.flanders' (Got an error reading communication packets)
> 050122 20:28:49 Aborted connection 53612 to db: 'unitnet' user: 'paries'
> host: `local.krusty' (Got an error reading communication packets)
> 050122 20:29:20 Aborted connection 53671 to db: 'unitnet' user: 'paries'
> host: `local.flanders' (Got an error reading communication packets)
> 050122 20:32:14 Aborted connection 53910 to db: 'unitnet' user: 'paries'
> host: `local.flanders' (Got an error reading communication packets)
> 050122 20:34:47 Aborted connection 54111 to db: 'unitnet' user: 'paries'
> host: `local.flanders' (Got an error reading communication packets)
> 050122 20:34:48 Aborted connection 54116 to db: 'unitnet' user: 'paries'
> host: `local.flanders' (Got an error reading communication packets)
> 050122 20:35:11 Aborted connection 54142 to db: 'unitnet' user: 'paries'
> host: `local.krusty' (Got an error reading communication packets)
> 050122 20:38:45 Aborted connection 54468 to db: 'unitnet' user: 'paries'
> host: `local.flanders' (Got an error reading communication packets)
> 050122 20:39:46 Aborted connection 54572 to db: 'unitnet' user: 'paries'
> host: `local.krusty' (Got an error reading communication packets)
> 050122 20:40:54 Aborted connection 54584 to db: 'unitnet' user: 'paries'
> host: `local.flanders' (Got an error reading communication packets)
> 050122 20:42:09 Aborted connection 54794 to db: 'unitnet' user: 'paries'
> host: `local.krusty' (Got an error reading communication packets)
> 050122 20:43:33 Aborted connection 54936 to db: 'unitnet' user: 'paries'
> host: `local.krusty' (Got an error reading communication packets)
> 050122 20:44:40 Aborted connection 55004 to db: 'unitnet' user: 'paries'
> host: `local.krusty' (Got an error reading communication packets)
> 
> 

Not unless you can tell us which application is making those log entries and
which log file you just quoted. What you just did is a lot like playing
a sound over the telphone and asking a painter what's wrong with your
plumbing. This may not even be a MySQL problem. Unless we know where those
entries are (which log) and where they come from(which app is making them),
we can have no clue what they mean. 

Next time, please provide us with more context to your question, OK? We need
to know what OS you are using, what version of MySQL you are using, and many
details about what exactly you were doing that created the problem you are
trying to get us to help you with. If you can describe the problem even
more, please do.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine 



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

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

[Guilhem Bichot]

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 fixed in 5.0 .. could be please confirm
> this.

It was fixed in 3 branches:
http://dev.mysql.com/doc/mysql/en/news-4-0-24.html
and also 4.1.9 and 5.0.2.

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

Re: looking for direction on how to debug this message

[Gleb Paharenko]

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-//

 >050122 20:28:00 Aborted connection 53561 to db: 'unitnet' user: 'paries'

 >host: `local.flanders' (Got an error reading communication packets)

 >050122 20:28:49 Aborted connection 53612 to db: 'unitnet' user: 'paries'

 >host: `local.krusty' (Got an error reading communication packets)

 >050122 20:29:20 Aborted connection 53671 to db: 'unitnet' user: 'paries'

 >host: `local.flanders' (Got an error reading communication packets)

 >050122 20:32:14 Aborted connection 53910 to db: 'unitnet' user: 'paries'

 >host: `local.flanders' (Got an error reading communication packets)

 >050122 20:34:47 Aborted connection 54111 to db: 'unitnet' user: 'paries'

 >host: `local.flanders' (Got an error reading communication packets)

 >050122 20:34:48 Aborted connection 54116 to db: 'unitnet' user: 'paries'

 >host: `local.flanders' (Got an error reading communication packets)

 >050122 20:35:11 Aborted connection 54142 to db: 'unitnet' user: 'paries'

 >host: `local.krusty' (Got an error reading communication packets)

 >050122 20:38:45 Aborted connection 54468 to db: 'unitnet' user: 'paries'

 >host: `local.flanders' (Got an error reading communication packets)

 >050122 20:39:46 Aborted connection 54572 to db: 'unitnet' user: 'paries'

 >host: `local.krusty' (Got an error reading communication packets)

 >050122 20:40:54 Aborted connection 54584 to db: 'unitnet' user: 'paries'

 >host: `local.flanders' (Got an error reading communication packets)

 >050122 20:42:09 Aborted connection 54794 to db: 'unitnet' user: 'paries'

 >host: `local.krusty' (Got an error reading communication packets)

 >050122 20:43:33 Aborted connection 54936 to db: 'unitnet' user: 'paries'

 >host: `local.krusty' (Got an error reading communication packets)

 >050122 20:44:40 Aborted connection 55004 to db: 'unitnet' user: 'paries'

 >host: `local.krusty' (Got an error reading communication packets)



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




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

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

[SGreen]

"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: 'unitnet' user: 'paries'
> host: `local.flanders' (Got an error reading communication packets)
> 050122 20:28:49 Aborted connection 53612 to db: 'unitnet' user: 'paries'
> host: `local.krusty' (Got an error reading communication packets)
> 050122 20:29:20 Aborted connection 53671 to db: 'unitnet' user: 'paries'
> host: `local.flanders' (Got an error reading communication packets)
> 050122 20:32:14 Aborted connection 53910 to db: 'unitnet' user: 'paries'
> host: `local.flanders' (Got an error reading communication packets)
> 050122 20:34:47 Aborted connection 54111 to db: 'unitnet' user: 'paries'
> host: `local.flanders' (Got an error reading communication packets)
> 050122 20:34:48 Aborted connection 54116 to db: 'unitnet' user: 'paries'
> host: `local.flanders' (Got an error reading communication packets)
> 050122 20:35:11 Aborted connection 54142 to db: 'unitnet' user: 'paries'
> host: `local.krusty' (Got an error reading communication packets)
> 050122 20:38:45 Aborted connection 54468 to db: 'unitnet' user: 'paries'
> host: `local.flanders' (Got an error reading communication packets)
> 050122 20:39:46 Aborted connection 54572 to db: 'unitnet' user: 'paries'
> host: `local.krusty' (Got an error reading communication packets)
> 050122 20:40:54 Aborted connection 54584 to db: 'unitnet' user: 'paries'
> host: `local.flanders' (Got an error reading communication packets)
> 050122 20:42:09 Aborted connection 54794 to db: 'unitnet' user: 'paries'
> host: `local.krusty' (Got an error reading communication packets)
> 050122 20:43:33 Aborted connection 54936 to db: 'unitnet' user: 'paries'
> host: `local.krusty' (Got an error reading communication packets)
> 050122 20:44:40 Aborted connection 55004 to db: 'unitnet' user: 'paries'
> host: `local.krusty' (Got an error reading communication packets)
> 
> 

Not unless you can tell us which application is making those log entries 
and which log file you just quoted. What you just did is a lot like 
playing a sound over the telphone and asking a painter what's wrong with 
your plumbing. This may not even be a MySQL problem. Unless we know where 
those entries are (which log) and where they come from(which app is making 
them), we can have no clue what they mean. 

Next time, please provide us with more context to your question, OK? We 
need to know what OS you are using, what version of MySQL you are using, 
and many details about what exactly you were doing that created the 
problem you are trying to get us to help you with. If you can describe the 
problem even more, please do.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine 

RE: Timezone setting wrong?

[Jeff McKeon]

> -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 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 ahead.  
> All the data on this system is replicated from a master.  The 
> master is set correctly, hwclock and sysclock at UTC.
> 
> The same query:
> 
> Select max(from_unixtime(timestamp_field)) from table;
> 
> Run on both servers returns a result 1 hour ahead on the new slave.
> 
> A show variables on the new slave returns
> 
> *** 120. row ***
> Variable_name: timezone
> Value: IST
> 
> I'm sure I've missed something simple here but what?
> 
> Thanks,
> 
> Jeff
> 

Ok, update, show variables on the master returns timezone of GMT, the
slave IST.  The master is on RH9 and the slave on RHEL3.
So on mysql 4.0.16 where do I force the timezone to be GMT?  

I've tried putting TZ = GMT and TZ = UTC into the my.cnf file but then
mysql won't even start.


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

Re: connect from oracle to MYSQL.

[Ananda Kumar]

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
> >
> > -- 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
> >
> > Hi All,
> > Can you please help me in connecting from oracle database to mysql
> database.
> > I am trying to setup the hetrogenious service provided by oracle, but i
> am
> > not able to complete all the steps.
> > I am failing at this step
> > *cp MyODBC-3.51.06-sun-solaris2.8-sparc/libmyodbc3* lib*
> > # *mv etc/odbc.ini etc/odbc.ini.backup*
> > # *cp MyODBC-3.51.06-sun-solaris2.8-sparc/odbc.ini etc*
> > # *cd lib*
> > # *rm libmyodbc3.so libmyodbc3_r.so*
> > # *ln -s libmyodbc3-3.51.06.so  <
> http://libmyodbc3-3.51.06.so/> libmyodbc3.so
> > *
> > # *ln -s libmyodbc3_r-3.51.06.so  
> libmyodbc3_r.so*
> > **
> > *I am not seeing libmyodbc files in
> > MyODBC-3.51.06-sun-solaris2.8-sparcdirectory. I am seeing only this
> > files
> > *
> > MyODBC-3.51.10-sun-solaris2.8-sparc.pkg
> > README.
>
> #pkgadd -d MyODBC-3.51.10-sun-solaris2.8-sparc.pkg
> #more README
>
> ?
>
> > I am using solaris2.8 for oracle database and mysql 4.1 on linux fedaro.
> > regards
> > anandkl
> >
> >
>
>
> --
> Pooly
> Webzine Rock : http://www.w-fenec.org/
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>

Log file full of Got an error reading communication packets

[Randy Paries]

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 packets)
050122 20:28:49 Aborted connection 53612 to db: 'unitnet' user: 'paries'
host: `local.krusty' (Got an error reading communication packets)
050122 20:29:20 Aborted connection 53671 to db: 'unitnet' user: 'paries'
host: `local.flanders' (Got an error reading communication packets)
050122 20:32:14 Aborted connection 53910 to db: 'unitnet' user: 'paries'
host: `local.flanders' (Got an error reading communication packets)
050122 20:34:47 Aborted connection 54111 to db: 'unitnet' user: 'paries'
host: `local.flanders' (Got an error reading communication packets)
050122 20:34:48 Aborted connection 54116 to db: 'unitnet' user: 'paries'
host: `local.flanders' (Got an error reading communication packets)
050122 20:35:11 Aborted connection 54142 to db: 'unitnet' user: 'paries'
host: `local.krusty' (Got an error reading communication packets)
050122 20:38:45 Aborted connection 54468 to db: 'unitnet' user: 'paries'
host: `local.flanders' (Got an error reading communication packets)
050122 20:39:46 Aborted connection 54572 to db: 'unitnet' user: 'paries'
host: `local.krusty' (Got an error reading communication packets)
050122 20:40:54 Aborted connection 54584 to db: 'unitnet' user: 'paries'
host: `local.flanders' (Got an error reading communication packets)
050122 20:42:09 Aborted connection 54794 to db: 'unitnet' user: 'paries'
host: `local.krusty' (Got an error reading communication packets)
050122 20:43:33 Aborted connection 54936 to db: 'unitnet' user: 'paries'
host: `local.krusty' (Got an error reading communication packets)
050122 20:44:40 Aborted connection 55004 to db: 'unitnet' user: 'paries'
host: `local.krusty' (Got an error reading communication packets)



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

Timezone setting wrong?

[Jeff]

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 ahead.  
All the data on this system is replicated from a master.  The master is
set correctly, hwclock and sysclock at UTC.

The same query:

Select max(from_unixtime(timestamp_field)) from table;

Run on both servers returns a result 1 hour ahead on the new slave.

A show variables on the new slave returns

*** 120. row ***
Variable_name: timezone
Value: IST

I'm sure I've missed something simple here but what?

Thanks,

Jeff



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

Charset problems (utf-8 -> latin1)

[Morten Fangel]

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) FROM old_db.table;

When doing a
SELECT CHARSET(field) FROM new_db.table;
It returns "latin1", so everthings seems to be A-Okay - but since
 I'm posting this message you could prolly guess that it didn't - 
and right, it failed...

Using SSH to the mysql-server, and using `mysql` it always 
returns the data as UTF-8 (when setting the encoding to 
anything else it trashes the special-chars). I don't know if this is
 normal - I might be, so I continued my work on the migration.

I then reloaded the webpage (yes, it's for a PHP driven CMS), 
and no - the problem still existed. All data was returned as 
UTF-8 (when running a utf8_decode() in PHP on the db-output
the output was corrected and the speciel-chars showed up.

But - this isn't normal. Normally you can just enter the data as
 latin1, and display the output on the webpage (assuming that 
content-type has a charset og iso-8859-1). And this works 
everywhere else on the website.

SO, my question is: How the heck do you actually transfer 
data from the utf8-table to a latin1-table and properly
 re-encoding the text so that the latin1-table wouldn't contain
raw utf8-data (because that my friends - sucks)

Below are som excerps from SHOW VARIABLES - tell if 
your wan't more info... just included a few of the lines:
+-+---+
| Variable_name   | Value|
+-+---+
| back_log| 50|
| basedir | /pack/mysql-4.1.13/|
| binlog_cache_size   | 32768|
| bulk_insert_buffer_size | 8388608|
| character_set_client| latin1|
| character_set_connection| latin1|
| character_set_database  | latin1|
| character_set_results   | latin1|
| character_set_server| latin1|
| character_set_system| utf8|
| version | 4.1.13-log|
+-+---+

Regards
  Morten Fangel // fangel

RE: Circular Replication

[Jeff]

> -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:
> >
> > server A is ver 4.0.x
> > server B is ver 4.1.x
> >
> > should there?
> >
> 
> There will totally by a problem here... The 4.1 server will take the  
> 4.0 feed without issue. The 4.1 server however puts all sorts of  
> information into the binary log which isn't in the original query,  
> like what sort of collation to use, and which character set it uses  
> and so on... 4.0 doesn't understand such commands and lots of things  
> break in this situation.
> 
> As a side note we deploy servers in pairs, with circular 
> replication.  
> We did three and four server circles, but it gets messy if  
> replication stops somewhere, the data becomes unpredictably  
> inconsistent (assuming all the servers in the circle are getting  
> production updates). Now we do simple two way replication between a  
> pair, and we hang a third server off the pair somewhere just  
> reading... the third server we use for backups, data dumps, reports  
> and other non production issues. Essentially it is something like A<- 
>  >B->C, where A and B have two way replication and C is used for  
> backups/reports etc... anything that changes the data happens 
> on A or B.
> 

I assume you then need to start server B with "--Log_slave_updates"?

> We do some other black magic to manage the replication on C so it's  
> perpetually behind the master servers by between 15 minutes and 2  
> hours... that way if we have a stupid operator error or some other  
> data corrupting event we can stop replication on the backup server  
> before it executes and start from there rather than having to 
> go back  
> to yesterdays backup or something.
> 
> Best Regards, Bruce
> 

Bruce,

Thanks for the info.  All my downstream servers are 4.1 and my masters
are all 4.0.  They will all be brought up to the latest when I can
figure out a production schedule that will allow it.

So for now what I'll have is:

A <-> B -> C
|\ 
D E

Where A and B (4.0.16) are masters in a circular replication and C,D,E
(4.1.13) are backups and other read only slave servers .

The reason for needing the circular replication is we are moving our
production systems to another data center and I need to be able to
quickly switch the applications over to the new data center and then
back again if something goes south.

After that however I think I'll keep the two db servers at the new data
center in a circular replication for redundancy probably.

I am interested in how you go about doing a "delayed replication" to
protect against operator error.  We've already fallen victim to that
situation here.

Thanks,

Jeff



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

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

[Pooly]

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 WHERE id=userID LIMIT 1;
> >>
> >>Sometimes when I execute this stored procedure with, for example:
> >>
> >>CALL getUser(7);
> >>
> >>I get the error "Lost connection to MySQL server during query".
> >>
> >>This only ever happens with stored procedures, never with any normal
> >>kind of query.
> >>
> >>I am using MySQL 5.0.12-beta-log on Gentoo Linux x86.
> >
> >
> > And what is your question?
> 
> Fairly obviously, how do I fix it!? ;)
> 
> > Most probably, a server crash...
> 
> Can you be a little bit more specific please? The MySQL server is
> working absolutely fine for everything else and also continues to
> respond to connections and queries perfectly after getting that error.
> 

I think he means, that you should try the official binaries, and this
still happens, file a bug report because 5.0 is still in Beta stage.

-- 
Pooly
Webzine Rock : http://www.w-fenec.org/

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

Re: Federated engine and "comment"???

[Martijn Tonies]

> > 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" is next to useless like this. It's already being misused
> > > by InnoDB to describe the FK constraints...
>
> Urm, where does it do that - my 4.1 server says
>   CONSTRAINT `login_properties_ibfk_1` FOREIGN KEY (`prop_login_id`)
> REFERENCES `login_master` (`login_id`) ON DELETE CASCADE ON UPDATE
CASCADE,
>   CONSTRAINT `login_properties_ibfk_2` FOREIGN KEY (`ref_prop_name`)
> REFERENCES `login_properties_master` (`prop_name`) ON DELETE CASCADE ON
> UPDATE CASCADE
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Properties for a login'
>
> nothing in the comment field about key constraints - or is that new in 5?

show table status

eg:
InnoDB free: 10240 kB; (`card_id`) REFER `test/card`(`pkey`) ON DELETE NO
ACTION ON UPDATE NO ACTION; (`card_id`) REFER `test/card`(`pkey`) ON DELETE
NO ACTION ON UPDATE NO ACTION; (`trans_id`) REFER `test/trans`(`pkey`) ON
DELETE NO ACTION ON UPDATE NO ACTION


Where's my original comment, if any?

All in all, bad!

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


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

Re: Federated engine and "comment"???

[Duncan Hill]

> 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" is next to useless like this. It's already being misused
> > by InnoDB to describe the FK constraints...

Urm, where does it do that - my 4.1 server says
  CONSTRAINT `login_properties_ibfk_1` FOREIGN KEY (`prop_login_id`) 
REFERENCES `login_master` (`login_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `login_properties_ibfk_2` FOREIGN KEY (`ref_prop_name`) 
REFERENCES `login_properties_master` (`prop_name`) ON DELETE CASCADE ON 
UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Properties for a login'

nothing in the comment field about key constraints - or is that new in 5?

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

Re: Federated engine and "comment"???

[Duncan Hill]

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" is next to useless like this. It's already being misused
> by InnoDB to describe the FK constraints...
>
> What's wrong with introducing a new clause?

The manual states:
The use of COMMENT for specifying the connection string is non-optimal and 
will likely change in MySQL 5.1. Keep this in mind when you use FEDERATED 
tables, because it means you'll need to make some modifications when that 
happens.

So I'd guess they know full well it's not the best way to do it.

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

Federated engine and "comment"???

[Martijn Tonies]

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 describe the FK constraints...

What's wrong with introducing a new clause?

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


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

Re: Failure to install on Solaris.

[Hugh Sasse]

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 \
 --prefix=/usr/local/mysql --enable-assembler \
 --enable-thread-safe-client \
 --with-mysqld-ldflags=-all-static --with-tcp-port=3308 \
 --with-unix-socket-path=/tmp/mysql4.sock \
 --with-pthread --with-gnu-ld && \
 gmake && \
 cd mysql-test && ./mysql-test-run --force
 exit


Get rid of the --with-mysqld-ldflags=-all-static flag; Solaris 9
doesn't provide a static pthread, and in Solaris 10, you can't build
static binaries at all:

http://partneradvantage.sun.com/protected/solaris10/adoptionkit/tech/proc.html
http://blogs.sun.com/roller/page/rie/?anchor=static_linking_where_did_it


Thank you. This worked.  I'd like to propose the following patch
against 4.1.13:


neelix hgs 96 %> gdiff -u INSTALL-SOURCE INSTALL-SOURCE.new
--- INSTALL-SOURCE  2005-07-15 11:42:14.0 +0100
+++ INSTALL-SOURCE.new  2005-09-21 10:40:23.848026000 +0100
@@ -60,12 +60,16 @@
 `-fno-rtti' along with`-fno-exceptions'. When in doubt, do the
 following:

- CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors \
--fno-exceptions -fno-rtti" ./configure \
+ CFLAGS="-O3"
+ CXX=gcc
+ CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti"
+ export CFLAGS CXX CXXFLAGS
+ ./configure \
 --prefix=/usr/local/mysql --enable-assembler \
 --with-mysqld-ldflags=-all-static

-On most systems, this gives you a fast and stable binary.
+On most systems, this gives you a fast and stable binary, but avoid
+--with-mysqld-ldflags=-all-static  on Solaris 2.9 and above.

 If you run into problems, _please always use`mysqlbug'_ when
 posting questions to aMySQL mailing list. Even if the problem isn't
neelix hgs 97 %>

This is mainly because the variables need to be exported for
recursive make to work correctly, from what I saw.


--
Dan Nelson
[EMAIL PROTECTED]


Thank you,
Hugh


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

bind (listen) question

[Andrea]

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://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

[Jasper Bryant-Greene]

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:

CALL getUser(7);

I get the error "Lost connection to MySQL server during query".

This only ever happens with stored procedures, never with any normal
kind of query.

I am using MySQL 5.0.12-beta-log on Gentoo Linux x86.



And what is your question?


Fairly obviously, how do I fix it!? ;)


Most probably, a server crash...


Can you be a little bit more specific please? The MySQL server is 
working absolutely fine for everything else and also continues to 
respond to connections and queries perfectly after getting that error.


Thanks

--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/

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

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

[Martijn Tonies]

> 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 the error "Lost connection to MySQL server during query".
>
> This only ever happens with stored procedures, never with any normal
> kind of query.
>
> I am using MySQL 5.0.12-beta-log on Gentoo Linux x86.

And what is your question?


;-)

Most probably, a server crash...

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


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

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

[Jasper Bryant-Greene]

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 the error "Lost connection to MySQL server during query".

This only ever happens with stored procedures, never with any normal 
kind of query.


I am using MySQL 5.0.12-beta-log on Gentoo Linux x86.

--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/

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

Re: connect from oracle to MYSQL.

[Pooly]

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
> 
>  Hi All,
> Can you please help me in connecting from oracle database to mysql database.
> I am trying to setup the hetrogenious service provided by oracle, but i am
> not able to complete all the steps.
>  I am failing at this step
>  *cp MyODBC-3.51.06-sun-solaris2.8-sparc/libmyodbc3* lib*
> # *mv etc/odbc.ini etc/odbc.ini.backup*
> # *cp MyODBC-3.51.06-sun-solaris2.8-sparc/odbc.ini etc*
> # *cd lib*
> # *rm libmyodbc3.so libmyodbc3_r.so*
> # *ln -s libmyodbc3-3.51.06.so  libmyodbc3.so
> *
> # *ln -s libmyodbc3_r-3.51.06.so  libmyodbc3_r.so*
> **
> *I am not seeing libmyodbc files in
> MyODBC-3.51.06-sun-solaris2.8-sparcdirectory. I am seeing only this
> files
> *
> MyODBC-3.51.10-sun-solaris2.8-sparc.pkg
> README.

#pkgadd -d MyODBC-3.51.10-sun-solaris2.8-sparc.pkg
#more README

?

>  I am using solaris2.8 for oracle database and mysql 4.1 on linux fedaro.
>  regards
> anandkl
> 
> 


-- 
Pooly
Webzine Rock : http://www.w-fenec.org/

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