bug with like, latin1 and umlaut ü/y

>Description: I was trying to find every row in a table which contains the umlaut ü (ue). MySQL listed every row which contained the umlaut and rows which contained the letter y, but no umlaut... Client and server characterset is latin1. >How-To-Repeat: CRE

bugs / inconsistencies with date functions

>Description: I have found some inconsistencies (one may call them bugs ;-) in the current MySQL 3.23 version. I tested this on Linux and Solaris 2.8 so this should not be platform specific... The result differs, if one uses the constant value "-00-00" or

Sarge problems with MySQL and DBI / DBD::mysql

gt; s main::failed(/home/domain/www.chpresenters.co.uk/web/cgi-bin/ocms-multi/common/cgi-lib.pl:117): If a row is added to the table to be returned by this query, the problem goes away. How can I debug or fix this problem, please? -- Oliver Elphick olly@

Server-side/prepared statements and CR_SERVER_GONE

he bind structure. Looking at the MYSQL_STMT structure it looks as though you have enough information to, for example, go through all of the stmt's attached to a connection and set their statement id to a value that indicates "reset". - Oliver -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Counting Entries

e what you expected and I can help you figure out what we are missing. You're missing an "OUTER" in the join on the query, his originally request was to include "0"s for months with no bookings, e.g. Jan, Feb, Apr. - Oliver -- MySQL General Mailing List For list archiv

Re: A different authentication question ...

Barney Dumb question, but is this in response to the error message you got where at the end of the error it asks you to "update your client program"? If so it is referring to the PHP code not the actual PHP/MYSQL/APACHE programs. you need to update your PHP code to work with the updated

// confusing syntax error when importing //

what the right syntax might be here. out of interest the same *.sql imports on the local system just fine using mysql on the commandline ('mysql -u -p < file.sql'), but on the remote machine fails with the same error as seen above. if someone could point me in the right direction i

Problem with MySQL user

d 'user'@'hostname', and then go in and start modifying the config (it's set in settings.php as well as several places in the httpd.conf) I do have /etc/hosts entries on both VMs resolving both 172.16.1.1 / 2 to known hostnames. -- **

Dump / restore rows in table?

table_name" and then add something to specify rows 1000-1050. And then I'm guessing that mysql < result.sql would restore? Or would it not know what table it came from, and I'd have to specify that? -- ******* * Jo

Some MySQL questions

from 'users' where = 1898; Is that right? I'm not sure if COLUMN_NAME is "uid" or "id" or maye something else, and since I can't pipe it through more or less... :-) -- ******* * John

Passwords not working

go to reset passwords, it doesn't want to let me specify 'user'@'ip.address' or 'user'@'host.name' but just 'user' I *think* it's resetting the password for both... the hashes are always the same. But I just don't know. What am I miss

Re: Passwords not working

blic, and one private. The private interfaces are connected to a private VLAN on a virtual switch that is only for these two servers. MySQL only listens on 172.16.1.1, and the web server connects to that IP. On each host, I have a hosts entry for the other. -- ****

MySQL db died / got corrupted / ???

I don't know what I can do about a "stray pointer". -- ******* * John Oliver

Re: MySQL db died / got corrupted / ???

ace! The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 100104 16:43:51 mysqld ended -- ******* * John Oliver

Merging deltas from one table to another?

y the deltas? Thanks... -- ******* * John Oliver http://www.john-oliver.net/ * * * *

Trancate table from command line?

ll, which won't work... this operation needs to be scripted, or to be presented as one command line that can be copy-and-pasted. How can I do something like : mysqladmin -h db_server -u user -pPASSWORD truncate table table1 ? -- ****

Re: Trancate table from command line?

On Tue, Mar 16, 2010 at 02:12:42PM -0700, John Oliver wrote: > Is there a way to use mysqladmin (or mysql) to truncate a table as a > one-off command from the command line? > > I have an issue with importing data from one database into another, but > the second database might ha

Strange Order on Calculation Field

tance FROM stations ORDER BY `distance` ASC LIMIT 0 , 30 So basically distance is calculated then I just want to order on this, however this is what I get out distance 9.6201 5.1337 12.508 3.5312 2.3165 So I'm confused, what strange kind of ordering is that? Any help much appreciated, Oliver

Foreign Key Restriction

Hi I updated mySQL 4.0.8 to 4.1.1 and I have now problems with foreign key retrictions. Is it right, that mySQL 4.1.x has something changed due to the foreign key restriction? Is there an option to turn off the foreign key restriction in mySQL 4.1.1? Thanks. -- Oliver Hirschi http

Re: Foreign Key Restriction

"Oliver Hirschi" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > Hi > > I updated mySQL 4.0.8 to 4.1.1 and I have now problems with foreign key > retrictions. > > Is it right, that mySQL 4.1.x has something changed due to the foreign > key

Re: Foreign Key Restriction

= 1; > I saw, that the tables on my mySQLVersion 4.0.8 are of type MyISAM and the tables on mySQL 4.1.1 are of type InnoDB, but they are created with the same SQL-Script. Could be this difference, that I could INSERT a record with a foreignkey-value 0 on mySQL 4.0.8? Thanks in advanced, Oli

OS 10.4 (Tiger) compilation errors on 4.1.11...

3]: *** [all-recursive] Error 1 make[2]: *** [all] Error 2 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 I believe 10.4 has gcc 4.0. Anyway; any tips appreciated. Thanks! -- Wells Oliver [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

WHERE field IN (SELECT stmt) not working

Sorry if this has been posted as a bug. I tried searching in the bug database but the word IN (which is the operative word here) is being ignored by the search engine... I'm using mysql-4.0.20a-win.zip. WHERE field IN (SELECT stmt) not working but WHERE field IN ('literal1', 'literal2' ) is work

Error in JDBC retrieval of mediumint column (mysql4.1.2b-alpha-win and java-3.1.2-alpha driver)

To be able to use subqueries, I'm now using mysql-4.1.2b-alpha-win.zip I'm using mysql-connector-java-3.1.2-alpha.zip as my jdbc driver to connect to the db... I'm selecting some columns from a table where the column is created using mediumint. Somehow, after creation, it becomes mediumint(9) Prep

SQLException when retrieving resultset containing mediumint (4.1.2b-alpha-win db and java-3.1.2-alpha driver)

I'm using mysql-4.1.2b-alpha-win.zip and mysql-connector-java-3.1.2-alpha.zip to access db via JDBC. The column is mediumint(9) It was created using type mediumint, somehow it was changed to mdiumint(9) I think there may be a problem in the size... java.sql.SQLException: Unknown type '9 in column

IN operator

Now, the question came up if there is a maximum of values or length in an IN operator which can used on mySQL? Does anybody know something about that? Thanks & Regards -- Oliver Hirschi http://www.FamilyHirschi.ch -- MySQL General Mailing List For list archives: http://lists.mysq

Re: update/join question..

pray, that you use mysql version >=4 in version 3 it doesnt work... Oliver On Tue, 14 Sep 2004 14:09:43 -0400, <[EMAIL PROTECTED]> wrote: Rhino, I hate to burst your bubble but JOINS __are allowed__ in MySQL updates. I use them all the time. http://dev.mysql.com/doc/mysql/en/UPDATE.html A

slow join

lnummer='".$row['artikelnummer']."'"; if (mysql_fetch_array(mysql_query($query))) echo $row['artikelnummer'] } Oliver -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: slow join

i solved the problem... for the ones, who wants to know: only creating an index on artikelnummer on both tables made the query beeing ready after 2 seconds again :-) Oliver On Wed, 15 Sep 2004 00:38:59 +0200, Oliver Schiessl <[EMAIL PROTECTED]> wrote: MySQL 3.23.58: ive got 2 tables w

mysql 4.0.8 on solaris 8 problem

es via http://sunsolve.sun.com. Happy weekend Oliver - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[E

Re: Smallest install of mySQL

already been ported to the Sharp Zaurus (http://www.caulfei.demon.co.uk/zaurus/index.html); it should run on the yopy also. Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377

Replication error

mote. If i try to connect with the mysql tool to the remote server all works fine. Could anybody help me ? Thanks Oliver - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.co

Enable InnoDB in RPM install?

I've got MySQL installed via RPM on a Red Hat 8.0 machine. How do I enable InnoDB? -- John Oliver, CCNAhttp://www.john-oliver.net/ Linux/UNIX/network consulting http://www.john-oliver.net/resume/ *** sendmail, Apache, ftp, DNS, spam filt

Re: Enable InnoDB in RPM install?

On Thu, Feb 13, 2003 at 03:33:31PM -0600, Paul DuBois wrote: > At 12:43 -0800 2/13/03, John Oliver wrote: > >I've got MySQL installed via RPM on a Red Hat 8.0 machine. How do I > >enable InnoDB? > > If it's < MySQL 4, install the -Max RPM on top of your exist

Re: Enable InnoDB in RPM install?

key-dokey, I'll give them a shot. Thanks... -- John Oliver, CCNAhttp://www.john-oliver.net/ Linux/UNIX/network consulting http://www.john-oliver.net/resume/ *** sendmail, Apache, ftp, DNS, spam filtering *** Coloca

Starting MySQL RPM

e isn't helping me much, either :-( -- John Oliver, CCNAhttp://www.john-oliver.net/ Linux/UNIX/network consulting http://www.john-oliver.net/resume/ *** sendmail, Apache, ftp, DNS, spam filtering *** Colocation

Re: Starting MySQL RPM

out current value: 3600 slow_launch_time current value: 2 sort_buffer current value: 2097144 table_cache current value: 64 thread_concurrencycurrent value: 10 thread_cache_size current value: 0 tmp_table_sizecurrent value: 33554432 thread_stack

Re: Starting MySQL RPM

On Fri, Feb 14, 2003 at 05:01:01PM +0200, Egor Egorov wrote: > On Friday 14 February 2003 01:06, John Oliver wrote: > > > I removed the Red Hat MySQL RPMs (which worked fine, other than not > > supporting InnoDB) and installed the 3.23.55-1 RPMs from mysql.com When >

Problem building .src.rpm

do *not* have an old Automake... [joliver@joliver-lnx joliver]$ rpm -qa | grep automake automake-1.6.3-1 automake14-1.4p6-3 automake15-1.5-4 -- John Oliver, CCNAhttp://www.john-oliver.net/ Linux/UNIX/network consulting http://www.john-oliver.net/resume/ ***

Re: mysqld-max but still no referential integrity?

the InnoDB Variables in the wrong section of the my.ini file. Move them into the [mysqld] section and all should work. Greetings Oliver - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lis

Re: Scripting MySQL Commands

Hy Steve, > bin/mysql -p http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Re: Scripting MySQL Commands

Hy Steve, > USE DATABASE Temp; try to change this into : USE Temp; and try it again, this should work. HTH Oliver for the filter : sql,query,queries,smallint - Before posting, please check: http://www.mysql.

Obtaining GMT time in mySQL

Hi, I would like to obtain the time in GMT in mySQL. CURRENT_TIMESTAMP returns the local time SHOW VARIABLES returns a list of variables, one being TZ which is "EST" on my system But how can I get the time in GMT??? Thanks for your ti

Re: Obtaining GMT time in mySQL

. Thanks Oliver At 12:35 AM 5/02/2002 +, DL Neil wrote: >Hi Oliver, > >> I would like to obtain the time in GMT in mySQL. >> >> CURRENT_TIMESTAMP returns the local time >> SHOW VARIABLES returns a list of variables, one being TZ which is "EST" on >> my

RE: Obtaining GMT time in mySQL

I am close to a solution: select FROM_UNIXTIME(UNIX_TIMESTAMP(), '%Y %D %M %h:%i:%s %x'); UNIX_TIMESTAMP() returns the number of seconds since '1970-01-01 00:00:00' GMT Convert this to a date format and you have a GMT date. Thanks to Chris Land for pointing the UNIX_TIMEST

RE: Obtaining GMT time in mySQL

in standard time right now. In Arizona, they don't do >daylight savings at all. > >james montebello > >On Tue, 5 Feb 2002, Oliver Mannion wrote: > >> I am close to a solution: >> >> select FROM_UNIXTIME(UNIX_TIMESTAMP(), >> '%

RE: Obtaining GMT time in mySQL

e. At 02:13 PM 5/02/2002 +1100, Oliver Mannion wrote: >I am close to a solution: > >select FROM_UNIXTIME(UNIX_TIMESTAMP(), > '%Y %D %M %h:%i:%s %x'); > > >UNIX_TIMESTAMP() returns the number of seconds since '1970-01-01 00:00:00' GMT >

Please have a look on this group by

e 'R%' and typ not like 'X%' and typ not like 'C%' group by preis this doesn´t bring the expected pair "preis / lfd" but all available "preis/lfd" grouped ascending. Any idea, even if I´m shure that the select worked tonight. TIA Oliver

SOLVED ..Please have a look on this group by..,not really

ity of returned rows (numrows) to be a flag. So now I use the sql-query : select min(preis),lfd from database where marke='marke' and typ not like 'R%' and typ not like 'X%' and typ not like 'C%' group by preis, lfd; (this gives me several lines ordered, s

Re: basic query question

At 19.02.2002 10:22, you wrote: >I'm fairly new to MySQL, so if anyone could help me I'd really appreciate >it! > >What I'm trying to do is join two pictures in a database to each other. My >database holds info about people with variables: > >id, lname, fname, engagedto, pic Try this, even if I´

Re: SSI's and Databases?

This is do-able, but slightly off topic, perhaps you want to continue this off list? Your senario is a little ambiguouse, are you trying to insert into the databse over the web via a form. Or do you want to query a database and include the results? Or both? -- Simon Oliver "Will K.&q

Re: Autocommit

Serge Paquin wrote: > Hello, > > I am setting up mysqld-max with InnoDB Tables. How can I set autocommit to >off? I want this a global option for the DBMS. Did you read the docs? There is even an example (chapter 7.5.8

Re: Replication zwischen MYSQL und MS Access 97(2000)

nliches zwischen MYSQL und Access auch? Try: http://www.accessmysql.com/ I didn't use it myself, but it promises synchronisation. A demo is available. Oliver - Before posting, please check: http://www.mysql.com/ma

load data infile and warnings

ings stored? Can I find out what went wrong during the import? Oliver - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

Re:Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine

s usual (no zombie). > > Regards > Irek. > Hi Irek, do you have something in the logs (i.e. /var/lib/mysql/.log) when this happens? Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbern

Re:Re: Re:Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine

oblem still exists, system working, so i don't >know, it is dangerous sytuation ? > >regards, > >Irek. > > >- Original Message - >From: "Oliver Six" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED

Re:Re: Licensing--web site is schizophrenic

sita >This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] >/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > Hi, does this mean that

Re:rand() ... limit by .... & my retrivals

t; echo ( $tName ); > > } // echo (""); > > echo(""); > > >problem: >it only displays firstName n nothing else though 5 random first names >but >i guess i'll ve to make seperate query fo each field in the

Re:help !

base is running and I can connect fine on the server >itself! > >Any suggestions would be greatly appreciated. > Hi Brett, try to connect using a "telnet 10.10.10.250 3306". You should get some control characters and the version number of your server. If not check your n

Re:Numeric Type Inconsistency ?Bug

's reproducible. The problem appears if the upper range exceeds 0.92233e19 (signed bigint). But the manual states that this is NOT a bug: expr BETWEEN min AND max ... - If expr is an integer expression, an integer comparision is done. - Otherwise, a floating-point (real) comparision is d

Re:UPDATE command..

; > >so that the id column becomes >+--+ >|id| >+--+ >|[EMAIL PROTECTED] | >|[EMAIL PROTECTED] | >|[EMAIL PROTECTED] | >+--+ > >thanks. > >Patrick J Okui > Hi Patrick, try UPDATE users SET id=REPLACE(id,'domain1',&#

Re:myODBC BIGINT conversion

ould be wrong. Are there workarounds >for this? Is this also an issue in later version of windows? > >DB > Hi Dennis, why don't you use SQL_BIGINT together with __int64? I think this should give you the correct values and you can control the conversion to a 32 bit unsigned. Bye Oli

Re:RE: Query Optimization

t; >Has anyone else tried writing a query similar to this? Does anybody have >any suggestions? > >Thanks in advance, > >Dave > Hi Dave, IMHO you can speed up your queries if you convert your columns to (unsigned) int if possible. It should be much faster to compare two integers

empty mysql_install_db file in sol8 i386 distribution

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: oliver To: [EMAIL PROTECTED] Subject: empty mysql_install_db file in sol8 i386 distribution >Descri

Installation on Sol8-x86

Does anyone know why the mysql_install_db file in the scripts directory is blank with the sol8-x86 distribution? I hit a snafu when I try to start the db and I assume it's because this file isn't doing something it is supposed to. Than

Replication

Is this still true in the latest version of MySQL? Is this behaviour by design? Cheers, Ollie -- Oliver CookSystems Administrator, ClaraNET [EMAIL PROTECTED] 020 7903 3065 - Before posting, please check:

Converting ACCESS or EXCEL Data to MySQL

y looked in the user manual at www.mysql.com and I read something about ODBC Support, but does that also work if the Database Server is lockated somewhere in the Internet ? Many thanks in advance, Oliver Hohlfeld - Before p

Missing Symbol mysql_real_escape_string in 3.23.40-win

Hi, I use the windows binary distribution from www.mysql.com (version 3.23.40). When I try to use the function mysql_real_escape_string, the linker complains about not finding it... Solution is easy :-) Add the symbol to libmysql.def and recompile... Cheers Oliver

Odd issue

Hello, I have a Cobalt Qube2. I have recently compiled Apache 1.3.19, PHP4.0.3pl1 and MySQL 3.23.33. Even though, everything compiled normally. I am unable to load PHP4 as a DSO. When I run 'apachectl configtest', I get this error: Syntax error on line 239 of /etc/httpd/conf/httpd.conf: Cannot lo

logging doesnt work with bdb if --with-debug

and run mysqld with --debug --log >Fix: Dont do that :/ >Submitter-Id: >Originator:Oliver Blasnik >Organization: Nextra Germany >MySQL support: none >Synopsis: --debug --log with bdb fails >Severity: serious >Priority: medium >

logging doesnt work with bdb if --with-debug

>> Description: oliver> After several sig 11 I compliled a --with-debug version and enabled oliver> debugging and logging. Mysqld crashed shortly after starting without oliver> trace (!) and then immediatly crashed again after restart. oliver>

Getting "NO format" output from cmd-line ?

n advance Oliver - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe,

Re: question on selects in multiple tables

from inventory a, customer b where b.purchasedby = a.id and a.purchasedby is NULL. (or a.purchased = ' ') depending how you set the default of purchasedby. HTH Oliver - Before posting, please check: http://www.mysql.co

Re: user / pwd access to db driven website

One step at a time. Your first problem is user authentication? A few options: 1. Directory access (as you mentioned in your message) The user must be authenticated to run the scripts / view the web pages 2. DBMS built-in security Not supported (properly) by MS-Access but can easily be se

Re: load data

ts.mysql.com/php/unsubscribe.php > > Hi Jorge, I think you try to import a "DOS" text file. Lines in "DOS" text files are terminated by '\r\n' so what you see in the last column is not '\n' but '\r'. Try to modify the statement to LOAD

ActiveX error Visual Basic Integration MySQL

dea what I might be doing wrong? Oliver - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTEC

[replication] adding new slaves

>From my reading of the manual it seems that for every time a new slave it to be added, the master will need to be locked while the snapshot is taken. Is this really necessary? Can another slave be somehow setup by taking the data from another slave instead, thereby avoiding downtime on the maste

Limiting Connections (per host)

Is there any way to limit connections to MySQL server on a per-host basis? There are the: max_connections and max_user_connections options for mysqld on the command-line, but I cannot see any way of limiting them on a per-host basis? Is there any way? Thanks, Ollie -- Oliver Cook

Re: Running a private copy of mysqld

/to/your/mysql/source/scripts directory Ollie -- Oliver CookSystems Administrator, ClaraNET [EMAIL PROTECTED] 020 7903 3000 ext. 291 - Before posting, please check: http://www.mysql.com/manual.php (the manu

Re: Debian - mySQL - php3

Janos, You need to install the php3-mysql package, which allows PHP3 to access MySQL databases. Although, you should think about compiling PHP4 or downloading the .debs for it. It's better than PHP3. Oliver - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PR

Problem with update using DBI & perl

Has anyone experienced problems using DBI and perl with update statements not updating tables when the equivalent statement at the command line works, and all other operations work perfectly? Oliver Hinds - Before posting

Re: Problem with update using DBI & perl

On Thu, 18 Jan 2001, Gerald L. Clark wrote: > Oliver Hinds wrote: > > > > Has anyone experienced problems using DBI and perl with update statements > > not updating tables when the equivalent statement at the command line > > works, and all other operations work

select-Problem

3 5 name122 3 6 name13 1 7 name2 0 8 name21 7 Is there any select statement, which give me the path e.g to the id 5? I want to provide the 5 and will get the following: id5 (pid3) -> id3 (pid1) -> id1 (pid0) name122 -> name12 -> name1 Do you have any idea? Oliver -- [EMA

Re: select-Problem

On Sun, 28 Jan 2001, Andrei Cojocaru wrote: > so you want to list all of them starting with the highest level and going > up to the lowest level? yes, or vice-versa. Oliver > > On Mon, 29 Jan 2001, Oliver Joa wrote: > > > Hi, > > > > I have a recursive Pro

mysql.sock

r/lib/mysql/mysql.sock" to "socket=/tmp/mysql.sock". That doesn´t work. What can I do? Perhaps put a link ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock in /tmp Oliver -- t-host GmbH Mobil: 0170/2781117 D-80337 München Tel: +49 89

Question again : mysql.sock

r/lib/mysql/mysql.sock" to "socket=/tmp/mysql.sock". That doesn´t work. What can I do? Perhaps put a link ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock in /tmp Oliver -- t-host GmbH Mobil: 0170/2781117 D-80337 München Tel: +49 89

Re: Question again : mysql.sock

Hello Tim, OK >easiest thing to is cd to /tmp and issue "ln -s /var/lib/mysql/mysql.sock >mysql.sock" What else can I do? Oliver Etzel -Original Message----- From: Oliver Etzel - GoodnGo.COM (R) [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 12:31 PM To: [EMAIL PR

Re: Question again : mysql.sock

Hello Egor, hello all, > If you change path to the socket file for the server, you must change it to the clients, too. How can I change the path to the socket file for the mysql clients??? Are there any config-files or shall I have to put a ln -s - link??? Oliver > >"Oliver Etzel

mysql.sock again

r/lib/mysql/mysql.sock" to "socket=/tmp/mysql.sock". That doesn´t work. What can I do? Perhaps put a link ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock in /tmp Oliver -- t-host GmbH Mobil: 0170/2781117 D-80337 München Tel: +49 89

Re: mysql.sock

r/lib/mysql/mysql.sock" to "socket=/tmp/mysql.sock". That doesn´t work. What can I do? Perhaps put a link ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock in /tmp Oliver -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

reach the hard limits!?

I'm going towards the hard limit or if I have a problem with my db design. Are there people who can share there knowledge about large mysql servers? Linux 2.4.4 SMP 2x PIII 800 512 MB RAM 80 GB EasyRaid System. Lev. 5 (~130 MB sec) average of ~ 330 queries per second. Regard

MySQL 3.23.40 and 4.0.20 parallely on the same data-source

t the two versions conflicting (e.g. when both version would try to change some database value within the same time)? How good is mysql's locking in that constellation? Thanks for your support in advance. Greetz, Oliver Neumann -- MySQL General Mailing List For list archives: http://lists

AW: MySQL not finidng openssl/opensslv.h

How did you install OpenSSL? From source or packages (e.g. debian or rpm). In that case you also have to install the dev-Package of OpenSSL (openssl-dev) Sincerly, Oliver Craig Harding wrote: No one else has had this problem? Just wondering if this may be a bug in the configure script