Re: Trancate table from command line?

2010-03-16 Thread John Oliver
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

Trancate table from command line?

2010-03-16 Thread John Oliver
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 ? -- ****

Merging deltas from one table to another?

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

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

2010-01-04 Thread John Oliver
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

MySQL db died / got corrupted / ???

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

Re: Passwords not working

2009-10-22 Thread John Oliver
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. -- ****

Passwords not working

2009-10-19 Thread John Oliver
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

Some MySQL questions

2009-10-08 Thread John Oliver
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

Dump / restore rows in table?

2009-10-07 Thread John Oliver
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

Problem with MySQL user

2009-09-16 Thread John Oliver
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. -- **

Strange Order on Calculation Field

2008-06-27 Thread Oliver Nightingale
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

// confusing syntax error when importing //

2006-04-03 Thread julian oliver
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

Re: A different authentication question ...

2006-03-18 Thread Jeremy Oliver
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

2005-08-31 Thread Oliver Smith
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

Server-side/prepared statements and CR_SERVER_GONE

2005-08-25 Thread Oliver Smith
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]

Sarge problems with MySQL and DBI / DBD::mysql

2005-06-21 Thread Oliver Elphick
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@

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

2005-05-11 Thread Wells Oliver
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]

Re: Foreign Key Restriction

2005-05-06 Thread Oliver Hirschi
= 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

Re: Foreign Key Restriction

2005-05-04 Thread Oliver Hirschi
"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

Foreign Key Restriction

2005-05-03 Thread Oliver Hirschi
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

2004-09-15 Thread Oliver Schiessl
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

slow join

2004-09-14 Thread Oliver Schiessl
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: update/join question..

2004-09-14 Thread Oliver Schiessl
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

IN operator

2004-09-13 Thread Oliver Hirschi
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

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

2004-06-28 Thread Oliver Chua
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

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

2004-06-28 Thread Oliver Chua
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

WHERE field IN (SELECT stmt) not working

2004-06-27 Thread Oliver Chua
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

AW: MySQL not finidng openssl/opensslv.h

2004-06-09 Thread Oliver Neumann [New Identity AG]
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

MySQL 3.23.40 and 4.0.20 parallely on the same data-source

2004-06-09 Thread Oliver Neumann [New Identity AG]
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

Re: mysql.sock

2003-07-17 Thread Oliver Etzel - GoodnGo.COM \(R\)
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

mysql.sock again

2003-07-17 Thread Oliver Etzel - GoodnGo.COM \(R\)
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

2003-07-17 Thread Oliver Etzel - GoodnGo.COM \(R\)
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

Re: Question again : mysql.sock

2003-07-16 Thread Oliver Etzel - GoodnGo.COM \(R\)
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

Question again : mysql.sock

2003-07-16 Thread Oliver Etzel - GoodnGo.COM \(R\)
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

mysql.sock

2003-07-12 Thread Oliver Etzel - GoodnGo.COM \(R\)
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: Re: Scripting MySQL Commands

2003-03-02 Thread Oliver Schlag
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.

Re: Scripting MySQL Commands

2003-03-02 Thread Oliver Schlag
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: mysqld-max but still no referential integrity?

2003-02-22 Thread Oliver Schlag
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

Problem building .src.rpm

2003-02-14 Thread John Oliver
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: Starting MySQL RPM

2003-02-14 Thread John Oliver
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 >

Re: Starting MySQL RPM

2003-02-13 Thread John Oliver
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

Starting MySQL RPM

2003-02-13 Thread John Oliver
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: Enable InnoDB in RPM install?

2003-02-13 Thread John Oliver
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

Re: Enable InnoDB in RPM install?

2003-02-13 Thread John Oliver
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

Enable InnoDB in RPM install?

2003-02-13 Thread John Oliver
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

Replication error

2003-02-07 Thread Oliver Schlag
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

Re: Smallest install of mySQL

2003-02-04 Thread Oliver Six
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

2003-01-19 Thread Oliver Schlag
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

ActiveX error Visual Basic Integration MySQL

2002-11-06 Thread Oliver Gottwald
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

Re: load data

2002-09-27 Thread Oliver Six
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

Re:RE: Query Optimization

2002-07-25 Thread Oliver Six
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

Re:myODBC BIGINT conversion

2002-07-18 Thread Oliver Six
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:UPDATE command..

2002-07-16 Thread Oliver Six
; > >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:Numeric Type Inconsistency ?Bug

2002-07-12 Thread Oliver Six
'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:help !

2002-07-10 Thread Oliver Six
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

bug with like, latin1 and umlaut ü/y

2002-07-09 Thread oliver
>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

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

2002-07-09 Thread Oliver Six
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:Re: Licensing--web site is schizophrenic

2002-07-08 Thread Oliver Six
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:Re: Re:Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine

2002-07-08 Thread Oliver Six
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:Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine

2002-07-08 Thread Oliver Six
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

load data infile and warnings

2002-06-13 Thread Oliver Vecernik
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: Replication zwischen MYSQL und MS Access 97(2000)

2002-06-12 Thread Oliver Vecernik
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

Re: Autocommit

2002-06-11 Thread Oliver Vecernik
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: SSI's and Databases?

2002-02-26 Thread Simon Oliver
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: basic query question

2002-02-19 Thread Oliver Heinisch
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´

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

2002-02-19 Thread Oliver Heinisch
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

Please have a look on this group by

2002-02-19 Thread Oliver Heinisch
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

RE: Obtaining GMT time in mySQL

2002-02-05 Thread Oliver Mannion
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 >

RE: Obtaining GMT time in mySQL

2002-02-04 Thread Oliver Mannion
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

2002-02-04 Thread Oliver Mannion
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

2002-02-04 Thread Oliver Mannion
. 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

Obtaining GMT time in mySQL

2002-02-04 Thread Oliver Mannion
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: user / pwd access to db driven website

2002-01-11 Thread Simon Oliver
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: question on selects in multiple tables

2002-01-01 Thread Oliver Heinisch
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

Getting "NO format" output from cmd-line ?

2001-12-30 Thread Oliver Heinisch
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,

bugs / inconsistencies with date functions

2001-10-30 Thread oliver
>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

reach the hard limits!?

2001-09-03 Thread Oliver Krapp - etracker.de e.K.
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

Missing Symbol mysql_real_escape_string in 3.23.40-win

2001-08-09 Thread Oliver Billmann
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

2001-07-18 Thread Oliver Hohlfeld
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

Replication

2001-07-17 Thread Oliver Cook
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:

Installation on Sol8-x86

2001-07-16 Thread Oliver Jones
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

empty mysql_install_db file in sol8 i386 distribution

2001-07-15 Thread Oliver Jones
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

Re: Debian - mySQL - php3

2001-04-24 Thread Oliver Hingst
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

Re: Running a private copy of mysqld

2001-04-22 Thread Oliver Cook
/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

Limiting Connections (per host)

2001-04-20 Thread Oliver Cook
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

[replication] adding new slaves

2001-04-20 Thread Oliver Cook
>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

logging doesnt work with bdb if --with-debug

2001-04-09 Thread oliver . blasnik
>> 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>

logging doesnt work with bdb if --with-debug

2001-04-07 Thread oliver . blasnik
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 >

Odd issue

2001-03-30 Thread Oliver Hingst
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

Re: select-Problem

2001-01-29 Thread Oliver Joa
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

select-Problem

2001-01-28 Thread Oliver Joa
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: Problem with update using DBI & perl

2001-01-18 Thread Oliver Hinds
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

Problem with update using DBI & perl

2001-01-17 Thread Oliver Hinds
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