remote connections have stopped working

I'm running mysql-3.23.49 on a redhat machine, mysql has stopped responding to remote connections ever since i rebooted it today. /var/log/mysqld.log says Number of processes running now: 1 mysqld process hanging, pid 3062 - killed 021015 20:37:05 mysqld restarted /usr/libexec/mysqld: ready for

Image display Blob

Hi! I have a html-php form which connects to a my-sql DB and retrieves and displays the name and image(Stored in Blob) I'm using Header("Content-type: image/gif") to display the mesage queried from my sql. This displays the image, but I want it displayed in a along with other text and not exclus

RE: Getting mysql up and running on Mac OSX

Well the @INC is the enviroment array of perl so the perl script you're running needs DBI.pm perl module that appears not to be instaled on your box you can find more info about on http://dbi.perl.org/index.html and you can get it on http://search.cpan.org/author/TIMB/DBI-1.30/ -jose >I've g

RE: MySql SETUP Problem

Well try mysql -u root -p it will prompt asking for the password I really don't remember if the derault password is mysql but you could try empty too. -jose >Hi! > >I installed the full version of Mandrake 8.2. >The problem is that i can't setup the mysql server. >When i tried: mysql -u root

Re: Query using the same table twice

Yeah, I know. I just meant the comma with the appropriate WHERE clause was equivalent to INNER JOIN with an ON or USING clause. Sorry if that wasn't clear. I prefer the comma operator. By using commas, I was able to get rid of all the parenthesis and simplify the FROM and WHERE clauses. --jeff -

Getting mysql up and running on Mac OSX

I've gotten mysql server running but am getting lots of errors when I try to run any of the scripts that come with it. for example when issuing the following command. [HDSK-Laptop:/library/mysql/sql-bench] haridass# ./run-all-tests The result I get is: Can't locate DBI.pm in @INC (@INC contains

MySql SETUP Problem

Hi! I installed the full version of Mandrake 8.2. The problem is that i can't setup the mysql server. When i tried: mysql -u root mysql; the server responded: acces denied for root@localhost !! Then tried the command mysql_install_db. But when i wanted to sign in: still acces denied. Then

Mysql seg faults on remote connections

Description: I have some issues with mysql in my production environment that is causing mysql not to accept remote connections on multiple machines. It now appear that a name resolution problem is the root of the problem but it is not handled very well by mysql so it may want to be looked at.

Crystal Reports & MySQL

Hi, does anyone knows if Cristal reports is a good reporter to make reports out of MySQL, or does anyone knows a good reporter for PHP MySQL? Thanks The Vampmaster - Before posting, please check: http://www.mysql.com/manua

inserting records

Hello folks ** sql,query * Can anyone give me a clue, how to solve this problem I have a table with only one column and values are inserted by getting user request from my application. I want to display the column values in the order they are inserted. So only option is t

Re: List of Linked Libraries for 3.23.52

> I have been running MySQL in 32-bit mode on Solaris for about a year now. > I've been attempting to compile 3.23.52 in 64 bit mode using the Sun > Workshop 6 Update 2 compiler. Everything works/compiles great until it's Any reason to go 64-bit? I've compiled 64-bit myself and it seems to work

Re: unauthenticated user

On Wed, Oct 16, 2002 at 11:30:47AM +0800, Terence wrote: > sql,query > > I have noticed an entry in the processlist which reads > > UserHostDBCommandState > unauthenticated userconnecting host[blank]connectlogin > > Can someone shed some light on this for me? Whe

unauthenticated user

sql,query I have noticed an entry in the processlist which reads UserHostDBCommandState unauthenticated userconnecting host[blank]connectlogin Can someone shed some light on this for me? Where is it coming from? Is it anything to be concerned about? Thanks --

can not login

Greeting, I have installed mysql on my solaris9/sunblade100. After I logout yesterday, I can not login anymore # ./mysql -h hostname -u username -p database Enter password: ERROR 1045: Access denied for user: 'username@hostname' (Using password: YES) I am sure the password is right, so, it mus

MDaemon Warning - Virus Found

The following message had attachment(s) which contained the viruses: >From : [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject : Frameborder Date : Message-ID: AttachmentVirus name Action taken

MDaemon Warning - Virus Found

The following message had attachment(s) which contained viruses: >From : [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject : Happy new Allhallowmas Date : Message-ID: AttachmentVirus name Action taken -

RE: Misunderstandings about SQL

I've been trying for hours to make the dropdown work but to no avail. I am able to get the dropdown to show up but What I want the first item to show is Categories. Next when I choose one of the categories the results show only one result regardless of the category I choose. Thank you. THI

Re: Query using the same table twice

At 18:03 -0700 10/15/02, Jeff Kilbride wrote: >Commas in the FROM clause are the same as INNER JOIN. Not any more. That was true up until 3.23.17, at which point INNER JOIN was changed to require an ON or USING clause. > To make it clearer and >easier to understand, I'd write it something like

How many columns does MySQL Support?

Two questions: 1) How many columns does MySQL support per table? 2) Is it just as fast with Mysql to access 10 fields in a table with 10 columns as it would be to access those same 10 fields among let's say 90 other fields in a 100 column table? Would speed only be reduced if I pulled a query on

Re: Where's safe_mysqld?

On Wed, Oct 16, 2002 at 10:06:43AM +0900, Chung Ha-nyung wrote: > > Dear, > > I installed MySQL 4.0.4 from source tarball and I found that > "safe_mysqld" is > mentioned here and there in the manual but I can't where it, > safe_mysqld, is > located. All that I found with `find . -name "*safe

Re: language charset

Egor As you said I have set the default-character-set = sjis But I need few clarfications for my strange problems I am using mysql 4.0.3-beta(innodb) on windows NT 4.0 (SP6) machine 1. Under \MYSQL_HOME\SHARE\CHARSETS, there is no config file for sjis like the ones for cp1251, german1 etc. Wil

Where's safe_mysqld?

Dear, I installed MySQL 4.0.4 from source tarball and I found that "safe_mysqld" is mentioned here and there in the manual but I can't where it, safe_mysqld, is located. All that I found with `find . -name "*safe"*"' command is mysqld_safe script. Thanks. -- Chung Ha-nyung Sayclub

Re: Query using the same table twice

Commas in the FROM clause are the same as INNER JOIN. To make it clearer and easier to understand, I'd write it something like this: SELECT psh.StatID, pt1.TeamName AS Home, pt2.TeamName AS Visitor, psh.GameDate FROM PH_TEAMS pt1, PH_TEAMS pt2, PH_SCORE_HEADER psh WHERE psh.Home = pt1.TeamID AND

Re: Looking for Doc on using XML with Mysql, Xml-Aware.

At 17:14 -0700 10/15/02, David Kramer wrote: >Can anyone point me in the direction of using XML with MySql, any doc will >do. Looking for info on the concept of Mysql being xml-aware. Im new with >using xml in a DB Environment. Hopefully Im asking the right questions >here. MySQL *isn't* XML-a

Re: Transaction isolation level - potential bug?

Amine Korch wrote: > Hello all. > I have encountered an really annoying problem in MySQL 3.23.49 on Win32. > I am using InnoDB because I need transactions. I use autocommit off. > I'll try best to describe the problem I have: > I have two sessions to my DB. > Session 1 inserts some data into a

Looking for Doc on using XML with Mysql, Xml-Aware.

Can anyone point me in the direction of using XML with MySql, any doc will do. Looking for info on the concept of Mysql being xml-aware. Im new with using xml in a DB Environment. Hopefully Im asking the right questions here. Thanks, DK David Kramer Software Developer Reflect.com Direct: 415

Re: Query using the same table twice

No time to figure out what you are doing, but I think you will find your answer here - if not send the table structure for the table you store the team id of the home and visitor in: http://www.wdvl.com/Authoring/DB/SQL/Joins/ olinux --- "Michael J. Mitchell" <[EMAIL PROTECTED]> wrote: > > I a

Re: "select CURTIME - " returns NULL sometimes

At 19:53 -0300 10/15/02, Joao A. Marques wrote: >Hi, >I´m getting problem with function CURTIME(). >The problem happens, apparently, when then current seconds of the current >time (server´s time) is between 43 and 59, as result of "CURTIME - type TIME>". >See : No, the problem is that you cannot

RE: Date Woes

As a matter of fact I am refering to ORACLE and the TO_CHAR which I find quite usefull. I have written a very poor and inflexable PHP function to do this outside the database. I have not played with doing my own functions in mySQL but your suggestion is well taken. I believe that I will atte

Re: Date Woes

You cannot always control the data you are getting from external sources. Not everyone uses the ISO standard (Including the default from Oracle and MS SQL Server). We get data from outside sources and it would be much eaiser to deal with if mysql had such a function. I'm not sure if I am bla

Re: Help downgrading

On Tue, Oct 15, 2002 at 03:41:24PM -0700, Karl Stubsjoen wrote: > Hello, > > Any help downgrading my MySQL Server from 4.0.0.0ALPHA to 3.23 would be a > huge help. I'm not sure where to start. Do I need to save records to a > flat file and then reimport them? I'm not sure if this is the right

"select CURTIME - " returns NULL sometimes

Hi, I´m getting problem with function CURTIME(). The problem happens, apparently, when then current seconds of the current time (server´s time) is between 43 and 59, as result of "CURTIME - ". See : [root@test01 /root]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL co

Re: How to : Export BLOB

How can a binary field inserted in a text file ? Can you give me an example ? Thanks - Original Message - From: "Insanely Great" <[EMAIL PROTECTED]> To: "Jean-Francois nadeau" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, October 15, 2002 6:33 PM Subject: Re: How to : Export B

Help downgrading

Hello, Any help downgrading my MySQL Server from 4.0.0.0ALPHA to 3.23 would be a huge help. I'm not sure where to start. Do I need to save records to a flat file and then reimport them? Karl - Before posting, please check:

Re: Copy table with column attributes

I have a table tbl_version_history which has a primary key and an index. Through this query I am able to create a copy tbl_version_history_copy with all the index. Just replace the stuff with yours and probably it will help. create table `tbl_version_history_copy` ( primary key ( FLD_REG_NUM )

Re: How to : Export BLOB

If you use mysqldump, escape the fields with proper escaping characters. You will get a proper dump. Rgds Insane SQLyog - The Definative GUI for MySQL http://www.webyog.com/sqlyog - Original Message - From: "Jean-Francois nadeau" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday,

Segmentation Fault when connecting via TCP/IP

>Description: Recently the server had to be hard-booted... a safe shutdown was not possible. After the server came back up, mysql has been acting very funny. When the server first boots, mysql wont respond to anything. I restart mysql and all works fine when connecting to Localhost, ho

Re: Export, then Import HUGE number of rows/data?

At 4:46 PM -0500 10/15/02, Paul DuBois wrote: >At 14:56 -0400 10/15/02, Bill Leonard wrote: >>We have a client who wants to switch their hosting over to us, but has an >>issue with his MySQL database. >> >>It's about 1.4 million rows, and about 350MB of data. PhpMyAdmin apparently >>times out when

Re: Problems installing on Solaris/Intel

On Tue, Oct 15, 2002 at 05:25:22PM -0400, Alan W. Rateliff, II wrote: > > First, install gcc 3.2. Then, check out this link (thanks to John > Warburton): > > http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:116929:200208:ngkbacmgkmgkdbbf > gjdo > > The line numbers are different as of the latest

Re: Problems installing on Solaris/Intel

On Tuesday 15 October 2002 05:07 pm, Jesse Sheidlower wrote: > I did check out the link below, in which someone else has an > error identical to mine, and Sinisa Milivojevic replied > basically saying that the answer is described in detail in the > Manual. > > Well, I can't find it in the Manual.

Re: Export, then Import HUGE number of rows/data?

At 14:56 -0400 10/15/02, Bill Leonard wrote: >We have a client who wants to switch their hosting over to us, but has an >issue with his MySQL database. > >It's about 1.4 million rows, and about 350MB of data. PhpMyAdmin apparently >times out when he is doing the dump. Is that a MySQL issue, or a

Re: Copy table with column attributes

At 11:10 -0700 10/15/02, David Yee wrote: >Hi all. What's the quickest way to copy a table so that all column >attributes such as auto_increment and primary key along with all indexes get >copied over? I like using: > >create table new_table select * from old_table > >But it doesn't copy any ind

Re: HELP Can't build mysql-3.23.53

On Tuesday 15 October 2002 04:53 pm, [EMAIL PROTECTED] wrote: > Thanks very much for your replay > Is very interesting but how to change that declaration on mysql or > on the headers if there is any to modify. I have others Linux boxes > running mysql fine but each time I have to deal with the oth

Re: Problems installing on Solaris/Intel

- Original Message - From: "Jesse Sheidlower" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, October 15, 2002 5:07 PM Subject: Re: Problems installing on Solaris/Intel > > I did check out the link below, in which someone else has an > error identical t

Re: HELP Can't build mysql-3.23.53

Thanks very much for your replay Is very interesting but how to change that declaration on mysql or on the headers if there is any to modify. I have others Linux boxes running mysql fine but each time I have to deal with the others sparcs Solaris is really a real nightmare . Regards Jose Albe

Transaction isolation level - potential bug?

Hello all. I have encountered an really annoying problem in MySQL 3.23.49 on Win32. I am using InnoDB because I need transactions. I use autocommit off. I'll try best to describe the problem I have: I have two sessions to my DB. Session 1 inserts some data into a table, then commits. Session 2

Re: Problems installing on Solaris/Intel

I did check out the link below, in which someone else has an error identical to mine, and Sinisa Milivojevic replied basically saying that the answer is described in detail in the Manual. Well, I can't find it in the Manual. There are things somewhat related in the various Solaris sections, and

Re: HELP Can't build mysql-3.23.53

[EMAIL PROTECTED] wrote: > Hi everyone! > I'm trying to build /mysql-3.23.53 on a sparc Solaris 9 box but > without any luck > Please guys can anyone give me an idea about? > > Any help will be highly appreciated > > -Jose > > Specs: solaris 9, gcc-3.2, mysql-3.23.53 > configured as: > > CC=gcc C

Re: MySQL server crash on Red Hat 8.0

Hi, It happens to me too.I think are some problems with GLIBC. RED HAT 8.0 install MySQL ver 3.23.52.I install from source distribution MySQL ver 4.0.4 and nothing change. MySQL seems can not create socket file(BAD FILE DESCRIPTOR) and for this reason make the error.It want to create a child (fork

Re: Export, then Import HUGE number of rows/data?

Hi, Well I've tried to export 12 million rows with success from mysql to Oracle. I used MS Access and created an ODBC connection to get the data from Mysql, then i exported all rows to a .csv file. Then i used Oracle Sql-loader, because I wanted em in an Oracle DB. But you can import it to anot

Query using the same table twice

I am trying to make a query that usses the same table twice. I have a table of scores and a table of teams and the scores table has both the visitors and home team in it as an ID that is in the teams table. I can't get my MySQL statement to work, it does not like the parentheses. SELECT PH_

Connection to MySQL

We have a large application made using a special database/product (not an SQL database). This application also uses CGI (writen in C). CGI is used on every transaction to send a request to the product and format the result. We want to write a log of EVERY transaction made by the customer in a M

Export, then Import HUGE number of rows/data?

We have a client who wants to switch their hosting over to us, but has an issue with his MySQL database. It's about 1.4 million rows, and about 350MB of data. PhpMyAdmin apparently times out when he is doing the dump. What is the best way to go about getting this data on to one of our systems?

Re: Date Woes

On 15 Oct 2002, at 12:10, Serge Paquin wrote: > I'm just plugging away at a converion project where we are > migrating to mySQL. I am getting increasingly down on the poor > support for importing dates into mySQL. Why are you blaming MySQL for that problem? You could just as well say it

How to : Export BLOB

Hi all, I use a mix of innodb and MyIsam tables under 3.23.52. As mysqldump does not supports BLOB, how do you export / import databases for backup puposes. I dont want to stop the engine to backup or use a tool that exports all databases (like Innodb hot backup). I want to backup a selected

MySQL 3.23.53 - Error changing user to mysql

I've upgraded from MySQL-max 3.23.52 to MySQL-max 3.23.53 I'm running Linux, kernel version 2.4.17 I tried installing the binary version of MySQL, and followed all the steps under: http://www.mysql.com/doc/en/Installing_binary.html as I've always done for all my versions of mysql. when I ran .

Copy table with column attributes

Hi all. What's the quickest way to copy a table so that all column attributes such as auto_increment and primary key along with all indexes get copied over? I like using: create table new_table select * from old_table But it doesn't copy any indexes or those special attributes I mentioned over

RE: High Load Average

Now we are getting load averages >30 on 3.23.50 It seems like a single long query (>1-2 minutes) can push the system over the edge and cause most queries to lock even though they are on tables not related to the long query. Then the load average goes through the roof. I hear that 53 will fix t

error executing 'show variables' and 'show table status from [table]'

hello, I'm running version 4.0.3-beta-max-log on SunOS 5.8 (Generic_108528-15 sun4u sparc SUNW,Sun-Fire-280R) output from mysqlshow -V: mysqlshow Ver 9.4 Distrib 4.0.3-beta, for sun-solaris2.8 (sparc) I'm finding that executing either 'show variables' from a mysql session or 'mysqladmin -varia

Re: Problems installing on Solaris/Intel

Jesse Sheidlower wrote: > I've been trying for a week to get MySQL installed on a Solaris > system running on Intel, not Sparc, and am rather at the end of > my line. I know almost nothing about the process of compiling > things, but various people have given me advice and I still can't > get it

RE: Flakey Updates

I'm not getting an error message. This is what is on my FreeBSD box MySQL-4.0.0-ALPHA-CONFIGURED.TAR.TZ 4.0.0-ALPHA FreeBSD Version 4.4 We are questioning this version for production. I've had problems in the past and think its time to do a downgrade to version 3.23. We've taken owner of thi

HELP Can't build mysql-3.23.53

Hi everyone! I'm trying to build /mysql-3.23.53 on a sparc Solaris 9 box but without any luck Please guys can anyone give me an idea about? Any help will be highly appreciated -Jose Specs: solaris 9, gcc-3.2, mysql-3.23.53 configured as: CC=gcc CFLAGS="-O3" \ CXX=gcc CXXFLAGS="-O3 -felide-co

mysql-3.23.53 source compile failure --with-libwrap redhat linux

>Description: compile fails on redhat-7.2 if --with-libwrap option to ./configure is specified; works fine without said option >How-To-Repeat: ./configure --with-libwrap >Submitter-Id: >Originator:[EMAIL PROTECTED] >Organization: >MySQL support: none >Synopsis:

RE: Date Woes

Serge, What are you used to in the database that you are migrating from? My guess on what would be nice is something like the ORACLE to_date and to_char functions, which work in query strings and load data statements: http://www.llcsystems.com/FAQ/oracle_SQL/oracle_SQL_11.htm Though if some

Re: Date Woes

Serge Paquin wrote: > Hello All, > > I'm just plugging away at a converion project where we are migrating to >mySQL. I am getting increasingly down on the poor support for importing dates into >mySQL. In the near future could we expect a function that is basicaly the opposite >to dat

Problems installing on Solaris/Intel

I've been trying for a week to get MySQL installed on a Solaris system running on Intel, not Sparc, and am rather at the end of my line. I know almost nothing about the process of compiling things, but various people have given me advice and I still can't get it to work. All I want is a standar

Re: Unknown error code : 1053

On Tuesday, Oct 15, 2002, at 08:30 America/Phoenix, LAFONTAINE Julien - LYO ([EMAIL PROTECTED]) wrote: > Hi evryone, > I've developed a java program that extract data from C-ISAM files and > put it > in a MySQL DB. > It creates temporary files, load them into temporary tables and then > updat

Re: Date Woes

Perl has functions to do this. If you are writing an import, use language native functions. For a "load data in file", just how would you expect this to work? Serge Paquin wrote: >Hello All, > > I'm just plugging away at a converion project where we are migrating to mySQL. > I am getting

Re: Flakey Updates

On 15 Oct 2002, at 9:32, Karl Stubsjoen wrote: > So if I have a field that looks like this > > My_Text_Field > |HELLO WORLD| > > and I try to change it to: > "HELLO WORLD." > (note the "." at the end) > > It fails. You're not providing enough information for people to be very helpful. W

Re: Replication and LOAD DATA INFILE

Lothar Jenisch wrote: >Hello, > >I have a problem with replication and LOAD DATA INFILE. >I use version 3.23.37 on Liunx distribution. > >1. I check the replication with a manual i.e. insert and > delete of one record. This works fine without problems. >2. I do a > LOAD DATA INFILE 'file.

Re: Help with RH7.3+ and 3.23.49

After reading all the postings of this issue (and a couple of private replies) I'm wondering if the upcoming .53a is the solution, or should I downrev my glibc? --- no spam <[EMAIL PROTECTED]> wrote: > Prior to Redhat updates, database was working fine. > Did updates, rebooted, and now remote q

query slow on join and order by

Group, Here is my query: explain select phones.*, ops.plid, ops.box, ops.mac from phones, ops where (ops.box = 'Mcds') or (ops.box = 'Mn3300') and (phones.suffix1 = ops.phone) order by ops.mac My describe of the phones table and the ops table: Phones: ++--+--+-

Flakey Updates

Hello, I have been having trouble with MySQL Updates now for sometime. It involves making changes to a field who's type is varchar. The problem is intermitent (I hate that), but usually manifests itself when a period "." is part of the text in the update. So if I have a field that looks like th

tux, MySQL, SH-4 and no WinCE

I need to get Linux on my WinCE based handhelp PC and intend to run MySQL on it. The unit has a Hitachi SH-4 processor and I will be useing the tux web server. I cant find any info on running MySQL with tux, or running MySQL on a SH-4 processor. Has anyone trised this? Does anyone have any ideas?

RE: RE: Getting started - mysql.sock error

Egor, > Run > >ps ax | grep mysqld > > to see if mysqld is already running. > This returns '11276 pts/1S 0:00 grep mysql' I have checked and cannot find mysql.sock anywhere. Cheers George - Before posting, p

re: 3.23.53 can't change to user mysql bug

Richard, Tuesday, October 15, 2002, 4:20:20 PM, you wrote: RG> I just upgraded from 3.32.51 to 3.23.53. With MySQL 3.23.53, mysqld RG> wouldn't start. In the error log, the error was that it couldn't change to RG> the mysql user. The mysql user did indeed exist. A downgrade back to RG> 3.23.51

Date Woes

Hello All, I'm just plugging away at a converion project where we are migrating to mySQL. I am getting increasingly down on the poor support for importing dates into mySQL. In the near future could we expect a function that is basicaly the opposite to date_format where the first para

Replication and LOAD DATA INFILE

Hello, I have a problem with replication and LOAD DATA INFILE. I use version 3.23.37 on Liunx distribution. 1. I check the replication with a manual i.e. insert and delete of one record. This works fine without problems. 2. I do a LOAD DATA INFILE 'file.txt' REPLACE INTO TABLE table F

High Load Average

HELP! We are running RH 6.2 and when we applied all the current patches including upgrading glibc, MySQL 3.23.41 stopped working. It would not start and produced the following error 5 times per second. Number of processes running now: 1 mysqld process hanging, pid 21458 - killed 021011 00:16:1

Re: Privileges - Does Anybody knows how to answer to me?

> > Hi, I read the book, but there is not explain about it. > > I would like to know when I give privileges to the user, in the table > level, and after I give privileges in the database level. Do I replace > the privileges? Any time you execute a query, MySQL looks for the privileges needed for

Re: SOLVED: Can't upgrade: "Can't change to run as user 'mysql'"

On Tue, 15 Oct 2002, harm wrote: > Same error here. If I install the new binaries I get the error. If I > only update mysqld to .53 I get the error as well. .52 works fine. .53 version tries to load nss dynamic libraries from /home/serg/binaries/Glibc/lib, if you really want to run the .53 vers

data-type help with NULL entries

I have a table named projects. Within that table, one specific column is called costing and is of the following schema (projects float(8,2)). Nothing fancy. The interface that updates information to this table where the column (projects) resides in via a php web script. Within that script it is op

Re: Problem with 3.23.53 (glibc used to compile MySQL has dynamic NSS)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, thanks for reporting this. On Tuesday 15 October 2002 15:13, Predrag Malicevic wrote: > As far as I know, the statically compiled glibc (that you guys at MySQL > are using when making binary distributions) should be compiled with > --enable-sta

re: RE: Getting started - mysql.sock error

George, Tuesday, October 15, 2002, 5:09:47 PM, you wrote: GP> Its slightly difficult doing it exactly as my email is on my W2K laptop - GP> but here goes: GP> error: 'Can't connect to local MySQL server through socket GP> '/var/lib/mysql/mysql.sock' (2)' GP> Check that mysqld is running and that

[redhat 7.2 errata breaks MySQL]

>Description: safe_mysqld eats all available cpu >How-To-Repeat: install glibc-2.2.4-30 (and other current patches) from RH errata >Fix: none yet (can't downgrade system libs safely) >Submitter-Id: >Originator:root >Organization: >MySQL support: none >Synopsis:

Unknown error code : 1053

Hi evryone, I've developed a java program that extract data from C-ISAM files and put it in a MySQL DB. It creates temporary files, load them into temporary tables and then update the db from those temp tables. This application is executed every night. Unfortunatly, once in a while there's some da

Re: innodb not using correct index

On Tuesday 15 October 2002 10:59 am, Heikki Tuuri wrote: > Walt, > > - Original Message - > From: "walt" <[EMAIL PROTECTED]> > To: "Heikki Tuuri" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Tuesday, October 15, 2002 5:56 PM > Subject: Re: innodb not using correct index > > > Heik

InnodDB missing from MySQL 3.23.53-Max

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, due to an unfortunate error on my side the MySQL-3.23.53-Max binaries we just released yesterday have not been compiled with InnoDB support. If you want to run MySQL 3.23.xx with InnoDB databases, please stick with a previous version for the tim

Re: MySQL Replication - v4 slave with v3 master

On Tue, Oct 15, 2002 at 02:35:34PM +0100, Andrew Braithwaite wrote: > Hi all, > > Does anyone have any experience with running a v3 master and v4 slaves? > > Will it work? - I can't see why not... Works well, yes. We have a .51 master with 4.0.{3,4} slaves. -- Jeremy D. Zawodny | Perl,

Re: SOLVED: Can't upgrade: "Can't change to run as user 'mysql'"

On Tue, Oct 15, 2002 at 05:13:24PM +0300, Antonios Christofides wrote: > I tried 3.23.52 rather than 3.23.53. This solved both the remote > connection problem I had in 3.23.37, which was caused by the glibc > upgrade, and the "Can't change to run as user 'mysql'" problem, which > I had on 3.23.53.

Re: innodb not using correct index

Walt, - Original Message - From: "walt" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, October 15, 2002 5:56 PM Subject: Re: innodb not using correct index > Heikki Tuuri wrote: > > > Walt, > > > > - Original Message - > ... > >

Re: Compressed JDBC protocol

- Original Message - From: "Max Morawski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 7:55 AM Subject: Compressed JDBC protocol > mysql,query > > Hello! > > Maybe I've missed something in the docs... how can I turn compression on > using JDBC with Connect

Re: innodb not using correct index

Heikki Tuuri wrote: > Walt, > > - Original Message - > From: "walt" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.mysql > Sent: Saturday, October 12, 2002 11:20 AM > Subject: innodb not using correct index > > > Is there a way to find out what index an sql query is using? I know you

Re: MySQL 3.23.53-max - No innodb?

Kees, thank you for notifying us. I downloaded mysql-max-3.23.53-pc-linux-gnu-i686.tar.gz from ftp.sunsite.dk. It does not contain InnoDB. It looks like The MySQL AB build master or the web team have made an error. The error will be corrected as soon as possible. Regards, Heikki Tuuri Innobas

MySQL server crash on Red Hat 8.0

SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: root To: [EMAIL PROTECTED] Subject: MySQL server crash on Red Hat 8.0 >Description: The safe_mysqld daemon makes segmentatio

Re: Lossing connetion to MySql server

- Original Message - From: "Robert Canary" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, October 15, 2002 6:59 AM Subject: Lossing connetion to MySql server > Please forgive me for double posting, but I can't remeber if my mysql > list subscription is s

little typo

A little typo in mysql_convert_table_format.sh of mysql-3.23.53 distro: print "$table is alread of type $opt_type; Ignored\n"; must have been print "$table is already of type $opt_type; Ignored\n"; regards, -engin - Befor

SOLVED: Can't upgrade: "Can't change to run as user 'mysql'"

I tried 3.23.52 rather than 3.23.53. This solved both the remote connection problem I had in 3.23.37, which was caused by the glibc upgrade, and the "Can't change to run as user 'mysql'" problem, which I had on 3.23.53. Both questions are FAQs this month. The "Can't change..." could be a 3.23.53

RE: Getting started - mysql.sock error

Ed, Its slightly difficult doing it exactly as my email is on my W2K laptop - but here goes: error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! If I run mysqld, I get a

RE: MySQL Replication - v4 slave with v3 master

According to the replication compatibility table, you can. http://www.mysql.com/doc/en/Replication_Implementation.html -J -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 8:36 AM To: [EMAIL PROTECTED] Subject: MySQL Replication - v

  1   2   >