Re: transaction isolation level

[Heikki Tuuri]

Hi!

- Original Message -
From: "Mark Matthews" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, October 08, 2002 5:07 AM
Subject: Re: transaction isolation level


> Jianliang Zhao wrote:
...
> >>I am connecting to MySql 3.23(innodb) with
> >>mysql-connector-java-2.0.14-bin.jar. I set the global transaction
> >>isolation level to READ COMMITTED. However, I still couldn't see the
> >>committed changes through JDBC client. Does anyone know about this
> >>issue?
...
> The isolation level of READ_COMMITTED has no effect currently in MySQL,
> unless you're using BDB tables...InnoDB runs either as REPEATABLE_READ
> or SERIALIZABLE, and converts everthing else to REPEATABLE_READ, because
> it can do REPATABLE_READ as fast (or faster) than most other DB's
> READ_COMMITTED.

I have to correct that BDB always runs at the SERIALIZABLE isolation level.

The default for InnoDB is REPEATABLE READ, and you can enhance it to
SERIALIZABLE with the

SET [GLOBAL | SESSION] TRANSACTION ISOLATION LEVEL
{ READ UNCOMMITTED | READ COMMITTED | REPEATABLE READ | SERIALIZABLE }

SQL command. Since MyISAM uses table locking, we can say that MyISAM always
runs at the SERIALIZABLE level.

The command SHOW VARIABLES currently shows the MySQL default isolation level
as READ-COMMITTED, but it has no effect on any of the table handlers.

Version 4.0.5 will probably feature a new InnoDB isolation level READ
COMMITTED. I will probably at the same time change the MySQL default
isolation level to REPEATABLE READ. You can then lower the InnoDB isolation
level by the command

SET [GLOBAL | SESSION] TRANSACTION ISOLATION LEVEL ...

Users porting from Oracle and other databases will find READ COMMITTED a
useful level.

> -Mark

Best regards,

Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com




-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql@lists.mysql.com

[root]

>Description:

>How-To-Repeat:

>Fix:


>Submitter-Id:  
>Originator:root
>Organization:
 
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:  
>Severity:  
>Priority:  
>Category:  mysql
>Class: 
>Release:   mysql-3.23.52 (Official MySQL RPM)

>Environment:

System: Linux lynx 2.2.16-3 #1 Mon Jun 19 18:10:14 EDT 2000 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc'  CFLAGS='-O6 -fno-omit-frame-pointer -mpentium'  CXX='gcc'  
CXXFLAGS='-O6 -fno-omit-frame-pointer  -felide-constructors 
-fno-exceptions -fno-rtti -mpentium'  LDFLAGS=''
LIBC: 
lrwxrwxrwx   1 root root   13 Jan 21 01:52 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x   1 root root  4101836 Jan 15  2001 /lib/libc-2.1.3.so
-rw-r--r--   1 root root 20273324 Jan 15  2001 /usr/lib/libc.a
-rw-r--r--   1 root root  178 Jan 15  2001 /usr/lib/libc.so
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static 
--with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc 
--without-berkeley-db --without-innodb --enable-assembler --enable-local-infile 
--with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ 
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin 
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql 
--infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man 
'--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer 
-mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer  -felide-constructors 
-fno-exceptions -fno-rtti -mpentium' CXX=gcc
Perl: This is perl, version 5.005_03 built for i386-linux








-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

All Remote requests hang server

[Les Fenison]

I am having a problem getting any kind of remote connections.  Connections 
to localhost work just fine.

It doesn't matter which mysql client I use or if I just attempt to telnet 
to port 3306, the result is the same.  The server restarts.

The log reports this;

Number of processes running now: 1
mysqld process hanging, pid 11951 - killed
021007 22:39:19  mysqld restarted
021007 22:39:19  InnoDB: Started
/usr/libexec/mysqld: ready for connections

When attempting a connection using telnet to port 3306 I get connection 
refused.

If I attempt to connect using a mysql client I get;
ERROR 2013: Lost connection to MySQL server during query

The platform is Linux 7.3
Installed RPMs are;
mysqlclient9-3.23.22-6
mysql-server-3.23.49-3
mysql-3.23.49-3
php-mysql-4.1.2-7.3.4
mysql-devel-3.23.49-3


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Recommended Books

[Tarun Khandelwal]

Hi Thomas,
This is Tarun Khandelwal from Jaipur, Rajasthan, INDIA
!!! 'N' I hav also bought a book on MySQL whose name is: MySQL by Paul
DuBios ( Forwarded by Michael "Monty" Widenius,MySQL Moderator)

This all is written on the book 'n' it one of the best book available. There
is also a book of Oriely. U can check it's price 'n' other views on
www.amazon.com ( on the books section ) These books will be available.

Awaiting your earliest reply

the cyberwiz
Tarun Khandelwal
Jaipur

[EMAIL PROTECTED]
[EMAIL PROTECTED]

MSN messenger Id: [EMAIL PROTECTED]


- Original Message -
From: "Curley, Thomas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 07, 2002 5:58 PM
Subject: Recommended Books


Hi,

Any anyone have recommendations on MySql books currently in print.  What's
the best or is the online manual all that's needed !

Thomas

-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php










-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: how to check .MYI file withour shutdown database

[Dan Nelson]

In the last episode (Oct 08), Patrick Hsieh said:
> Hello list,
> 
> Can I use myisamchk to check the index without shutdown the mysql
> server?

As long as your mysqld is running with locking enabled.  You can check
by running " SHOW VARIABLES LIKE 'skip_external_locking' ".  If it's
set to NO, you can run myisamchk while mysqld is running.

You might want to just use the "CHECK TABLE tablename" command, though,
which will always work.

-- 
Dan Nelson
[EMAIL PROTECTED]

-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: problem

[vinita vigine Murugiah]

HI
You may NOT have create privileges.

check your privileges by doing show grants for @;

You can give CREATE privileges for databases & tables

GRANT CREATE ON *.* To  IDENTIFIED BY ''

Refer to http://www.mysql.com/doc/en/GRANT.html

Phung Huu Phu wrote:

>Dear Sir or Madam:
>I have installed MySQL database to Sun Enterperise 250 with Solaris 8
>OS.
>I can run database server and query but I can't create database.
>Please tell me know how can I correct it ?
>Thank in advance.
>Phu
>
>
>-
>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]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Problems with LOAD DATA LOCAL INFILE

[nellA hciR]

the permissions on the file and the enclosing directory (all the way up 
to the root dir) must allow for execution

also, my.cnf need to have

[mysqld]
local-infile=1

#!/usr/bin/perl
use DBI;

$dbh = DBI->connect( "dbi:mysql:databasename", 'user', 'password', {
PrintError => 0 } ) or die "Can't connect to mysql database: 
$DBI::errstr\n";

$input = "load data infile '/users/hcir/p99x/palmer/last/trk' into 
table trk";
$dbh->do($input) or warn "$DBI::errstr\n";

$dbh->disconnect or print "Disconnect failure: $DBI::errstr\n";

- hcir



On Monday, Oct 7, 2002, at 18:51 America/Anchorage, Ronald Petty wrote:

> I just tried the following and got
>
> ysql> load data local infile "/home/repett0/contact.data" into table
> CONTACT;
> ERROR 1148: The used command is not allowed with this MySQL version
> mysql>
>
> I too use perl and dbi
>
> What is going on?


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

how to check .MYI file withour shutdown database

[Patrick Hsieh]

Hello list,

Can I use myisamchk to check the index without shutdown the mysql server?




-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Remote Connection Probem

[Daevid Vincent]

I have the exact same problem. Nothing has changed other than I upgraded
from RH7.3 to RH8.0. I've tried at least five (5) different mySQL
windows clients and all refuse to connect. However I can use phpMyAdmin
locally (via web) and also all my web based database pages work fine
too. I've tried adding some entries to the mysql/hosts table and still
nothing. It's very confusing and frustrating indeed. Anyone know how to
get this working again? And for what it's worth. I have no firewall on
the linux box (removed all that crap), and both my winxp and linux boxes
are sitting on an internal LAN 192.168.0.% 

[root@daevid var]# rpm -qa | grep "mysql"

mysql-server-3.23.52-3
libdbi-dbd-mysql-0.6.5-2
mysql-3.23.52-3
mysql-devel-3.23.52-3
mod_auth_mysql-1.11-1
mysqlclient9-3.23.22-6
php-mysql-4.1.2-7.3.4

DÆVID.

"A good friend will come and bail you out of jail...but a true friend
will be sitting next to you in the holding cell, laughing and saying
-'That was fucking awesome!'" 

> -Original Message-
> From: Stefan Kuss [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, October 07, 2002 7:41 PM
> To: [EMAIL PROTECTED]
> Subject: Remote Connection Probem
> 
> 
> Hi,
> 
> I am running MySQL 3.23 on Redhat 8.0. I can connect to MySQL 
> from the local machine without any problem and I created a 
> user with remote login privileges. Trying to connect to it 
> from another machine (on the same network as well as the same 
> subnet) gives "ERROR: 10061 Connection to mysql server 
> failed." I have no problems connecting to the linux machine 
> via hhtp, ftp, and ssh and a port scan shows that MySQL is 
> infact running on the remote machine (default port 3306). Has 
> anyone heard of similar problems and an idea of how to solve this?
> 
> -Stefan


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: .Optimize mySQL memory usage ? 41MB threads ??

[root]

On Mon, 7 Oct 2002, Jon Shoberg wrote:

> Ok,
> 
>   So how do I optimize memory usage?  Where to start ?
> 
> -Jon
> 
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, October 07, 2002 9:16 PM
> To: Jon Shoberg
> Cc: [EMAIL PROTECTED]
> Subject: Re: .Optimize mySQL memory usage ? 41MB threads ??
> 
> In the last episode (Oct 07), Jon Shoberg said:
> > I have a small PHP website that gets a fair amount of traffic.  It's
> > a simple layout with two tables. I average about 50 concurrently open
> > apache sessions and 40 open mysql connections.  I am calling for
> > persistent connections from the mySQL/PHP API.
> > 
> > But here is the kicker.  Each mySQL thread takes about 41mb!! :(  Can
> > anyone point me to resources on optimizing mySQL's memory usage under
> > a moderate/heavy load?
> 
> Threads have no memory.  You're getting misled by Linuxes threads
> implementation, which displays each thread as if it were a separate
> process.  They actually share the same block of memory, which is why
> they're threads and not processes.
> 
> 

add 
set-variable = key_buffer=128M
to my.cnf file.

actually 128M should be the sum of all the index (*.MYI) files.
FYI - mysql only caches data read from indexes 

you can check innodb buffer usage or hit ratios  by running the 
innodb_monitor.



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: .Optimize mySQL memory usage ? 41MB threads ??

[Dan Nelson]

In the last episode (Oct 07), Jon Shoberg said:
> From: Dan Nelson [mailto:[EMAIL PROTECTED]] 
> > In the last episode (Oct 07), Jon Shoberg said:
> > > I have a small PHP website that gets a fair amount of traffic. 
> > > It's a simple layout with two tables. I average about 50
> > > concurrently open apache sessions and 40 open mysql connections. 
> > > I am calling for persistent connections from the mySQL/PHP API.
> > > 
> > > But here is the kicker.  Each mySQL thread takes about 41mb!! :(
> > > Can anyone point me to resources on optimizing mySQL's memory
> > > usage under a moderate/heavy load?
> >  
> > Threads have no memory.  You're getting misled by Linuxes threads
> > implementation, which displays each thread as if it were a separate
> > process.  They actually share the same block of memory, which is
> > why they're threads and not processes.
> 
> So how do I optimize memory usage?  Where to start ?

Have you read the manual?  Chapter 5 pretty much covers everything. 
http://www.mysql.com/doc/en/MySQL_Optimisation.html
http://www.mysql.com/doc/en/Memory_use.html

-- 
Dan Nelson
[EMAIL PROTECTED]

-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Problems with LOAD DATA LOCAL INFILE

[Ronald Petty]

I just tried the following and got

ysql> load data local infile "/home/repett0/contact.data" into table
CONTACT;
ERROR 1148: The used command is not allowed with this MySQL version
mysql>

I too use perl and dbi

What is going on?
Thanks
Ron



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

problem

[Phung Huu Phu]

Dear Sir or Madam:
I have installed MySQL database to Sun Enterperise 250 with Solaris 8
OS.
I can run database server and query but I can't create database.
Please tell me know how can I correct it ?
Thank in advance.
Phu


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Remote Connection Probem

[Stefan Kuss]

Hi,

I am running MySQL 3.23 on Redhat 8.0. I can connect to MySQL from the local
machine without any problem and I created a user with remote login
privileges. Trying to connect to it from another machine (on the same
network as well as the same subnet) gives "ERROR: 10061 Connection to mysql
server failed." I have no problems connecting to the linux machine via hhtp,
ftp, and ssh and a port scan shows that MySQL is infact running on the
remote machine (default port 3306). Has anyone heard of similar problems and
an idea of how to solve this?

-Stefan



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Install Problem

[John Coder]

On Mon, 2002-10-07 at 19:18, Daniel Miller wrote:
> 
> I have been trying to install the  
> mysql-3.23.52-pc-linux-gnu-i686.tar.gz on my SUSE Linux 7.3 machine.
> Everything seems to be going smoothly until I entered the command
> 
> ./scripts/mysql_install_db
> 
> I got this output which i believe is ok;
> 
> 
> 
> 
> cords-orj86jfje:/usr/local/mysql/mysql # ./scripts/mysql_install_db
> Preparing db table
> Preparing host table
> Preparing user table
> Preparing func table
> Preparing tables_priv table
> Preparing columns_priv table
> Installing all prepared tables
> 021007 18:15:39  ./bin/mysqld: Shutdown Complete
> 
> 
> To start mysqld at boot time you have to copy support-files/mysql.server
> to the right place for your system
> 
> PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
> This is done with:
> ./bin/mysqladmin -u root  password 'new-password'
> ./bin/mysqladmin -u root -h cords-orj86jfje  password 'new-password'
> See the manual for more instructions.
> 
> You can start the MySQL daemon with:
> cd . ; ./bin/safe_mysqld &
> 
> You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
> cd sql-bench ; run-all-tests
> 
> Please report any problems with the ./bin/mysqlbug script!
> 
> The latest information about MySQL is available on the web at
> http://www.mysql.com
> Support MySQL by buying support/licenses at https://order.mysql.com
> 
> 
> 
> 
> 
> Then I try to enter this command to configure my passwords;
> 
> Firstly
> 
> cords-orj86jfje:/usr/local/mysql/mysql # ./bin/safe_mysqld --user=mysql &
> [1] 1346
> cords-orj86jfje:/usr/local/mysql/mysql # Starting mysqld daemon with databases from 
>/usr/local/mysql/mysql/data
> 021007 19:15:21  mysqld ended
> 
> [1]+  Done./bin/safe_mysqld --user=mysql
> 
> THEN,
> 
> cords-orj86jfje:/usr/local/mysql/mysql # ./bin/mysqladmin -u root password sqlpass
> ./bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)'
> 
> OR
> cords-orj86jfje:/usr/local/mysql/mysql # ./bin/mysqladmin -u root sqlpass
> ./bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)'
> Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
> 
> What am I doing wrong ??
> 
> 
> Thanks, Daniel
it's easier to do this from and rpm that suse provides. if you do
reinstall using a rpm from suse before you issue the command
mysql_install_db run the command from any terminal 'rcmysql start' that
runs a script that is located in /etc/init.d . For further explanation
read the README.SUSE. I suspect the problem is where you are installing
it. by definition by tar it usually winds up wherever you tar gunzip it.
by rpm it winds up in /var/lib/mysql. I've also have done a soft link
from one to the other. Hope this helps.

John Coder




-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: .Optimize mySQL memory usage ? 41MB threads ??

[Jon Shoberg]

Ok,

So how do I optimize memory usage?  Where to start ?

-Jon

-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]] 
Sent: Monday, October 07, 2002 9:16 PM
To: Jon Shoberg
Cc: [EMAIL PROTECTED]
Subject: Re: .Optimize mySQL memory usage ? 41MB threads ??

In the last episode (Oct 07), Jon Shoberg said:
> I have a small PHP website that gets a fair amount of traffic.  It's
> a simple layout with two tables. I average about 50 concurrently open
> apache sessions and 40 open mysql connections.  I am calling for
> persistent connections from the mySQL/PHP API.
> 
> But here is the kicker.  Each mySQL thread takes about 41mb!! :(  Can
> anyone point me to resources on optimizing mySQL's memory usage under
> a moderate/heavy load?

Threads have no memory.  You're getting misled by Linuxes threads
implementation, which displays each thread as if it were a separate
process.  They actually share the same block of memory, which is why
they're threads and not processes.

-- 
Dan Nelson
[EMAIL PROTECTED]



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: .Optimize mySQL memory usage ? 41MB threads ??

[Dan Nelson]

In the last episode (Oct 07), Jon Shoberg said:
> I have a small PHP website that gets a fair amount of traffic.  It's
> a simple layout with two tables. I average about 50 concurrently open
> apache sessions and 40 open mysql connections.  I am calling for
> persistent connections from the mySQL/PHP API.
> 
> But here is the kicker.  Each mySQL thread takes about 41mb!! :(  Can
> anyone point me to resources on optimizing mySQL's memory usage under
> a moderate/heavy load?

Threads have no memory.  You're getting misled by Linuxes threads
implementation, which displays each thread as if it were a separate
process.  They actually share the same block of memory, which is why
they're threads and not processes.

-- 
Dan Nelson
[EMAIL PROTECTED]

-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Error with LOAD DATA INFILE

[nellA hciR]

check the permissions of the enclosing directory

- hcir

On Monday, Oct 7, 2002, at 17:43 America/Anchorage, Unidux (MIS) - K 
Sudhir wrote:

> Hi,
>
> When i try to query ... load data infile ...
> i am getting the following error ...
> ERROR 13: Can't get stat of 'upload_fct_HQ_CA001S.txt' (Errcode: 2)
>
> The above mentioned same query i have used in many other modules, but i
> never get the error.  The file from which i am trying to load the data 
> has
> got the same read priviliges as the other files have got.
>
> Can anybody tell me how to fix this error.


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: transaction isolation level

[Mark Matthews]

Jianliang Zhao wrote:

>Thanks Jeremy. It turns out the JDBC SQL query tool(ViennaSQL) I am trying is causing 
>the problem. I couldn't reproduce the problem by writing a test case.
>
>Thanks,
>
>Jianliang
>
>-Original Message-
>From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
>Sent: 2002?10?7? 17:36
>To: Jianliang Zhao
>Cc: [EMAIL PROTECTED]
>Subject: Re: transaction isolation level
>
>
>On Mon, Oct 07, 2002 at 05:30:57PM -0700, Jianliang Zhao wrote:
>  
>
>>Hi,
>>
>>I am connecting to MySql 3.23(innodb) with
>>mysql-connector-java-2.0.14-bin.jar. I set the global transaction
>>isolation level to READ COMMITTED. However, I still couldn't see the
>>committed changes through JDBC client. Does anyone know about this
>>issue?
>>
>>
>
>Can you provide a sample test case, maybe?
>  
>
The isolation level of READ_COMMITTED has no effect currently in MySQL, 
unless you're using BDB tables...InnoDB runs either as REPEATABLE_READ 
or SERIALIZABLE, and converts everthing else to REPEATABLE_READ, because 
it can do REPATABLE_READ as fast (or faster) than most other DB's 
READ_COMMITTED.

-Mark

-- 
For technical support contracts, visit https://order.mysql.com/?ref=mmma

__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /  Mark Matthews <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
 /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com




-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Error with LOAD DATA INFILE

[Unidux \(MIS\) - K Sudhir]

Hi,

When i try to query ... load data infile ...
i am getting the following error ...
ERROR 13: Can't get stat of 'upload_fct_HQ_CA001S.txt' (Errcode: 2)

The above mentioned same query i have used in many other modules, but i
never get the error.  The file from which i am trying to load the data has
got the same read priviliges as the other files have got.

Can anybody tell me how to fix this error.

Thanks and Best Regards,

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.393 / Virus Database: 223 - Release Date: 30/Sep/2002


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Further info for my problem

[Dan Goodes]

Hi again,

Just did a stack trace, as the error log advised, and can't make heads or 
tails of it.

The error was brought about by me typing "mysql -u root -p mysql" at the 
command line, and hitting enter (and entering root's password):

0x808476a _Z15handle_segfaulti + 398
0x813152c __pthread_sighandler + 116
0x814fe3d vfprintf + 8057
0x8156d33 vsprintf + 79
0x807e63f _Z10net_printfP6st_netjz + 95
0x808cb1b _Z10check_userP3THD19enum_server_commandPKcS3_S3_b + 211
0x808d062 _Z17check_connectionsP3THD + 646
0x8086916 _Z21handle_one_connectionPv + 202

I think I understand some of that - threads, segfaults, and printfs. Thats 
about it. Incidentally, this is being built exactly the same way as a 
mysql-3.23.51 installation on RH7.2, that has been running and 
successfully driving a web site for the last couple of months (not long 
after 3.23.51 came out).

-- 
Regards,

Dan Goodes


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: transaction isolation level

[Jianliang Zhao]

Thanks Jeremy. It turns out the JDBC SQL query tool(ViennaSQL) I am trying is causing 
the problem. I couldn't reproduce the problem by writing a test case.

Thanks,

Jianliang

-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: 2002?10?7? 17:36
To: Jianliang Zhao
Cc: [EMAIL PROTECTED]
Subject: Re: transaction isolation level


On Mon, Oct 07, 2002 at 05:30:57PM -0700, Jianliang Zhao wrote:
> Hi,
> 
> I am connecting to MySql 3.23(innodb) with
> mysql-connector-java-2.0.14-bin.jar. I set the global transaction
> isolation level to READ COMMITTED. However, I still couldn't see the
> committed changes through JDBC client. Does anyone know about this
> issue?

Can you provide a sample test case, maybe?
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 3.23.51: up 62 days, processed 1,334,315,423 queries (246/sec. avg)

-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Problems with RH8 doing a source install

[Dan Goodes]

Hi,

Like a number of other people on the list, I've been having considerable 
difficulty getting MySQL (i've tried both 3.23.51 and 3.23.52) to work on 
RH8.0

Initially, I ran ./configure with --localstatedir=/server/local/mysql 
(among a number of other directives - note that I install the software in 
a completely different location to the datadir). This compiled and 
installed fine, until I went to run scripts/mysql_install_db. This 
generated pages and pages of suggestions, telling me where I should try to 
look (such as the log files in /server/local/mysql/).

No such log files existed. So I ran mysqld --help, and lo-and-behold, the 
server was compiled with datadir (also called localstatedir in 
./configure) == /ser/ . After much retrying and digging, I decided to try 
safe_mysqld --datadir=/server/local/mysql/. It started, but couldn't read 
the grant tables (since mysql_install_db was still failing).

To cut a [very] long story short, I finally got some grant tables 
happening (by copying them from a backup i'd made, since mysql - the 
client - was causing errors and failing all over the place). When I try 
to load an SQL script from the command line, I get:

ERROR 2013 at line 50: Lost connection to MySQL server during query

The error's i'm getting in my log file are:

Number of processes running now: 1
mysqld process hanging, pid 24946 - killed
021008 10:37:42  mysqld restarted

It does this every time I try to run a query. I also can't ^C the daemon - 
I have to kill -9 it.

I'm not even sure where to go here. Please don't tell me I have to install 
the binary packages. I install from source for a number of really good 
reasons (the major two are that I use "stow" to keep my installed apps 
managed, and that I like to have control over where my data is stored).

Hope someone has suggestions for a solution.

-- 
Regards,

Dan Goodes


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: transaction isolation level

[Jeremy Zawodny]

On Mon, Oct 07, 2002 at 05:30:57PM -0700, Jianliang Zhao wrote:
> Hi,
> 
> I am connecting to MySql 3.23(innodb) with
> mysql-connector-java-2.0.14-bin.jar. I set the global transaction
> isolation level to READ COMMITTED. However, I still couldn't see the
> committed changes through JDBC client. Does anyone know about this
> issue?

Can you provide a sample test case, maybe?
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 3.23.51: up 62 days, processed 1,334,315,423 queries (246/sec. avg)

-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

transaction isolation level

[Jianliang Zhao]

Hi,

I am connecting to MySql 3.23(innodb) with mysql-connector-java-2.0.14-bin.jar. I set 
the global transaction isolation level to READ COMMITTED. However, I still couldn't 
see the committed changes through JDBC client. Does anyone know about this issue?

Thanks,

Jianliang

-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysqlimport problem.

[John Ragan]

> Greetings,
> 
>   I have an application that creates an SQL file from the data it
> produces, but in some of that data, there might be a , or ' which
> mysqlimport does not like. I need to use the mysqlimport utility, and I am
> wondering if there is a way around this. I admit I have not tried yet, but
> if my application writes the data beginning and ending with "'s would that
> solve my problem?
> 
> Thanks,
> - Chris


if you have a windows machine that you can use for a 
front end to your mysql server, download corereader 
from http://corereader.com/ .  it's free.

it does point and click queries, so it's very fast 
except for making the data connection.  

run a query containing the apostrophe.  then open 
corereader's sql frame to see its sql statement.  
it'll show you how to mask delimiters.

( because it's so powerful, corereader contains 
safeguards that prohibit updates, so you cannot 
update directly from it. )


-- 
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.com/ 


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Install Problem

[Daniel Miller]

I have been trying to install the  
mysql-3.23.52-pc-linux-gnu-i686.tar.gz on my SUSE Linux 7.3 machine.
Everything seems to be going smoothly until I entered the command

./scripts/mysql_install_db

I got this output which i believe is ok;




cords-orj86jfje:/usr/local/mysql/mysql # ./scripts/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
021007 18:15:39  ./bin/mysqld: Shutdown Complete


To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
./bin/mysqladmin -u root  password 'new-password'
./bin/mysqladmin -u root -h cords-orj86jfje  password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd . ; ./bin/safe_mysqld &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; run-all-tests

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com





Then I try to enter this command to configure my passwords;

Firstly

cords-orj86jfje:/usr/local/mysql/mysql # ./bin/safe_mysqld --user=mysql &
[1] 1346
cords-orj86jfje:/usr/local/mysql/mysql # Starting mysqld daemon with databases from 
/usr/local/mysql/mysql/data
021007 19:15:21  mysqld ended

[1]+  Done./bin/safe_mysqld --user=mysql

THEN,

cords-orj86jfje:/usr/local/mysql/mysql # ./bin/mysqladmin -u root password sqlpass
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)'

OR
cords-orj86jfje:/usr/local/mysql/mysql # ./bin/mysqladmin -u root sqlpass
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

What am I doing wrong ??


Thanks, Daniel


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RES: gcc 2.96 & sourcecode

[Robert H.R. Restad]

Hm... No offense, but I believe the [EMAIL PROTECTED] just spammed
itself... As it clearly says 'if you just reply to this message, and include
the entire text...'

I also believe JK did just as instructed by the list itself, which resulted
in spam... or what :)

Hmz

Cheers
Rob.

-Mensagem original-
De: Jochen Kächelin [mailto:[EMAIL PROTECTED]]
Enviada em: segunda-feira, 7 de outubro de 2002 16:29
Para: [EMAIL PROTECTED]
Assunto: gcc 2.96 & sourcecode


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 this message, and include the entire text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. Just typing the word MySQL once will be sufficient, for example.

You have written the following:

I  read  that's  not  good  to compile the sources with RedHat's gcc
2.96.  I  just  compiled  4.0.4  Beta  and  no errors occured during
installation.

Where's the problem with gcc 2.96?

--
Jochen Kaechelin

--
Jochen Kaechelin


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

__
Se den nye Yahoo! Mail på http://no.yahoo.com/
Nytt design, enklere å bruke, alltid tilgang til Adressebok, Kalender og Notisbok

-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL Question

[David M. Gonzalez Salinas]

Hi everybody...

Does anybody knoy what is equivalent stmt in MySQL? select * from table1 
where col1 in (select col1 from table2)

thanks in advance.

David.




-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

BUG: Table locking under ISAM/MyISAM can easily fail

[Jason Garrett]

(Perl Script mysqlbug not used as Perl is not installed)

SUBJECT:Table locking under ISAM can fail
ORGANIZATION:   Owens Services B.O.P. Ltd, New Zealand
LICENCE:None (expired support license)
SYNOPSIS:   User can cause table locking to fail by USE'ing the same database
but spelt with different case sensitivity
SEVERITY:   Serious
PRIORITY:   High
CLASS:  sw-bug
RELEASE:3.23.46-max-nt
DESCRIPTION:
Table locking in ISAM and MyISAM tables can be made to fail by simply
specifying the database name differently (upper/lower case).
A user performing a table lock in database 'test' has no locking effect
on another user in database 'TEST'.

HOW_TO_REPEAT:

Execute the following script to create a database called 'test'
with a table called 'dummy', which consists of a single field called
'bogus'.
= database script starts =
CREATE DATABASE test;
USE test;
CREATE TABLE dummy (
bogus VARCHAR(50)
) TYPE=ISAM;
= database script ends =

I have two examples of how to repeat this.  The first example, (A) is not as
simple as (B) but tries a different tact on the same problem.  For
simplicity,
try example (B) first.

Example (A)
===
Open two instances of mysql.exe (referred to as (1) and (2) from here on in)
In (1) enter:
USE test;
LOCK TABLES dummy WRITE;
In (2) enter:
USE test;
SELECT * FROM dummy;
As expected, (2) will appear to be waiting for the table 'dummy' to be
unlocked.
In (1) enter:
USE mysql;
USE TEST;
UNLOCK TABLES;
(2) will be released by the 'unlock' statement, and display the contents of
the
table 'dummy' as expected.  From here on, the error can be seen.  Note that
the
database name has changed from 'test' to 'TEST'.
In (1) enter:
LOCK TABLES dummy WRITE;
In (2) enter:
SELECT * FROM dummy;
(2) will not wait, and will display the result immediately.  We seem to have
confused
the server as to which 'database/table' we are locking, and (2) has the
ability to
query the table.
= End Example (A) =

Example (B)
===
Open two instances of mysql.exe (referred to as (1) and (2) from here on in)
In (1) enter:
USE test;
LOCK TABLES dummy WRITE;
In (2) enter:
USE Test;
SELECT * FROM dummy;
(2) is using the same database but has used an uppercase 'T' in the database
name.
The result of this small inconsistency is that the locking does not work.
(2) is seen
to return the result immediately
= End Example (B) =

We had been trying to find a problem in a MyISAM database where table
corruption would
occur, and the error message 'Got error 134 from Table Handler'.  We figured
that we
should try to repeat the error consistently before we reported it.

We currently suspect that the table corruption is caused by the Table
Handler being unable to
synchronize updates from multiple clients where the database name differs
(case sensitivity).
The table locking problem could be to blame for this.

We are able to repeat this problem with MyISAM tables as well.

FIX:
We will be ensuring all our applications lower the case of the database
name before using.
We believe this will work satisfactorily for the meantime.  The danger
exists that later
applications may not use the same case, and access the database, possibly
causing this
corruption.

= Other information =
Platform: Win2000 (5.00.2195 Service Pack 2)

Client and Server information:
mysql> \s
--
mysql  Ver 11.15 Distrib 3.23.46, for Win95/Win98 (i32)

Connection id:  23
Current database:
Current user:   ODBC@localhost
Server version: 3.23.46-max-nt
Protocol version:   10
Connection: . via named pipe
Client characterset:latin1
Server characterset:latin1
UNIX socket:MySQL
Uptime: 51 min 13 sec

Threads: 1  Questions: 205  Slow queries: 0  Opens: 63  Flush tables: 1
Open tables: 4 Queries per second avg: 0.067
--


Jason.

Jason Garrett
Owens Services BOP Ltd
Phone: +64 7 5756274  Fax: +64 7 5750262  Cell: +64 27 2212246


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

.Optimize mySQL memory usage ? 41MB threads ??

[Jon Shoberg]

I have a small PHP website that gets a fair amount of traffic.  It's a
simple layout with two tables. I average about 50 concurrently open
apache sessions and 40 open mysql connections.  I am calling for
persistent connections from the mySQL/PHP API.


But here is the kicker.  Each mySQL thread takes about 41mb!! :(  Can
anyone point me to resources on optimizing mySQL's memory usage under a
moderate/heavy load?

Thanks
Jon



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

FW: REVISED: Connecting from web server to a MySQL server using Apache+PHP

[Nestor Florez]

OK now I am getting this error:

Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in
/usr/local/httpd/htdocs/mbn.com/confirmation.php on line 36

Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]'
(Using password: YES) in /usr/local/httpd/htdocs/mbn.com/confirmation.php on
line 36
Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)

I look at the db table of mysql and [EMAIL PROTECTED] has select and insert
permissions
on the table that I am trying to connect

Nestor :-)


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

REVISED: Connecting from web server to a MySQL server using Apache+PHP

[Nestor Florez]

I messed up in the ip addressing sorry!
--


People,

I have a linux web server running apache 1.3.26 and php(IP= 10.1.1.3)
I have a W2K Database server running MySQL 3.23.52(IP= 10.1.1.2)

My connecting string is
   mysql_connect("10.1.1.2:3306", $dbuser, $db_pwd);

And I ge the error:

Warning: Can't connect to MySQL server on '10.1.1.3' (111) in
/usr/local/httpd/htdocs/mbn.com/confirmation.php on line 36

Warning: MySQL Connection Failed: Can't connect to MySQL server on
'10.1.1.3' (111) in /usr/local/httpd/htdocs/mbn.com/confirmation.php on
line 36
Can't connect to MySQL server on '10.1.1.3' (111)


Line 36 is where mymysql_connect function is at.

Any ideas?

Nestor :-)


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

REVISED: Connecting from web server to a MySQL server using Apache+PHP

[Nestor Florez]

People,

I have a linux web server running apache 1.3.26 and php(IP= 10.1.1.3)
I have a W2K Database server running MySQL 3.23.52(IP= 10.1.1.2)

My connecting string is
   mysql_connect("10.1.1.2:3306", $dbuser, $db_pwd);

And I ge the error:

Warning: Can't connect to MySQL server on '10.1.1.3' (111) in
/usr/local/httpd/htdocs/mbn.com/confirmation.php on line 36

Warning: MySQL Connection Failed: Can't connect to MySQL server on
'10.1.1.3' (111) in /usr/local/httpd/htdocs/mbn.com/confirmation.php on
line 36
Can't connect to MySQL server on '66.161.11.215' (111)


Line 36 is where mymysql_connect function is at.

Any ideas?

Nestor :-)


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: JDBC RowSets in Mysql Connector

[Mark Matthews]

Vincent Stoessel wrote:

>Yeah, I was thinking about doing the scrolling results thing
>using a pure java solution. I will look into the CachedRowset
>from Sun, thanks for that info. I still believe the mysql driver
>is cool. What's up with the docs, though?
>
JDBC-2.0 result sets are fully scrollable (read the API docs)

What's the problem with the docs? They're in the README. Everything that 
is specific to the driver is in there. Anything that's not is in 
ten's-of-thousands of pages in books, websites and magazine articles 
about JDBC...it is a _standard_ API in Java.

-Mark

-- 
For technical support contracts, visit https://order.mysql.com/?ref=mmma

__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /  Mark Matthews <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
 /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com




-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Connecting from web server to a MySQL server using Apache+PHP

[Nestor Florez]

People,

I have a linux web server running apache 1.3.26 and php(IP= 10.1.1.3)
I have a W2K Database server running MySQL 3.23.52(IP= 10.1.1.2)

My connecting string is
   mysql_connect("10.1.1.2:3306", $dbuser, $db_pwd);

And I ge the error:

Warning: Can't connect to MySQL server on '66.161.11.215' (111) in
/usr/local/httpd/htdocs/mbn.com/confirmation.php on line 36

Warning: MySQL Connection Failed: Can't connect to MySQL server on
'66.161.11.215' (111) in /usr/local/httpd/htdocs/mbn.com/confirmation.php on
line 36
Can't connect to MySQL server on '66.161.11.215' (111)


Line 36 is where mymysql_connect function is at.

Any ideas?

Nestor :-)


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: HA of MySQL

[Jeremy Tinley]

The problem isn't so much with the failover.  It's with data integrity.
Binlogs control replication.  You can place a failover master in between
the master and slaves.  In the event of a master failure, you eliminate
the loss of writes by directing them to the failover.  If you lose your
failover, the binlogs can be completely different thus pointing the
slaves to the master is useless.

The binlog position is the real problem.  Since binlogs are stored with
their byte position as the indicator instead of a unique value passed on
from the master, there's no easy way of finding the position you were
just at.

Is is possible to write two binlogs?  One to the local disk, one to a
network device?

-J

-Original Message-
From: Daniel Koch [mailto:[EMAIL PROTECTED]] 
Sent: Monday, October 07, 2002 11:47 AM
To: Jeremy Tinley
Cc: [EMAIL PROTECTED]
Subject: Re: HA of MySQL

On Mon, 2002-10-07 at 10:30, Jeremy Tinley wrote:
> Howdy,
> 
> There has been some interest lately in HA of MySQL services both in my
> company and on the list.  A few of us here sat down on Friday (at 5PM
no
> less) and started hashing out the details of providing such a service.
> Following several possible approaches, we ran into major stumbling
> blocks on each path.
> 


You might check with these guys, who have a similar project:

http://mysql-ha.sourceforge.net/



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: JDBC RowSets in Mysql Connector

[Vincent Stoessel]

Yeah, I was thinking about doing the scrolling results thing
using a pure java solution. I will look into the CachedRowset
from Sun, thanks for that info. I still believe the mysql driver
is cool. What's up with the docs, though?


Mark Matthews wrote:
> Vincent Stoessel wrote:
> 
>> Hello,
>> I am working on a J2EE app and I really would love to take
>> advantage of jdbc 2.0's  RowSet functionality.
>> Is Connector J (2 or 3) compliant
>> with this part of the standard?
>>  
>>
> No.  There hasn't been a large demand for support of that API, and it's 
> not required to be JDBC-compliant. What particular feature of a rowset 
> would you be using that isn't in java.sql.ResultSet?
> 
> There are a lot of third party ones that do work with MySQL. Sun's 
> CachedRowset provider (from java.sun.com) is one.
> 
>-Mark
> 


-- 
Vincent Stoessel
Linux Systems Developer
vincent xaymaca.com


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: The secure mode in InnoDB

[Heikki Tuuri]

Hi!

- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Dyego Souza do Carmo" <[EMAIL PROTECTED]>
Cc: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, October 07, 2002 10:10 PM
Subject: Re: The secure mode in InnoDB


> On Mon, Oct 07, 2002 at 01:53:25PM -0300, Dyego Souza do Carmo wrote:
> > Hello Heikki !
> >
> > what is the best secure mode to use innodb ? ( min time to write data
> > in disk )
>
> You're confusing two ideas.  The most secure (reliable) is 1.  The
> fastest is 0.  You can't have both.

Jeremy is right. 1 is the only option which calls fsync after each log write
at trx commit. An fsync flushes the log to disk, at least in theory.

For most users who need high speed, 2 is the best option starting from
3.23.52. It writes the log buffer to the log file at each commit. You will
not lose committed transactions in a pure mysqld process crash as long as
your OS does not crash, or there is no power outage. That is because the OS
file cache is not lost in a pure mysqld crash.

> Jeremy

Regards,

Heikki

sql query


> --
> Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
> <[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/
>
> MySQL 3.23.51: up 62 days, processed 1,331,355,814 queries (246/sec. avg)



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: JDBC RowSets in Mysql Connector

[Mark Matthews]

Vincent Stoessel wrote:

>Hello,
>I am working on a J2EE app and I really would love to take
>advantage of jdbc 2.0's  RowSet functionality.
>Is Connector J (2 or 3) compliant
>with this part of the standard?
>  
>
No.  There hasn't been a large demand for support of that API, and it's 
not required to be JDBC-compliant. What particular feature of a rowset 
would you be using that isn't in java.sql.ResultSet?

There are a lot of third party ones that do work with MySQL. Sun's 
CachedRowset provider (from java.sun.com) is one.

-Mark



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysqlimport problem.

[Chris]

Greetings,

I have an application that creates an SQL file from the data it
produces, but in some of that data, there might be a , or ' which
mysqlimport does not like. I need to use the mysqlimport utility, and I am
wondering if there is a way around this. I admit I have not tried yet, but
if my application writes the data beginning and ending with "'s would that
solve my problem?

Thanks,
- Chris



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Problems with LOAD DATA LOCAL INFILE

[Mailing List Receiver]

I have found to do a LOAD DATA LOCAL INFILE is no longer possible
using perl-DBI, even though local-infile=1 is in the [mysql], [mysqld],
and [client] sections of my.cnf.

I am not sure what prompted the engineering powers-that-be to 
change the default for this version, 3.23.49, of mysql, but it sure has
caused a lot of trouble.

Todd Merriman
[EMAIL PROTECTED]


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

gcc 2.96 & sourcecode

[Jochen Kächelin]

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 this message, and include the entire text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. Just typing the word MySQL once will be sufficient, for example.

You have written the following:

I  read  that's  not  good  to compile the sources with RedHat's gcc
2.96.  I  just  compiled  4.0.4  Beta  and  no errors occured during
installation.

Where's the problem with gcc 2.96?

-- 
Jochen Kaechelin

-- 
Jochen Kaechelin


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Loading data into a table

[Sean Moshenko]

I seem to have run into a rather peculiar problem.  I was attempting to load
data into a table from a file.  I checked with the online documentation and
found the following syntax:

LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;

I used this format exactly (with my own file and table names of course) and
was greeted with the following error message:

ERROR 1148: The used command is not allowed with this MySQL version

Calling 'mysql --version' I have found that I am using version 11.18 Distrib
3.23.52 (on w2k).  Is there another means by which I can get large amounts
of data into my table without using a whole whack of INSERT statements?

Any help would be greatly appreciated.

Sean



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: The secure mode in InnoDB

[Jeremy Zawodny]

On Mon, Oct 07, 2002 at 01:53:25PM -0300, Dyego Souza do Carmo wrote:
> Hello Heikki !
> 
> what is the best secure mode to use innodb ? ( min time to write data
> in disk )

You're confusing two ideas.  The most secure (reliable) is 1.  The
fastest is 0.  You can't have both.

Jeremy
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 3.23.51: up 62 days, processed 1,331,355,814 queries (246/sec. avg)

-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

replace

[Nissim Lugasy]

I have a table with two column; the first column contain unix timestamp(of 
type double ) which is the primary key. I would like to round the time. 
could I do :
mysql> insert into mytbl(time) values(round(time));

should this work?
Thanks
Nissim


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Protecting CC Numbers

[David Gerler]

Michael,
Thanks for the input. Feel confident that you are in good company
with your recommendations. After many replies to my original post and
some discussion, I have decided that I will encrypt the card numbers
using command line PGP before sending the using sendmail to myself.
Only a stub will be stored on the server for client verification. I
will then store them (encrypted) on a system that is isolated and
secure. I will maintain my private key on removable media and only
decrypt them long enough to process the monthly charges. At no time
will they be stored in a database unencrypted.
Do you have any suggested modifications to this plan? I do need to
charge the cards on a recurring basis, but the charges will vary from
month to month. So the recurring charge method at the payment gateway
will not work for this.

Thanks again to all that gave input.

Dave



-Original Message-
From: Michael T. Babcock [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 10:18 AM
To: '[EMAIL PROTECTED]'
Subject: Re: Protecting CC Numbers

Hack Hawk wrote:


>> This implies hard-coding a private key and password somewhere on
your
>> system.  This type of system (IMO) should NEVER be connected to the
>> Internet.
>
>

Agreed and doubly agreed.  In fact, I'd say you should never save a CC
#
in your database _ever_ unless you're doing routine billing to it from
accounting software.  If you just want to 'remember' the user's CC #
so
they don't have to type it back in then don't -- point out on the
website that that would be a security risk and for their own safety,
you'd like them to re-enter the card # every time they make a
purchase.


>> NEVER under any circumstances should you "permanently" store CC's
>> (even encrypted) on systems that are connected to the Internet.
>
>

Agreed.


>> I say 2 to 3 days max before archiving them off-line
(off-Internet).
>> This minimizes the risk if a hacker should happen to break in.
>
>

Or seconds ... 2 or 3 days is a long time in hacked-time; set up a
write-only encrypted pipe to send the cards (if indeed you must store
them) to a database which can only be read from locally and doesn't
allow any form of login or connection from the webserver machine
except
the write-only db connection.

Stupid SQL spam filter ...

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

JDBC RowSets in Mysql Connector

[Vincent Stoessel]

Hello,
I am working on a J2EE app and I really would love to take
advantage of jdbc 2.0's  RowSet functionality.
Is Connector J (2 or 3) compliant
with this part of the standard?

Thank You

sql,query
-- 
Vincent Stoessel
Linux Systems Developer
vincent xaymaca.com


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: protecting CC numbers

[William R. Mussatto]

On Sun, 6 Oct 2002, David Gerler wrote:

> Date: Sun, 6 Oct 2002 14:21:11 -0400
> From: David Gerler <[EMAIL PROTECTED]>
> To: Mysql <[EMAIL PROTECTED]>
> Subject: protecting CC numbers
> 
> Hi,
>   I am working on an application that will need to store users CC
> numbers so that they can be charge once a month and to verify
> identity. My question is: I am in process of getting an SSL, but my
> experience with SSL is none existent. Can someone give me an overview
> of protecting the numbers with mysql and SSL? Will the SSL protect the
> numbers when they are stored on the site? Or just when they are
> transmitted? Should I use something like PGP to encrypt the numbers
> before storing?
If you are applying SSL to your webserver (i.e., getting/generating a 
certificate then you are protecting the information only when it is being 
sent to the webserver.  You will need to encode the information again 
when you put it into the database using a two way key (i.e, unlike crypt 
or mysql's PASSWORD function which only encode it you will need a system 
which allows access to the original, unencoded version).  In perl there 
are several options under Crype,  Blowfish, Twofish and 3des are all 
secure although the latter may be nearing the end of its life).  Please 
remember you will also need to protect the 'key' you use to encode the 
information.  On a *nix box you can generate good keys from /dev/urandom.

Luck

> 
> David Gerler
> Gerler Enterprises
> PO Box 16357
> Chesapeake VA 23328
> (757) 410-0738
> http://www.GerlerEnterprises.com/
> 
> Nationwide Dial-up from $12.45 /mo.
> http://www.EasySitesForLess.com/
> 
> 
> 
> -
> 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]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 

Sincerely,

William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Question regarding processes

[Almar van Pel]

Hello,

When I do ps aux, mysql shows a lot of child processes. Why doesn't it close
them down? The load is low, at 12.00 I performed some heavy stuff, but
that's almost 6 hours ago for me.

Can anyone tell me?

mysql24020  0.0 11.8 78972 61368 ?   SOct04   0:28
/usr/local/libexec/mysqld
mysql24021  0.0 11.8 78972 61368 ?   SOct04   0:00
/usr/local/libexec/mysqld
mysql24022  0.0 11.8 78972 61368 ?   SOct04   0:13
/usr/local/libexec/mysqld
mysql24024  0.0 11.8 78972 61368 ?   SOct04   1:13
/usr/local/libexec/mysqld
mysql24026  0.0 11.8 78972 61368 ?   SOct04   1:10
/usr/local/libexec/mysqld
mysql24088  0.0 11.8 78972 61368 ?   SOct04   1:13
/usr/local/libexec/mysqld
mysql24151  0.0 11.8 78972 61368 ?   SOct04   1:34
/usr/local/libexec/mysqld
mysql24528  0.0 11.8 78972 61368 ?   SOct04   1:12
/usr/local/libexec/mysqld
mysql 1172  0.0 11.8 78972 61368 ?   SOct04   1:05
/usr/local/libexec/mysqld
mysql 7380  0.0 11.8 78972 61368 ?   SOct05   0:46
/usr/local/libexec/mysqld
mysql10037  0.0 11.8 78972 61368 ?   SOct05   0:45
/usr/local/libexec/mysqld
mysql28822  0.0 11.8 78972 61368 ?   SOct06   1:32
/usr/local/libexec/mysqld
mysql28823  0.0 11.8 78972 61368 ?   SOct06   0:21
/usr/local/libexec/mysqld
mysql28824  0.0 11.8 78972 61368 ?   SOct06   0:22
/usr/local/libexec/mysqld
mysql28825  0.0 11.8 78972 61368 ?   SOct06   0:57
/usr/local/libexec/mysqld
mysql28826  0.0 11.8 78972 61368 ?   SOct06   0:24
/usr/local/libexec/mysqld
mysql28851  0.0 11.8 78972 61368 ?   SOct06   0:28
/usr/local/libexec/mysqld
mysql 2500  0.0 11.8 78972 61368 ?   S12:01   0:02
/usr/local/libexec/mysqld
mysql 2502  0.0 11.8 78972 61368 ?   S12:01   0:03
/usr/local/libexec/mysqld
mysql 2505  0.0 11.8 78972 61368 ?   S12:01   0:03
/usr/local/libexec/mysqld
mysql 2510  0.0 11.8 78972 61368 ?   S12:01   0:03
/usr/local/libexec/mysqld
mysql 2517  0.0 11.8 78972 61368 ?   S12:01   0:03
/usr/local/libexec/mysqld
mysql 2518  0.0 11.8 78972 61368 ?   S12:01   0:03
/usr/local/libexec/mysqld
mysql 2523  0.0 11.8 78972 61368 ?   S12:01   0:03
/usr/local/libexec/mysqld
mysql 2526  0.0 11.8 78972 61368 ?   S12:01   0:03
/usr/local/libexec/mysqld
mysql 2527  0.0 11.8 78972 61368 ?   S12:01   0:03
/usr/local/libexec/mysqld
mysql 2534  0.0 11.8 78972 61368 ?   S12:01   0:03
/usr/local/libexec/mysqld
mysql 2536  0.0 11.8 78972 61368 ?   S12:01   0:03
/usr/local/libexec/mysqld
mysql 2538  0.0 11.8 78972 61368 ?   S12:01   0:03
/usr/local/libexec/mysqld
mysql 2541  0.0 11.8 78972 61368 ?   S12:01   0:03
/usr/local/libexec/mysqld
mysql 2545  0.0 11.8 78972 61368 ?   S12:01   0:03
/usr/local/libexec/mysqld
mysql 2547  0.0 11.8 78972 61368 ?   S12:01   0:03
/usr/local/libexec/mysqld
mysql 2549  0.0 11.8 78972 61368 ?   S12:01   0:03
/usr/local/libexec/mysqld
mysql 2555  0.0 11.8 78972 61368 ?   S12:02   0:03
/usr/local/libexec/mysqld
mysql 2557  0.0 11.8 78972 61368 ?   S12:02   0:03
/usr/local/libexec/mysqld
mysql 2563  0.0 11.8 78972 61368 ?   S12:02   0:03
/usr/local/libexec/mysqld
mysql 2564  0.0 11.8 78972 61368 ?   S12:02   0:03
/usr/local/libexec/mysqld
mysql 2567  0.0 11.8 78972 61368 ?   S12:02   0:03
/usr/local/libexec/mysqld
mysql 2571  0.0 11.8 78972 61368 ?   S12:02   0:03
/usr/local/libexec/mysqld
mysql 2577  0.0 11.8 78972 61368 ?   S12:02   0:03
/usr/local/libexec/mysqld
mysql 2579  0.0 11.8 78972 61368 ?   S12:02   0:03
/usr/local/libexec/mysqld
mysql 2581  0.0 11.8 78972 61368 ?   S12:02   0:03
/usr/local/libexec/mysqld
mysql 2591  0.0 11.8 78972 61368 ?   S12:02   0:03
/usr/local/libexec/mysqld
mysql 2592  0.0 11.8 78972 61368 ?   S12:02   0:03
/usr/local/libexec/mysqld
mysql 2593  0.0 11.8 78972 61368 ?   S12:02   0:03
/usr/local/libexec/mysqld
mysql 2594  0.0 11.8 78972 61368 ?   S12:02   0:03
/usr/local/libexec/mysqld
mysql 2598  0.0 11.8 78972 61368 ?   S12:02   0:03
/usr/local/libexec/mysqld

Best regards,


Almar van Pel



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Problem with encode() and decode() functions

[Ross Rannells]

We am having a problem with the encode() and decode() functions.  When
the second argument to the functions is a quoted string, the functions
return values as expected.  When the second argument to the functions is
another function call, i.e. the char() function, encode() and decode()
return SQL syntax errors.

The System is specs are:
Solaris SunOS sven 5.7 Generic_106541-16 sun4u sparc SUNW,Ultra-5_10, 
MySQL version 3.23.33 

I looked through the bug fix lists of the later versions and could not
find a reference to any problem like this on.  If it has been fixed, in
what version was it fixed?

An example from the MySQL command line is as follows:
select encode("Password","key");
+--+
| encode("Password","key") |
+--+
| méLC..É£ |
+--+

select decode("Password","key");
+--+
| decode("Password","key") |
+--+
| ß}ª  lÉÛ |
+--+

select encode(char(80,97,115,115,119,111,114,100),"key");
+---+
| encode(char(80,97,115,115,119,111,114,100),"key") |
+---+
| méLC..É£  |
+---+

select decode(char(80,97,115,115,119,111,114,100),"key");
+---+
| decode(char(80,97,115,115,119,111,114,100),"key") |
+---+
| ß}ª  lÉÛ  |
+---+

select encode("Password",char(107,101,121));
ERROR 1064: You have an error in your SQL syntax near
'char(107,101,121))' at line 1

select decode("Password",char(107,101,121));
ERROR 1064: You have an error in your SQL syntax near
'char(107,101,121))' at line 1

select encode(char(80,97,115,115,119,111,114,100),char(107,101,121));
ERROR 1064: You have an error in your SQL syntax near
'char(107,101,121))' at line 1

select decode(char(80,97,115,115,119,111,114,100),char(107,101,121));
ERROR 1064: You have an error in your SQL syntax near
'char(107,101,121))' at line 1


Any assistance in solving or finding a workaround for this problem would
be greatly appreciated.

Ross Rannells
Adjunct Professor, Purdue University
Donnell Systems Senior Systems Analyst


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

The secure mode in InnoDB

[Dyego Souza do Carmo]

Hello Heikki !

what is the best secure mode to use innodb ? ( min time to write data
in disk )

innodb_flush_log_at_trx_commit=0 ?

or

innodb_flush_log_at_trx_commit=1 ?

or

innodb_flush_log_at_trx_commit=2 ?

My System is MySQL/InnoDB 3.23.52 running in windows 2000 Server and
linux 2.4 ( with ReiserFS ) :D


sql,query,mysql !


-
  ++  Dyego Souza do Carmo   ++   Dep. Desenvolvimento   
-
 E S C R I B A   I N F O R M A T I C A
-
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
-- 
$ look into "my eyes"
look: cannot open my eyes
-
   Reply: [EMAIL PROTECTED]


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: HA of MySQL

[Daniel Koch]

On Mon, 2002-10-07 at 10:30, Jeremy Tinley wrote:
> Howdy,
> 
> There has been some interest lately in HA of MySQL services both in my
> company and on the list.  A few of us here sat down on Friday (at 5PM no
> less) and started hashing out the details of providing such a service.
> Following several possible approaches, we ran into major stumbling
> blocks on each path.
> 


You might check with these guys, who have a similar project:

http://mysql-ha.sourceforge.net/


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: 3.22.52 log rotation crash

[Victoria Reznichenko]

Matthew,
Wednesday, October 02, 2002, 5:29:38 PM, you wrote:

MJF> My company runs a moderately large and loaded MySQL replication network
MJF> across four Solaris machines. While upgrading from a fairly old 3.23.4x
MJF> installation to 3.23.52 we've encountered a problem with replication and
MJF> binlog rotation.
MJF> One of the machines is simultaneously slave to one server and master to
MJF> two others; on that machine, if a "RESET MASTER" or "PURGE MASTER LOGS"
MJF> is executed while its slave thread is performing a query, mysqld
MJF> reproducibly dies.


MJF> Looking in the mysql list archives, I see one other report of something
MJF> similar, but no detailed bug reports or resolution.

[skip]

I also saw the similar bug report, but I couldn't repeat it. Could you
test it with our binaries?


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Major MySQL Server Problems

[Jason Frisvold]

Greetings,

We're experiencing some severe problems with MySQL and I'm at a loss as
to what to look at ...  It seems we've encountered some sort of a loop
but I'm not sure what's causing it.  The system will run fine for a
while and then begin using 100% cpu on both processors in the system.

We've spent several days trying to track it down and I believe we may
have found the process responsible, but I haven't seen anything at all
in that process that's suspect.  It's a fairly simple perl script that
generates some email addresses via the db.  It has to use several
different db's to do so, but again, I can't see it putting a lot of load
on the system doing this.

Can anyone help me pinpoint this problem?  It's causing the entire DB
to run extremely slow and because of this we sometimes lose data. 
Killing and restarting the DB speeds it back up, but I believe this is
because it kills those DB connections and the processes fail.

The system is a Dell PowerEdge 2650
Dual 1.4 Ghz Intel P3 Processors
512 Meg RAM
MySQL 3.23.52
RedHat Linux 7.3
Hardware Raid 5
The DB partition is 4 GB, only 300 Meg used.
Overall, the HD's are less than 50% full.

Any help or suggestions are gladly welcome!

Thanks,

-- 
---
Jason 'XenoPhage' Frisvold
Senior ATM Engineer
Penteledata Engineering
[EMAIL PROTECTED]
RedHat Certified - RHCE # 807302349405893
---
"Something mysterious is formed, born in the silent void. Waiting alone
and unmoving, it is at once still and yet in constant motion. It is the
source of all programs. I do not know its name, so I will call it the
Tao of Programming."


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

syntax help , sql,query

[Dragos Madalin Popa]

sql,query

Hi,

I am trying to run this update statement, but I got an error syntax...near
offsetCould You please point out what is wrong?

Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where
ABBREVIATION is null;

Thank You,

Best Regards,
Madalin.



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

FW: Bug #19529 [Com]: Occational "Commands out of sync" errors

[Steven Roussey]

I thought I'd cross post this thread here. Maybe someone with MySQL API
experience can assist. 

Is there a way to reset a connection? That is, send one command that can
keep a connection open, but reset all the variables and rollback
unfinished transactions? I don't use transactions, but I can see where
this would be part of the need.

Sincerely,
Steven Roussey
http://Network54.com/?pp=e

-Original Message-
From: PHP Bug Database [mailto:[EMAIL PROTECTED]] 
Sent: Monday, October 07, 2002 5:03 am
To: [EMAIL PROTECTED]
Subject: Bug #19529 [Com]: Occational "Commands out of sync" errors

ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at
http://bugs.php.net/?id=19529


 ID:   19529
 Comment by:   [EMAIL PROTECTED]
 Reported By:  [EMAIL PROTECTED]
 Status:   Feedback
 Bug Type: MySQL related
 Operating System: Linux 2.4.18
 PHP Version:  4.2.3
 Assigned To:  georg
 New Comment:

Removing the ROLLBACK seems to have fixed the problem for me too.

Reading the MySQL docs on the error message in question, it would seem
that just adding a mysql_free_result call before executing the ROLLBACK
query might fix things. I noticed that the PgSQL extension does
something similar when rolling back transactions at shutdown.


Previous Comments:


[2002-10-06 14:51:51] [EMAIL PROTECTED]

Currently, neither mysql 4.x or 3.x supports enough functionality for
handling some problems when using persistent connections, e.g.

restoring session variables to global variables,
restoring auto_commit, unsetting user variables etc.

The probably error is not MySQL-version dependend. The 4.x clientlib is
100% backwards compatible to MySQL 3.x (> .23).

For some more information, it would be useful, if you could send me
some sources...

assigned to myself.

Georg





[2002-10-06 12:23:42] [EMAIL PROTECTED]

The problem seems to have disappeared when the ROLLBACK was removed.



[2002-10-06 11:02:28] [EMAIL PROTECTED]

Scratch the above; I was looking at the current CVS version. In 4.2.3
the function is still called _rollback_mysql_transactions and only does
the ROLLBACK, nothing more.

I just disabled the ROLLBACK as well, so if neither Erik nor myself see
any more errors, I think it's safe to assume that's where the problem
is. But shouldn't it always be safe to execute a rollback in MySQL,
even if transactions aren't in use?



[2002-10-06 10:14:36] [EMAIL PROTECTED]

I agree that the most plausible cause of the problem is in the
_restore_connection_defaults function, which is the one responsible for
doing the ROLLBACK. That theory would seem to be supported by the fact
that the problem disappears when disabling persistent connections
(since the function does nothing when the connection isn't
persistent).

What I don't get is why executing ROLLBACK on a straight-MyISAM
database would cause problems. Is that a bug in MySQL?

If the ROLLBACK isn't the problem, it would have to be either the SET
AUTOCOMMIT=1 or the stuff about unsetting the selected DB. Since my
application uses only one DB and no transactions, I'm going to just
disable the entire function and recompile.



[2002-10-06 09:58:10] [EMAIL PROTECTED]

What happens is that the mysql connection that gets the problem is
locked up. It won't ever work again.

After a while all of our mysql connections showed the problem making
the site completely unusable. As of v4.2.3 php does a ROLLBACK each
time connection is re-used. ROLLBACKS will give an error if updates
have been done on a MyISAM table, I have removed that query now. Will
see if that solves it.

It looks like all us are running quite many queries per second? I see
the problem on a site running 60+ queries per second.



The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/19529


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Getting Fields from a sql table

[Soheil Shaghaghi]

Hello everyone,
Can someone please tell me how I can do the following:
>From the query below, I want to get the details of the header of the message
and display them on a page, one per line.
If I just query the Header field, it displays them in one long line.
What can I do to display the them one per filed?
sub _converttoHTML {
my $self = shift;
my $string   = shift;

$string =~ s/([^\s\<]+\@[^\s\r\,\;\>]+)/\%lta
href\=\"$self->{_ScriptUrl}?action=mailto&email=$1\"\%gt$1\%lt\/a\%gt/g;

$string =~ s/\&/\&\;/g;
$string =~ s/\/\>\;/g;

$string =~ s/\%lt/\/g;

return $string;
}

This is the code where the haeder gets displayed:
$self->_converttoHTML($self->{_Header}



my $query = "SELECT
EmailID,Header,ToWho,FromWho,EmailFrom,FormattedDate,Subject,Content_Type,Si
zeOf,";
$query
.="Location,NumOfAttachments,Notes,CC,Unread,BCC,SaveCopy,SendHTML,Priority,
Signature FROM EMAILS WHERE ";
$query .="EmailID = $EmailID AND UserID = $UserID";
my $sdb = $self->{_dbobj}->prepare("$query");
$sdb->execute;


while(my($EmailID,$Header,$ToWho,$FromWho,$EmailFrom,$FormattedDate,$Subject
,$Content_Type,$SizeOf,$Location,$NumOfAttachments,$Notes,$CC,$Unread,$BCC,$
SaveCopy,$SendHTML,$Priority,$Signature)=$sdb->fetchrow_array) {
$self->{_EmailID}   = $EmailID;
$self->{_Header}= $Header;
$self->{_ToWho} = $ToWho;
$self->{_FromWho}   = $FromWho;
$self->{_EmailFrom} = $EmailFrom;
$self->{_FormattedDate} = $FormattedDate;
$self->{_Subject}   = $Subject;
$self->{_SizeOf}= $SizeOf;
$self->{_Location}  = $Location;
$self->{_NumOfAttachments}  = $NumOfAttachments;
$self->{_Notes} = $Notes;
$self->{_Content_Type}  = $Content_Type;
$self->{_CC}= $CC;
$self->{_BCC}   = $BCC;
$self->{_SaveCopy}  = $SaveCopy;
$self->{_SendHTML}  = $SendHTML;
$self->{_Unread}= $Unread;
$self->{_Signature} = $Signature;
$self->{_Priority}  = $Priority;
last;
}


The header should look like this:

Return-Path: <[EMAIL PROTECTED]>
Received: from site.com (ns1.site.net [216.188.0.66])
by www.site.com (8.11.1/8.11.1) with ESMTP id g8I2Eir74182
for <[EMAIL PROTECTED]>; Tue, 17 Sep 2002 19:14:44 -0700 (PDT)
(envelope-from [EMAIL PROTECTED])
Received: from servername (adsl-63-207-125-101.dsl.sndg02.pacbell.net
[63.207.125.101])
by site.com (8.9.3/8.9.3) with SMTP id TAA30428
for <[EMAIL PROTECTED]>; Tue, 17 Sep 2002 19:21:36 -0700
Reply-To: <[EMAIL PROTECTED]>
From: "Sender Name" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: test
Date: Tue, 17 Sep 2002 19:16:56 -0700
Message-ID: <[EMAIL PROTECTED]>
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="=_NextPart_000_55F6_01C25E7E.C991C8E0"
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0)
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Importance: Normal
X-UIDL: =hN"!>(@!!Sa]"!Ig~"!


But it looks like this:
Return-Path: <[EMAIL PROTECTED]> Received: from site.com (ns1.site.net
[216.188.0.66]) by www.site.com (8.11.1/8.11.1) with  SMTP id g8I2Eir74182
for <[EMAIL PROTECTED]>; Tue, 17 Sep 2002 19:14:44 -0700 (PDT)
(envelope-from [EMAIL PROTECTED]) Received: from servername
(adsl-63-207-125-101.dsl.sndg02.pacbell.net [63.207.125.101]) by site.com
(8.9.3/8.9.3) with SMTP id TAA30428 for <[EMAIL PROTECTED]>; Tue, 17 Sep 2002
19:21:36 -0700 Reply-To: <[EMAIL PROTECTED]> From: "Sender Name"
[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: test Date: Tue, 17 Sep
2002 19:16:56 -0700 Message-ID:
<[EMAIL PROTECTED]> MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="=_NextPart_000_55F6_01C25E7E.C991C8E0" X-Priority: 3 (Normal)
X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416
(9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Importance: Normal X-UIDL: =hN"!>(@!!Sa]"!Ig~"!



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

thread creation problem

[Philipp Steinkrueger]

Hello,


i have a problem with the mysql database. mysql seems not able
to created ne threads sometimes. the system is running several deamons,
like a webserver and a ftpserver. RAM was short so i added more. now there
are 2 GB RAM available. first, here is the error message:

Can't create a new thread (errno 11). If you are not out of available
memory, you
can consult the manual for a possible OS-dependent bug

here is my system configuration:

debian 3.0
kernel 2.4.19 (high memory enabled)
mysql 3.23.52 (compiled from source)

here is what mysql looks like in the ps-tree (top 3):

root 27041  0.0  0.0  2056  976 pts/5S<   17:43   0:00 /bin/sh
/usr/local/mysql/bin/safe_mysqld --core --err-log=/var/log/mysql/mysql.err -
-datadir=/www/mysql/data --pid-file=/www/mysql/data/www4.pid
mysql27073  0.0  0.3 401804 7268 pts/5   S<   17:43   0:00  \_
/usr/local/mysql-3.23.52-src/libexec/mysqld --basedir=/usr/local/mysql-3.23.
52-src --datadir=/www/mysql/data --user=mysql --pid-file=/www/mysql/data/www
4.pid --skip-locking --core
mysql27075  0.0  0.3 401804 7268 pts/5   S<   17:43   0:00  \_
/usr/local/mysql-3.23.52-src/libexec/mysqld --basedir=/usr/local/mysql-3.23.
52-src --datadir=/www/mysql/data --user=mysql --pid-file=/www/mysql/data/www
4.pid --skip-locking --core

here is the output of `cat /proc/meminfo`:

MemTotal:  2069560 kB
MemFree: 19072 kB
MemShared:   0 kB
Buffers: 74828 kB
Cached:1334320 kB
SwapCached:   1900 kB
Active: 756716 kB
Inactive:   850452 kB
HighTotal: 1179584 kB
HighFree: 3220 kB
LowTotal:   889976 kB
LowFree: 15852 kB
SwapTotal:  384476 kB
SwapFree:   379276 kB


i see that the cached-value is high, but i think this is to be considered as
"free if needed". i am not sure at this, could
someone correct me please if i am worng here.

here is my /etc/my.conf (parts):

skip-locking
port= 3306
socket  = /var/run/mysql/mysql.sock
set-variable= max_connections=400

set-variable= open_files_limit=8129
set-variable= key_buffer=384M
set-variable= max_allowed_packet=5M
set-variable= table_cache=512
set-variable= sort_buffer=2M
set-variable= record_buffer=2M
set-variable= thread_cache=8
set-variable= myisam_sort_buffer_size=64M
server-id   = 1

[isamchk]
set-variable= key_buffer=256M
set-variable= sort_buffer=256M
set-variable= read_buffer=2M
set-variable= write_buffer=2M

[myisamchk]
set-variable= key_buffer=256M
set-variable= sort_buffer=256M
set-variable= read_buffer=2M
set-variable= write_buffer=2M


finally, here is the outout of 'sysctl -a | grep file-max':

fs/file-max = 65536


Do you need anything else ? Sorry if the mail got to long, but i dont
know what you need to help me...


Best Regards and thank you,

Philipp



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Re: DISTINCT and ORDER BY

[Victoria Reznichenko]

Marc,
Saturday, October 05, 2002, 9:59:57 PM, you wrote:

> It seems that ORDER BY interferes with DISTINCT when
> I
> use the 2 in the same statement. When I append order
> by to the end of a MySQL statement, I get all the
> matches instead of the distinct ones. Is this normal
> behavior?

Could you provide SELECT statement?


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: sql syntax help

[Victoria Reznichenko]

Scott,
Saturday, October 05, 2002, 7:45:16 AM, you wrote:

SJ> I have a db with slightly over 614,000 records of names and addresses.  In
SJ> the address column, there are quite a few records like

SJ> "123 any rd # 2"
SJ> "319 w. 1st st # B"
SJ> "4321 test blvd # 42"
SJ> etc

SJ> I want to replace all the number signs with the actual word 'number'.

SJ> Is there a SQL command I can use for this or do I need the help of a
SJ> scripting language (php or vb)?

SJ> I was trying to construct something like "update into table.column select
SJ> where column like '%#%' replace with '%number%'"

SJ> but of course that is not going to work.  I am a SQL newb btw.

Take a look at string function REPLACE():
 http://www.mysql.com/doc/en/String_functions.html


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: SELECT...LIKE... bug with cyrillic

[Egor Egorov]

Dimo,
Friday, October 04, 2002, 6:26:16 PM, you wrote:

>Description:
DV>  I have a table with columns containing
DV> keywords in cyrillic. If I write i.e.
DV> select * from imgs where kw_1 like '%xx%'
DV> (xx are two cyrillic letters and kw_1 is the first
DV> keyword-column. The table contains 2666 rows.)
DV> MySQL returns a lot of words(396 rows) and all of them
DV> do not contain xx.

[skip]

What character set is set in MySQL?



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Problems with LOAD DATA LOCAL INFILE

[Egor Egorov]

Sorin,
Saturday, October 05, 2002, 8:33:23 AM, you wrote:

SC> 1)Is it possible to enable LOAD DATA LOCAL INFILE from the configuration
SC> file?
SC> My.ini file is below:

SC> [mysqld]
SC> basedir=C:/mysql
SC> datadir=C:/mysql/data
SC> enable-local-infile
SC> local_infile=1

SC> When I perform the LOAD DATA LOCAL INFILE 'file_name.txt' INTO... command
SC> from a client application using MyOBDC I receive the error message 1148
SC> ('The used command is not allowed with this MySQL version').

SC> Where is the mistake?

Add local-infile=1 in the [mysql] section, too.

SC> The server version is 4.0.2.-alpha.

SC> 2)Other problems appears when I use the 3.23.47 My SQL version.

SC> 2.1.
SC> In that case LOAD DATA LOCAL INFILE 'file_name.txt' INTO... works but
SC> 'file_name.txt' is
SC> loaded just if it reside on the server. But notice that I want to load the
SC> file ('file_name.txt') from the client machine.
SC> Again, what is wrong?

Hm ..
It's strange. I tested it on 3.23.52 and it worked as expected.

SC> 2.2.
SC> I tried another approach for this problem and I have performed from the
SC> client machine a SELECT * FROM... INTO OUTFILE 'file_name.txt' command. Now,
SC> everything goes well and LOAD DATA LOCAL INFILE 'file_name.txt' INTO...
SC> works fine. It seems my troubles are finished, but... If I run again the
SC> same command, another new file with the same name cannot be created (because
SC> 'file_name.txt' already exists). How can I remove the older 'file_name.txt',
SC> doing this from the client side and using MyODBC?

No, you can't do it with MySQL.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: table limitations

[Egor Egorov]

Kip,
Sunday, October 06, 2002, 11:20:25 PM, you wrote:

KK> Mysql -  how many tables will it handle?

KK> I currently have no access to docs, so forgive me as I'm sure it is
KK> documented.

The only limitation is how many files can be stored in the directory.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Unicode Support with MySQL

[Victoria Reznichenko]

Schmid,
Monday, October 07, 2002, 10:23:52 AM, you wrote:

SM> we are very interested in using MySQL with our machines, but we need a full
SM> Unicode-support with the database.
SM> Can you give us information's about the time, when MySQL will com with a
SM> full Unicode Support?

Unicode support will be implemented in 4.1


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Re: Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (111)

[Egor Egorov]

Edwin,
Monday, October 07, 2002, 1:09:37 PM, you wrote:

>>>On Monday 07 October 2002 12:04, Edwin Raj wrote:
>>>
When I type mysql in the command prompt it is giving the error "ERROR
2002: Can't connect to local MySql server through socket
'/var/lib/mysql/mysql.sock' (111)"
There is no file mysql.sock at that location???

>>>Exactly.
>>>
What is the problem amd what should I do to make it run? I didn't
install MySql on my own and it was a default built on the OS installation.

>>>I don't know your installation in details, but I assume it is probably
>>>configured for TCP/IP connections only, so you would need the -h option.
>>>
>>
>>Unfortunately, all of your advice is probably not germane to the problem.  Does the 
>file "/tmp/mysql.sock" exist?  If so, the
>>easiest thing to do is to "ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock".
>>
ER> Thanks for the inputs.

ER> There is no file /tmp/mysql.sock to link. In fact what is more bothering 
ER> me is the file [EMAIL PROTECTED] . 
ER> This is not found in the path /var/lib/mysql. Is it OK?
ER> And also when I boot my system the mysql daemon starts but immediately 
ER> it ends up.

MySQL server is not running, that why you get error "can't connect .."

ER> Does any one have a guess of what's wrong. I am also going
ER> to post this to a linux group, may be I think that wud be the right 
ER> place for this kinda of problem (not sure either)

Take a look into MySQL data dir, you can find .err there.
Is there any causes of failed start in the error log?



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: mysql can't connect to the localhost

[Egor Egorov]

junhuazhu,
Monday, October 07, 2002, 4:54:35 AM, you wrote:

ja3dn> After I used the comment "mysqld",I used the "mysqladmin ping" comment,then the 
following infomations appeard(c:\mysql):
ja3dn> mysqladmin: connect to server at 'localhost' failed 
ja3dn> error: 'Can't connect to MySQL server on 'localhost' (10061)' 
ja3dn> Check that mysqld is running on localhost and that the port is 3306. 
ja3dn> You can check this by doing 'telnet localhost 3306'

So? Is MySQL server running?



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Initial Connection

[Victoria Reznichenko]

Cohan,
Monday, October 07, 2002, 5:13:39 PM, you wrote:

CS> How do I initially connect to mysql on linux.   I've successfully installed
CS> from the rpm and the daemon is up and running.  If I try to connect to root
CS> without a password, I get the following message:

CS> error: 'Access denied for user: root@localhost (Using password: NO)'

CS> Is there a password for root initially?  How do I set if it I can't connect?

No, 'root' doesn't have a password initially. Did you have MySQL
server installed before or you install it at first?


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Question

[Egor Egorov]

Andrej,
Monday, October 07, 2002, 2:51:29 PM, you wrote:

AF> May name is Andrej and I'm from Slovenia. I downloaded and tried  mysqlGui
AF> program. I have one question. Tell me please how to create a new table in this
AF> program. I select Create table in menu, but the program do nothing. Maybe I do
AF> something wrong.

"Create tables" does nothing in MySQLGUI. MySQLGUI currently is not
under development. Take a look at MyCC:
  http://www.mysql.com/downloads/gui-mycc.html



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Re: show tables .question

[Victoria Reznichenko]

Kip,
Monday, October 07, 2002, 4:03:05 AM, you wrote:

KK> Is it possible to do a "show tables" similar to a select statement
KK> where ...

KK> similar to: select field where anotherfield like "ABC%" gives matches
KK> for all "field" which begins with ABC

KK> I'd like to say 

KK> show tables like "ABC%"

KK> ie.  to get a list of all tables whose name begins with ABC.

Yes, you can do it exactly as you wrote above:
 http://www.mysql.com/doc/en/SHOW.html


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Not inserting into MySQL table and not showing any error msgs

[Victoria Reznichenko]

Fabiana,
Monday, October 07, 2002, 1:51:06 AM, you wrote:

FMPdA> I'm trying to insert some data into a MySQL table and I'm just not getting
FMPdA> it to work. It's not a problem with the connection with the database because
FMPdA> I get to SELECT and show the data, but when I try to INSERT or UPDATE any
FMPdA> record, nothing happens...The weird thing is that it doesn't appear any
FMPdA> error message and it looks like everything is ok, but when I check to see if
FMPdA> the data was changed, it's not.

FMPdA> Does anyone have a clue about what could be happening?
FMPdA> Is there a security or permission issue?

FMPdA> I've created a user with all the fields set to 'Y' in the users mysql's
FMPdA> table.

Did you INSERT/UPDATE table from mysql command-line client?
What are your INSERT/UPDATE queries?


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Server comparison running Mysql

[gerald_clark]

You don't give operating system versions for the two machines.

James Riordon wrote:

> Hi,
>
> I have two servers.
>
> Server A:
> Dual 1GHz processors
> 1GB of RAM
> MySQL-Max 3.23.49a
> PHP 4.2.1
>
> Server B:
> Single 1.7GHz processors
> 1.5GB of RAM
> MySQL-Max 3.23.49a
> PHP 4.2.2
>
> Server A has a site that uses about 75GB of bandwidth per month 
> all pulled through PHP and MySQL. Load average is 0.4 over time. 
> Processlist is never above 2-5 process showing at a time. All in all a 
> very nice server.
>
> When I switch the site to Server B - same database, same program, 
> same my.cnf, my load average on Server B jumps to 25-35, the process 
> list jumps to 30-50 processes, the server comes to a grinding hault 
> and then sits there, all within 30-60 seconds of redirecting the site.
>



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Innodb - row locks?

[Eric]

>Hi,
>
>I was just wondering. Is it a common issue to have problems with INSERTS or
>UPDATES that have not been commited stick(not commit ) even though the
>connection gets killed? The thing is autocommit is on. But I still am
>getting this kind of behavior from scripts that are not persistent.
>I figured I needed to autocommit  = 0 and commit explicitly. But I just
>wanted to see if that made sense.

sql,query,mysql arrgghh


>Thanks,
>
>Eric
>
>http://www.kwinternet.com/eric
>(250) 655 - 9513 (PST Time Zone)
>
>"Inquiry is fatal to certainty." -- Will Durant


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Full-text search and extended characters

[Josh Santangelo]

I'm working on an application that uses the MySQL full-text search to search
for words in pre-existing content. This content can and does contain HTML
entities like "ö".

At least in my setup, if I place words like "mögliche" in an AGAINST()
clause, incorrect results are returned. For example:

SELECT title, datetime,  MATCH(title, strippedtext) AGAINST('mögliche')
AS `mö_3B_gliche` FROM content ORDER BY MATCH(title, strippedtext)
AGAINST('mögliche') DESC LIMIT 2;
++-+--+
| title  | datetime| mö_3B_gliche |
++-+--+
| 9-5| 2002-10-04 08:08:31 |  5.8614664130118 |
| Trauer | 2001-11-27 04:03:42 |  2.2698967450068 |
++-+--+

The strippedtext field for the first row contains "mögliche" and is
properly returned as the first result. The second row does not contain
"mögliche" at all, and seems like it should have a relevancy of zero.

Is there a solution for this, or do I need to be searching only with the
actual "ö" character instead?

Thanks,
-josh




-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: sql syntax help

[Brent Baisley]

You almost got it. Your syntax will be something like this:
UPDATE Table SET address=REPLACE(address,'#','Number') WHERE column 
like"%#%"

When I am trying to figure out the syntax for something, I always add a 
LIMIT 1 at the end so that only one record gets changed.

On Saturday, October 5, 2002, at 12:45 AM, Scott Johnson wrote:

> I have a db with slightly over 614,000 records of names and addresses.  
> In
> the address column, there are quite a few records like
>
> "123 any rd # 2"
> "319 w. 1st st # B"
> "4321 test blvd # 42"
> etc
>
> I want to replace all the number signs with the actual word 'number'.
>
> Is there a SQL command I can use for this or do I need the help of a
> scripting language (php or vb)?
>
> I was trying to construct something like "update into table.column 
> select
> where column like '%#%' replace with '%number%'"
>
> but of course that is not going to work.  I am a SQL newb btw.
>
> Any help appreciated.
>
> Thanks
>
> Scott
>
> -
> 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]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: A little hair-pulling can be a "good thing" (or not)

[gerald_clark]

Check youry my.cnf file.

You have the temp directory set to /root/tmp instead of /tmp.
If this is not the case, add an entry to redefine the temp directory.

Bob Nelson wrote:

>I'm encountering a situation with MySQL that's really driving me crazy and I
>have been unable to locate a solution.  I'm hoping that someone on the
>mailing list can provide some guidance...
>
>I'm attempting to use a piece of php software (phpBB) which is talking to a
>dedicated MySQL server via TCP.  The MySQL install is the Mandrake 8.2
>default (3.23.47).
>
>Okay, here's the error I receive using their debug mode...
>
>Couldn't obtain forum list
>DEBUG MODE 
>SQL Error : 1 Can't create/write to file '/root/tmp/#sql1f77_259_0.MYI'
>(Errcode: 13) 
>SELECT f.* FROM phpbb_forums f, phpbb_categories c WHERE c.cat_id = f.cat_id
>ORDER BY c.cat_order ASC, f.forum_order ASC
>Line : 166 
>File : /var/www/html/phpBB2/admin/admin_forumauth.php
>  
>



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

FW: Initial Connection

[Cohan, Sean]

Nevermind.  I just had to use root's OS password.

-Original Message-
From: Cohan, Sean [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 10:14 AM
To: MySql (E-mail)
Subject: Initial Connection


How do I initially connect to mysql on linux.   I've successfully installed
from the rpm and the daemon is up and running.  If I try to connect to root
without a password, I get the following message:

error: 'Access denied for user: root@localhost (Using password: NO)'



Is there a password for root initially?  How do I set if it I can't connect?

Thanks.

-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Truncated Text data Type

[gerald_clark]

The file must reside on the SERVER in a directory accessible to the
user 'mysql'.

Oswaldo Castro wrote:

>Hi List,
>
>I am new to mysql so I ask for your patience...
>
>1 - I am trying to load a text file (with mysql-front) to a table that
>contains a TEXTdata type field. Despite of the documentation (TEXT = 2^16
>bytes), after the load of the file that field is truncate to 51 characters.
>On the text file I have some entries with more than 800 characters.
>
>2 - I am trying to load the same file but now with LOAD DATA INFILE at a
>term session. I am connect as root, I call mysql but when I execute the
>command, I receive an Permission Denied Error (13) saying that I cannot stat
>the text file. I tried to change the owner and the permissions of the file
>but nothing works.
>
>Could someone help me?
>
>Thanks in advance
>
>Oswaldo Castro
>
>  
>


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

HA of MySQL

[Jeremy Tinley]

Howdy,

There has been some interest lately in HA of MySQL services both in my
company and on the list.  A few of us here sat down on Friday (at 5PM no
less) and started hashing out the details of providing such a service.
Following several possible approaches, we ran into major stumbling
blocks on each path.

The Setup:
One master database, 5 slave databases.  The end application are Perl
CGIs connecting to DNS CNAMES (db1, db2, db3, etc).  I started by
demonstrating the application of slaves in an LVS
(http://www.linuxvirtualserver.org) cluster.  This proved to be very
successful.  I was able to build a cluster of slaves, load balancing the
queries among them, weighting them differently and having ones removed
from the cluster by shutting down MySQL.  The goal then is to point
queries to web-db, which is a cluster of 2 or 3 slaves.

The next step is to use heartbeat (http://www.linux-ha.org) to do IP
address takeover of the master in the event of a failure.  This is where
it gets tricky. One of the slaves will be designated the master
failover. Upon detection of a master failure, the program...

1) Runs a SLAVE STOP on the failover slave
2) Runs a script to enable writes to the slave tables
3) Removes itself from the cluster
4) Takes over the IP address of the master

The problem then lies in how to miss as few inserts queries as possible.
The easiest solution is to start the binlog on the failover slave as
soon as it becomes the master.  As a downfall, some writes to the master
will be lost, possibly forever with a disk failure (but disk failure is
a scenario you can't always prepare for at a software level).

What happens if other slaves in the cluster are "very far" behind,
possibly due to long reporting queries. If the master goes down, these
would have to rely on the new master to catch up, however, the new
master has no binlog information resulting in wildly out of sync data.

In order to provide true data redundancy, the binlog position would have
to be identical to that of the master to retain the same filename and
position.  That's not an easy feat to accomplish.  If you bring the
slave down, the master down, the slave up, then the master up, you
should get binlogs that match, but I can't confirm this yet.

So, I put it to the list.  Am I missing the obvious here?  How do YOU
achieve a failover master?

-J




-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Recommended Books

[David Lloyd]

Actually, I'd suggest the New Riders Book by Paul DuBois, "Mysql"...what
was it you wanted to achieve with your book:

* do you want a reference
* a tutorial

...?

mysql,query

DSL

-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: bug report

[Mark Matthews]

Quasimodo wrote:

>This occured while using phpmyadmin 2.3.0-rc4:
>
>
>You seem to have found a bug in the SQL parser.
>Please submit a bug report with the data chunk below:
>--BEGIN CUT--
>JElkOiBzcWxwYXJzZXIubGliLnBocCx2IDEuMTUgMjAwMi8wNy8yNiAxODozMDo1OSBsZW05
>[snip]
>
This is reporting a bug in phpMyAdmin's SQL parser, not MySQL's. You 
need to file this bug report at phpMyAdmin's sourceforge bug page:

http://sourceforge.net/tracker/?group_id=23067&atid=377408

-Mark

-- 
For technical support contracts, visit https://order.mysql.com/?ref=mmma

__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /  Mark Matthews <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
 /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Protecting CC Numbers

[Michael T. Babcock]

Hack Hawk wrote:


>> This implies hard-coding a private key and password somewhere on your 
>> system.  This type of system (IMO) should NEVER be connected to the 
>> Internet.  
>  
>

Agreed and doubly agreed.  In fact, I'd say you should never save a CC # 
in your database _ever_ unless you're doing routine billing to it from 
accounting software.  If you just want to 'remember' the user's CC # so 
they don't have to type it back in then don't -- point out on the 
website that that would be a security risk and for their own safety, 
you'd like them to re-enter the card # every time they make a purchase.


>> NEVER under any circumstances should you "permanently" store CC's 
>> (even encrypted) on systems that are connected to the Internet.
>  
>

Agreed.


>> I say 2 to 3 days max before archiving them off-line (off-Internet).  
>> This minimizes the risk if a hacker should happen to break in.
>  
>

Or seconds ... 2 or 3 days is a long time in hacked-time; set up a 
write-only encrypted pipe to send the cards (if indeed you must store 
them) to a database which can only be read from locally and doesn't 
allow any form of login or connection from the webserver machine except 
the write-only db connection.

Stupid SQL spam filter ... 

-- 
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Initial Connection

[Cohan, Sean]

How do I initially connect to mysql on linux.   I've successfully installed
from the rpm and the daemon is up and running.  If I try to connect to root
without a password, I get the following message:

error: 'Access denied for user: root@localhost (Using password: NO)'



Is there a password for root initially?  How do I set if it I can't connect?

Thanks.

-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Performance Question

[Antoine]

> I am writing a serverside application in Java which needs to query/search
> 200 000 rows and update affected records once every 2 minutes.
> As performance/speed is of importance here -  and this Table only contains
> 5-10 Columns of Integer numbers, I figured that using a HEAP type of table
> would be the fastest.. (right?)
> The imaginary system this will run on, is a Dual CPU P4/1,5Ghz or similar
> with 2Gb RAM.

Really, you will have no problem with that kind of workload. Just keep
MyISAM (the default) and it's ok. You should of course tune MySQL a little
(with 2 GB Ram you can set at least 256 MB for key_buffer_size, which
is the most important setting). Keep in mind that MySQL doesn't cache the
data by itself, it just uses the filesystem cache, so don't fill all of
your RAM with the other apps. Run "top" from time to time, and check that
"cached" memory is fairly used ; on my MySQL server with 2 GB RAM, the
cached memory is currently ~800 MB (but my database is bigger than yours
;-PP).

And don't forget to run EXPLAIN on your queries to check they use indexes
correctly ;-))

However, given the figures you told us, I don't think you should worry
very much





-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

bug report

[Quasimodo]

This occured while using phpmyadmin 2.3.0-rc4:


You seem to have found a bug in the SQL parser.
Please submit a bug report with the data chunk below:
--BEGIN CUT--
JElkOiBzcWxwYXJzZXIubGliLnBocCx2IDEuMTUgMjAwMi8wNy8yNiAxODozMDo1OSBsZW05
IEV4
cCAkPGJyIC8+CldoeSBkaWQgd2UgZ2V0IGhlcmU/IDE0MiAxNDMgMTkzMTxiciAvPgpMZWZ0
b3Zl
cjog3zxiciAvPgpBOiAxNDIgMTQzPGJyIC8+ClNRTDogQ1JFQVRFIFRBQkxFIGRkcF9rdW5k
ZW4g
KA0KICBLdW5kZW5udW1tZXIgbWVkaXVtaW50KDUpIE5PVCBOVUxMIGRlZmF1bHQgJzAnLA0K
ICBG
aXJtYSB0ZXh0IE5PVCBOVUxMLA0KICBBbnNwcmVjaHBhcnRuZXIgdGV4dCBOT1QgTlVMTCwN
CiAg
U3RyYd9lIHRleHQgTk9UIE5VTEwsDQogIFBMWiBpbnQoNSkgTk9UIE5VTEwgZGVmYXVsdCAn
MCcs
DQogIE9ydCB0ZXh0IE5PVCBOVUxMLA0KICBUZWxlZm9uIHRleHQgTk9UIE5VTEwsDQogIEZh
eCB0
ZXh0IE5PVCBOVUxMLA0KICBlTWFpbCB0ZXh0IE5PVCBOVUxMLA0KICBIb21lcGFnZSB0ZXh0
IE5P
VCBOVUxMLA0KICBQYXNzd29ydCB2YXJjaGFyKDI4KSBOT1QgTlVMTCBkZWZhdWx0ICcnLA0K
ICBQ
UklNQVJZIEtFWSAgKEt1bmRlbm51bW1lcikNCikgVFlQRT1NeUlTQU07DQoNCiMNCiMgRGF0
ZW4g
ZvxyIFRhYmVsbGUgYGRkcF9rdW5kZW5gDQojDQoNCklOU0VSVCBJTlRPIGRkcF9rdW5kZW4g
VkFM
VUVTICg0ODI3OSwgJ0p1Z2VuZG5ldHogQmFkZW4tV/xydHRlbWJlcmcnLCAnSm9oYW5uZXMg
R2ll
bmdlcicsICdNYWxlcmJ1Y2tlbCA4JywgNzEyNjMsICdXZWlsIGRlciBTdGFkdCcsICcwNzAz
MyAv
IDEzODczNycsICcnLCAnaW50ZXJuYXRpb25hbEBqdWdlbmRuZXR6LmRlJywgJ2h0dHA6Ly93
d3cu
aW50ZXJuYXRpb25hbC5qdWdlbmRuZXR6LmRlJywgJycpOw0KSU5TRVJUIElOVE8gZGRwX2t1
bmRl
biBWQUxVRVMgKDU0ODk3LCAnSnVnZW5kYWdlbnR1ciBDYWx3JywgJ1dvbGZnYW5nIEJvcmtl
bnN0
ZWluJywgJ1ZvZ3RlaXN0cmHfZSA0NCcsIDc1MzY1LCAnQ2FsdycsICcwNzA1MSAvIDE2MC00
Nzcn
LCAnMDcwNTEgLyA3OTUtNDc3JywgJzQzLkJvcmtlbnN0ZWluQGtyZWlzLWNhbHcuZGUnLCAn
aHR0
cDovL3d3dy5qdWdlbmRhZ2VudHVyLWNhbHcuZGUnLCAnJyk7DQpJTlNFUlQgSU5UTyBkZHBf
a3Vu
ZGVuIFZBTFVFUyAoMjQ2NTUsICdNVFMtSGFuZHlzaG9wJywgJ1R1bmNheSBH9mtz/Gf8cics
ICdF
dWdlbi1aZXloZXItU3RyYd9lIDEnLCA3NTM4MiwgJ0FsdGhlbmdzdGV0dCcsICcwNzA1MSAv
IDc5
OTc3MFxyXG4nLCAnMDcwNTEgLyA3OTk3NzJcclxuJywgJ2luZm9AbXRzLWhhbmR5c2hvcC5k
ZScs
ICdodHRwOi8vd3d3Lm10cy1oYW5keXNob3AuZGUnLCAnJyk7DQpJTlNFUlQgSU5UTyBkZHBf
a3Vu
ZGVuIFZBTFVFUyAoOTQ2NTMsICdWZXJzaWNoZXJ1bmdzbWFrbGVyIEJvcm5zY2hlaW4nLCAn
Jywg
J0hlaWRld2VnIDMnLCA3NTM3OCwgJ0JhZCBMaWViZW56ZWxsIC0gVUgnLCAnMDcwNTIgLyA1
NDcw
JywgJzA3MDUyIC8gNTQ3OVxyXG4nLCAnJywgJ2h0dHA6Ly93d3cuYm9ybnNjaGVpbi5kZScs
ICcn
KTsNCklOU0VSVCBJTlRPIGRkcF9rdW5kZW4gVkFMVUVTICgzNzg5NywgJ0ludGVybmF0aW9u
YWxl
cyBGb3J1bSBCdXJnIExpZWJlbnplbGwnLCAnR2VydHJ1ZCBHYW5kZW5iZXJnZXInLCAnUG9z
dGZh
Y2ggMTIyOCcsIDc1Mzc4LCAnQmFkIExpZWJlbnplbGwnLCAnMDcwNTIgLyA5MjQ1LTI0Jywg
JzA3
MDUyIC8gOTI0NS0xOCcsICdnYW5kZW5iZXJnZXJASW50ZXJuYXRpb25hbGVzRm9ydW0uZGUn
LCAn
aHR0cDovL3d3dy5pbnRlcm5hdGlvbmFsZXNmb3J1bS5kZScsICcnKTsNCklOU0VSVCBJTlRP
IGRk
cF9rdW5kZW4gVkFMVUVTICg2NTE0OCwgJ1NjaG1pZGjkdXNsZXIgLSBDb21wdXRlcnNlcnZp
Y2Ug
JiBXZXJiZXRlY2huaWsnLCAnR/xudGhlciBTY2htaWRo5HVzbGVyJywgJ1Bvc3RmYWNoIDEz
NDYn
LCA3MzA1MCwgJ0Vpc2xpbmdlbicsICcwNzE2MSAvIDgyMTUzNicsICcwNzE2MSAvIDgyMTUz
NyAn
LCAnaW5mb0BzY2htaWRoYWV1c2xlci5kZScsICdodHRwOi8vd3d3LnNjaG1pZGhhZXVzbGVy
LmRl
JywgJycpOw0KSU5TRVJUIElOVE8gZGRwX2t1bmRlbiBWQUxVRVMgKDEsICcnLCAnJywgJycs
IDAs
ICcnLCAnJywgJycsICcnLCAnJywgJzEnKTs=
---END CUT---


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Kylux

[Silmara]

I need use MySql to Linux ( Connectiva 7 )and Kylux.

What version of the MySQL?
Do I need MyODBC?


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

The secure mode in InnoDB

[Dyego Souza do Carmo]

what is the major secure mode to use innodb ? ( min time to write data
in disk )

innodb_flush_log_at_trx_commit=0 ?
or

innodb_flush_log_at_trx_commit=1 ?

or

innodb_flush_log_at_trx_commit=2 ?

My System is MySQL/InnoDB 3.23.52 running in windows 2000 Server and
linux 2.4 ( with ReiserFS ) :D





-
  ++  Dyego Souza do Carmo   ++   Dep. Desenvolvimento   
-
 E S C R I B A   I N F O R M A T I C A
-
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
-- 
$ look into "my eyes"
look: cannot open my eyes
-
   Reply: [EMAIL PROTECTED]


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

evaluation

[robert_goetz]

hi!
i am a trainee at westlb-systems in duesseldorf, germany and it's my task
to evaluate different dbms' like Postgre SQL, MySQL, MS Access ´97 ;), SAP
DB and Oracle
well i searched the web and various documentations but i'm not really sure
if all of this is still correct or if i may have misunderstood some things
so i'd like to ask you if you could help me...
i think it will only take 5 or 10 minutes for you guys to send me some
_brief_ information about the following aspects concerning MySQL:

- SQL Standards
- Support: ODBC, JDBC, API's?
- Portation (is it possible to transport data and how and to which other
databases?)
- Administration Tools
- Native Tools
- Licences/Prices
- Support
- System's Requirements / Required Ressources
- Operation Systems (Unix/Linux, Windows,...)
- Documentation
- Limits / Restrictions
- Performance (pretty hard to find something about that...)
- Connection to other DB-Systems (Import/Export)
- Cluster - Ability ?
- Languages
- Backup Possibilities
- Internet - Ability ?

well i'd be really glad if someone could help me with this exhausting
task... within the next 2 or 3 days would be awesome...

Mit freundlichen Grüßen / Best Regards

Robert Goetz
WestLB Systems
EMail: [EMAIL PROTECTED]






Diese Nachricht ist vertraulich. Sie ist ausschliesslich fuer
den im Adressfeld ausgewiesenen Adressaten bestimmt.
Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten
wir um eine kurze Nachricht. Jede unbefugte Weiterleitung
oder Fertigung einer Kopie ist unzulaessig. Da wir nicht die
Echtheit oder Vollstaendigkeit der in dieser Nachricht
enthaltenen Informationen garantieren koennen, schliessen wir
die rechtliche Verbindlichkeit der vorstehenden Erklaerungen
und Aeusserungen aus. Wir verweisen in diesem Zusammenhang
auch auf die  fuer die Bank geltenden Regelungen ueber die
Verbindlichkeit von Willenserklaerungen mit verpflichtendem
Inhalt, die in den bankueblichen Unterschriftenverzeichnissen
bekannt gemacht werden.
 
This message is confidential and may be privileged. It is
intended solely for the named  addressee. If you are not the
intended recipient please inform us. Any unauthorised
dissemination, distribution or copying hereof is prohibited.
As we cannot guarantee the  genuineness or completeness of
the information contained in this message, the statements
set forth above are not legally binding. In connection
therewith, we also refer to the governing regulations of
WestLB concerning signatory authority published in the
standard bank signature lists with regard to the legally
binding effect of statements made with the intent to
obligate WestLB.


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Recommended Books

[Peter Brawley]

For now, Joe Celko, "SQL for Smarties".

But stay tuned :-).

-

- Original Message -
From: "Curley, Thomas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 07, 2002 5:28 AM
Subject: Recommended Books


Hi,

Any anyone have recommendations on MySql books currently in print.  What's
the best or is the online manual all that's needed !

Thomas

-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php






-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Recommended Books

[Curley, Thomas]

Hi,

Any anyone have recommendations on MySql books currently in print.  What's the best or 
is the online manual all that's needed !

Thomas

-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Question

[Andrej Felbar]

Hello,
May name is Andrej and I'm from Slovenia. I downloaded and tried  mysqlGui
program. I have one question. Tell me please how to create a new table in this
program. I select Create table in menu, but the program do nothing. Maybe I do
something wrong.

Thank you in advance,

Andrej



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

ÖйúÕÐÉÌÒý×ÊÍø£º×£¹úÇì½Ú¿ìÀÖ£¡

[zsyz]

ÖйúÕÐÉÌÒý×ÊÍøΪÄúÀ©´óÕÐÉÌ£¡








  

  
 
  http://www.china-138.com"; target="_blank">http://www.china-138.com/images/cn/zsyz.gif"; width="120" height="60" 
border="0">
   

   ÖйúÕÐÉÌÒý×ÊÍø·þÎñÖÐÐÄ
  

  
  
  
  
 
   
 
  ¹ØÓÚ·¢²¼"ÕÐÉÌÐÅÏ¢¡¢ÕбêÏîÄ¿"µÄ
ÌØ ±ð ͨ Öª
  ¹óµ¥Î»¸ºÔðÈË£º
ÄúºÃ£¡
¡¡ÖйúÕÐÉÌÒý×ÊÍø£¨http://www.China-138.com"; target="_blank" 
class="hei">www.China-138.com£©£¬ÊÇ·þÎñÓÚÖйú¸÷µØÕÐÉÌÒý×Ê¡¢Õ÷ÕÐÈ«¹ú´úÀí¼°µØÇø´úÀí¡¢¾­¼Ã¿ª·¢¡¢ÏîÄ¿·þÎñ¡¢ÐÅÏ¢ÍƼöµÄ´óÐÍרҵÍøÕ¾¡£ÎªÖйú¸÷µØÆóÒµ¡¢µ¥Î»¡¢¹«Ë¾¡¢³§ÉÌÒÔ¼°¸÷¼¶ÕÐÉ̲¿ÃÅ£¬¿ª·¢Çø£¬ÆóÒµµÈÌṩÐÅÏ¢Ðû´«¡¢ÍƹãºÏ×÷¡¢ÏîÄ¿ÕÐÉ̵È×ۺϷþÎñ¡£
 


¡¡ÖйúÕÐÉÌÒý×ÊÍø½«Óë¹ú¼ÒÍ⾭󲿡¢ÖÐÍ⾭óͶ×ʺÏ×÷ÖÐÐÄÁªºÏÍƳö¶àÏîרҵ·þÎñ£¬Èȳϻ¶Ó­¸÷µØÆóÒµ¡¢¹«Ë¾¼°¿ª·¢ÇøµÈ»ý¼«²ÎÓ룬ÌṩÐÅÏ¢£¬ÒԱ㼰ʱ·¢²¼¡¢ÍƼö£¬´Ó¶ø»ñµÃ¸ü¶àÆóÒµµ¥Î»¡¢Í¶×ÊÉ̼ҵĹØ×¢¡£
¡¡¹óµ¥Î»µÄÕÐÉÌ/ºÏ×÷/ÏîÄ¿µÈÐÅÏ¢£¬ÎÒÃǼƻ®ÔÚ"ÖйúÕÐÉÌÒý×ÊÍø"Ö÷ҳΪÄú·¢²¼£¬Ïò¸÷µØÇøÕë¶ÔÐÔÍƼö£¬¼ÓÇ¿Ðû´«£¬À©´óÕÐÉÌ¡£Ä¿Ç°ÔÚÈ«¹ú¸÷µØÇø£¬Ã¿ÌìÓнüÁ½ÍòÉ̼ҹØ×¢ÖйúÕÐÉÌÒý×ÊÍøµÄÐÅÏ¢¡£±±¾©Êи߿Ƽ¼Ãܼ¯²úÒµÇø--Öйش庣µíÇøÕþ¸®¡¢º¼ÖÝ¡¢ÄϾ©µÈ¸÷µØÒÑίÍÐÖйúÕÐÉÌÒý×ÊÍøÕÐÉÌÐû´«£¬¡¶ÈËÃñÈÕ±¨¡·º£Íâ°æ¡¢¹úÎñÔº¹Ù·½ÍøÕ¾¡¢ÖйúÍâÉÌͶ×ÊÆóҵЭ»á¡¢ÊÀ½çÈÕ±¨¡¢º£Íâ×î´óÖÐÎÄýÌ塶»ªÉù±¨¡·£¬Ö÷Á¦ÍƼöÖйúÕÐÉÌÒý×ÊÍø£¬²¢×÷ÖصãÁ¬½Ó¡£ÖйúÕÐÉÌÒý×ÊÍøΪµ±µØµÄÕÐÉÌÐû´«¡¢ÏîÄ¿ºÏ×÷µÈµÈÆðµ½Á˾޴óµÄ´Ù½ø×÷Óá£
  ÖйúÕÐÉÌÒý×ÊÍø 
·þÎñÄÚÈݼò½éÈçÏ£º
¡ï 
ÔÚÖйúÕÐÉÌÒý×ÊÍø.Ê×Ò³£¬·¢²¼ÐÅÏ¢Ðû´«¡¢¹ã¸æÍƼö£¬
¡¡ ·¢²¼·þÎñ·Ñ2000Ôª/Ô£¬1Ôª/°ëÄê¡£
¡ï ÔÚÖйúÕÐÉÌÒý×ÊÍø.Ê×Ò³£¬¿¯µÇͼ±ê¡¢¶¯»­Ðû´«ÍƼö£¬
¡¡ ·¢²¼·þÎñ·Ñ3000Ôª/Ô£¬15000Ôª/°ëÄê¡£
¡ï 
ÐèÒª½¨ÉèÍøÕ¾µÄµØÇø¡¢ÆóÒµ¡¢¹«Ë¾£¬Î¯ÍÐÖйúÕÐÉÌÒý×ÊÍø½¨Éè×Ô¼ºµÄÍøÕ¾£¬
¡¡ ÕûÌ彨վ·þÎñ6000Ôª¡£ 
¡ï ¹úÄÚµ±µØµÄÕÐÉÌ/Õþ¸®/¿ª·¢ÇøÍøÕ¾Á¬½ÓÍƼö£¬
¡¡ Ö÷Ò³±êÌ⿯µÇ1000Ôª/Ô£¬Í¼±êÍƼö3000Ôª/Ô¡£
 
¡¡»¶Ó­ÉÐ佨ÉèÍøÕ¾µÄµØÇøºÍÆóÒµ£¬Î¯ÍÐÖйúÕÐÉÌÒý×ÊÍø½¨Éè¹óµ¥Î»×Ô¼ºµÄÍøÕ¾¡£ 

¡¡ÖйúÕÐÉÌÒý×ÊÍø£¨http://www.China-138.com"; target="_blank" 
class="hei">www.China-138.com£©£¬1999ÄêÒѵõ½¹ú¼ÒÕýʽÅú×¼£¨Åú×¼ºÅ£º¾©ICP010418ºÅ£©¡£ÔÚ¹úÄÚÍâÿÌì¹Ì¶¨ÓÐÊýÒÔÍò¼ÆÉ̼ҵĹØ×¢£¬2000Äê»ñµÃÊÀ½ç»ªÈ˽»Á÷Э»áµÄÈ«ÇòÍƼö¡£
 

¡¡ÖйúÕÐÉÌÒý×ÊÍø£¨http://www.China-138.com"; target="_blank" 
class="hei">www.China-138.com£©ÔÚÖйú±±¾©ÏµÓɱ±¾©ÊÀ»ªÌìµØÍøÂç¼¼Êõ·þÎñÓÐÏÞ¹«Ë¾Ìṩרҵ¼¼Êõά»¤£¬±±¾©×¢²áµÇ¼ÇºÅµÚ1101092140613ºÅ¡£ÔÚÖйúÏã¸ÛϵÓÉÖÐÍâÆóÒµ¾­Ã³Í¶×ʺÏ×÷ÖÐÐÄÁªºÏ¼àÖÆ¡£

ÁªÏµ·½Ê½£º
  

  
  
 
   
±± 
¾©£ºµØÖ·£º£¨100012£©±±¾©ÊÐÑÇÔË´åÌì´´ÊÀÔµ´óÏÃD1×ù9²ã910ÊÒ
   ¡¡µç»°£º£¨010£©6480.1986 ¡¡ £¨010£©6480.1987£¨´«Õ棩 
  ¡¡ ÁªÏµÈË£º¸ßÏÈÉú °×ÏÈÉú 
  ¡¡ E-mail£ºmailto:[EMAIL PROTECTED]"; 
class="hei">[EMAIL PROTECTED] 
  mailto:[EMAIL PROTECTED]"; class="hei">[EMAIL PROTECTED]
  

  
  
 
  Ïã 
¸Û£ºµØÖ·£ºÏã¸ÛÓ¢»ÊµÀ14ºÅÇÈÐË´óÏÃ16/FÂ¥F×ù
¡¡ ͶËßÐÅÏ䣺Ïã¸ÛÐË·¢½ÖÓÊÕþ¾Ö38196ºÅÐÅÏä
¡¡ µç»°£º852-2915.6312 ¡¡2915.7428 
¡¡ ´«Õ棺 852-2915.6313
¡¡ E-mail£ºmailto:[EMAIL PROTECTED]"; 
class="hei">[EMAIL PROTECTED]
   
http://www.china-138.com/images/biao.jpg"; 
width="145" height="98">
  

  
  
  
 
   
ͨѶµØÖ·£º£¨100012£©±±¾©ÊÐÑÇÔË´åÌì´´ÊÀÔµ´óÏá¡ 
  ÁªÏµµç»°£º£¨010£©6480.1986 

  

  

  





ÓʼþÄÚÈÝÓëÒÔÏÂÎÄ×ÖÎÞ¹Ø=

ÓÅÁªÍøÂç http://www.chinamysql.com  רҵÌṩ¸÷ÀàÐéÄâÖ÷»ú£¬²»ÂúÒâ¿É»ñÍË¿î¡£

Ç¿ÊÆÌײͣº100MÖ÷»úËͶ¥¼¶ÓòÃû£¬ËÍ10¸ö10MÆóÒµÓÍÏ䣬¼ÓËÍ20¸ö¶þ¼¶ÓòÃû£¬½öÐè318Ôª/Ä꣡


ÈýÁú֤ȯͶ×Ê http://3long.sayba.com 
ΪÄúÌṩרҵÀí²Æ·þÎñ¡£ÏÖÔÚ¹ºÂòÖ»Ðè588Ôª£¬ÔùËͼÛÖµ³¬¹ý1800ÔªµÄÀñÆ·£¡

˵°ÉÍøÉÏÉÌ³Ç http://shop.sayba.com 
È«Êdz§ÉÌÖ±ÏúµÄÐÂÆ·»òÕÛÉÏÕÛµÄÉÌÆ·£¬ÊÇÄúÍøÂ繺ÎïµÄºÃÈ¥´¦£¡


ʹÓü«ÐÇÓʼþȺ·¢£¬ÎÞÐëͨ¹ýÓʼþ·þÎñÆ÷£¬Ö±´ï¶Ô·½ÓÊÏ䣬ËٶȾø¶ÔÒ»Á÷£¡

Èí¼þÏÂÔØÍøÖ·£ºhttp://www.lovexin.com£¬¸ü¶àµÄ³¬¿áÈí¼þµÈÄãÀ´ÏÂÔØŶ£¡

-
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]>
Trou

Re: MySQL won't run (WinXP)

[Gelu Gogancea]

Hi,
My opinion:
You must be sure that my.cnf is on "c:\" or if you use my.ini configuration
files, that file is on c:\windows

Regards,

Gelu
_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]
- Original Message -
From: "Thomas Andersson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 07, 2002 12:22 PM
Subject: MySQL won't run (WinXP)


> Hi!
>
> I'm trying to install MySQL as it's needed for a guestbook (PHP+MySQL) but
I
> just can't get it to work. I've downloaded both 3.23 and 4.0 and used the
> installed, then installed them as services.
> Whenever I try to start the service I get a 1067 error and it terminates,
> seem to be no way I can get either to start :(
> I've installed under E:\mysql and I'm running Win XP with SP1.
> What do I need to edit/do after a basic installation to get MySQL running?
> do I need to change some configuration, if so, to what and where?
> Sorry for taking up your time with such (probably) basic stuff, but I
really
> want this guestbook up and running and I have no experience with databases
> like MySQL :/
>
> TIA & Best Wishes
> Thomas
>
> --
>
> "All I want is to have a .sig and say ahhh!"
>
>
>
> -
> 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]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: where clause question

[Steve Edberg]

Well, it depends on what exactly you mean by 'checking' Bfn1, Bfn2 
and Bfn3, but you should be able to do something like this (assuming 
for this example that you want only want to return results where 
Bfn1/Bfn2/Bfn3 is equal to 99):

select *
from table_a as A, table_b as B
where
   (case A.Afn when 1 then B.Bfn1 when 2 then B.Bfn2 when 3 then B.Bfn3 end)
   = 99

Or you could nest IFs:

select *
from table_a as A, table_b as B
where
   if(A.Afn = 1, B.Bfn1, if(A.Afn = 2, B.Bfn2, B.Bfn3)) = 99

Neither of these does error checking if A.Afn not in {1,2,3}.

See

http://www.mysql.com/doc/en/Control_flow_functions.html

for more info.

-steve



At 12:33 PM +1000 10/7/02, "Peter Goggin" <[EMAIL PROTECTED]> wrote:
>This requires a similar function to Oracles decode. I do not know if MySQL
>provides such a function.
>
>Regards
>
>Peter Goggin
>
>- Original Message -
>From: "Alex Shi" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Monday, October 07, 2002 6:47 AM
>Subject: where clause question
>
>
>>  Hi,
>>
>>  I need a where clause in following situation:
>>
>>  Say I want to query two tables: A and B. In table A there is field Afn,
>>  while in table B there ere 3 fields: Bfn1, Bfn2 and Bfn3. I want to
>>  compose a query, in which the where clause can do this:
>>
>>  if A.Afn=1, then check Bfn1,
>>  if A.Afn=2, then check Bfn2,
>>  if A.Afn=3, then check Bfn3.
>>
>>  So how I compose a where clause to do this? Thanks in advance!
>>
>  > Alex Shi
>>

-- 
++
| Steve Edberg  [EMAIL PROTECTED] |
| University of California, Davis  (530)754-9127 |
| Programming/Database/SysAdmin   http://pgfsun.ucdavis.edu/ |
++
| The end to politics as usual:  |
| The Monster Raving Loony Party (http://www.omrlp.com/) |
++

-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL won't run (WinXP)

[Thomas Andersson]

 Hi!

I'm trying to install MySQL as it's needed for a guestbook (PHP+MySQL) but I
just can't get it to work. I've downloaded both 3.23 and 4.0 and used the
installed, then installed them as services.
Whenever I try to start the service I get a 1067 error and it terminates,
seem to be no way I can get either to start :(
I've installed under E:\mysql and I'm running Win XP with SP1.
What do I need to edit/do after a basic installation to get MySQL running?
do I need to change some configuration, if so, to what and where?
Sorry for taking up your time with such (probably) basic stuff, but I really
want this guestbook up and running and I have no experience with databases
like MySQL :/

TIA & Best Wishes
Thomas

--

"All I want is to have a .sig and say ahhh!"



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (111)

[Edwin Raj]

Ed Carp wrote:

>>On Monday 07 October 2002 12:04, Edwin Raj wrote:
>>
>>>When I type mysql in the command prompt it is giving the error "ERROR
>>>2002: Can't connect to local MySql server through socket
>>>'/var/lib/mysql/mysql.sock' (111)"
>>>There is no file mysql.sock at that location???
>>>
>>Exactly.
>>
>>>What is the problem amd what should I do to make it run? I didn't
>>>install MySql on my own and it was a default built on the OS installation.
>>>
>>I don't know your installation in details, but I assume it is probably
>>configured for TCP/IP connections only, so you would need the -h option.
>>
>
>Unfortunately, all of your advice is probably not germane to the problem.  Does the 
>file "/tmp/mysql.sock" exist?  If so, the
>easiest thing to do is to "ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock".
>
Thanks for the inputs.

There is no file /tmp/mysql.sock to link. In fact what is more bothering 
me is the file [EMAIL PROTECTED] . 
This is not found in the path /var/lib/mysql. Is it OK?
And also when I boot my system the mysql daemon starts but immediately 
it ends up. Does any one have a guess of what's wrong. I am also going 
to post this to a linux group, may be I think that wud be the right 
place for this kinda of problem (not sure either)

Any help wud be much appreciated
Edwin



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: looking for portnumber ...

[hans schneidhofer]

Am Montag, 7. Oktober 2002 13:07 schrieben Sie:
> 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 this message, and include the entire text of it in the
> reply, your reply will go through. However, you should
> first review the text of the message to make sure it has something to do
> with MySQL. Just typing the word MySQL once will be sufficient, for
> example.
>
> You have written the following:
>
> hi list,
> have forgotten, how the file is called, where I can take a look for the u=
> sed=20
> portnumbers in my system - does anybody know, where I have to go for look=
> ing=20
> ?
> thanks in advance
> bye hans


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Select IN and NOT IN

[Javier Campoamor]

Hello everybody,

I have a next problem to get a query working.

I have some tables. A User has Phone numbers and Calls associated with
each phone.
# Example: All the calls of the user number 1
SELECT
Call.*
FROM
User, Phone, Call
WHERE
Phone.User=1 AND
Call.Phone=Phone.PhoneNumber

A User has also an agenda with ContactGroups an Contacts, where the
contact has also a phone number.
#Al the contacts for the user 1
SELECT
Contact.*
FROM
User, ContactGroup, Contact
WHERE
ContactGroup.User=1 AND
Contact.ContactGroup=ContactGroup.ContactGroupId


What I want to retrieve is a list with all the calls, but with the
contact associated to the called number (if that contact exists) or a
text showing that the call is no assigned to a contact.

I have tried something like this:

SELECT
IFNULL(Contact.Name, 'Not Assigned'), Call.*
FROM
User, Phone, Call
LEFT JOIN
ContactGroup
ON
ContactGroup.User=1
LEFT JOIN
Contact
ON
Contact.ContactGroup=ContactGroup.ContactGroupId
WHERE
(Contact.PhoneNumber=Call.CalledNumber OR Contact.PhoneNumber IS
NULL) AND
Phone.User=1 AND
Call.Phone=Phone.PhoneNumber


It works with calls that have the called number in the user contact
list, but the query repeat the calls for each group that don't have
received calls (the effect of the "OR Contact.PhoneNumber IS NULL").

I don't know if I'm missing something or this cannot be done with MySql.
I think that this could be done with a Temp table, but I need to do it
in only a query.

Any idea about how to do it? 

Regards

Javier

*Note: The tables are simplified because they were named in Spanish and
there were more tables used to filter the calls, but they are not
related with my problem



-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

how mysql compare chars

[lb]

Dear all,

I am not sure why mysql thinks char(192) = char(194) = char(193) =
char(195)?

mysql> select char(192)=char(193);
+-+
| char(192)=char(193) |
+-+
|   1 |
+-+
1 row in set (0.00 sec)
mysql> select char(192)=char(194);
+-+
| char(192)=char(194) |
+-+
|   1 |
+-+
1 row in set (0.01 sec)

mysql> select char(192)=char(195);
+-+
| char(192)=char(195) |
+-+
|   1 |
+-+
1 row in set (0.01 sec)

mysql> select char(192)=char(196);
+-+
| char(192)=char(196) |
+-+
|   0 |
+-+
1 row in set (0.00 sec)

Oscar Yen.




-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Full-text search and extended characters

[Josh Santangelo]

I'm working on an application that uses the MySQL full-text search to search
for words in pre-existing content. This content can and does contain HTML
entities like "ö".

At least in my setup, if I place words like "mögliche" in an AGAINST()
clause, incorrect results are returned. For example:

SELECT title, datetime,  MATCH(title, strippedtext) AGAINST('mögliche')
AS `mö_3B_gliche` FROM content ORDER BY MATCH(title, strippedtext)
AGAINST('mögliche') DESC LIMIT 2;
++-+--+
| title  | datetime| mö_3B_gliche |
++-+--+
| 9-5| 2002-10-04 08:08:31 |  5.8614664130118 |
| Trauer | 2001-11-27 04:03:42 |  2.2698967450068 |
++-+--+

The strippedtext field for the first row contains "mögliche" and is
properly returned as the first result. The second row does not contain
"mögliche" at all, and seems like it should have a relevancy of zero.

Is there a solution for this, or do I need to be searching only with the
actual "ö" character instead?

Thanks,
-josh


-
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php