mysqld freezing/hanging every some day, by now every some minutes

Description: sig 11 every now and then, mysqld freezes. we have exim + courier authenticating against mysql, also some customer databases (php) How-To-Repeat: well, no idea, it just happens... fivefold /tmp # resolve_stack_dump -s /tmp/mysqld.sym -n

access denied 1045

I'm completely new to mysql. I've been hunting all over the web and mysql help/documentation but could not find a working solution to my problem. I installed mysql on a RAQ4 from the standard package that came from Cobalt. I was able to set the root@host password, but unable to set the

question for research (OT)

Hi! I saw Czech people posting here. Im doing research for a local computer magazine and I'm looking for online fees in Czech Republic. The article deals with chances for international companies after Czech EU accedence. Nothing to find in Google database. Could you please feed me some data or

RE: access denied 1045

Hi Cobalt uses 'cobalt-mysql' as the default mysql root password. I spent hours trying to sort this one out, reinstalled the whole thing, manually recreated Mysql database all sorts Stupid to use non standard setup really. If that doesn't work come back to me. Peter

re: /usr/bin/mysqladmin missing from Linux/x86 RPM

scott, Saturday, November 16, 2002, 12:08:52 AM, you wrote: sdaaado I downloaded and installed the RPM from mysql.org (the uu.net mirror sdaaado in the USA). The transcript told me to set a root password using sdaaado /usr/bin/mysqladmin, but that program doesn't exist. I also am

re: installing mySQLGUI

Craig, Friday, November 15, 2002, 10:45:08 PM, you wrote: CM How do I go about installing mysqlGUI? I have downloaded all of the CM files. What about reading README and install.txt files? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored

SQL Query

Hi, I have a colum with this values : ,1,4,5,66,247,7, ,1,3,5,62,767,6, ,1,5,5,11 ,1,9,5,36,7677,9, ,1,40,55,66,444,3, I want to get whis values : (second field) 4 3 5 9 40 I have tried this : REPLACE(SUBSTRING_INDEX(value, ',', 3), ',','') But the following is returned : 14

RE: SQL Query

Why not just split that field up into multiple fields. Seems ridiculous to have multiple values in a single field in a RDMS -Peter -Original Message- From: Paul van Brouwershaven [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 16, 2002 14:46 To: [EMAIL PROTECTED] Subject: SQL

RE: SQL Query

I'ts a dump of an other database with more than 4 million records -Original Message- From: Thoenen, Peter Mr. EPS [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 16, 2002 2:54 PM To: 'Paul van Brouwershaven'; [EMAIL PROTECTED] Subject: RE: SQL Query Why not just split

Help: Problem creating db's in winMySQLAdmin

Hi everyone – I have a problem: I installed mySQL yesterday on a WinXP Pro system and have used winMySQLAdmin.exe for most administrative purposes. According to the website and the documentation, I can create a new db from within the program by going to the “Databases” tab and right-clicking,

Re: SQL Query

- Original Message - From: Paul van Brouwershaven [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 16, 2002 8:58 AM Subject: RE: SQL Query I'ts a dump of an other database with more than 4 million records Yeah, but that still doesn't mean that you can't use the earlier

RE: SQL Query

The number of values is also not the same, this can be 1 till +/-30 values -Original Message- From: Dennis Salguero [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 16, 2002 1:46 PM To: Paul van Brouwershaven; [EMAIL PROTECTED] Subject: Re: SQL Query - Original Message

RE: SQL Query

Sorry it's default -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 16, 2002 5:23 PM To: Paul van Brouwershaven Subject: Re: SQL Query Please do NOT mark posted messages 'request reply'. - - Original Message - From:

Re: SQL Query

First of all, don't do this in mysql . If you got a dump of the database, using cut utility u can easily extract the second field in the delimited by the comma.. and then split them into different columns in the table when you want to insert them into the mysql database. If you are still

Problems with reserved words

Howdy, Recently I was working with a contractor on a schema for a project. I'm terribly embarrassed to admit that one of the tables we came up with got named order since it keeps track of an order number assigned to a shipment by a vendor. I bet you know what's coming next. Somehow, mysql

Re: SQL Query

Hi, If the lenght of what wish to retrieve is fixed to 2 length,you can try something like this: select MID(YOUR_FIELD,3,IF(RIGHT(LPAD(YOUR_FIELD,4,','),1)=',',1,2)) from YOUR_TABLE; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail

Re: Problems with reserved words

Never mind. Renaming the files worked the trick. :) Matt - Original Message - From: Matt Kenigson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 16, 2002 11:35 AM Subject: Problems with reserved words Howdy, Recently I was working with a contractor on a schema

Re: Problems with reserved words

Oh, FYI, I did stop mysql first, change the file names, then restart it. Matt - Original Message - From: Matt Kenigson [EMAIL PROTECTED] To: Matt Kenigson [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 16, 2002 11:39 AM Subject: Re: Problems with reserved words Never