RE: Installing MySQL on Fedora

2003-11-29 Thread Phil Ellett
As far as I am aware mysqladmin is a server control program so it comes with the mysql-server RPM .. The one listed below is purely a mysql client and shared library package. Regards, Phil. From: Todd Cary [mailto:[EMAIL PROTECTED] Sent: 30 November 2003

New To MySQL Connector J

2003-11-29 Thread Eternal Designs, Inc
Hi I am new to MySQL connector J. I do not know how to install it. I just downloaded the .zip file and I am using XP Home. I want to use it with tomcat which is already running OK. I need someone to help me how to install it and connect to MySQL which is also installed and working fine. Thank y

Re[2]: MySql Server Overload

2003-11-29 Thread mos
At 07:34 PM 11/29/2003, you wrote: Hello mike, Saturday, November 29, 2003, 11:45:59 PM, you wrote: m> At 11:14 AM 11/29/2003, you wrote: >>Hello Everybody, >> >>We have a relatively busy e-commerce shop running MySQL 4 + PHP 4. >> >>We have just upgraded to a Pentium 4 - 3ghz , with 1 gb ram bec

DB Replication

2003-11-29 Thread Richard Bewley
Hi, I did manage to get two-way replication to work properly, but I have to type: mysql> load data from slave; This is the only way it replicates the data. Is there a way to have it replicate back and forth in real time? Thanks, Richard -Original Message- From: Richard Bewley [mailto:

Installing MySQL on Fedora

2003-11-29 Thread Todd Cary
I tried installing MySQL on Fedora and all seemed to go fine, but there is no mysqladmin.   Have I missed something here? And I am not sure where the mysql executable resides.  The version is MySQL-3.23.58-1.i386.rpm Todd -- <>

Re: Database replication

2003-11-29 Thread Chuck Gadd
Richard Bewley wrote: Ok, but the slave would also replicate to the master? Is anyone using this type of setup? Both machines would be set up as both masters and slaves. We tried it during the Mysql class I took a few weeks ago. Worked fine, except for when there were conflicting updates. -

RE: Database replication

2003-11-29 Thread Richard Bewley
Ok, but the slave would also replicate to the master? Is anyone using this type of setup? Thanks, Richard -Original Message- From: Chuck Gadd [mailto:[EMAIL PROTECTED] Sent: Saturday, November 29, 2003 6:34 PM To: Richard Bewley Subject: Re: Database replication Richard Bewley wrote:

Re: MySql Server Overload

2003-11-29 Thread Chuck Gadd
Nev wrote: > We have just upgraded to a Pentium 4 - 3ghz , with 1 gb ram because > our last server was very slow. What operating system? > Another related point, in the MySQL documentation it says in the > "mysqladmin show extended status" that the Select_full_join value should > be zero mine is

RE: Images in a table

2003-11-29 Thread Richard Bewley
Yes, you can insert the binary into a table. Richard -Original Message- From: Zenzo [mailto:[EMAIL PROTECTED] Sent: Saturday, November 29, 2003 1:42 PM To: MySQL List Subject: Images in a table How can I insert images in a table if I can do it with MySQL? __

Database replication

2003-11-29 Thread Richard Bewley
Hi, I'm working on setting up db replication, and I have a question. If I have a master server, which will replicate to a slave, what about vice versa? What I'm thinking I want to do, is load balance between two database servers (our mail authentication database) using the Cisco LocalDiretor. My

HELP!

2003-11-29 Thread Andy (da man) Rosenblatt
hi I bought a book with your mySQL program and seemed to have installed it worng and i cant stop it. I never set a user name or a password. ~AndyR.

Images in a table

2003-11-29 Thread Zenzo
How can I insert images in a table if I can do it with MySQL? __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EM

MySql Server Overload

2003-11-29 Thread Nev
Hello Everybody, We have a relatively busy e-commerce shop running MySQL 4 + PHP 4. We have just upgraded to a Pentium 4 - 3ghz , with 1 gb ram because our last server was very slow. On this new server at peak times when we receive in the region of 150 to 200 connections at anyone time, our serv

Re: UFT-8 support under mysql-3.23.5x?

2003-11-29 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Zsolt Koppany wrote: > Hi, > > we use mysql-3.23.5x? under Linux and cannot upgrade to 4.x. Our java > applications can store and fetch UTF-8 characters we have problem only with > sorting. > > Any ideas how I can fix the problem? > > Zsolt If you ca

Re: MySQL separate downloads

2003-11-29 Thread Dan Nelson
In the last episode (Nov 29), Director General: NEFACOMP said: > Can someone tell me where I can get MySQL in separate files? For > example I am interested in only the standard MySQL binary for WinNT > (mysqld-nt.exe) But, I cannot find where to download it alone since > the package contains every

RE: MySQL Win32 Service

2003-11-29 Thread miguel solorzano
At 08:29 29/11/2003 -0600, Gerald R. Jensen wrote: Hi Gerald, all Some comments about this thread: Installer tools handle the service application in basic general way, I think the vendor would said non-simple service than non-standard service. For example MySQL aborts the service start if the conf

RE: MySQL Win32 Service

2003-11-29 Thread Gerald R. Jensen
Robert ... An excellent suggestion. Our best Programmer / Analyst has already reviewed the source code, and his conclusion is that there is absolutely nothing 'non-standard' about the way MySQL installs/removes services. G R Jensen -Original Message- From: Robert Rowe [SMTP:[EMAIL P

Re[2]: Retrieving info from a Joined column

2003-11-29 Thread Bruce Therrien
This is what I tried to find an entry in the column, but it doesn't work for some reason. This is a download center, and I want to se if $cfpd[5] has already been downloaded. my ($dls, @downloads); $query = qq{ SELECT downloads,bytesdown,filesdown FROM $utable WHERE handle=? }; $sth

Re: MyODBC and MySQL 4.1

2003-11-29 Thread Director General: NEFACOMP
I have found the issue. It is talked about at the URL http://www.mysql.com/doc/en/Password_hashing.html The question now is When Will MyODBC support that new hashing? Thanks Emery - Original Message - From: "Director General: NEFACOMP" <[EMAIL PROTECTED]> To: "abaid al-mutairy" <[EMAIL

MySQL separate downloads

2003-11-29 Thread Director General: NEFACOMP
Hi group, This is not a problem as such but a limitation. I have a problem with downloading MySQL due to its download size. Can someone tell me where I can get MySQL in separate files? For example I am interested in only the standard MySQL binary for WinNT (mysqld-nt.exe) But, I cannot find where

Re: MyODBC and MySQL 4.1

2003-11-29 Thread Director General: NEFACOMP
I know how to grant privileges but the problem is with the password type of mysql 4.1.0 After granting privileges using GRANT (in 4.1.0), I can only login using the mysql client. But I can't use the same username and password for logging in. Nor MyODBC will succeed. But c:\mysql\bin\mysql.exe wi

Re: MySQL users.

2003-11-29 Thread Director General: NEFACOMP
Check also the other tables in the `mysql` database such as db and host to make sure that there are no entries of that user with 'locahost' as host. If you created the entries earlier, there is a chance that the entries are still there with the localhost entry. Or simply delete everything in DB t

Re: Order by a number not leading in zero

2003-11-29 Thread Hans van Harten
Scott Haneda wrote: > I have the following... > > tSql = "SELECT l.team, l.link, lc.category, l.age, l.date > FROM league AS l > INNER JOIN league_category AS lc > ON l.category = lc.id > WHERE lc.id = " & prepSQL(tConn, id) & " AND l.status = '1' > ORDER BY

Re: MySQL log files

2003-11-29 Thread Egor Egorov
Admin-Stress <[EMAIL PROTECTED]> wrote: > > How can I enable MySQL 4.0.16 log ? > > I just compiled and installed it in my RedHat 9.0 system, but I cant see any log > files. I use > default /etc/my.cnf from my-large.cnf. > Depends on what exactly logging you want to turn on (binary, update, g

How to Deploy MySQl with VB

2003-11-29 Thread Sreedhar Reddy .D
Hai .. Iam Sreedhar , If iam not wasting ur time - please help me out. Prob: Is it neccessary to instal MYSQL Software in clients place to do transactions with database. for example: If an an application is developed using MS-Access and VB then we have to add ".MDB" file in P&D . The

Re: sample my.cnf

2003-11-29 Thread Egor Egorov
"Martin Gainty" <[EMAIL PROTECTED]> wrote: > > I recently downloaded 4.1beta > when i run the DB initialisation utilities I get > > D:\MySQL\mysql\bin>mysqld-opt --skip-grant-tables > 031128 16:18:09 Can't find messagefile 'I:\MySQL\share\english\errmsg.sys' > > I:\MySQL was my old (now deleted