Re: Can't run the mysql deamon on linux

2001-08-28 Thread Grigory Bakunov
Date |Tue, 28 Aug 2001 03:16:59 -0230 (NDT) From |Neil Zanella [EMAIL PROTECTED] Hello! NZ RedHat 7.1 users: NZ The command used to start mysqld on this platform is simply (as root): NZ # /etc/init.d/mysqld start NZ This is _all_ that is required. NZ Once that works you can set NZ the

Re: Select in groups of 5

2001-08-28 Thread Grigory Bakunov
Date |Mon, 27 Aug 2001 18:32:57 -0500 From |Tyler Longrne [EMAIL PROTECTED] Hello! TL Hello everyone, TL Is there any way to make selections in groups of 5. I want to get 5 record TL sets at a time until we get to a point that there's 4 or less records. TL Thank you everyone, TL Tyler TL

reports? from MySQL

2001-08-28 Thread get86
hello. with a lot of help from many of you and some very nice folks, i have been able to build some example/experiment/'mess around' type of dbs. yay. i'd like to ask... if any of you are familar with (File Maker Pro, most recent versions)... how does one go about using MySQL to create a

Re: MySQL+InnoDB

2001-08-28 Thread Grigory Bakunov
Date |Mon, 27 Aug 2001 18:16:43 -0400 From |alexus [EMAIL PROTECTED] Hello! A hi A i'm trying to setup mysql w/ InnoDB A i followed all steps from http://www.mysql.com/doc/I/n/InnoDB_start.html A and i'm end up with this in my log every time i run mysql and in addition it A ends A here is

Re: msg board with efficient threaded view design?

2001-08-28 Thread Grigory Bakunov
Date |Mon, 27 Aug 2001 14:14:22 -0700 From |PR [EMAIL PROTECTED] Hello! P I was wondering if anyone could point me to a message board (perl or php) P that has a very efficient database design to handle threaded views. I know P that this is a difficult task under mysql and have seen the threads

Re: image data type

2001-08-28 Thread Grigory Bakunov
Date |Mon, 27 Aug 2001 15:31:26 -0700 From |John Meyer [EMAIL PROTECTED] Hello! JM At 09:15 AM 8/28/01 +1200, you wrote: Hi there, I treat image data type as text, does anyone know how to insert an image into the table? JM the image data type is actually a BLOB, not text. Usually, it's more

Updating auto_increment ID Column/Selecting Duplicate Rows

2001-08-28 Thread Tom Churm
hi, i have 2 questions that i badly need answered. i use phpmyadmin, but any answers containing SQL syntax should work in this app... 1) this should be simple but i don't know it. i use the following mysql table field as the Key for my tables: id int(10) unsigned NOT NULL auto_increment,

Re: Need Help Setting Up MySQL on Win98

2001-08-28 Thread Grigory Bakunov
Date |Mon, 27 Aug 2001 12:54:25 -0700 (PDT) From |S K Bryan [EMAIL PROTECTED] Hello! SKB Hello - SKB I'm very new at this, so please pardon the very beginner questions... SKB I'm attemtping to install MySQL to my local machine running Win98. The SKB install seems to go alright, but when I try

Help with blobs

2001-08-28 Thread Doug
Hi All, can someone point me in the right direction for saving formatted RichEdit Text to a blob field and then loading the RichEdit field with the data from the blob. I am using Borland Builder 5 odbc to MySQL database. Regards Doug [EMAIL PROTECTED]

Need info

2001-08-28 Thread Nilesh Keshavji Parmar
Hello Everybody :-) Well, I just suscribed to the mailing lists and would like to know a few more things about mysql. I have heard a lot about it and i think i will enjoy learning it a lot. I would be glad if anyone could care answering to my query. what is mysql most usefull for ,i mean

RE: Need info

2001-08-28 Thread Simon Green
Hi Nilesh MySQL is very fast but has not got all the things SQL can have (this is for speed). So we use it for web sites and for authenticating users over radius. Simon -Original Message- From: Nilesh Keshavji Parmar [mailto:[EMAIL PROTECTED]] Sent: 28 August 2001 09:05 To: [EMAIL

Re: unique()

2001-08-28 Thread Grigory Bakunov
Date |Sat, 25 Aug 2001 00:24:07 +0200 From |Boaz Yahav [EMAIL PROTECTED] Hello! BY Hi BY I have a table with a filed that is unique (used unique() in the BY creation). BY how do I undo this unique()? unique is an index property. Just remove them by ALTER TABLE command

Re: ERROR: Lost connection to MySQL server during query

2001-08-28 Thread Grigory Bakunov
Date |Fri, 24 Aug 2001 14:08:43 -0400 (EDT) From |boulat [EMAIL PROTECTED] Hello! B Hi group, B Im using the latest mySQL 3.23.41, ever since I installed the new B version I've been getting Lost connection to MySQL server during query B 50% of the time on my mySQL server. I have a load

Re: Error: 6 (Errcode: 13)

2001-08-28 Thread Grigory Bakunov
Date |Fri, 24 Aug 2001 14:09:20 -0500 From |Tyler Longren [EMAIL PROTECTED] Hello! TL DROP TABLE Track TL Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13) TL Anyone know what that means? As you can see, it came from tryign to do a TL DROP on a table. TL Thanks, TL Tyler

Re: Max table size in MySQL on Redhat 7.0 be default

2001-08-28 Thread Grigory Bakunov
Date |Fri, 24 Aug 2001 10:29:53 -0700 From |Benjamin Arai [EMAIL PROTECTED] Hello! BA What is the maximum table size allowed by MySQL and Redhat 7.0 be default? BA Benjamin Arai Read about it here: http://www.mysql.com/doc/T/a/Table_size.html

Re: MySQL and GPL license: questions and discussion

2001-08-28 Thread Sinisa Milivojevic
Neil Zanella writes: 1. What was the name of the first GPL file release of MySQL? 3.23.xx 2. Which portions are not distributed by mysql.com as part of MySQL? All are. 3. Which portions of the Windows MySQL release are not released under the GPL if any? For instance is the

Equivalent as UNION (Oracle)

2001-08-28 Thread Järkeborn Joacim
Hi, We have Oracle SQL statements that uses UNION is there an equivalent for this in mySQL? // Jocke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Re: ezmlm response

2001-08-28 Thread Ute Hoffmann
Hi all, I work with mysql 3.23.40 on Mac Os X 10.0.x and have created a Database. This Database has to move to another mysql server 3.23.40 on a Mac OS X Server. In older versions (up to 3.23.39 I think) it was sufficient to create an empty database on the destination machine and just copy and

SQL syntax near 'IDENTIFIED BY'...

2001-08-28 Thread Alexander Barkov
Hello! These query produces an SQL syntax error in 3.23.29a-gamma: GRANT ALL PRIVILEGES ON databases.* TO 'foo'@'localhost' IDENTIFIED BY 'bar'; SHOW TABLES FROM databases; Probably this is because of databases is a keyword. However, mysqladmin does allow to create database

More info

2001-08-28 Thread Alexander Barkov
Sorry, It was a little mistake in my previous letter. mysqladmin create databases does not output any error messages, however it does not create database databases. However, mysqladmin drop databases produce this: /usr/local/mysql/etc/ access.grant mysqladmin drop databases Dropping the

Re: Equivalent as UNION (Oracle)

2001-08-28 Thread Rafal Jank
Jrkeborn Joacim wrote: Hi, We have Oracle SQL statements that uses UNION is there an equivalent for this in mySQL? Not yet. It should be in version 4.0 -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA

autoincrement

2001-08-28 Thread sean . odonnell
When you have just inserted a record into a table that autoincrements the primary key, is there a way of retrieving the id assigned at the same time? I'm using ASP to write the code in question , and I'm trying to find a better solution that looking at the max key value just before/after in

Problem: MERGE tables for different databases

2001-08-28 Thread Alexander Barkov
HEllo! Is it possible to create a merge table for tables from different databases. I wrote this script for database collection: CREATE TABLE dict ( url_id int(11) DEFAULT '0' NOT NULL,

strange problems with MySQL db

2001-08-28 Thread Wintercom New Media
Hello list. I am having strange problems with my Tables since the partition had been running out of space and mysql crashed. I repaired all the tables and thought it was a success (no errors were detected anymore) but some days later there was an error in another table and I fixed it but

Re: MySQL Still a wise choice for developers?

2001-08-28 Thread Ilya Martynov
Let me add my $.02 CHP A) There's no *point* in keeping the image in the database. CHP A DBMS is all about searching, comparing, relations, etc. You CHP get *none* of these by storing the image data in the DB. Sometimes it just easier to store all things in same place. Right now I working on

query

2001-08-28 Thread muruganandam
for a particular query i have to select data from five tables. can any one suggest me a best way to do that in terms of performace.. thanks in advance muruganandam - Before posting, please check:

Re: autoincrement

2001-08-28 Thread Ian Barwick
On Tuesday 28 August 2001 12:36, [EMAIL PROTECTED] wrote: When you have just inserted a record into a table that autoincrements the primary key, is there a way of retrieving the id assigned at the same time? I'm using ASP to write the code in question , and I'm trying to find a better

Deleted mysql.host Table!

2001-08-28 Thread Steffen Hainke
Hallo, i'm new to mysql. I delete a mysal.host table. Does it means i can't access the rest of my tables in the database? If so, can i rebuild this table or is there another way, to access the rest of the tables? I'am running MySQL under Linux. Thank's for Comment's, Help ... Steffen

Re: autoincrement

2001-08-28 Thread Ian Barwick
On Tuesday 28 August 2001 13:55, Harald Fuchs wrote: In article 01082813314101.11299@redgrave, Ian Barwick [EMAIL PROTECTED] writes: You mean using SELECT LAST_INSERT_ID() ? and praying no other query was run at the same time. Try locking the table for writes just before your

autoincrement

2001-08-28 Thread sean . odonnell
When you have just inserted a record into a table that autoincrements the primary key, is there a way of retrieving the id assigned at the same time? I'm using ASP to write the code in question , and I'm trying to find a better solution that looking at the max key value just before/after in

Feature suggestion

2001-08-28 Thread Alexander Barkov
Hello! Currently replication is implemented between two mysqld. I would like to suggest new feature. Make it possible for two mysqld to exchange data between each other. For example, MERGE tables distributed between two machines. Question to authors. How do you think, will it ever be

Re: Error: 6 (Errcode: 13)

2001-08-28 Thread Gerald Clark
It means mysql does not have write permission on the sports directory. Grigory Bakunov wrote: Date |Fri, 24 Aug 2001 14:09:20 -0500 From |Tyler Longren [EMAIL PROTECTED] Hello! TL DROP TABLE Track TL Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13) TL Anyone know what

RE: Feature suggestion

2001-08-28 Thread Simon Green
See V 4 -Original Message- From: Alexander Barkov [mailto:[EMAIL PROTECTED]] Sent: 28 August 2001 14:13 To: [EMAIL PROTECTED] Subject: Feature suggestion Hello! Currently replication is implemented between two mysqld. I would like to suggest new feature. Make it possible for two

MYSQL Stops for no reason

2001-08-28 Thread Michael Fontbin
Hello all Please if could someone help, I am running MYSQL to record print transactions at my company..the way I have set this up is by after a print job has completeda bat file is run whih basically says...go and insert into the table the following values Now on more than 1 occasion the

Re: strange problems with MySQL db

2001-08-28 Thread Gerald Clark
When the temp directory runs out of space, the thread executing will wait for space to become free. If you kill the server, this client has not closed the table properly. How do you determine that the server crashed ? If it stopped responding, maybe it is just waiting for space to become

limits to volume handled by MySQL

2001-08-28 Thread Bernard-Olivier Clist
Hi there We are switching to a MySQL 3.23.38 on a PIII 933 MHz machine running with a FreeBSD and a web Apache server 1.3.19 . The hosting company has just argued MySQL cannot handle more than 1Go in database files opened per session. Is it true ? If so how to go over that 1Go limit ? ( :-) yes

Re: MySQLgui problems

2001-08-28 Thread Stefan Murariu
[EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire

Re: Updating auto_increment ID Column/Selecting Duplicate Rows

2001-08-28 Thread Gerald Clark
Tom Churm wrote: hi, i have 2 questions that i badly need answered. i use phpmyadmin, but any answers containing SQL syntax should work in this app... 1) this should be simple but i don't know it. i use the following mysql table field as the Key for my tables: id int(10)

design

2001-08-28 Thread Mallikarjuna Rao N
Hi Is there any design document available of the complete architecture of the mysql database. I wanted to try out small changes . I want to make sure that it does not effect any transactions or anythings like that in any way. mallik --

MySQLGUI Version 1.7.5 Question and Comment

2001-08-28 Thread Marion Berryman
I've been trying out MySQLGUI Version 1.7.5, and it seems to work fine on my Win 98SE client. I do have a question about the menu entries under Commands, Tables for Edit table and Create tables. I've searched through the help file and didn't find any mention of these two menu entries, and

Re: limits to volume handled by MySQL

2001-08-28 Thread Sergei Golubchik
Hi! On Aug 28, Bernard-Olivier Clist wrote: Hi there We are switching to a MySQL 3.23.38 on a PIII 933 MHz machine running with a FreeBSD and a web Apache server 1.3.19 . The hosting company has just argued MySQL cannot handle more than 1Go in database files opened per session. Is it

RE: Updating auto_increment ID Column/Selecting Duplicate Rows

2001-08-28 Thread Daniel Von Fange
This would give you a list of all users that have entered things more than once; However, it would not give you all the rows that are duplicated. SELECT Count(User) from mail_form2 GROUP BY User HAVING Count(User) 1 Hope this helps! Daniel Von Fange

Maximum number of keys

2001-08-28 Thread joseph . bueno
Hello, According to MySQL documentation (Chap. 7.1 MyISAM Tables): Maximum number of keys/table is 32 as default. However when I try to create more than 16 keys, I get: ERROR 1069 at line 1: Too many keys specified. Max 16 keys allowed This table is of MyISAM type. I am currently running

Trying to build MySQL 3.23.39 on LynxOS 3.1.0

2001-08-28 Thread Mott Brian-P28702
Hello, I'm trying to build MySQL 3.23.39 for a LynxOS 3.1.0 platform. I believe that I only need the client, and have selected the no-server options. However, when trying to run make it bombs out in the client directory due to the sql_string.cc file which has declared an include for

Roles

2001-08-28 Thread John Meyer
In Oracle, I remember working with roles that I could assign to a user. Is there such a mechanism, or are there plans to implement such a mechanism, in MySQL. - Before posting, please check:

Please..Desperate for Help |||||||

2001-08-28 Thread nrwalker
I am trying to install the dbf2mysql converter and really getting a headache. Someone told me that I need to install the Include files and libraries for MySQL and I have been searching frantically all over the web for the source for this. All I have been able to find is the RPM's. I am on Mac

mySQL

2001-08-28 Thread Thomas Ekegren Christensen
Hi mySQL, I have a huge problem and unfortunately my Domain Hosting Services has no interest in helping me. I am running mySQL with ASP and use a DSN-less call to connect to mySQL. The problem is a little bit weird because running the query using phpmyadmin gives me a perfect recordset.

Re: Roles

2001-08-28 Thread Kurt Hansen
In Oracle, I remember working with roles that I could assign to a user. Is there such a mechanism, or are there plans to implement such a mechanism, in MySQL. This sounds a lot link granting a user certain privileges. Here's the part of the documentation that talks about this:

Re: Roles

2001-08-28 Thread John Meyer
At 09:57 AM 8/28/01 -0700, you wrote: In Oracle, I remember working with roles that I could assign to a user. Is there such a mechanism, or are there plans to implement such a mechanism, in MySQL. This sounds a lot link granting a user certain privileges. Here's the part of the

Re: problems compiling on FreeBSD 3.3 (mysql-3.23.41)

2001-08-28 Thread Angel Behar
I just update the gcc version and still the same problem : absa# gcc -v Reading specs from /usr/local/lib/gcc-lib/i386-unknown-freebsd3.3/3.0.1/specs Configured with: ../configure --enable-languages=c++ Thread model: posix gcc version 3.0.1 Any Ideas ? thanks - Original Message -

Re: reports? from MySQL

2001-08-28 Thread Dana Powers
linking tables via MyODBC + MS Access works great for me. dpk - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 28, 2001 12:06 AM Subject: reports? from MySQL hello. with a lot of help from many of you and some very nice folks, i have been

Drop Down Boxes

2001-08-28 Thread Webmaster Odell
HI We are trying to populate a form drop down box (HTML) with a column from our database. What is the query that will get us that without repeating the items (in the 500 or so records this column has only 12 non-repeated items) Thanks. Kevin Pottie Internet Designer O'Dell Web Design

Re: Drop Down Boxes

2001-08-28 Thread Cal Evans
Select Distinct. Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Webmaster Odell [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Tuesday, August 28, 2001 04:56 Subject: Drop Down Boxes HI We are trying to populate a form drop down

Re: Drop Down Boxes

2001-08-28 Thread Jeremy Zawodny
On Tue, Aug 28, 2001 at 02:56:13PM -0700, Webmaster Odell wrote: We are trying to populate a form drop down box (HTML) with a column from our database. What is the query that will get us that without repeating the items (in the 500 or so records this column has only 12 non-repeated items)

MySQL Error Codes

2001-08-28 Thread A. Clausen
I'm developing some MySQL applications using VB6 and ADO, and need to do some work on error handling. I can get the error code easily enough from ADO's Error collection, but is there a list of error codes and their descriptions. I've been doing this by generating errors and seeing what codes

Re: reports? from MySQL

2001-08-28 Thread j.urban
If you're accessing via Windows, you can use MyODBC and a reporting package such as Crystal Reports or Quick Reports or just about any ODBC-compliant reporting package. You should also be able to link MS Access to your MySQL database... For simple reports where you just want to print some data,

Re: MySQL Error Codes

2001-08-28 Thread Gerald Clark
Check the source. include/mysqld_error.h A. Clausen wrote: I'm developing some MySQL applications using VB6 and ADO, and need to do some work on error handling. I can get the error code easily enough from ADO's Error collection, but is there a list of error codes and their descriptions.

BDB questions

2001-08-28 Thread Sheena Sidhu
Greetings everyone! I had 2 questions related to using BDB and mysql. I don't see any startup options for BDB, so can I safely assume that there are'nt any , so don't need a my.cnf file? Also, how do I specify 'autocommit off' every time BDB starts, instead of specifying it

dbf2mysql problem please help

2001-08-28 Thread Armando Cerna
I have problems only converting certain DBF files to mysql with dbf2mysql. Some work but some don't and when they dont' I get the following error bash-2.05$ dbf2mysql -d maria -t cusine -c -P pass -U user CUSINE.DBF Error creating table! Detailed report: You have an error in your SQL syntax

RE: dbf2mysql problem please help

2001-08-28 Thread Venu
Hi !!! )-Original Message- )From: Armando Cerna [mailto:[EMAIL PROTECTED]] )Sent: Tuesday, August 28, 2001 1:27 PM )To: [EMAIL PROTECTED] )Subject: dbf2mysql problem please help ) ) )I have problems only converting certain DBF files to mysql with )dbf2mysql. )Some work but some don't and

Progress indicator in a query

2001-08-28 Thread Pires Claudio
Hi guys, could anybody help me? I have a very big database. When I make querys to my database, depends on the type of query, it takes a lot of time. I want to implement a progress indicator. Is there any way to implement something like this? Thanks Claudio P.

What is Pupport ? :)

2001-08-28 Thread Sam Masiello
Not really a MySQL question, but it is related to the MySQL web site If I go to: http://www.mysql.com/udmsearch/search.php the Support link is spelled Pupport (on other pages it is spelled correctly, however)whoops :) --Sam Sam Masiello Software Quality Assurance Engineer (providing

Re: What is Pupport ? :)

2001-08-28 Thread Jeremy Zawodny
On Tue, Aug 28, 2001 at 05:10:17PM -0400, Sam Masiello wrote: Not really a MySQL question, but it is related to the MySQL web site I forwarded it to [EMAIL PROTECTED], which is where that sort of thing should go... Few folks on this list have any control of MySQL's web site. Jeremy --

Re: fwd: What is Pupport ? :)

2001-08-28 Thread Matt Wagner
Hi, Damn you guys are fast! :) Fixed. But the udmsearch is busted right now for unknown reasons. I will fix shortly. Matt Jeremy Zawodny writes: FYI... - Forwarded message from Sam Masiello [EMAIL PROTECTED] - From: Sam Masiello [EMAIL PROTECTED] To: MySQL General

show create table URGENT

2001-08-28 Thread Martin Jeremic
This is really stupid, but I can remember how to save results of SHOW CREATE TABLE tbl_name and SHOW COLUMNS FROM tbl_name in to text file. I'm running mysql 23.41 on Win2k. Thanks in advance -- Martin Jeremic mailto:[EMAIL PROTECTED]

cannot get mysqld to start

2001-08-28 Thread Sheena Sidhu
Hello, I just installed mysql-max-3.23.41 on Linux. All went smooth but alas cannot get myqld to start. here is the log from the systemname.err file in mysql/data directory: 010828 14:26:30 mysqld started Can't initialize InnoDB as 'innodb_data_file_path' is not set 010828 14:26:30

FULLTEXT exact match queries?

2001-08-28 Thread Ed Carp
How do I do exact phrase matches using FULLTEXT? I have this 2 million row table, full of text data, that I want to search for an exact phrase. When I say: select * from Laws WHERE MATCH(Line) AGAINST ('MDMA') ORDER BY ID; It works correctly, returning 1 row, MUCH faster than doing a select

Re: FULLTEXT exact match queries?

2001-08-28 Thread Sergei Golubchik
Hi! On Aug 28, Ed Carp wrote: How do I do exact phrase matches using FULLTEXT? I have this 2 million row table, full of text data, that I want to search for an exact phrase. When I say: select * from Laws WHERE MATCH(Line) AGAINST ('MDMA') ORDER BY ID; It works correctly, returning 1

RE: FULLTEXT exact match queries?

2001-08-28 Thread Ed Carp
On Aug 28, Ed Carp wrote: How do I do exact phrase matches using FULLTEXT? I have this 2 million row table, full of text data, that I want to search for an exact phrase. When I say: select * from Laws WHERE MATCH(Line) AGAINST ('MDMA') ORDER BY ID; It works correctly, returning

ERROR 1044: Access denied

2001-08-28 Thread Pierre-Yves
Hello, I have a problem with the access : I have created 2 users with no privileges in the user table (privileges are set in the db table, so those users can only access one particular db). the first user has all the privileges set to Y for the db hello, this user works fine. the second user

Re: cannot get mysqld to start

2001-08-28 Thread Dana Powers
This is covered in the mysql manual here: http://www.mysql.com/doc/P/o/Post-installation.html First, you need to install the default databases ( installs mysql/host.frm ): bash mysql_install_db Then tell mysql not to use InnoDB: put this in your /etc/my.cnf file: [mysqld] skip-innodb

Re: ERROR 1044: Access denied

2001-08-28 Thread Dana Powers
ERROR 1044: Access denied for user: '@localhost' to database 'hello' This says that you are connected as user '' ( blank ) from localhost. Make sure you're logging on correctly and try again. dpk - Before posting, please

Re: ERROR 1044: Access denied

2001-08-28 Thread Pierre-Yves
- Original Message - From: Dana Powers [EMAIL PROTECTED] To: Pierre-Yves [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 1:22 AM Subject: Re: ERROR 1044: Access denied ERROR 1044: Access denied for user: '@localhost' to database 'hello' This says that you

how to import a text file into the mysql database

2001-08-28 Thread Chakravarthy K Sannedhi
hello all, i am trying to install web calendar software on my machine, which is available at sourceforge.net website. to run that software first of all a textfile named tables-mysql.sql needs to imported into the mysql database. for doing that i typed the following command at the shell prompt

Re: ERROR 1044: Access denied

2001-08-28 Thread Dana Powers
The way mysql access tables work, if it cant find a user named 'user2', it will default to the blank user ( '' ). dpk - Original Message - From: Pierre-Yves [EMAIL PROTECTED] To: Dana Powers [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, August 28, 2001 4:39 PM Subject: Re: ERROR

mysqladmin is missing from RPM distribution

2001-08-28 Thread root
Description: I downloaded, via ftp, and installed MySQL-3.23.41-1.i386.rpm. The user instructions at the end of the rpm -i ./*.rpm command proscripbed the use of /usr/bin/mysqladmin -u root -p password 'new-password' and /usr/bin/mysqladmin -u root -h 'my-dns-name' -p password 'new-password'.

Root password revisited

2001-08-28 Thread Gregg Baker
Hi all, I just joined list. I spent a couple hours in the archive and decided MySQL better improve their install message regarding setting the root password! Half the posts are about it going badly. ;) I believe I found the answer in the archives, but they all aren't the same answer. So is the

Error Install MySQL Binary on AIX

2001-08-28 Thread Michael Widenius
Hi! ajgrif == ajgrif [EMAIL PROTECTED] writes: Description: ajgrif I downloaded the lated AIX binary from mysql.com, and unpacked it to /usr/local/mysql. I then cd'd to /usr/local/mysql and ran scripts/mysql_install_db per the INSTALL-BINARY file. This is the error I recieve:

Re: Solaris 2.8 configure problem...

2001-08-28 Thread Michael Widenius
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Jeremy Zawodny writes: I have a fairly new Solaris 2.8 (Ultra Sparc) machine on which I'm trying to build the MySQL client libraries. According to the INSTALL-SOURCE file, I need to use a command-line like this: CC=gcc

Re: Root password revisited

2001-08-28 Thread Gregg Baker
Hi all, I got a No Database Chosen. What's the syntax for adding the database? I tried *.*, mysql, and test between UPDATE and user but all returned syntax error. Thanks much, Gregg UPDATE user SET Password=PASSWORD(desiredpasswordhere) WHERE User=root;

Re: RE: FULLTEXT exact match queries?

2001-08-28 Thread Ed Carp
Alok K. Dhir ([EMAIL PROTECTED]) writes: select * from Laws WHERE MATCH(Line) AGAINST ('growth hormone') AND Line like '%growth hormone%' ORDER BY ID; This defeats the purpose of the fulltext index, don't you think? Not really - since the WHERE clause is executed left to right, the

binary bin problems on HPUX 11.0

2001-08-28 Thread William Chi
Hi, we are using mysql 3.23.33 on HPUX11 and every time we reboot the machine, it overwrites the binary log and starts from 001 again. This is only happening on a couple of machines. It doesn't do this if i manually restart mysql, only when the machine is rebooted. On one of the machines, mysql

Re: how to import a text file into the mysql database

2001-08-28 Thread Daniel Woods
shell # mysqlimport -u root -p webcalendar tables-mysql.sql where, 'webcalendar' is the database that i have created for this purpose. after entering the password at the password prompt it is displaying the following error: mysqlimport: Error: You have an error in your SQL syntax near

New MySQL Site

2001-08-28 Thread Mike
Just a kudos to those that redid the MySQL site. DAMMM IT LOOKS GOOD Excellent job!!! Cheers M;) Quote from The Young Ones: I suppose you think it's pretty weird, don't you Mike? Well, you'd be right. Because THAT's the kind of guy I am, right! WEIRD! Which is why I go

reports? from MySQL (oops, on a Mac)

2001-08-28 Thread get86
i'd like to ask... if any of you are familar with (File Maker Pro, most recent versions)... how does one go about using MySQL to create a printable report? e.g., where you select the fields you wanted in the report and then create a layout and page setup for the report, (then print it)?

Re: query

2001-08-28 Thread Grigory Bakunov
Date |Tue, 28 Aug 2001 16:32:49 +0530 From |muruganandam [EMAIL PROTECTED] Hello! M for a particular query i have to select data from five tables. M can any one suggest me a best way to do that in terms of performace.. M thanks in advance M muruganandam Please give more details. Like table

compiling mysql with InnoDB for AMD Athlon cpu

2001-08-28 Thread Stanislav Dmitrenko
G'day, Is it possible to compile mysql with InnoDB for AMD Athlon processor ? Error produced during compilation follows: make[4]: Entering directory `/usr/local/src/mysql-3.23.41/innobase/sync' gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include -DDBUG_OFF -O3 -DDBUG_OFF