Re: Between Operator

t up a linked table that holds the sorting and rating string information. You could go with either a two column or three column table. The only difference being that the three column table would have an auto increment primary key so the sorting column can be changed without affecting the l

Re: MySQL Open Source Status

n all not a bad deal if you don't want to GPL your code. Michael -- Michael Johnson < [EMAIL PROTECTED] > Internet Application Programmer, Pitsco, Inc. +++ Opinions are my own, not my employer's +++ -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

Re: Cost of joins?

hardware at the problem. I have no doubt that some day every problem that must be de-normalized now for acceptable performance can be renormalized at some future time. But you can't know when that future time will be exactly and must accept a compromise in the meantime. Michael -- Michael

Cannot start 4.1.3 on Debian Linux

x82ca2ca pthread_rwlock_rdlock + 234 0x826eef4 mi_rnext + 148 0x80fae2a index_next__9ha_myisamPc + 42 0x80e6789 __11GRANT_TABLEP8st_tableT1 + 1641 0x80e80fe grant_init__FP3THD + 526 0x808d389 main + 697 0x82d74f4 __libc_start_main + 212 0x8048101 _start + 33 -- Michael Johnson < [EMAIL PROTECT

MySQL upgrade

I have ben trying to install MySQL v4 for Linux on a machine that had a previous v3 installed badly. I have removed all of the old v3 or so I thought. When I try and put the new v4 on it says that it cannot do this as there is still a v4 on the machine. What can I do to overide? Michael Johnson

sock file

When trying to start mysql on a lx50 I get the following message: Error 2002 Cannot connect to local MySQL server through socket /var/lib/mysql/mysql.sock (111). What can I do to resolve this problem pls? Regards Michael Johnson

RE: Connect string for ASP

[mailto:[EMAIL PROTECTED] Sent: 29 April 2004 19:54 To: 'Joy Johnson '; Victor Pendleton; ''michael johnson ' '; ''[EMAIL PROTECTED] mysql. com ' ' Subject: RE: Connect string for ASP You will need to have MyODBC installed. You do not need to create a

Connect string for ASP

Dear All I am using ASP. Can anyone give me the connection code to connect to a MySQL database without using ODBC DSN? Thanks Michael Johnson Director BPEnet EMEA Sun iForce Premier Solution, Sales, Change Management & Development Partner Part of the BPEnet Group Limited 13 Austin Fr

German Language characters storage.

Can MySQL store German characters such as ä, o, u and ß Thinking the Problem all the way through Michael Johnson Managing Director Humphrey Consulting Limited BPEnet 13 Austin Friars London EC2N 2JX [EMAIL PROTECTED] tel: fax: mobile

What is the proper method of creating innodb/ibdata files with mysqld_multi?

Good morning: What is the proper method of creating ibdata files with mysqld_multi? Using mysqld_multi the second server started, but just created one ibdata file instead of four, which I have indicated in the second servers' my.cnf file located in its data dir. Also, I was unable to log on

INNODB - Reclaiming ibdata space and various ibdata questions

Good Afternoon and thank you in advance for any help that you may be able to provide. QUESTION 1 : How do you reclaiming ibdata space? We have 3 databases that together use several ibdata files (ie each database does not have its own ibdata file) . We would like to drop 2 databases and reclai

RE: automate MSAccess into MySQL

Visit my web site and look at data converters Michael Johnson Director BPEnet Humphrey Consulting Limited 13 Austin Friars London EC2N 2JX Tel +44(0)870 922 0247 Fax +44(0)1323 419554 email [EMAIL PROTECTED] URL www.bpenet.net Also in Dublin & Luxembourg -Original Message- From: McKe

V3.23 to V4

work. My Question is: Should I have used some procedure in addition to the transfer to re-index the files. Under version 3.23 the MySQL Manager says the tables are MyISAM. Any help will be gratefully received. Michael Johnson Director BPEnet Humphrey Consulting Limited 13 Austin Friars London

Send someone a database

Dear All I want to send a MySQL database to a client by email. Which is the best way to do it? Michael Johnson Director BPEnet Humphrey Consulting Limited 13 Austin Friars London EC2N 2JX Tel +44(0)870 922 0247 Fax +44(0)1323 419554 email [EMAIL PROTECTED] URL www.bpenet.net Also in Dublin

Re: Intermittent 'access denied' errors.

er 3.x version. But I wrote the loop and forgot about it. This is happening to me on a low volume server right now, but when I move to production it will handle a much higher volume of traffic. I'm just hoping my looping check doesn't bog things down too much. :) If you find a solutio

Re: web interface...

gt;--> -->-->Thanks -->--> --> -->- Dathan Vance Pattishall --> - Sr. Programmer and mySQL DBA for FriendFinder Inc. --> - http://friendfinder.com/go/p40688 --> --> --> --> --> -- MySQL General Mailing List For list archives: http://lists.mysql.c

Re: newbie SELECT question

COUNT with this to allow me to build a table in PHP of the most popular root domains which go to my site. I hope this all makes sense ;-) kind regards, Graham Nichols. -- Michael Johnson < [EMAIL PROTECTED] > Internet Application Programmer, Pitsco, Inc. 620-231-2424x516 -- MySQL General

Re: Select statement

his done ? thanks, Darryl -- Michael Johnson < [EMAIL PROTECTED] > Internet Application Programmer, Pitsco, Inc. 620-231-2424x516 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL 4.1, derived tables, and privileges

ke this? Thanks, Michael PS If there is a better way to do this query, I'd like to know that, too, but I've run into this problem at other places where I *know* I have to use derived tables, so the problem is still pertinent to my use. -- Michael Johnson < [EMAIL PROTECTED] > I

Sage

I do apologies I should have said has anybody been able to connect Sage Accounting to MySQL Michael Johnson Director BPEnet Humphrey Consulting Limited 13 Austin Friars London EC2N 2JX Tel +44(0)1323 438975 Fax +44(0)1323 738355 email [EMAIL PROTECTED] URL www.bpenet.net Also in Dublin

Sage

Has anyone used saga to connect to MySQL database? If so what tools did they use? Michael Johnson Managing Director Humphrey Consulting Limited BPEnet Tel/Fax: 0870 922 0247 email: [EMAIL PROTECTED] websites: www.humphreyconsulting.co.uk & www.bpenet.net

Goldmine

Dear All Has anyone successfully used Goldmine accessing MySQL databases via ODBC or any other connection method? Regards Michael Johnson - Before posting, please check: http://www.mysql.com/manual.php (the manual

RE: convert ms access mdb file to file that can be imported in mysql

I can supply a converter that will do this without having Access installed. Contact my Sales Manager Joy Johnson at [EMAIL PROTECTED] who will let you have a copy for £30.00 plus VAT (If in the EU) Michael Johnson Director BPEnet Humphrey Consulting Limited 13 Austin Friars London EC2N 2JX Tel

Re: MySQL Starts, but quits immediately

You need the mysql daemon running before you can connect to it. To me it looks like need to start the daemon as a user with the right permissions and then connect to it. Is mysql configured at all on your box? If you haven't read the docs--you probably should. -mj On Fri, 2 Aug 2002, Bill Leona

Lost root password

We have a support contract with you. One of my clients has lost his root password. How can we access his mysql? Michael Johnson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Lost root password

We have a support contract with you. One of my clients has lost his root password. How can we access his mysql? Michael Johnson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: Compile guide / needed /recommended versions solaris 8 Sparc

We can supply MySQL box set with manuals and releases for all supported platforms plus some goodies. The price is £35.00 plus VAT (if applicable) you can find details on our website at www.bpenet.net. The price above is a concessionary price. Michael Johnson Managing Director Humphrey Consulting

RE: Should We purchase mysql license Under Windows 2000??----Please Help!!!

If you are using MySQL for commercial gain then you need a developer's license. Michael Johnson Director BPEnet Humphrey Consulting Limited 13 Austin Friars London EC2N 2JX Tel +44(0)1323 438975 Fax +44(0)1323 738355 email [EMAIL PROTECTED] URL www.bpenet.net Also in Dublin & L

mysql distribution box sets available

5. Benchmarks 6. FAQs 7. MySQL Manual Server Client 8. Graphical User Interface (GUI) 9. Bonus Software I am offering this package for £50.00 plus VAT. If you would like one then just reply to this email. MAJ Michael Johnson Director BPEnet Humphrey Consulting Limited 13 Austin Friars London

Various Issues the Mysql Community seems to be raising

are all asking. Regards Michael Johnson Director BPEnet Humphrey Consulting Limited 13 Austin Friars London EC2N 2JX Tel +44(0)1323 438975 Fax +44(0)1323 738355 email [EMAIL PROTECTED] URL www.bpenet.net Also in Dublin & Luxemb

Removal of MySQL

Is there a simple command one can give in Linux that will remove all trace of Mysql except the databases so that I can install from fresh? Michael Johnson Director Humphrey Consulting Limited BPEnet 13 Austin Friars London EC2N 2JX Tel +44 (0)1323 438975 Fax +44(0)1323 738355 Email [EMAIL

mysql.sock

I have been trying to install MySQL on my Cobalt RAQ3 and I seem to have lost my mysql.sock file. I get the following error message when I tray to carryout any mysql activity. ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Pls ad