MYSQL DATABASE SERVER

2007-10-17 Thread Krishna Chandra Prajapati
Hi All, The production server on which mysql database was running, get shutdown on one day. Then we have to manually start it. The server is hpdl585. What can be the reason of shutdown. What has gone wrong with the server. Is there is any to find the reason for shutdown. Thanks, Krishna

Re: MySQL 5.1.22 is out

2007-10-17 Thread Jim
Is there any kind of timetable for when 5.1 is actually expected to be released? - Original Message - From: "Kaj Arnö" <[EMAIL PROTECTED]> To: "MySQL List" Sent: Wednesday, October 17, 2007 3:07 AM Subject: BLOG: MySQL 5.1.22 is out MySQL users, Sorry for spamming mysql@lists.mys

Re: urgente

2007-10-17 Thread Tiago Cruz
Hello David, On Tue, 2007-10-16 at 12:59 -0500, david chan cocom wrote: > estos son los errores que proporciona mysql cuando instalo el paquete o el > codigo fuente. > Espero que me puedan ayudar me urge mucho. > P.D hace 15 dias que tengo este problema por favor ayudenme de antemano se

urgente

2007-10-17 Thread david chan cocom
buenas tardes espero que al recibir este mail se encuentre bien de salud todos . El motivo por el cual les envio este mail, es porque mysql que estoy instalando en solaris 10 marca errores cuando estoy instalando el paquete , el mysql lo obtuve de la pagina sunfreeware y cuando le doy un pkgadd

[mysql] Text = Tinytext = MediumText = LongText?

2007-10-17 Thread Weston, Craig (OFT)
Hello everyone, hopefully a quick question: is there a functional difference between the various text field sizes other than size? For example if I wanted to could I run a FULLTEXT index against a LongText field? The collary is of course how good of an idea is this, assuming that MOST of the d

Bug?: "SELECT *, Field" vs. "SELECT Field, *"

2007-10-17 Thread Ralf Hüsing
Hi, When i try: "SELECT *, id FROM " all is fine. But if i want the "*" at the end (because the table is large) i try: "SELECT id, * FROM " and got: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*

Re: find real/valid name current db

2007-10-17 Thread Sebastian Mendel
ups, typo ... Sebastian Mendel schrieb: > Hi, > > how can i find the real/valid name for current active db? > > Windows, lower_case_table_names = 2 > > CREATE DATABASE `UPPERCASE`; > USE `UPPERCASE`; > SELECT DATABASE(); > // `UPPERCASE` should read // returns `uppercase` > but working with

BLOG: MySQL 5.1.22 is out

2007-10-17 Thread Kaj Arnö
MySQL users, Sorry for spamming mysql@lists.mysql.com, but you may be interested in my blog entry that complements our MySQL 5.1.22 announcement. The Real Thing in HTML is on http://www.planetmysql.org/kaj/?p=131 and pasted below for offline reading. MySQL 5.1.22 is out A good two weeks a

find real/valid name current db

2007-10-17 Thread Sebastian Mendel
Hi, how can i find the real/valid name for current active db? Windows, lower_case_table_names = 2 CREATE DATABASE `UPPERCASE`; USE `UPPERCASE`; SELECT DATABASE(); // `UPPERCASE` but working with the returned lower case `UPPERCASE` results in an invlaid db error also see bug #31658 (http://bugs