re: problem with mysqlimport

2002-10-17 Thread Egor Egorov
Julia, Thursday, October 17, 2002, 2:29:57 PM, you wrote: JM> This is what I've done: JM> created a database testdb in access with a table cop JM> exported the table as comma separated values into cop.txt JM> created a database called testdb in mysql, JM> created a table called cop of the same

Re: [No mysqladmin was installed]

2002-10-17 Thread gerald_clark
It is in the clients RPM. [EMAIL PROTECTED] wrote: >>Description: >> >> > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archi

Updated MySQL 3.23.53a binaries now available

2002-10-17 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, we've now replaced the faulty MySQL-Max 3.23.53 binaries with version 3.23.53a on our downloads section at http://www.mysql.com/downloads/index.html - the mirror sites should catch up on these changes soon as well. Please update, if you experien

re: Problem with UPDATE table ... can u help plz?

2002-10-17 Thread Egor Egorov
STIBS, Thursday, October 17, 2002, 12:26:34 AM, you wrote: S> I have a littlebig problem: S> I want to UPDATE table1.fields with data from table2.fields WHERE the id (in this S> case a product number) is the same in both tables. S> OK, I did this: S> UPDATE table1 SET table1.field1 = table2.fi

What about 3.23.53a max for windows ?

2002-10-17 Thread Ireneusz Piasecki
Hi. When will version 3.23.53a for windows users ? I downloaded version 3.23.53 but in zip package were mysql version 3.23.52. (innodb not working in this wersion on win98). What about this ?? Little mistake ? I. Piasecki - B

Re: bug? - "FLUSH PRIVILEGES" releases table locks

2002-10-17 Thread Donal Diamond
On Thu, Oct 17, 2002 at 05:47:02PM +0200, [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to

RE: Server crash upon remote access

2002-10-17 Thread ITweb / Lars Andre Landås
Hi! This is a bug in RedHat 8.0. Also an up-to-date RedHat 7.x is affected by this bug. Sollution: Start mysql with --skip-name-resolve option. More info: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=74943 --- Lars Andre -Original Message- From: Victoria Reznichenko [mailto:

re: Importing Large Files Into MySQL?

2002-10-17 Thread Egor Egorov
Erica, Thursday, October 17, 2002, 12:24:53 PM, you wrote: ED> I have three large files containing MySQL commands. However, when ED> importing them using mysql -u [username] -p [database] < file.sql, I get ED> an error: ED> ERROR 2006 at line xxx: MySQL server has gone away >From reading more a

re: when will 3.23.53a be released?

2002-10-17 Thread Victoria Reznichenko
Lars, Thursday, October 17, 2002, 11:54:02 AM, you wrote: LA> I wonder if anyone knows when 3.23.53a will be released? I don't need an LA> exact time, just if it's due today, tomorrow or next week. New build will be made in a couple of days. -- For technical support contracts, goto https://or

Re: re: startup error

2002-10-17 Thread Victoria Reznichenko
Hello Maximo, Wednesday, October 16, 2002, 8:05:23 PM, you wrote: MM> nscd?? nscd - A Name Service Caching Daemon It's a DNS-something for glibc.. MM> I searched for that program and did not find it in linux. MM> How would you go about fixing that problem? It will be fixed in 3.23.53a that wi

RE: Problem with UPDATE table ... thx 4 your help

2002-10-17 Thread STIBS
Thanx guys! but: I'm not in the mood to try Greg's suggestion ... LOL! I think I'll work around that with Escapade programming language. It's much easier to handle. If not: I run a script that checks record by record in the first table if an update in the second table is available then I query

Importing Large Files Into MySQL?

2002-10-17 Thread Erica Douglass
Hi! I have three large files containing MySQL commands. However, when importing them using mysql -u [username] -p [database] < file.sql, I get an error: ERROR 2006 at line xxx: MySQL server has gone away >From reading more at mysql.com, it seems that MySQL reads these large packets as errors on

re: NULL sometimes joins to NULL

2002-10-17 Thread Victoria Reznichenko
jfield, Thursday, October 10, 2002, 1:33:10 AM, you wrote: jazdc> >Description: jazdc> After adding a key to a nullable column, null values will jazdc> successfully join through to null values in other tables. jazdc> This only seems to happen when the index is added after jazdc> the row contains

re: Connection to MySQL

2002-10-17 Thread Egor Egorov
Hello Steeve, Tuesday, October 15, 2002, 9:57:04 PM, you wrote: SG> We want to write a log of EVERY transaction made by the customer in a MySQL SG> database. Writing has to be very fast because customers are waiting for their SG> results. We want to add code using "MySQL C API" to the already

when will 3.23.53a be released?

2002-10-17 Thread Lars Andersson
I wonder if anyone knows when 3.23.53a will be released? I don't need an exact time, just if it's due today, tomorrow or next week. Regards /Lars -anti-spam-workaround sql query - Before posting, please check: http://www.m

Select now() in Mysql 4.0.x

2002-10-17 Thread Ismed Ismail Daud
I have test install MySQL ver.4.0.x on RedHat Linux 7.2. When I test query using MySQL Front(Under Windows) Select now() it's displayed: '10/17/2002 3:10:20' PM, but when I test using telnet under command line it's shown '2002-10-17 3:10:34'. In the client I'm using mysql.dll ver 3.23.52. Any one

RE: loggin all calls made to mysql from php

2002-10-17 Thread Chung Ha-nyung
With --log[=filename] option to mysqld_safe, you can specify the path and name of log file. You may put the line like this to my.cnf file log = filename If absoulte path is not given, the path is considered one relative to $data directory, in my case /usr/local/mysql/var and filename is

RE: loggin all calls made to mysql from php

2002-10-17 Thread Petre Agenbag
Hi Thanks for the prompt reply. Can you please tell me where the logfile will be located if I start it with the --log option? Will syslogd take over the function of the logging, ie, do the log rotation etc. and if possible, could you give me an example of how the log would look? Sorry for asking

Rebuild source 3.23.49 ?????

2002-10-17 Thread Carmen Geldenhuys
I want to install mylua (stored procedures for mysql). I installed lua like the instructions said. Then I do a configure: ./configure --enable-assembler --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags="-L/usr/src/lua/lib -llua -llualib" When I try to do a make, I get the foll