Re: Error with mysql_install_db

2001-08-15 Thread Grigory Bakunov
Date |Wed, 15 Aug 2001 11:02:00 -0700 >From |Alex Cook <[EMAIL PROTECTED]> Hello! AC> I'm attempting a source installation of mysql-3.23.40 on a Solaris 7 SPARC AC> server. the compile process completed without any errors. After reading AC> the various docs, I located the mysql_install_db scri

Re: Benchmarking

2001-08-15 Thread Jeremy Zawodny
On Mon, Aug 13, 2001 at 05:54:35PM +0100, Tadej Guzej wrote: > How do I benchmark 2 queries that return same results without having > mysql read from cache? The only certain way is to restart the server between the queries and do what you can to flush the OS cache, too, if you're concerned about

Dates: To Slash or to Hyphen. That is the question

2001-08-15 Thread Van
Greetings: Building a web form. There are 3 datetimes: RequestDate, FulfillDate, and CancelDate. New record populates a web form with the current date/time in -mm-dd hh:mm:ss format. RequestDate is current date, FullFillDate and CancelDate are "-00-00 00:00:00". Updates present them

RE: insert records

2001-08-15 Thread Venu
Hi ! )-Original Message- )From: rsaras [mailto:[EMAIL PROTECTED]] )Sent: Wednesday, August 15, 2001 10:23 PM )To: [EMAIL PROTECTED] )Subject: insert records ) ) )hai ) ) can anybody help me? ) )Table A )--- )name date )a2000/12/12 )b2000/12/12 )c2000/

Re: Problems starting the MySQL server.

2001-08-15 Thread Grigory Bakunov
You need to start mysql in RH version by service mysqld start or /etc/init.d/mysqld start ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___

RE: SunUltra-60 compiler problem!!

2001-08-15 Thread Aru.Chen
Sinisa Milivojevic, I have do this 'export CXXLD=g++' config, but the problem still exist on solaris. attachments for you reference: Regards, Aru August -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 8:34 PM To: Aru.Che

Recall: SunUltra-60 compiler problem!!

2001-08-15 Thread Aru.Chen
Aru.Chen §Æ±æ¦^¦¬³o«Ê¶l¥ó [SunUltra-60 compiler problem!!]¡C

Re: Replication housekeeping

2001-08-15 Thread Jeremy Zawodny
On Tue, Aug 14, 2001 at 03:58:05PM +0100, Robert Cross wrote: > > I've got a fairly simple MySQL system here using replication, one > master and one slave. > > Looking at the system the other day and the database logs are sure > building up. Is there any standard way ("best practice") - > prefer

Re: replication problems & questions

2001-08-15 Thread Jeremy Zawodny
On Wed, Aug 15, 2001 at 10:55:53PM +0100, Neil Tompkins wrote: > Hello, > > I'm very new to MySQL and have posted a few mails regarding > replication in mySQL. I'm still having problems ! Can someone > please send me a step by step guide on how I can setup replication > between my ISPs MySQL da

Re: insert records

2001-08-15 Thread Jeremy Zawodny
On Thu, Aug 16, 2001 at 01:23:15PM +0800, rsaras wrote: > > now i want to take first 2 records from Table A and insert back to > Table A with different date. What language are you programming in? Do you know how to query MySQL using it? If yes, what's the specific problem? If no, then you'll

re: deleing exactly the same rows from a table?

2001-08-15 Thread oltra jean-michel
> Hi, I am curious if there is a way to delete exactly the same rows from a > table with one query? > Or must I do select and delete one query at a time? > I accidentally parse an html file twice, and I want to keep the rows that > are distinct. bonjour, use: deletewhere some-matchi

insert records

2001-08-15 Thread rsaras
hai can anybody help me? Table A --- name date a2000/12/12 b2000/12/12 c2000/12/12 d2000/12/12 now i want to take first 2 records from Table A and insert back to Table A with different date. The result should be:- Table A --- n

Re: auto_increment vs. heap tables

2001-08-15 Thread Jeremy Zawodny
On Tue, Aug 14, 2001 at 12:05:08PM +0200, Leos Bitto wrote: > Hello, > > I am currently changing a simple PHP4-based application from > PostgreSQL 7.1 to MySQL 3.23. Welcome to MySQL, then. :-) > I have some tables in the database which I would like to create as > TYPE=HEAP in MySQL. Because I

Re: Large data in tables

2001-08-15 Thread Jeremy Zawodny
On Wed, Aug 15, 2001 at 09:25:27PM +0300, Sinisa Milivojevic wrote: > > This limit is already increased in 4.0 to 4 Gb. 4.0 will be > available next month. 4.0 will be in alpha/beta testing at that point, right? It's important not to set expections too high. :-) Jeremy -- Jeremy D. Zawodny, <

Re: NuSphere final speaks out

2001-08-15 Thread Jeremy Zawodny
On Wed, Aug 15, 2001 at 01:38:17PM -0400, Michael T. Babcock wrote: > > Does anyone know if this contract available for viewing online > anywhere? It is not. -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-59

Re: I'd like to use MySQL but actually I'm not sure ...

2001-08-15 Thread Jeremy Zawodny
On Wed, Aug 15, 2001 at 04:59:03PM -0400, Michael T. Babcock wrote: > > Or, you could write your business rules as a middleware application > in C or Python (etc.) and access that middleware to do the rest of > your application. A good idea. > Consider sending queries to your middleware and hav

Replication PROBLEM

2001-08-15 Thread Lists Servers Email
Does any know how to fix this database replication problem. Last Lines from Err File 010815 21:38:55 Slave thread exiting, replication stopped in log 'salem-bin.013' at position 6867 010815 21:38:55 Error running query, slave aborted. Fix the problem, and re-start the slave thread with "mysql

RE: Left join? Is this query possible.

2001-08-15 Thread Philip Mak
On Thu, 16 Aug 2001, Rodney Moses wrote: > Thanks for the reply Philip! > > Unfortunately that doesn't work. I should have clarified that there never > are null values in the 'amount' fields. Even if you don't have NULL values in the 'amount' fields, doing the LEFT JOIN will cause NULL values to

database,sql,query,table[**] (was: "http://lists.mysql.com/ ?!?").

2001-08-15 Thread s. keeling
Am I missing something? I just looked at this thing (General Discussion List?) from netscape and lynx. It looks like a brain dump of subject lines[*]. I clicked on threaded, same. There's some cryptic "[#]" along the left side; does that have any meaning? Is my browser just too old to do what

RE: Left join? Is this query possible.

2001-08-15 Thread Rodney Moses
Thanks for the reply Philip! Unfortunately that doesn't work. I should have clarified that there never are null values in the 'amount' fields. Maybe it is wrong to join both the payment and the order tables to the account table in the query as neither of these directly related to eachother. On

Chinese PinYin/Traditional Support in mysql?

2001-08-15 Thread FWC Stylist Hong Wong
Hi I'd like to be able to input pinyin and Big5 Chinese characters into mysql using Jive discussion forum software, e.g. I would input both English and Chinese into the same field. After reading some past postings I understand that I only need to load Chinese language support if I want to do

Re: Left join? Is this query possible.

2001-08-15 Thread Philip Mak
On Thu, 16 Aug 2001, Rodney Moses wrote: > This doesn't work, it has really wacky results: > #balance of all accounts > select a.id, (sum(o.amount) - sum(p.amount)) from > accounts as a left join orders as o on a.id = o.account_id left join > payments as p on a.id = p.account_id > group by a.

Re: NuSphere final [sic] speaks out

2001-08-15 Thread Michael Bacarella
On Wed, Aug 15, 2001 at 04:22:47PM -0500, C. Bond wrote: > I'm very sad this is all happening. But however you may feel > about NuSphere, I find it a bit unsettling that MySQL AB, as > an open-source organization, would claim a trademark in the > first place. From what I've seen, it looks like bot

Left join? Is this query possible.

2001-08-15 Thread Rodney Moses
Hi, This is probably not the right forum for this question, sorry, I'm really stuck... I need to write a query for an e-commerce system that calculates account balances. With the current database structure I can write two separate queries, one to get the sum of all payments and one to get the sum

Re: Looks like any user can read the mysql db!

2001-08-15 Thread Jose de Leon
mysqld is running as mysql == On Wed, 15 Aug 2001 17:46:58 -0400 "Vadim P." <[EMAIL PROTECTED]> wrote: > Jose-- > > Are you running mysqld as 'root'? > > Run it as 'mysql' and change the group membership of the data directory and > its contents to 'mysql'.

errors rotating logs and using phpMyAdmin

2001-08-15 Thread Daniel Woods
I have spent a week trying to resolve this, searching without success :( For the past week since an OS upgrade, the mysql log rotation fails... -- errors occured while rotating /var/lib/mysql/mysqld.log { ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed error:

Re: NuSphere final [sic] speaks out

2001-08-15 Thread ryc
[snip] > I'm very sad this is all happening. But however you may feel > about NuSphere, I find it a bit unsettling that MySQL AB, as > an open-source organization, would claim a trademark in the > first place. From what I've seen, it looks like both sides > are being equally childish. I dont thi

RE: NuSphere final speaks out

2001-08-15 Thread Carsten H. Pedersen
Everyone, please: Let's not have another round of "Let's all go bash NuSphere". Yes, I too, am interested in the case -- but let's have the details - and not least *facts* - from the people who are actually involved in this dispute. I think some of Justin Farnsworth wise words from July 18 bea

Fw: replication problems & questions

2001-08-15 Thread Neil Tompkins
Also regarding this matter, is it possible that I would on a local copy of the data on my own computer and it is then replicated automatically back to the ISP database ? Thanks Neil - Original Message - From: "Neil Tompkins" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, A

replication problems & questions

2001-08-15 Thread Neil Tompkins
Hello, I'm very new to MySQL and have posted a few mails regarding replication in mySQL. I'm still having problems ! Can someone please send me a step by step guide on how I can setup replication between my ISPs MySQL database and one I wish to have and use locally. I have already a database c

Re: Looks like any user can read the mysql db!

2001-08-15 Thread Vadim P.
Jose-- Are you running mysqld as 'root'? Run it as 'mysql' and change the group membership of the data directory and its contents to 'mysql'. Vadim. Jose de Leon wrote: > > Here are the perms on the mysql db files /var/lib/mysql/mysql > > Also, I was logged into mysql with a plain user 'jos

Re: case sensitivity issue

2001-08-15 Thread Werner Stürenburg
> I'm having trouble with what appears to be a case sensitivity issue. > Essentially, when I use the "right" case for a table name, the query fails, > but when I use the wrong case, the query succeeds. Well, it seems to depend on the system you are using. I noticed that when I created tables thro

Re: NuSphere final [sic] speaks out

2001-08-15 Thread C. Bond
At 01:38 PM 8/15/2001 -0400, Michael T. Babcock wrote: >> trademarks. In May, MySQL AB unilaterally decided the contract was no >longer >> valid, and started proceedings to take away our trademark rights. After > >Actually, the rights would belong to MySQL AB unless the contract was >drawn up hor

Re: Looks like any user can read the mysql db!

2001-08-15 Thread Jose de Leon
Can somebody running redhat using the mysql rpm provided by redhat, version 3.23.36-1, please try this and verify if it exists as a bug for you too? Thanks, Jose == On Thu, 16 Aug 2001 03:01:20 -0700 Jose de Leon <[EMAIL PROTECTED]> wrote: > This is what I

Re: I'd like to use MySQL but actually I'm not sure ...

2001-08-15 Thread Michael T. Babcock
> - transaction support (this may have been implemented through Gemini, but > the legal status of this contribution appears to be in question now) Transactions are also supported with BDB and InnoDB tables afaik ... > If you want to embed a lot of the business logic in stored or needb other of >

RE: NuSphere final speaks out

2001-08-15 Thread Philippe Paravicini
mySql.org's position (whomever they are) *** Dear Philippe: mySQL.org is a not for profit organization dedicated to promoting and further enhancing the mySQL database engine. Like all open source projects we welcome community input to help enhance the product. The MySQL AB company is a commerc

Re: NuSphere final speaks out

2001-08-15 Thread Michael T. Babcock
> That agreement also allows NuSphere to release MySQL > under the GPL license forever and print and distribute the > manual. It doesn't seem that this is what is at stake, however. Would you say that MySQL AB wishes Nusphere to stop distributing the official GPL'd distribution of MySQL? Would

Re: C and mySQL

2001-08-15 Thread Michael T. Babcock
www.mysql.com click on documentation scroll down to the C interface documentation. - Original Message - From: "Tobias Wennerberg" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 15, 2001 3:44 PM Subject: C and mySQL how do you make a connection in C?

Re: Lost mySQL password on Cobalt Qube 3

2001-08-15 Thread Stefan Hinz
Dear Chris, 1. Stop the MySQL server and restart mysqld with the --skip-grant-tables option. 2. Use the GRANT command to set up a new root user / superuser. 3. Stop the MySQL server and restart it. Manual pages: http://www.mysql.com/doc/R/e/Resetting_permissions.html and http://www.mysql.com/doc

RE: I'd like to use MySQL but actually I'm not sure ...

2001-08-15 Thread Philippe Paravicini
MySQL is pretty fast and very reliable. It's also simple to use. It supports standard ANSI-92 SQL, as far as I can tell, and the standard distribution does not have certain features such as: - triggers - stored procedures - referential integrity - transaction support (this may have been implemen

Re: INSERT problem

2001-08-15 Thread btjones
Try it like this -- SELECT @BF:=Date FROM Results WHERE GameID=1 ORDER BY Date ASC LIMIT 1; SELECT @BL:=Date FROM Results WHERE GameID=1 ORDER BY Date DESC LIMIT 1; SELECT @BF AS BF, @BL AS BL; "Mariusz Muszalski" <[EMAIL PROTECTED]> wrote: Look at this MS SQL: Declare @BF ch

RE: NuSphere final speaks out

2001-08-15 Thread Philippe Paravicini
My humble response to NuSphere, sent this morning to various and sundry of their email addresses. Please make your opinions known to NuSphere, it can't hurt. Dear Sirs: I believe that your decision to sue MySql AB, the creators of one of the most popular products to come from the Open Sour

enable log and updatel log

2001-08-15 Thread Shu Xiao
I have 2 questions: 1.How to enable log and update log with MySQL rpm installation? In /etc/my.cnf? The default installation disable them, as shown with "mysqladmin -u root -p variables" 2.In rpm installation, there is a mysqld under /etc/init.d. And to start MySQL server at booting ti

Re: difference between UnixWare binary distributions?

2001-08-15 Thread Boyd Lynn Gerber
On Wed, 15 Aug 2001, Steve Rickard wrote: > What is the difference between the 2 UnixWare binary distributions, > mysql-3.23.41-sco-sysv5uw7.1.0-i386-lcudk70.tar.gz and > mysql-3.23.41-sco-sysv5uw7.1.0-i386.tar.gz ? Which one is recommended? I > have tried both and find no obvious operational diff

C and mySQL

2001-08-15 Thread Tobias Wennerberg
how do you make a connection in C?

Trouble upgrading to mysql ver 3.23.41

2001-08-15 Thread sachin shetty
Hi i have successfully installed the 3.23.39 version of mysql. but the 3.23.41 version throws the following error when the mysqld daemon is started 010815 15:14:42 mysqld started 010815 15:14:42 Warning: setrlimit couldn't increase number of open files to more than 64 010815 15:14:42 Warning:

Lost mySQL password on Cobalt Qube 3

2001-08-15 Thread Chris Lathem
Hello all, Recently I made an attempt at setting up phpMyAdmin to allow my colleagues to interface with mySQL easily. In doing so I set a password for the root user, and placed the settings in my config file. When a new version of phpMyAdmin was released, I upgraded without backing up my old co

Re: Looks like any user can read the mysql db!

2001-08-15 Thread Andrew Schmidt
What are the permission in your /var/lib/mysql/mysql directory? here's what I get: mysql> load data local infile '/usr/local/var/db/mysql/mysql/user.MYD' into table t; ERROR: File '/usr/local/var/db/mysql/mysql/user.MYD' not found (Errcode: 13) mysql> and here is the file [dev-405:andrew] ...

Re: Looks like any user can read the mysql db!

2001-08-15 Thread Jose de Leon
Here are the perms on the mysql db files /var/lib/mysql/mysql Also, I was logged into mysql with a plain user 'jose' that had access to only his db, 'jose' grant select,insert,create,drop,delete,alter on jose.* to jose@localhost identified by 'jose'; -rw-rw1 mysqlroot

Re: Looks like any user can read the mysql db!

2001-08-15 Thread Jose de Leon
This is what I did: load data local infile '/var/lib/mysql/mysql/user.MYD' into table data; At first I did it without the 'local' keyword. But with 'local' keyword it works. == On Wed, 15 Aug 2001 14:51:44 -0400 "Andrew Schmidt" <[EMAIL PROTECTED]> wrote:

Re: Looks like any user can read the mysql db!

2001-08-15 Thread Andrew Schmidt
I'm not sure how you were able to do that. Especially since you didn't provide exactly what you did. But here's what I get as ROOT (all privileges): mysql> load data infile '/usr/local/var/db/mysql/mysql/user.MYD' into table t; ERROR 1085: The file '/usr/local/var/db/mysql/mysql/user.MYD' must

Re: Table size limitations...

2001-08-15 Thread Nathanial Hendler
On Wednesday 15 August 2001 11:30, Dan Nelson wrote: > In the last episode (Aug 15), Nathanial Hendler said: > > I have a table that holds a lot of information. I tried to INSERT > > something into it, and received... > > > > DBD::mysql::st execute failed: The table 'fancy_big_table' is full at >

Re: Table size limitations...

2001-08-15 Thread Dan Nelson
In the last episode (Aug 15), Nathanial Hendler said: > I have a table that holds a lot of information. I tried to INSERT > something into it, and received... > > DBD::mysql::st execute failed: The table 'fancy_big_table' is full at > ./tom_to_mutt.pl line 156. > > The table is 4G is size. Th

Re: Lots of spawning Mysql processes and one that won't die?

2001-08-15 Thread Ed Carp
Ryan Shrout ([EMAIL PROTECTED]) writes: > PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND= > =20 > 24424 mysql 18 0 6116 6116 2196 R99.9 0.5 4:05 mysqld = > This is after a mysqld restart -- It restarted, but didn't work because = > this single

Re: MySQL and multiple CPUs

2001-08-15 Thread Sinisa Milivojevic
Kevin writes: > > Does MySQL running on Solaris take advantage of multiple CPUs? > Yes, automatically ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/

Re: Large data in tables

2001-08-15 Thread Sinisa Milivojevic
Trevor Linton writes: > I'm researching whether it is possible to store large amounts (30-70MB > files) into mysql columns. It looks as if a LONG BLOB could handle this, > however I read that the communications buffer size can only support up to 16 > MB transfers. It also said that you could inc

Re: MySQL + VB problem

2001-08-15 Thread Doc
hey Mariusz what i usually do is like this: Set SQL1 = conn.execute("select * from tbl_blah") Set SQL2 = conn.execute("select count(*) as hops from tbl_pong where row_poof='&SQL1("blah")&'") and so forth - Doc " database sql query table < -- as requested " > I try to execute mySQL query f

Re: Adding & editing tables

2001-08-15 Thread Sinisa Milivojevic
Ray Gurganus writes: > I am running MySQL 3.23.39, and I just installed MySQL GUI 1.7.5-1, running > on Windows 2000. I have several databases already loaded, and have a table > chosen. In the GUI, when I go to the menu commands or hotkeys to create > tables or edit tables, I get no response. A

Looks like any user can read the mysql db!

2001-08-15 Thread Jose de Leon
MySQL 3.23.36 Using the LOAD DATA command, I was able to read the first field of user.MYD. I think I should be able to load the rest of the table with a little bit of playing around... I think with a little bit of ingenious delimeter specification, etc, anybody should be able to load any tabl

Error with mysql_install_db

2001-08-15 Thread Alex Cook
I'm attempting a source installation of mysql-3.23.40 on a Solaris 7 SPARC server. the compile process completed without any errors. After reading the various docs, I located the mysql_install_db script and executed it. When running the mysql_install_db script, I recieve the following error

Re: Table size limitations...

2001-08-15 Thread ryc
Look into MAX_ROWS... ie: alter table mytable max_rows = 1 ryan - Original Message - From: "Nathanial Hendler" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Wednesday, August 15, 2001 12:19 PM Subject: Table size limitations... > > I have a table that holds a lot o

RE: Table size limitations...

2001-08-15 Thread Trevor Linton
I'm not an SQL expert but if FreeBSD supports > 4GB files than you should check your "MAX_DATA_LENGTH" properties on the table you're using. You can do this by running SHOW TABLE STATUS on the table. I believe you can use ALTER (or on create table statements) to change this value. Hope this helps

case sensitivity issue

2001-08-15 Thread Alex Pukinskis
I'm having trouble with what appears to be a case sensitivity issue. Essentially, when I use the "right" case for a table name, the query fails, but when I use the wrong case, the query succeeds. Here's my table list: mysql> show tables\g ++ | Tables_in_ac | ++

MySQL and multiple CPUs

2001-08-15 Thread Kevin
Does MySQL running on Solaris take advantage of multiple CPUs? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this threa

RE: MySQL + VB problem

2001-08-15 Thread Michael Widenius
hi! > "Venu" == Venu <[EMAIL PROTECTED]> writes: Venu> Hi ! Venu> MySQL doesn't support sub-queries/selects yet, will be supported from 4.x Venu> version onwards. Venu> Please read the following link for more information about the missing Venu> functionality and how you can make it up. Ve

Re: NuSphere final speaks out

2001-08-15 Thread Michael T. Babcock
> trademarks. In May, MySQL AB unilaterally decided the contract was no longer > valid, and started proceedings to take away our trademark rights. After Actually, the rights would belong to MySQL AB unless the contract was drawn up horribly. > past June, to give us back the trademark rights we h

Large data in tables

2001-08-15 Thread Trevor Linton
I'm researching whether it is possible to store large amounts (30-70MB files) into mysql columns. It looks as if a LONG BLOB could handle this, however I read that the communications buffer size can only support up to 16 MB transfers. It also said that you could increase the size of the buffer,

Re: How to make this code pretty?

2001-08-15 Thread s. keeling
On Wed, Aug 15, 2001 at 11:30:44AM -0400, Philip Mak wrote: > I've had an ongoing problem where the SQL statements in my perl programs > come out rather messily. > > Does anyone have specific and general suggestions on how to write embedded > SQL code cleanly in perl programs? Here's an example o

Table size limitations...

2001-08-15 Thread Nathanial Hendler
I have a table that holds a lot of information. I tried to INSERT something into it, and received... DBD::mysql::st execute failed: The table 'fancy_big_table' is full at ./tom_to_mutt.pl line 156. The table is 4G is size. The table's Max_data_length = 4294967295 (4G) I'm running the MySQL

Re: Setting up and running mySQL on a unix server

2001-08-15 Thread Josh Burroughs
On Wed, 15 Aug 2001 [EMAIL PROTECTED] wrote: > How easy/hard is it install and run mySQL on a unix server? Depends on how you would answer this question: "How easy/hard is it to run a Unix server?" ;-> If you're confortable using Unix and installing software then I think you'll find the basic i

I'd like to use MySQL but actually I'm not sure ...

2001-08-15 Thread Nexus Terminator
Hello: I'd like to know how good MySQL is, also what SQL extension it uses (like T-SQL, PL-SQL or something else?). Any comment will be appreciated _ Do You Yahoo!? Obtenga su dirección de correo-e gratis @yahoo.com en http://correo.espano

Re: Setting up and running mySQL on a unix server

2001-08-15 Thread Dan Makovec
Most likely very hard, if you don't RTFM first :) d - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 15, 2001 11:40 PM Subject: Setting up and running mySQL on a unix server > How easy/hard is it install and run mySQL on a unix server? > >

NuSphere final speaks out

2001-08-15 Thread David Price
News from NuSphere -- #8This came from the NuSphere newsletter sent today. I would like hear from MySQL AB on this issue again since nothing has been said since the two company meet. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 1

difference between UnixWare binary distributions?

2001-08-15 Thread Steve Rickard
What is the difference between the 2 UnixWare binary distributions, mysql-3.23.41-sco-sysv5uw7.1.0-i386-lcudk70.tar.gz and mysql-3.23.41-sco-sysv5uw7.1.0-i386.tar.gz ? Which one is recommended? I have tried both and find no obvious operational difference. Thanks, Steve [EMAIL PROTECTED] -

Build problems with BerkeleyDB

2001-08-15 Thread Jeff Hinds
While attempting to build MySQL from the source distribution, I have received the following message from the configuration utility. checking for BerkeleyDB... supplied configure: error: didn't find valid BerkeleyDB: invalid version 3.3.11 (must be version 3.2.3h or ) We

DEC OSF Replication Problem

2001-08-15 Thread wsmoore
To the contributing party of the following builds: 3.23.33 - DEC OSF (Alpha) [dec-osf5.1-alphaev6] 3.23.38 - DEC OSF (Alpha) [dec-osf5.1-alphaev6] Have you or anyone else used these versions for replication? I cannot seem to start the mysql server for the slave after setting up everything acco

Re: nested if statements allowed?

2001-08-15 Thread Benjamin Pflugmann
Hi. On Tue, Aug 14, 2001 at 01:31:04PM -0700, [EMAIL PROTECTED] wrote: > I am trying to do a nested if, but it appears to break my query... > Here is a sample of what I am trying to, basically validating email > addresses out of a db: > > select IF( (LENGTH( emailaddr ) <= 1 || > NOT LOCATE( "

Re: SELECT MIN(field) takes minutes on a large table!

2001-08-15 Thread Benjamin Pflugmann
Hi. On Tue, Aug 14, 2001 at 10:41:16PM +0930, [EMAIL PROTECTED] wrote: > Hi Heitzso, > > Thanks for your suggestion, and in the absence of feedback from anybody else > I suspect you're probably right. The system this thing is running on is a > vastly outdated P150 with 128MB. With 128MB, you t

RE: MySQL + VB problem

2001-08-15 Thread Mariusz Muszalski
my question was not about subqueries Mariusz Muszalski > -Original Message- > From: Venu [mailto:[EMAIL PROTECTED]] > Sent: 15 August 2001 16:29 > To: Mariusz Muszalski; [EMAIL PROTECTED] > Subject: RE: MySQL + VB problem > > > Hi ! > > MySQL doesn't support sub-queries/selects y

How to make this code pretty?

2001-08-15 Thread Philip Mak
I've had an ongoing problem where the SQL statements in my perl programs come out rather messily. Does anyone have specific and general suggestions on how to write embedded SQL code cleanly in perl programs? Here's an example of an ugly piece of SQL statement I wrote recently: $dbh->do ("REPLA

RE: MySQL + VB problem

2001-08-15 Thread Venu
Hi ! MySQL doesn't support sub-queries/selects yet, will be supported from 4.x version onwards. Please read the following link for more information about the missing functionality and how you can make it up. http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html# Missing_Sub

Adding & editing tables

2001-08-15 Thread Ray Gurganus
I am running MySQL 3.23.39, and I just installed MySQL GUI 1.7.5-1, running on Windows 2000. I have several databases already loaded, and have a table chosen. In the GUI, when I go to the menu commands or hotkeys to create tables or edit tables, I get no response. Am I missing a step? Or is it

Problems starting the MySQL server.

2001-08-15 Thread Paul Carter
I just installed mysql-3.23.36-1.i386.rpm, mysqlclient9-3.23.22-4.i386rpm and mysql-server-3.23.36-1.i386rpm over Redhat 7.1. I followed instructions both in Redhat's manual and www.mysql.com/doc/P/o/Post-installation.html. following links to and reading 2.4.2 Problems Starting the MySQL Server

RE: Case sensitive

2001-08-15 Thread Don Read
On 15-Aug-2001 Järkeborn Joacim wrote: > Hi, > > I have the table: > > CREATE TABLE WI_TEXTLISTUS ( > TEXTID VARCHAR(50) NOT NULL, > COUNTRY VARCHAR(2) NOT NULL, > LANGUAGEVARCHAR(3) NOT NULL, > TEXTVARCHAR(250), > PRIMARY KEY (TEXTID,COUNTRY,LANGUAGE)

MySQL + VB problem

2001-08-15 Thread Mariusz Muszalski
I try to execute mySQL query from VB: strSQL = "SELECT @BF:= Date From Results Where GameID=" & GameID & " Order by Date ASC LIMIT 1;" strSQL = strSQL & "SELECT @BL:= Date From Results Where GameID=" & GameID & " Order by Date DESC LIMIT 1;" strSQL = strSQL & "SELECT @BF as BF, @BL as BL;" Set R

Setting up and running mySQL on a unix server

2001-08-15 Thread Wizcom781
How easy/hard is it install and run mySQL on a unix server? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail

Re: imigration of db from server 2 localhost as backups

2001-08-15 Thread Werner Stuerenburg
use mysqldump, i.e. if you are in your data dir /usr/local/mysql/bin/mysqldump -c -h localhost -u user_name -p db_name | gzip -9 > db_name.sql.gz hanan khader schrieb am Mittwoch, 15. August 2001, 09:02:49: > Hi everybody ... > I need ur help urgently in this: how can we make imigration of da

An E-mail account for 2 years, 5 years, for life ? Avenger Mail System is for you !

2001-08-15 Thread ams
Hello, I will like to present you, very quickly, with a new Internet service that i will be putting on line in a few days. Do you want an account Mail independent of your FAI or ISP ? What ever your reasons, Avenger Mail System is for you. Avenger mail System is like Msn, Hotmail, etc . . . ht

MySQL Multi-Table Select Query Problem

2001-08-15 Thread Charles Williams
Hey folks, I'm new to the list and already have a problem. if you go to http://www.acnsnet.com/czc/show.php?state=Bayern You can see my problem with this query. This thing is killin me so if you have any ideas just shout. thanks, chuck Chuck's Top 10 Things to Remember and Think about! =

Re: Local Sockets vs TCP

2001-08-15 Thread Hans Zaunere
> > And I was thinking, since a socket is a socket (just a file descriptor) > NO - a socket is not a file descriptor, > something like a communication end/handshake point > read more > http://orkinos.cmpe.boun.edu.tr/netlab/courses/cmpe476/netprog/SocketsFAQ.txt > Sure they are file descriptors,

Re: FreeBSD4.3 && Mysql3.23.40 - problems with start-up

2001-08-15 Thread Ken Menzel
Hi Jon, My guess is you installed from the freebsd ports, which should have setup your ( ' /usr/local/mysql_install_db') but since this is a fresh install try running is again to make sure. The at the command line enter: /usr/local/bin/safe_mysqld& If it gives and error message check the 'my-

RE: SELECT .. OR from multiple tables

2001-08-15 Thread Eric Anderson
> >> How about a UNION query...? > > >Too bad MySQL doesn't support them yet ;) > > Oops...sorry...I see it is on the TODO list. > > Would a MERGE table not achieve the same result as a UNION query? It > appears that a MERGE table acts like a VIEW. > > Eric if your Current and Temporary tables ha

Re: FreeBSD4.3 && Mysql3.23.40 - problems with start-up

2001-08-15 Thread Jon Cheng
Hello all, I reinstalled mysql3.23.40 server twice on freebsd 4.3, and I am still having the problem that mysqld would not load up just after booting. I ran safe_mysqld& as root, and then it loaded fine. I checked that /usr/local/etc/rc.d/mysql-server.sh exists, but it is not loading for some re

Re: SunUltra-60 compiler problem!!

2001-08-15 Thread Sinisa Milivojevic
Hi, When I install mysql that occur something error on solaris. attachments for you reference: Hardware Spec. Generic_105181-19 sun4u sparc SUNW,Ultra-60 CPU: 450Mhz *2 RAM: Memory: 2048M H.D: 18G *2 Soft Spc. SunOS i2dev 5.6 Mysql 3.23.41 error message as below: ---

Case sensitive

2001-08-15 Thread Järkeborn Joacim
Hi, I have the table: CREATE TABLE WI_TEXTLISTUS ( TEXTID VARCHAR(50) NOT NULL, COUNTRY VARCHAR(2) NOT NULL, LANGUAGEVARCHAR(3) NOT NULL, TEXTVARCHAR(250), PRIMARY KEY (TEXTID,COUNTRY,LANGUAGE), INDEX TEXTLISTUS_X1 (TEXT) ); and when

Re: gcc 2.95.3 compile failure -"sql_lex.cc: In function `void lex_init()':"

2001-08-15 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: > >Description: > > I am using the recommended ./configure options as specified by: > http://www.mysql.com/doc/S/o/Solaris.html. I am unsure how to > specifiy the GNU ld - the output from ./configure shows that I am > using the Solaris ld. Perha

backup db from server into localhost

2001-08-15 Thread hanan khader
HI there, Iam looking for an answer for this problem, I want to imigrate database as backups from the server to localhost, how can this be accomplished ? Yours: Hanan M. Khader _ Get your FREE download of MSN Explorer at http://e

Re: Fulltext problem with '.'

2001-08-15 Thread Sergei Golubchik
Hi! On Aug 15, Martin Kjeldsen wrote: > Hi, > > if you use the fulltext to search for words like "internet.com" my > search allways fails. The reason for is as far as I know that the > dot (".") is used by the parser as a word separator at least when > making the index. > > The easy way to sol

Re: Upgrading

2001-08-15 Thread Irmund Thum
Am Mittwoch, 15. August 2001 12:26 schrieb Ralf R. Kotowski: > Hi, > > I'm currently runnig RH 6.2 and I'm considering upgrading to RH7.1 > I'm planning on whiping the HD's completely and start from scratch > and then install the latest RPM's from MySQL's site. > > The question is what would be th

Re: MySQL 3.23.41 has invalid asm constrainst

2001-08-15 Thread Sinisa Milivojevic
Trond Eivind Glomsrod writes: > >Description: > > mysql 3.23.41 doesn't build properly on IA32 with assembly and innobase enabled. > 3.23.40 didn't have this problem > > Configure statement in spec file ("%configure" is a standard rpm macro, specifying > CFLAGS and CXXFLAGS and various prefixes

  1   2   >