phpMyAdmin w/ winXP - IIS w/PHP 4.3 w/mysql 4.1.8

Has anyone had any problems installing phpMyAdmin with the above configuration? I get an error about the mySql client and authentication methods? MySQL Error: 1251 : Client does not support authentication protocol requested by server Please assist Happy New Year Gary -- MySQL General Mailing Lis

please advise on mysql memory,users monitoring

First of all, thanks for the mailing list for giving details about myisamchk.we used them but we got some errors which I have reported in 'myisamchk errors' mail to mysql. At present we are working in mysql 3.23.32 ,windows xp os. Are there any system tables that store mysql related info.(like me

Re: AW: [PHP] How to argue with ASP people...

On Fri, Dec 31, 2004 at 05:17:27PM -0600, Bob Ramsey wrote: > > The only snage with the header function is that you must not print or > echo anything to the browser before you use it. In other words you > can't do this: > > > > I moved you to another page. > http://someotherpage.com";); ?> >

Re: AW: [PHP] How to argue with ASP people...

Don't mean to start a discussion whatsoever, I love php, but one thing i can't do in php is Response.Redirect("page.asp") . Apart from that no complains so far :) Um, as I understand it this is simple to do in php. Just use: header("Location: $somestring"); Here's

Re: AW: [PHP] How to argue with ASP people...

> > -Ursprüngliche Nachricht- > > Von: mail.pmpa [mailto:[EMAIL PROTECTED] > > Gesendet: Freitag, 31. Dezember 2004 03:27 > > An: mysql@lists.mysql.com > > Betreff: RE: [PHP] How to argue with ASP people... > > > > Don't mean to start a discussion whatsoever, I > love php, but > > one th

Re: use of soundex in queries

This will give you a list of names and their soundex values. Is this what you want? What is it you are trying to do, there may be a better way to do this than by getting a list and reprocessing it somehow. SELECT nn, soundex(nn) FROM table WHERE nn > '' Shawn Green Database Administrator Unimi

Re: use of soundex in queries

Hi Shawn, I printed the manual, but as I am not such a database guru I was not able to transfer this knowlegde into an select-statement. Thanks for your realtimehelp. Is it possible to do an select-query with soundex like the following examble? select nn from table where nn !='' my database h

php mysql library and mysql 4.1.x

Hello all, I know the php manual warns that some functionality may not work if you use the regular mysql libraries with mysql versions greater than 4.1.x. I have found so far that MYSQL_ASSOC return types don't work, just wondering if anybody has found any other issues. I would just have the d

RE: AW: [PHP] How to argue with ASP people...

And if you believe ASP.NET only provides a few benefits, then you are adequately informed, my friend Freddie I agree completely! Max Michaels Systems Engineer Right Media LLC -Original Message- From: Freddie Sorensen [mailto:[EMAIL PROTECTED] Sent: Friday, December 31, 2004 10:02 AM

Re: use of soundex in queries

Did you think to check the manual? English: http://dev.mysql.com/doc/mysql/en/String_functions.html German http://dev.mysql.com/doc/mysql/de/String_functions.html French: http://dev.mysql.com/doc/mysql/fr/String_functions.html and your query would look like SELECT ... FROM ... WHERE SOUNDEX(fi

use of soundex in queries

Hi, I need to compare names from different tables and therefore I need to know the proper use of soundex. I googled for it, but could not find anything useful. And select soundex('text') is no help for me. The query should look like this: select field from table where field like [soundexquery i

RE: Multi table update

"Jay Blanchard" <[EMAIL PROTECTED]> wrote on 12/30/2004 05:20:49 PM: > [snip] > > Anyhow, it has been a good discussion. No bugs were uprooted and > > everyone's understanding may have risen a notch. After a couple of > > decades using SQL I still find interesting topics to discuss. > > Yes, I t

InnoDB: Error: tablespace size stored in header is 17024 pages, but ...

Dear MySQL people I have a question regarding the error: InnoDB: Error: tablespace size stored in header is 17024 pages, but InnoDB: the sum of data file sizes is only 16576 pages which appeared when I upgraded from 4.0.7 to 4.1.7. Somehow I am 448 pages (7M) short of table space. Can I fix th

Re: BIG InnoDB problems!

Greetings Heikki and Happy New Year! Here's what I got. I hope it's useful. beech:/home/jfreeman # resolve_stack_dump -s /tmp/mysqld.sym -n mysqld.stack 0x815f0cf handle_segfault + 575 0xe420 _end + -138916432 0x82e71d5 buf_read_page + 165 0x82e71d5 buf_read_page + 165 0x82db68f buf_page_get

AW: AW: [PHP] How to argue with ASP people...

Shawn, It is worth it for performance reasons ! And yes, I am LOOKING at the code and DEBUGGING it every single day, also without the use of VS, what's the problem ? And it is global.asax, not global.asp I and my colleagues have never had a project which we didn't get right the first time,

Re: AW: [PHP] How to argue with ASP people...

Have you actually LOOKED at the code (global.asp, *.asp, *.aspx, etc... ) that VS produces to make an ASP.NET application? Have you EVER had to be in the position to debug and modify that by hand (without the aid of VS)? I have. I ask that you try it before you continue your high praise for t

Re: auto commit

I haven't worked with ODBC in several years and I was never very fluent with it but I *think* you need to use a SQLSetConnectAttr call, passing the desired value to SQL_ATTR_AUTOCOMMIT. This article describes the SQLSetConnectAttr call:

Re: Weird server timeout problem

On Thu, 2004-12-30 at 16:19 -0700, Sasha Pachev wrote: > Dale Blount wrote: > > Hello, > > > > I've been fighting this problem for a while, and now it's time to ask > > the experts. Please also CC me on this, I'm only on the list as a > > digest. > > Dale: > > Enable the log-long-format and log

Re: export from older version

Eric Bergen wrote: If you can use mysqldump to export the data from 3.23 with the -Q switch to quote all db, table, and column names. Thanks for the input, that has worked for me in the past, but it's on a hosted db server and I don't think I have rights to run mysqldump on it. I was hoping to av

auto commit

Hi All, I am using ODBC interface to access MySQL database. All DML oparations like insert, update and delete are performed using ODBC API's ( C program and ODBC API's). We start the transaction in the following order. 1.create savepoint a 2. do dml operation 3. commit if dml is succes

Re: AW: [PHP] How to argue with ASP people...

FOAD Quoting Freddie Sorensen <[EMAIL PROTECTED]>: > Tony, > > Check out ASP.NET and you will want to forget everything about PHP ;-) > > Freddie > > > -Ursprüngliche Nachricht- > > Von: mail.pmpa [mailto:[EMAIL PROTECTED] > > Gesendet: Freitag, 31. Dezember 2004 03:27 > > An: mysql@lists

AW: [PHP] How to argue with ASP people...

Tony, Check out ASP.NET and you will want to forget everything about PHP ;-) Freddie > -Ursprüngliche Nachricht- > Von: mail.pmpa [mailto:[EMAIL PROTECTED] > Gesendet: Freitag, 31. Dezember 2004 03:27 > An: mysql@lists.mysql.com > Betreff: RE: [PHP] How to argue with ASP people... > >