Trancate table from command line?

... 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 DATABASE truncate table table1 ? -- *** * John Oliver

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 have columns

Merging deltas from one table to another?

... -- *** * John Oliver http://www.john-oliver.net/ * * * *** -- MySQL

MySQL db died / got corrupted / ???

what I can do about a stray pointer. -- *** * John Oliver http://www.john-oliver.net

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

-pointer? Aborting backtrace! 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

Re: Passwords not working

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. -- *** * John Oliver

Passwords not working

'@'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 missing? -- *** * John Oliver http://www.john-oliver.net

Some MySQL questions

from 'users' where COLUMN_NAME = 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 Oliver http

Dump / restore rows in table?

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? -- *** * John Oliver http://www.john

Problem with MySQL user

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. -- *** * John Oliver http

Strange Order on Calculation Field

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

// confusing syntax error when importing //

database 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'd be very grateful. cheers, julian -- julian oliver [EMAIL PROTECTED] -- http://www.fastmail.fm - Does exactly what it says on the tin -- MySQL

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

Re: Counting Entries

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 0s for months with no bookings, e.g. Jan, Feb, Apr. - Oliver -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Server-side/prepared statements and CR_SERVER_GONE

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]

Sarge problems with MySQL and DBI / DBD::mysql

-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@lfix.co.uk Isle of Wight http://www.lfix.co.uk

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

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]

Re: Foreign Key Restriction

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, Oliver Hirschi -- MySQL General Mailing List For list

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 restriction? Is there an option to turn off

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: 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 with ca

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 At the top

slow join

'].'; 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]

IN operator

, 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.mysql.com/mysql

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)

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

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

MySQL 3.23.40 and 4.0.20 parallely on the same data-source

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.mysql.com

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

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 - GoodnGo.COM \(R

mysql.sock again

/mysql/mysql.sock to socket=/tmp/mysql.sock. That doesnt 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 Mnchen Tel: +49 89 54071102 Tumblinger Strae 50

Re: mysql.sock

/mysql/mysql.sock to socket=/tmp/mysql.sock. That doesnt 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://lists.mysql.com/[EMAIL

Question again : mysql.sock

/mysql/mysql.sock to socket=/tmp/mysql.sock. That doesnt 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 Mnchen Tel: +49 89 54071102 Tumblinger Strae 50

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 PROTECTED] Subject

mysql.sock

/mysql/mysql.sock to socket=/tmp/mysql.sock. That doesnt 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 Mnchen Tel: +49 89 54071102 Tumblinger Strae 50

Re: Scripting MySQL Commands

Hy Steve, bin/mysql -p bin/mysql -p /[the complete pathname, honest]/Temp.sql try the following command : bin/mysql -p /[the complete pathname, honest]/Temp.sql HTH Oliver - Before posting, please check: http

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.com

Re: mysqld-max but still no referential integrity?

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://lists.mysql.com/ (the list archive

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 I try to start it: [joliver

Problem building .src.rpm

... [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/ *** sendmail, Apache, ftp, DNS

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 filtering

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 existing installation to get a server with InnoDB

Re: Enable InnoDB in RPM install?

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 *** Colocation, T1s, web/email/ftp

Starting MySQL RPM

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, T1s, web/email/ftp

Re: Starting MySQL RPM

thread_concurrencycurrent value: 10 thread_cache_size current value: 0 tmp_table_sizecurrent value: 33554432 thread_stack current value: 65536 wait_timeout current value: 28800 -- John Oliver, CCNAhttp://www.john-oliver.net/ Linux/UNIX

Replication error

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.com/ (the list archive

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

mysql 4.0.8 on solaris 8 problem

://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 [EMAIL PROTECTED

ActiveX error Visual Basic Integration MySQL

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 PROTECTED] To unsubscribe, e-mail [EMAIL

Re:RE: Query Optimization

? 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 (4 bytes,2 assembler instructions) than comparing two strings (9 bytes,10 assembler instructions). Bye Oliver -- Good

Re:myODBC BIGINT conversion

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 Oliver -- Good programming is 40% experience, 30% skill

Re:UPDATE command..

] | |[EMAIL PROTECTED] | |[EMAIL PROTECTED] | +--+ thanks. Patrick J Okui Hi Patrick, try UPDATE users SET id=REPLACE(id,'domain1','domain2') WHERE domain='domain1. com'; Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail

Re:Numeric Type Inconsistency ?Bug

... - If expr is an integer expression, an integer comparision is done. - Otherwise, a floating-point (real) comparision is done. ... 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

Re:help !

! 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 network connection. Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10

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

first names but i guess i'll ve to make seperate query fo each field in the table or will i thnx a million . toby . 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

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:

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

in the logs (i.e. /var/lib/mysql/yourhostname.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, Cimbernstr. 51, Germany 81377 Muenchen Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42

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

don't know, it is dangerous sytuation ? regards, Irek. - Original Message - From: Oliver Six [EMAIL PROTECTED] To: [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Monday, July 08, 2002 11:38 AM Subject: Re:Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine Ireneusz

Re:Re: Licensing--web site is schizophrenic

AB / Ensita.net ___/ www.mysql.com Hi, does this mean that whenever I write a program in msc which makes use of the libmysql.dll in conjunction with MySQL 4.x I have to make this program GPL? Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5

load data infile and warnings

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 thread, e-mail [EMAIL

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

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/manual.php (the manual) http

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.6). Oliver

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. wrote

Please have a look on this group by

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 - Before posting, please check

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

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, so the min(preis),lfd is the first row) Oliver

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´m

RE: Obtaining GMT time in mySQL

/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 Convert this to a date format and you have a GMT date. Thanks to Chris

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 time, Oliver

Re: Obtaining GMT time in mySQL

on. 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 system But how can I get the time in GMT??? MySQL

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

RE: Obtaining GMT time in mySQL

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(), '%Y %D %M %h:%i:%s %x'); UNIX_TIMESTAMP() returns the number of seconds since '1970

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

Re: question on selects in multiple tables

the default of purchasedby. HTH 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

Getting NO format output from cmd-line ?

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, e-mail [EMAIL PROTECTED

reach the hard limits!?

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. Regards, Oliver Krapp

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

Converting ACCESS or EXCEL Data to MySQL

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 posting, please check

Replication

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: http://www.mysql.com

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. Thanks, Oliver

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 Description: I'm running down

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 PROTECTED] Sent

Re: Running a private copy of mysqld

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

[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

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

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 /sw/pkg/mysqldebug

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

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 perfectly? Oliver Hinds Only

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