Re: Query Question

Hi, Since you have over 10,000 member ids it depends on the exact appln that you have. If the length of the SQL query increases above a certain length (i am not sure abt the exact figure), an error is thrown saying "query too complex". such wont be the case in your former method. but, if ther

Help MySQL on website...

Hi can anyone, please help me!!! I need to put a MySQL database onto my website??? What do I have to do to make this work??? Is it just 1 file that I have to upload, or do I have to do something more? My web-service-provider, have enabled my website, so that it can run a MySQL database??? Ple

Re: MERGE Tables

Hi, > Ok, the first bug (incorrect COUNT, etc. for MERGE and individual tables) > was fixed some time ago. Though, it is possible that you found another bug, > the probability is low. I thought I might be encountering actual bugs in the code in my 3.23.32 version. I'd taken a look at the changel

Mysql server grant privileges problem

Hello everyone: After I have successfully installed mysql server 3.23.37 and connect to it and do some operations.but I have found that there is a security hole that other users can use "mysql" database !!!. And I have started the server like that: bin/safe_mysqld -Sg & then mysql>grant al

RE: To install MySQL, where can free download Lunix?

http://www.slackware.com/ (IMHO the best distro) Other distros: http://www.suse.com/ http://www.debian.com/ http://www.mandrake.com/ http://www.redhat.com/ etc A google for "download linux" would have answered the question for you, BTW. HTH Jon -Original Message- From: johnd [mailto:[

Re: Mysql server grant privileges problem

> >So would anyone explain to me how can I setup up a good privileges of >mysql server.Thx Take a look at the manual. It's all there.. as far as I remember.. Bye, B. - Before posting, please check: http://www.mysql.com/

RE: To install MySQL, where can free download Lunix?

I agree with u slack rules, you download slackware and I believe some other distros too at ftp.cdrom.com have fun On Tue, 1 May 2001, Jon Haworth wrote: > http://www.slackware.com/ (IMHO the best distro) > > Other distros: > http://www.suse.com/ > http://www.debian.com/ > http://www.mandrake.

Re: What can I do to help the mysql developers to get mysql to work on OS X?

[EMAIL PROTECTED] writes: > So, I'd really like to have mysql working on OS X and while there were a > few people trying it out and having difficulty, I have yet to see any > posts of total success. > > I'm an experienced MacOS programmer, but I have little experience on > Unix -- so I'm way

memory leaks problem

hi, i have a process running in daemon to maintain a database connection i am using mysql_ping before every query the program is having large memory leaks is it because of mysql_ping what happens to previous mysql handler is it freed or re used pls reply munish -

Re: Problems with mysqlshow under linux

Start the server. Siomara Pantarotto wrote: > Hi all, > > When I try to execute mysqlshow under linux I get this message: > > $ mysqlshow > mysqlshow: Can't connect to local MySQL server through socket > '/tmp/mysqld.sock' > (111) > $ > > However when I do the same under NT it works fine >

Re: MATCH AGAINST 2-3 tables

You need to add the table joining information the the where clause so the join only returns properly joined records. EX: where ta.id=tb.id Paul Van Slyke wrote: > Thanks for the response! > > The two tables contain different types of information which are related > by a foreign key (orginally

Re: Computer Exploded!!!

1. Read the manual 2. Read the manual 3. get a book on SQL Selvin Sakal wrote: > My computer didn't explode i just wrote that to get attention. My question > is this - I have a database with a table which looks like this - > > CREATE TABLE sites > ( > ID INT NOT NULL AUTO_INCREMENT, > name VAR

Re: Help MySQL on website...

Well, if you have to ask, then you are not ready. You need to discuss this with your ISP. Thay may have an implementation doc that shows you what you need to do. In the mean time, get a box, Linux, MySQL, Apache, and PHP. Read the manuals on all these, and pay special attention to the apache in

Re: Is my table hosed?

Stop the server, then myisamchk the index. Carina C. Zona wrote: > MySQL 3.23.33: > > This morning, one of my tables suddenly reported index corruption. I locked > the table, fixed with myisamchk -o, unlocked, and thought the problem was > solved. But it keeps on re-corrupting (I'm not even w

Re: ORDER BY DESC optimization

First, you don't have an index on 'b', and second, you don't have 'b' in the where clause, so it would not use it if it had one. It needs to sort the result set before it can apply the limit. ryc wrote: > I have a fairly large table (greater than 4mil rows) that I would to preform > a query li

RE: Computer Exploded!!!

hi. a link to the relevant section of the manual might be more helpful. http://www.mysql.com/doc/F/u/Fulltext_Search.html -ravi. -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 9:25 AM To: Selvin Sakal Cc: [EMAIL PROTECTED] Subject: Re: Compu

Re: Computer Exploded!!!

On Tue, 1 May 2001, Gerald Clark wrote: > 1. Read the manual > 2. Read the manual > 3. get a book on SQL > > > Selvin Sakal wrote: > > > My computer didn't explode i just wrote that to get attention. My question > > is this - I have a database with a table which looks like this - > > > > CREA

Re: problem

Mysql does not own its own files, so it can't open them chown -R mysql /usr/local/mysql/var or chown -R mysql /var/mysql whichever is correct for your system. aditya shanker wrote: > hi > i am attaching a log file which was generated by the server in starting up mysql > could any please tell

Empty Set Query question

Hello everyone. I am new to this list and hope it's the right one for my question. This may be really obvious, but I can't seem to figure it out...so here's the problem: I have a table that stores network incident report information, IP address, dates, type of incident, report name, etc. I am

Alternate Resource??

I'm looking for an online message forum or mailing list that deals with Perl/mySQL. Most of the sites I've found are outdated and unused. Any pointers greatly appreciated. Thanks!!! -- Shawn Cummings bostonwebspace.com $9 webhosting/mySQL/Perl/PHP ---

Re: Computer Exploded!!!

Why not start with the table of contents. I might have been more helpful, but I don't think trying to cover "lazy" with "cute" is a good approach to life. Ravi Raman wrote: > hi. > > a link to the relevant section of the manual might be more helpful. > http://www.mysql.com/doc/F/u/Fulltext_Sea

bug report

Please record the following bug identified on the MySQL server: 1. Hardware: SUN Ultra 10 2. Operating system: Sun Solaris 2.7 2. MySQL server version: 3.23.33 3. Error description: - The following SQL statement returns incorrect results when is executed using the 'mysql' client: SELECT @

Re: problem

Your mysql database (a system db with the access privileges) has a table called host which has amongst other files, one called host.frm It seems that mysqld doesn't have permission to read this file. Check that the mysqld owner and this file's owner are the same and change accordingly. regards,

Re: newbie question on variable length records.

This is straight from 7.7.1 of the MySQL manual: * If any column in a table has a variable length, the entire row is variable-length as a result. Therefore, if a table contains any variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR columns longer than three characters are changed to

Re: ORDER BY DESC optimization

On Mon, 30 Apr 2001, ryc wrote: > I have a fairly large table (greater than 4mil rows) that I would to preform > a query like: > > SELECT col1,col2 FROM table WHERE a=1, c=2 ORDER BY b DESC LIMIT 50; > > I have an index on the table INDEX1( a,b,c ); > > When running the query as is, it takes a

RE: trouble installing mysql rpm on Linux

I installed only mysql-3.23.32-1.7.i386.rpm -- at ftp://ftp.redhat.com/redhat/linux/7.0/en/os/i386/RedHat/RPMS/ there is no mysql-client, so I thought maybe the client was included in the same package. Now that you mention it, I just noticed that in the 7.1 directory there is a mysqlclient9-3.23.

Re: bug report

Aurelian Dumitru writes: > > > > Please record the following bug identified on the MySQL server: > > 1. Hardware: SUN Ultra 10 > 2. Operating system: Sun Solaris 2.7 > 2. MySQL server version: 3.23.33 > 3. Error description: > - The following SQL statement returns incorrect results when i

Re: bug report

Hi Try select from_days(to_days(curdate())-1); +-+ | from_days(to_days(curdate())-1) | +-+ | 2001-04-30 | +-+ 1 row in set (0.00 sec) Simon On Tuesday 01 May 2001 14:45, Aur

Re: Empty Set Query question

You are doing a text compare, and they have to match exactly, including leading zeros after the dots. You might look at storing them as integers. MySQL has to functions INET_ATON() and INET_NTOA() to convert them back and forth to strings. Erica B. Tanner wrote: > Hello everyone. I am new to t

Re: Problem with LAST_INSERT_ID();

This works for me. You will have to translate the javascript to whatever you are using ... SQL = "insert into myTable(field2, field3, field4) values("dat2", "dat3", "dat4")" var dataConn = Server.CreateObject("ADODB.Connection"); dataConn.open(MM_soCalData_STRING); var rs1 = dataConn.Execute

Re: newbie question on variable length records.

I think he may be trying to put a variable number of *fields* in each record. This of course cannot be done directly. If that is what he wants he will need to have his own program merge/parse the data into a fixed number of MySQL fields (columns). On Tue, May 01, 2001 at 09:53:21AM -0400, Tim wro

Re: ORDER BY DESC optimization

On Tue, 1 May 2001, Thalis A. Kalfigopoulos wrote: > On Mon, 30 Apr 2001, ryc wrote: > > > I have a fairly large table (greater than 4mil rows) that I would to preform > > a query like: > > > > SELECT col1,col2 FROM table WHERE a=1, c=2 ORDER BY b DESC LIMIT 50; > > > > I have an index on the

MySQL performance

Hi, I'm currently writing my final year thesis and i'm in need for some information on the efficiency of MySQL. If anyone knows a good site, book, paper etc ... pls let me know. I'm wondering how many request MySQL server can resolve per second and that kind of things. Thanks in advance, Raf

Re: bug report

either. >, when the > above query returned the following value: 20010500 . It should have returned > 20010430. No, it returned the right value. current_date returns a date of the format '2001-05-01'. When you do arithmetic on it, it's converted to an integer. 20010501 - 1 = 2001

Re: bug report

you use DATE_ADD, I'm quite sure what you have found is not a bug 20010501 - 1 = 20010500 MySQL sees CURRENT_DATE as the value 20010501 and performs your subtraction as requested, if you want to subtract a day from today I suggest DATE_ADD( CURRENT_DATE, INTERVAL -1 DAY ) Or the previ

Re: bug report

his now all the sudden a reasonable bug? > > Aurelian: > I suggest that you use DATE_ADD, I'm quite sure what you have found > is not a bug > 20010501 - 1 = 20010500 > > MySQL sees CURRENT_DATE as the value 20010501 and performs your subtraction > as requested, if you w

Newbie group/count query question

I have a table which contains a date column and an order_number column. I need to formulate a query syntax to return the total number of orders for each day in a given month (if any). Can someone help me with the syntax please as I've been stumbling around with it all day without success. Many th

how to insert the contents of a file into a column

pls don't tell me how I could do this with perl; there's a req for sh. Have got a bunch of small multi line files that I thought I was reading in ok: /usr/local/apache/htdocs/rpts/rvd The first word of ea file is the only thing that makes it in. Cheers... pushcontent() { SECTIONID=4 THETITLE=$1 T

Re: bug report

Hello Aurelian, I do the same thing but use the following code and it works fine. SELECT @myvar := DATE_SUB( CURRENT_DATE, INTERVAL 1 DAY) ; Edward 5/1/2001 6:45:19 AM, "Aurelian Dumitru" <[EMAIL PROTECTED]> wrote: > > >Please record the following bug identified on the MySQL server: > >1

Re: Alternate Resource??

On Tue, 1 May 2001 09:43:47 -0400 (EDT), Shawn Cummings <[EMAIL PROTECTED]> wrote: >> >>I'm looking for an online message forum or mailing list that deals with >>Perl/mySQL. Most of the sites I've found are outdated and unused. >> >>Any pointers greatly appreciated. check out DevShed at http:

Re: ORDER BY DESC optimization

> > I have a fairly large table (greater than 4mil rows) that I would to preform > > a query like: > > > > SELECT col1,col2 FROM table WHERE a=1, c=2 ORDER BY b DESC LIMIT 50; > > > > I have an index on the table INDEX1( a,b,c ); > > > > When running the query as is, it takes around 4seconds. If I

Re: MERGE Tables

Hi! On May 01, Basil Hussain wrote: > Hi, > > > Ok, the first bug (incorrect COUNT, etc. for MERGE and individual tables) > > was fixed some time ago. Though, it is possible that you found another bug, > > the probability is low. > > I thought I might be encountering actual bugs in the code in

Re: MySQL performance

"Raf Geusens" <[EMAIL PROTECTED]> wrote: > I'm currently writing my final year thesis and i'm in need for some > information on the efficiency of MySQL. If anyone knows a good site, book, > paper etc ... pls let me know. I'm wondering how many request MySQL server > can resolve per second and that

Re: What can I do to help the mysql developers to get mysql to work on OS X?

On Tuesday, May 1, 2001, at 04:42 AM, Sinisa Milivojevic wrote: > [EMAIL PROTECTED] writes: >> So, I'd really like to have mysql working on OS X and while there >> were a >> few people trying it out and having difficulty, I have yet to see any >> posts of total success. >> >> I'm an experienced

Re: Empty Set Query question

Thanks to all for the suggestions!! Turns out, if I use a regular expression instead of a text compare I get the desired result!! :) Thanks! Erica Gerald Clark wrote: > You are doing a text compare, and they have to match exactly, > including leading zeros after the dots. > > You might look a

Re: LAST_INSERT_ID returning 3 rows?

Ok I was thinking that you had to tell LAST_INSERT_ID the table you wanted to get the last insert id from. What if you run a web site and you have 10 tables in a database, how can you tell what the last insert id of table 6 was? Thanks, Graeme > Because you included a from clause, you got one

Re: LAST_INSERT_ID returning 3 rows?

Ok now I understand -- it's on a per-connection basis =) thanks, graeme - Original Message - From: "Graeme B. Davis" <[EMAIL PROTECTED]> To: "Gerald Clark" <[EMAIL PROTECTED]>; "Braxton Robbason" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, May 01, 2001 1:09 PM Subject: Re:

Is it possible?

hi, I was reading the manual for the full-text search. It is really interesting to have a search engine embedded into the database itself!!!. Mysql uses the criterias defined by the mysql developers. Is it possible for the user to specify the the criteria in his/her program and mysql rank the re

mysqlimport and Optionally Enclosed By spec

Hello, Has anyone experienced and/or solved this problem on a Linux / Apache / MySQL system? I'm trying to call mysqlimport remotely over CGI using perl's system command, to upload and import csv files. Basically everything works except for setting the '--fields-optionally-enclosed-by' argumen

Re: What can I do to help the mysql developers to get mysql to work on OS X?

tyler writes: > > Ok. Here's the output to the screen: > > > ./mysql-test-run > > Installing Test Databases > > Removing Stale Files > > Installing Master Databases > > Installing Slave Databases > > Starting MySQL daemon > > Loading Standard Test Databases > > Starting Tests > > > > TEST

RE: Newbie group/count query question

hi. your table looks something like this: table1 - date(date) order_number int(6) ...i wasn't sure if "order_number" is referring to a "order" table somewhere... if there are multiple rows for each day, and you want to add up "order_number" for each day, use: select DAYOFMONT

Re: Newbie group/count query question

On Tue, 1 May 2001, Graham Nichols wrote: > I have a table which contains a date column and an order_number column. I > need to formulate a query syntax to return the total number of orders for > each day in a given month (if any). Can someone help me with the syntax > please as I've been stumbli

column count doesn't match and updating 2 tables

I have 2 tables with identical structures. The following sql statement works fine: insert into table_2 select * from table_1 but if I attempt to say insert into table_2 select fieldname_1 from table_1 or any combination of selecting specific fields to be put into the other table, I get an

Re: ORDER BY DESC optimization

On Tue, 1 May 2001, ryc wrote: > > > I have a fairly large table (greater than 4mil rows) that I would to > preform > > > a query like: > > > > > > SELECT col1,col2 FROM table WHERE a=1, c=2 ORDER BY b DESC LIMIT 50; > > > > > > I have an index on the table INDEX1( a,b,c ); > > > > > > When runni

How to set priority of mysql service in windows 2000

Does anyone know how to set or change the priority of the mysql service in Windows-2000 Pro. It runs by default as "normal" and I would like to make it "low". There doesn't appear to be a command line option or config file option for this. In addition, I can't change the priority of the service

difficulty with insert into

only the first word of the files being read into the var gets inserted into the table #!/bin/sh pushcontent() { SECTIONID=4 THETITLE=$1 THECONTENT=$2 THECOUNTER=1 mysql -u root -D nuke

Dates not compared properly?

Howdy all... I've run into a strange date problem as of midnight, May 1, 2001 on my i686 Linux machine running mySQL 3.23.37. For some reason, queries can no longer compare dates properly: mysql> select count(*) from hit where date > NOW()-1135560; +--+ | count(*) | +---

Re: Is it possible?

do & publish any improvements you suggest :) On Tue, 1 May 2001 10:26:05 -0700 (PDT) sagar tamhane <[EMAIL PROTECTED]> wrote: > hi, > > I was reading the manual for the full-text search. It > is really interesting to have a search engine embedded > into the database itself!!!. > > Mysql uses t

Re: column count doesn't match and updating 2 tables

Hi Suzanne, When you say: insert into table_2 select * from table_1 alls fine. All the records and fields will get copied. But when you say: insert into table_2 select fieldname_1 from table_1 you are just selecting fieldname_1 from table_1 while table_2 consists of fieldname_2 als

Compile question

It appears that in order to install MyODBC I have to install a compiled MySQL version so that I will have the shared client libraries, include files, 'thread-safe-client' and libmysqlclient installed as a shared library. Is this correct? Thanks, bernie lasalle

mySQL Hangs with Status 'D'

I have been having repeated problems with mySQL 3.23.36 on Linux (Red Hat 6.0, 2.4.3 kernel). I think I've got traced the problem but I don't know how to fix it... At some point after being started one or more of the mySQL threads hang with the ps status of 'D' (my research suggests this can mea

perl DBD make test errors??? Please Help (PROBLEM SOLVED, I think...)

I actually read the readme for DBD ;) and found what looks like the cause of the problem below: The Error means... that your linker doesn't include libgcc.a. You have the following options: a) Either recompile Perl or Mysql, it doesn't matter which. The important thing is that you use the same c

Question(s) regarding Build options

Hello; I have looked throught MySQL's website and to no avail, was unable to find a document that has a detailed description of the configurable build options. ie. --sharedstatedir --localstatedir --datadir If anyone could point me to a relevant document or web page, I would be greatful Kev

table corruption endemic

I've got two mysql servers on two different boxes, both running Linux (Red Hat 6.2) with 2.2.18 kernels. Both are recent, fresh installs of Mysql 3.23.37, but have data from older 3.23 versions. For the last week, any time the database does any kind of data loading, (multiple inserts and updates

mysql-test does not work from install directory after source dist. install

>Description: There are several problems running the mysql-test-run script from the installed directory if you are installing from a source distribution. e.g., if you do as the manual suggests (4.7.1 Quick Installation Overview) shell> groupadd mysql shell> useradd

INSTALL rpm over tar.gz??

I currently have Mysql .36 loaded on RH6.2 intel, installed from tar. How do I remove the .36 version so I can install the rpm version .37?? This is not an upgrade, I need to replace or recompile mysql - Is there a Un-Install process to remove the 36 version? Thank You in advance, ChrisB -

Optimization of MySQL

Hi, I am running a MySQL server on a nice machine (dual pIII 1gHz/1g ram), with RedHat 7.0. Currently, I am using the rpm version of mysql, which is 3.23.37. Our database is large, and getting larger, with several tables approaching the 1gig mark. In addition, the database will be moving to

user setting own password.

how does a user set his own password in mysql? I have searched through the archives, and have found only the 'st password..' command. this does not work. In my case, there are more then just one host in the user table and the set password command only changes the localhost entry, leaving me una

Apache/PHP/MySQL - processes multiply until about 30, then doom

I am running MySQL (3.23.27 at this point) with Apache1.3.12 and PHP3 on a PC running Redhat 6.0. My problem has survived upgrades of all components from earlier versions. Every PHP page has at least one query to a MySQL database for session tracking (home-rolled code, not PHPLib or anything

RE: mySQL Hangs with Status 'D'

Upgrade to 2.4.4. 2.4.3 had some rwsem issues. -- Vibol Hou KhmerConnection http://khmer.cc -Original Message- From: Hunter Hillegas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 2:20 PM To: mySQL List Subject: mySQL Hangs with Status 'D' I have been having repeated problems

Unusual dependency error w/ rpm??

I do believe I have these dependencies, why am I getting these errors? Running RH6.2 / INtel /mysql>rpm -i MySQL-3.23.37-1.i386.rpm failed dependencies: /bin/sh is needed by MySQL-3.23.37-1 /bin/sh is needed by MySQL-3.23.37-1 /usr/bin/perl is needed by MySQL-3.23.37-1

MySQL can't open mysql.sock on start

>Description: on start, MySQL creates a socket (mysqld.sock), in the /tmp directory by >default, and tries to start by opening socket mysql.sock. this might be a configuration error. the following fix worked. >How-To-Repeat: try to start mysql by running ./safe_mysqld >Fix:

Problem with mysqldump....

Hi everyone, I'm trying to backup all the databases from Server_A to Server_B. I'd issue "mysqldump" command in server_A to backup every single database, as below :- > mysqldump -uusername -ppassword databases_name > file_name In server_B, i create a new database using the command b

Re: Problem with mysqldump....

Dont use mysqldump to import. Use mysql. I can't remember the exact syntax, but reference mysql.com for mysqldump, then in the syntax example for that, they show you how to import it. Ryan Shrout Production Manager Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] (859) 653-3341 - Origina

very easy update, but how? Novice here

What is the syntax for UPDATING the results of this select statement? I am using mySQL 3.22.27 select service.servdef from service, account, user where account.number=user.account and user.number=service.user and (service.servdef = 1) and (account.customerof = 6 or account.customerof = 7 or acc

What do I do now?

HELP!!! I sent a message to this forum a couple of days ago about a problem that I am having with MySQL 3.23.37 (and now 36) running under RedHat 7.1. I am trying to use the mysqlimport utility and continue to get the following error: mysqlimport: Error: Can't get stat of '/home/yada/yada/file_

Re: What do I do now?

why not just use the LOAD DATA INFILE option? Bombardier Systems Consulting wrote: > > HELP!!! > > I sent a message to this forum a couple of days ago about a problem that I > am having with MySQL 3.23.37 (and now 36) running under RedHat 7.1. > > I am trying to use the mysqlimport utility an

How To Port the MS SQL Database To MySQL ??

Dear Friends , The basic problem I face in the new project is to convert the previous Stored Procedures in MS SQL Database into My SQL . How to Replicate the same in My SQL . The Front End is VB 6.0 . The Back End previously was MS SQL . Now Client want it to be in My SQL . Please send the d

Re: Optimization of MySQL

On Tue, May 01, 2001 at 04:46:39PM -0700, Bryan Coon wrote: > > Our database is large, and getting larger, with several tables > approaching the 1gig mark. In addition, the database will be moving > to a dedicated node on a beowulf cluster. Cool... :-) > For our users, we are not particulary i

Fw: What do I do now?

- Original Message - From: "Bombardier Systems Consulting" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 01, 2001 10:07 PM Subject: Re: What do I do now? > Thanks! > > I assume that I can put that command into a script and feed it to > mysql -options < filename > > Than

DBD::MySQL Help!!

Hi, Im trying to do the CPAN install of DBD::MySQL, Im running OpenBSD 2.7 --- I know this is prolly not the best list for this question, but its the only related list im currently subscribed to... When I do the install it askes me what db to test on and i put test, localhost for host, then i put

if no var/db directory where R DB files?

Hello, I have just installed mysql-3.23.37 in FreeBSD 4.2, I have already ./configure - make and - make install and notice that there is no /var/db directory, so I am wondering where the database files are? how can I find these database files? Thank you, Diego Montalvo -

get_meta_tags 4 proxy

I am on a lan and i would like to know how to use PHP's get_meta_tags function though my proxy. Can someone write me some sample code. Thanks database sql query _ Get Your Private, Free E-mail from MSN Hotmail at http://www

Installing MySQL on Solaris as a user(not root)

I have a problem running MySQL on Solaris. I downloaded the source and compiled it following all the instructions and made mysql directory in my home directory. When I enter "mysqladmin version" I get: mysqladmin Ver 6.9 Distrib 3.21.33b, for sun-solaris2.8 on sparc TCX Datakonsult AB, by Mont

RE: Optimization of MySQL

Hi there Is there anything similar to this that will run on a Windows platform? Regards WARREN ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 > -Original Messa

mysqld daemon ended

dear: i having problem when start mysql using "safe_mysqld" command it showed mysqld daemon ended here the error_log message: 010502 14:37:20 Found old style password for user 'root'. Restart using --old-protocol mysqld ended on Wed May 2 14:37:20 MYT 2001 can someone help me on this?