re: mysql can not start

2002-11-21 Thread Victoria Reznichenko
Frank, Thursday, November 21, 2002, 10:28:59 AM, you wrote: FK> mysql on a win2k box do not start after FK> a server down FK> win2k error: FK> mysql can not start cause FK> it was unexpected shutdown FK> mistake 1067 Run MySQL server in standalone mode mysqld.exe --standalone --console Yo

re: creation of table named 'group' should be prevented

2002-11-21 Thread Egor Egorov
J.C., Thursday, November 21, 2002, 10:20:06 AM, you wrote: JCK> if you use the following command in mysql: JCK> CREATE TABLE somedb.group(mip INT (8) UNSIGNED DEFAULT '0' NOT NULL JCK> AUTO_INCREMENT, name CHAR (255), PRIMARY KEY(mip), UNIQUE(mip), INDEX(mip)) JCK> Where somedb is the database n

Limitation of SQL when making LEFT JOIN

2002-11-21 Thread Juan C. P. Garrido
Hi, I´m using MySQL version 4.0.5 in Windows and I want to make a JOIN between two tables that have approximately 20,000 records and 20 columns. As all the records from one of the tables must appear in the result of the SQL( the tables don´t have the same number of records) , I ought to use a LE

tuning mysql

2002-11-21 Thread Sönke Ruempler
hi, do you have hints/documents for me were to find information about mysql server tuning (not table/index optimizing, but memory-tuning etc). thx! regards Sönke Ruempler top concepts Internetmarketing GmbH -- http://www.topconcepts.com

Re: Re: load data worked with warnings

2002-11-21 Thread DL Neil
Pallavi, [Please keep replies on-list. It helps other people, my mail rules keep you separated from paying clients, and the list archives are complete] > actually i created a new file by vim & then did cut & paste . =therein lies the problem. If you compare the listing below with the expected out

Re: Version 4.1

2002-11-21 Thread Heikki Tuuri
Daniel, - Original Message - From: "Daniel Kiss" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, November 21, 2002 7:18 AM Subject: Version 4.1 > Hi all, > > I would like to know when MySQL version 4.1 will be available for windows > as compiled install kit? my g

RE: Mysql Replication

2002-11-21 Thread Simon Green
Not out of the box. You would have to right some code to do this. The best way to do this is get every one who rights code to set up to hosts at the top of there code. Simon -Original Message- From: Massimo Bandinelli [mailto:[EMAIL PROTECTED]] Sent: 21 November 2002 09:48 To: Jon Frisby C

R: Mysql Replication

2002-11-21 Thread Massimo Bandinelli
I want do build a mysql cluster. The master receive all queries. Then, the master write, update, delete, ecc.. the slaves answer SELECTs If this is impossible, which is the utility to have slaves??? -Messaggio originale- Da: Jon Frisby [mailto:[EMAIL PROTECTED]] Inviato: mercoledì 20 no

Re: fulltext, trying to index 2 character words

2002-11-21 Thread Thomas Spahni
Kevin, are you sure that your 2 and 3 letter words do not appear in more than half of all rows? That would exclude them from the search. Thomas On Wed, 20 Nov 2002, Kevin Lewandowski wrote: > Hi, Sergei. > > In myisam/ftdefs.h I changed: > > #define MIN_WORK_LEN 4 > > to: > > #define MIN_WORD_L

performance tuning

2002-11-21 Thread Stefan Immel
Hi I have a problem with performance for out mysql db. The docs on www.mysql.com don't really help because they arent specific enought (what is big ???). The load on our server currently is over 2 permanently and I don't think that is very good. We use: MySQL 3.23.51 Linux Kernel 2.4.16 we do

Re: The dreaded move from Oracle to MySQL

2002-11-21 Thread Simon Windsor
Hi The Oracle export function, exp, does not export data in a clean file format, and whilst it may be possible to tidy the output to load into another database, you'd do better writing a perl script to dump the tables required to disk. The time factors in moving data from db1 on one machine t

mysql can not start

2002-11-21 Thread Frank Kaldewey
Hallo, mysql on a win2k box do not start after a server down win2k error: mysql can not start cause it was unexpected shutdown mistake 1067 what going wrong Tank you - Before posting, please check: http://www.mysql.com/m

creation of table named 'group' should be prevented

2002-11-21 Thread J.C. Kleinhout
Hi, if you use the following command in mysql: CREATE TABLE somedb.group(mip INT (8) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT, name CHAR (255), PRIMARY KEY(mip), UNIQUE(mip), INDEX(mip)) Where somedb is the database name and group was the intended group, you can create a table called 'group'.

help for put image into mysql

2002-11-21 Thread luoya li
Hi, I want to put a image into mysql,but when I run program listed below <% formsize=Request.TotalBytes formdata=Request.BinaryRead(formsize) Dim mycon set mycon=server.createobject("adodb.Connection") mycon.mode=adModeReadWrite mycon.connectionString="DSN=ez;UID=aa;PWD=bb" mycon.open "e

<    1   2