Re: long query status info

2002-02-07 Thread Gerald Clark
I can't read your structures or query from here. [EMAIL PROTECTED] wrote: >hi, > >i'm running a big query across a table containing more than 137 million rows >comparing them to another one with about 4000 rows and i'm wondering how long it will >still take... > >is there a way to see how many

Re: Problems with select

2002-02-08 Thread Gerald Clark
15.8 has no exact binary representation, so a test for equality will fail. Do not use floating point if you want to test for equality. Try DECIMAL Miguel Figueiredo wrote: >Hello all, > >I have a (probably dumb) question. >My table "temperatura" has two fields described bellow. > >mysql> descr

Re: Problems with select

2002-02-12 Thread Gerald Clark
15.8 has no exact binary representation, so a test for equality will fail. Do not use floating point if you want to test for equality. Try DECIMAL Miguel Figueiredo wrote: >Hello all, > >I have a (probably dumb) question. >My table "temperatura" has two fields described bellow. > >mysql> descr

Re: MySQL won't start...

2002-02-12 Thread Gerald Clark
Mysql must own its files and directories. chown -R mysql /var/lib/mysql assumong /var/lib/mysql is the data directory. FISHER,JOE (Non-HP-Roseville,ex1) wrote: >I have 2 SuSE Linux 7.2 machines at home... These boxes have completely >different hardware in each... But the O/S on each, contains

Re: long query status info

2002-02-13 Thread Gerald Clark
I can't read your structures or query from here. [EMAIL PROTECTED] wrote: >hi, > >i'm running a big query across a table containing more than 137 million rows >comparing them to another one with about 4000 rows and i'm wondering how long it will >still take... > >is there a way to see how many

Re: sql

2002-02-13 Thread Gerald Clark
perhaps because you are root@eros, and not [EMAIL PROTECTED] root wrote: > Hi > > How do I get off the list ? > > I have tried several times with sending a mail to > mysql-unsubscribe-srabol=mysql-unsubscribe-ing.aguirre=internetica.com.mx@lis >ts.mysql.com, and tried the > http://lists.mysql.co

Re: Problem in MySql while inserting '\'

2002-02-15 Thread Gerald Clark
How would you do: set field='Jim said, "that's crazy."' you would have to escape the quote somehow. The '\' is the escaper character. set field='Jim said, "that\'s crazy."' That means hat the escape character must also be escaped. Check the manual for the section on special characters. Most

Re: mysql.sock problem

2002-02-18 Thread Gerald Clark
check for a .my.cnf file in the user's home directory. It may have conflicting entries. Brad Emerson wrote: > > When I am logged in to my Linux system as root mysqladmin works > correctly. i.e. finds mysql.sock in the correct location. > > When I am logged in as a normal user I get this erro

Re: Anyone get MySQL and RH7.2 to work?

2002-03-08 Thread Gerald Clark
Install your ncurses rpm. Paul Warren wrote: >I've been frustrated with this for the past I-donno-how-many days. Has >anyone been able to get MySQL to work on Red Hat 7.2? > >I've been getting multiple errors. The First was the resolveIP() right from >the beginning. I follwed what the mysql webs

Re: Can not connect (again)

2002-03-08 Thread Gerald Clark
The client has to be able to search var/lib/mysql and read and write the var/lib/mysql/mysql.socket. It is probably not able to do one of the above due to imprpoer privileges at the filesystem level. Doug Thompson wrote: >Egor: > >Yesterday, I wrote and described that my fix for a single cpu,

Re: default value

2002-03-20 Thread Gerald Clark
Michal Dvoracek wrote: >Hello, > >s possible to create table with default value returned by built-in >function ?? >like: > No. > >create table x (a int not null default UNIX_TIMESTAMP()); > What is wrong with the timestamp field type? > > >When inserting new column in table field a will conta

Re: server startup error

2002-03-20 Thread Gerald Clark
Does mysql own the mysql database directory, and all its files? You should have run it as mysql_install_db --user=mysql Rance Hall wrote: > > Hello all > > I have a slackware 8.0 distro that includes mysql 3.39.x (I'm not at > that computer now, so that could be wrong slighly) install pkg > >

Re: Index only sometimes used

2002-03-20 Thread Gerald Clark
If more than a third of the rows would be selected, it is faster not to use the index. Over 2 million records match the '2'. How many are there total? Steve Gardner wrote: >Hi All > >Could someone explain to me why an index in a select I am doing is only >sometimes used. >The select I do is a c

Re: server startup error

2002-03-21 Thread Gerald Clark
I know that the server is running under safe_mysqld > --user=mysql it couldnt find the files cause under that account name > apparently they dont exist. > > The mysql user is part of what group, so I can chown the dir, and > start again? > > > Gerald Clark wrote > >&

Re: help with index/query

2002-03-21 Thread Gerald Clark
what about select Url from table where Ref = 'foo' Salada, Duncan wrote: >I am hoping I can get some help with a difficulty I am having with a table >of mine. I am going to give a lot of background info, so please bear with >me. First, let me say that I using 3.23.49. Now some info about the

Re: Access denied on use mysql;

2002-03-21 Thread Gerald Clark
Grant all on mysql.* to 'root'@'localhost' identified by "password"; What version MySQL are you running? You need 3.23 for GRANT to work. Kathy Reyes wrote: >I just gave up, everything that I tried did not work. > >I killed mysql and then >started with safe_mysql --skip-grant-tables >then I

Re: Table created on script Err

2002-03-25 Thread Gerald Clark
USE db2; alan4100 wrote: >mysql > >Paul, > >I was afraid to hear that. It had said about line 2 in the error message. >This line #2 looks normal. > >May I ask you to check this script below, but I am afraid it may be >annoying. I will eventually put this on posting. Remember I use Windows XP. >

Re: slow search on INDEX?

2002-03-25 Thread Gerald Clark
None of these selects will use an index. 1. An index can not be used for LIKE '$something'. 2. An index will not be used if 1/3 of the entries match. 3. See #1. Jaime Teng wrote: >Hi, > >I have this table: >mysql> describe eventlog; >+-+--+--+-+-+-

Re: Parameter passing on shell script

2002-03-25 Thread Gerald Clark
Try: echo " load data infile '/home/loader/txt/file_${date_proc}.txt' into table debits fields terminated by ';' " | mysql -u user -ppass dbname Oswaldo Castro wrote: >Hi List > >I'm new to MySQL and I need help on how to pass shell parameter to a mysql >script file (bash/SuSE 7.2) > >I have

Re: mysql.server

2002-03-26 Thread Gerald Clark
All init.d daemons take one of two options. These are "start" and "stop". Init supplies the correct option when changiing run levels. Where the daemon resides varies among versions of UNIX/Linux. [EMAIL PROTECTED] wrote: >>Description: >> >regarding mysql.server daemon > >>How-To-Repeat: >> >

Re: bug?

2002-04-01 Thread Gerald Clark
Did you dump the 24 records on both boxes and compare them? Maybe someone updated the records on the slave, and now the dates don't match. Vico Timmermans wrote: >I think i stumbled upon a bug that's got something to do with join >size. Detailed information below. > >Using 2 intel-linux platfo

Re: Group by?

2002-04-04 Thread Gerald Clark
Maybe you really wanted ORDER BY. Tobias K. Tobiasen wrote: > Hello > > I think the gruop by is behaving strange. Could someone please explain > this or maybe point me to a definition of the group by. (Inspired by > http://www.mysql.org/doc/E/x/Examples.html). > > > CREATE TABLE shop ( > arti

Re: Date and Mysql...

2002-04-10 Thread Gerald Clark
Your alias and column name are the same. Which one do you think is being tested? Also DATE is a reserved word. Chuck \"PUP\" Payne wrote: >Hi again... > >When I felt proud because last week I had asked about how to use NOW(), and >get answer that got me working, but now I have a strange problem

Re: BUG using left join.

2002-04-12 Thread Gerald Clark
You are passing a string to compare to a date. If you do this, pass it in the string format. Other wise " and t_boxdaily.boxdate < 19990101 " Steve Briant wrote: >Hi, > >I think I may have spotted a bug in connection with the LEFT JOIN statement. > >The following SQL > >select name, sum(

Re: ENUM Default values on NULL

2002-04-12 Thread Gerald Clark
Steve Katen wrote: > Ruben, > > If you leave it as NOT NULL it should default to NO. "If an ENUM is > declared NOT NULL, the default value is the first element of the list > of allowed values." > > SIDE QUESTION: > Are you doing something like: select * from table where enum_colum="NO" > > I

Re: cron job help running mysql/php script

2002-04-15 Thread Gerald Clark
crontab -l will list your current crontab entry. Cron is not running your job from a browser. If it won't run from your unix $ prompt, it won't run from cron. Harpreet Kaur wrote: > I am trying different options but everytime i make a change and type > crontab mycron.txt in telnet it comes

Re: remote

2002-04-16 Thread Gerald Clark
The only way I can see to get this message is if the client you are on when running mysql is 192.168.10.2 You should be using the IP address of the server you are connecting to, not the IP address of the client machine. George Pitcher wrote: >Toni, > >check your logs to make sure that the clien

Re: Strange behaviour with SQL vars and order by

2002-04-23 Thread Gerald Clark
I see no column named Site.nome showing that it is wrong. ds wrote: >Hi, > >I'm having a strange problem using SQL vars (@variable) and an order by >expression. > >I have a query that returns a record for each day. >Each record has a date (data), a column with the daily total value >(uv_views)

Re: insert for datatype of "set"

2002-04-23 Thread Gerald Clark
insert into mytable ( id , myset) values ('1', 'GA,SC') , ( '2', 'TN,NC,AL') ; Jim Philips wrote: >Yes. I found that page earlier. I still don't see how it answers my question. >What is the proper syntax for an insert statement? > >On Tuesday 23 April 2002 03:54 pm, Christopher Thompson wrote:

Re: last_insert_id() query

2002-04-24 Thread Gerald Clark
Don't include a from clause with the last_insert_id(), or you will get a full table scan. The last_insert_id will only give you the insert id for the last record inserted. mysql mailing list user wrote: > Hi, > I have a big problem with last_insert_id() query. > I am adding records to a tabl

Re: OSX Mysqladmin and Cron

2002-04-24 Thread Gerald Clark
Don't put quotes around your password. Dion Wickander wrote: >I set up a script to rotate my logs for mysql and cron fires it off >perfectly the logs are rotated but when the shell script gets to the last >line which is... > >mysqladmin -u usernam -p"Password" flush-logs > >it will not execute i

Re: how to get support help?

2002-04-25 Thread Gerald Clark
This is a mail list for MySQL users. If a user knows the answer to your problem, and feels like answering, you may get a correct, or incorrect answer. If you REQUIRE quick response, pony up for a service contract like I did. Clay Loveless wrote: >At this point, I'd like to solicit tips on how

Re: mysql_real_query and escaping a semicolon

2002-04-29 Thread Gerald Clark
The semicolon does not belong there. Anna Fowles-Winkler wrote: >Anna Fowles-Winkler wrote: > >>Paul DuBois wrote: >> Paul DuBois wrote: > At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote: > >Well, the function is called like this: > > > >mysql_real_query( mysql_connec

Re: compilation problem

2002-04-30 Thread Gerald Clark
kapil nakra wrote: > I am facing problem in compiling c++ program using mysql libraries. I > am doing this for the first time. I would appreciate if anyone of you > help me out. > > thanks. > > > folowing is the code > ___ > #include > #include > #include >

Re: lost root password trouble

2002-04-30 Thread Gerald Clark
Nick Wilson wrote: >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > > >* and then James Carrier declared > >>It'll be something like: >> >>/usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --skip-grant-tables >> > >Well, that's certainly progress of sorts :-) >It's just 'hanging' now. It s

Re: mysql log rotate

2002-05-01 Thread Gerald Clark
Opening a file access it by its inode. Once it is opened, it can be renamed, or deleted, and this will have no effect for the process that has it open. Flush logs will close the inode, and create a new log, which will assign a new inode to be opened. File names are just handy pointers to inodes

Re: Using MyODBC with Python

2002-05-01 Thread Gerald Clark
Python has its own MySQL interface module. You don't need MyODBC. Sabine Richter wrote: >Hello, > >I can't think straight today. So please help me: >I downloaded and installed myODBC 3.51. As far as I understand, it is >only the driver, which provides the connection to the database. In my >examp

Re: Error repairing: how do you Recreate an Index?

2002-05-01 Thread Gerald Clark
Error 13 is a permission problem. Mysql does not own the file. You probably repaired it while logged on as root, and changed ownership of the file. Make sure it is owned by mysql. MySQL wrote: >Hi all, > >I was trying to repair a table with myisamchk and got the following message: > >"error: 'x

Re: Problem with SELECT

2002-05-02 Thread Gerald Clark
Unfortunately, you did not tell us what version you are running, or what platform you are running it on. Try rebuilding the indexes with myisamchk or whatever is appropriate for your table type. Sheni R. Meledath wrote: > Hello: > > I have a problem while selecting the records from a table.

Re: ERROR 1036: Table 'xxx' is read-only

2002-05-03 Thread Gerald Clark
They must be owned by the user under which the mysqld runs, or change them to mode 766. Milan Reznicek wrote: >I have a problem with updating MySQL database on linux with mysql >3.23.24-beta-log. I have prepared a database on Win98 SE platform >with 3.23.49a and when i moved to my linux server

Re: RE: error granting rights

2002-05-10 Thread Gerald Clark
It should be 'username'@'localhost' Mark Shade wrote: >Yep... > >I am in as root, so I should have rights to everything. > >Yep, I have confirmed that the dbname is right, but doublechecking it >multiple times. Plus, this happens even on db that I did the same thing to >only a week ago. Th

Re: ERRORS

2002-05-13 Thread Gerald Clark
Make sure mysql owns its database files and directories. [EMAIL PROTECTED] wrote: >>Description: >> > I was getting a read-only error on one of my many databases. So, I tried doing >mysqladmin restart and now I'm getting "Can't find file: './Belzon/jobs.frm' (errno: >13). I've tried look

Re: [bug] Multiple daily crashes of mysql/innodb

2002-05-13 Thread Gerald Clark
Use gcc 2.95.3 [EMAIL PROTECTED] wrote: >>Description: >> > Our mysql server is crashing multiple times every day. In looking through the >logs, in mentions that we should check our key buffer, but the memory size is well >within our systems ability. Basically, if I don't find out how t

Re: Newbie asks error 1036 table read only?

2002-05-16 Thread Gerald Clark
Make sure mysql owns the tables and their directorys, and has write privileges to them. I talking about UNIX permissions here, not mysql permissions. Bill Flanagan wrote: >Hi, I recently inherited a Mysql 3.23.46 database, have some old ISAM >tables on which I am unable to do updates or insert

Re: INSERT INTO not working

2002-05-16 Thread Gerald Clark
Check your indexes. Daniel Lim wrote: >Hi there, >I have MySql version: 3.23.36 running on RedHat 7.1, it has been >working fine for sometimes until a day ago when the INSERT into for new >record appeared to return OK status but upon verifying the record isn't >there? > >This is an example; >

Re: Check tables?

2002-05-20 Thread Gerald Clark
Myisamchk returns an exit code. if myisamchk myfile.MYI ; then do something else do something else fi Mark wrote: >Hello, > >Is there a way I can do a "CHECK TABLES" which will return an exit code of >some sort, to use in a shell-script? Looking at the output of a myisamchk is >fun, bu

Re: Remote admin of MySQL from Win 2K

2002-05-20 Thread Gerald Clark
It is asking for myslq's root password, not the su password. If you have not set it yet, skip the -p option. Todd Cary wrote: >YES! I was missing something: Telnet!! I can log in *BUT* I am unable to >change the MySQL password. > >mysqladmin -h www.myhost.org -u root -p password 'new_password

Re: Newbie--Easy data loading question

2002-05-27 Thread Gerald Clark
Because mysql needs 'rx' permissions to read and search the directory. 755 should have been sufficient. Menard, Inc. Information Systems wrote: >I figured it out but I'm a bit confused as to why it happened. >I'm running the load as user1. The file resides at /home/user1/data/filename >Permiss

Re: File created by mysqldump cannot be read into MySQL

2002-05-27 Thread Gerald Clark
Don't use 'more'. It adds characters to the output. Instead: mysql --host=host --user=user --password=pwd < error_repeat.sql Elliot Smith wrote: >Description: >I used mysqldump to create an SQL file containing a dump of all databases on >the server, including all tables and data (using --a

Re: Fulltext search - several tables

2002-05-28 Thread Gerald Clark
You will get better response if you post only once, and NOT as a reply to someone else's question. Peter Engström wrote: >Hello everybody! > >How can I do a fulltext search on several tables >with just one SQL query? > >Best regards >/Peter > > > >--

Re: timestamp(8) GROUP BY problem

2002-05-28 Thread Gerald Clark
try timestamp(14) instead. [EMAIL PROTECTED] wrote: >Description: > Problem with timestamp(8) and GROUP BY > >How-To-Repeat: > >mysql> CREATE TABLE test ( >-> id int auto_increment, >-> dd timestamp(8), >-> data int, >-> PRIMARY KEY (id) >-> ); >Query OK, 0 rows affecte

Re: @INC

2002-05-28 Thread Gerald Clark
You need to install DBI first. Amy Zediak wrote: > >I'm a little confused on how to add things to @Inc path...i'm trying to >install Msql-Mysql-modules and it says that my DBI/DBD is not in the >@INC > >Thanks >Amy > > > - Be

Re: warning: 1 clients is using or hasn't closed the table properly

2002-05-28 Thread Gerald Clark
You should NOT be running myisamchk while the server is running! [EMAIL PROTECTED] wrote: >I get this message when I do a myisamchk on a table right after I use >phpMyAdmin or other mysql client tools. > >What do I need to do to get the table to close properly? I have been >having to run myis

Re: Extracting binary data from a row

2002-05-30 Thread Gerald Clark
All the numeric types are returned as strings. If you want to convert them to numbers, you need to use scanf or atod type functions. Michael Flora wrote: > Hello all, this is my first post to this list. I am relatively new to > MySQL, and my question might be a basic one. > > I have a table

Re: How to write output of sql stmt to file

2002-06-04 Thread Gerald Clark
Did you check out the -w option to mysqldump? andy wrote: >Hi there, > >I am trying to get only records out of a table mathing a query. This should >be piped into a textfile. My problem is that I have to transmit this records >to a new machine. So the output should be a kind of sql commands whi

Re: still not-empty set

2002-06-06 Thread Gerald Clark
Maybe if (!($result)) { Try print STDERR "RESULT=$result\n"; to see what you are comparing to. Chris Hohimer wrote: > thanks for all the replies!! but it is not working. > here is the loop: > > if($result == EMPTY SET){ > $Scheduled = NULL; > } > else{ > $Tech = mysql_result($result,

Re: Is it possibile to have something similar?

2002-06-06 Thread Gerald Clark
No you can't, but check out LIMIT. Marco Stagno wrote: >>IMHO, The Right Thing to do this, is to create the additional data in >>your application (as you said you won't change the table). >> > >(...) > >thank you! > >>If you want this with SQL for sure, using user-defined variables will >>work:

Re: Stupid Q

2002-06-07 Thread Gerald Clark
Are you shure you don't really want ENUM('y','n') SET('y','n') will allow the field to be both 'y' and 'n' at the same time. Chris Knipe wrote: >I'm talking under correction here, but > >SET('y'.'n') default 'n' NOT NULL - should work. I normally just do all >this stuff via phpmyadmin, it work

Re: Counting distinct elements

2002-06-07 Thread Gerald Clark
You mean SELECT ObjId,ElemId,count( distinct Objid,ElemId ) from Elems group by ObjId; ? Csaba Gabor wrote: >Seems like this should be an easy question, but I just don't get it: > >If I have CREATE TABLE Elems (ObjId INT, ElemId INT); >Is there a nice query to find the Number of Distinct Ele

Re: Permissions for mysqladmin

2002-06-07 Thread Gerald Clark
Cindy Nelson wrote: > Hi, > > I am using SuSE 7.0 and MySQL 4.0.1. I had quite a time > getting the daemon started on Linux but finally succeeded. > I can start the daemon logged on as su and I can connect > to the database as user=mysql and modify the existing DB > called test. > > I set the p

Re: Unique Indexes across multiple columns

2002-06-10 Thread Gerald Clark
It looks to me like 'a' is '127-30-127-1' Notice the dashes. I don't believe you are splitting the IP address into 4 separate numbers. Chris Knipe wrote: >Hi again, > >Not to long ago, I had a query regarding the best way to store IP addresses >in a DB, and make sure that they are unique. > >I

Re: Installation problem

2002-06-10 Thread Gerald Clark
Mysql does not own the database and its tables; chown -R mysql /usr/local/mysql/var ( or whatever the database location is. ) Kariuki, JohnX K wrote: >Hi I am pretty new to linux and I was trying to setup and use mysql, I >followed the directions you provided about compiling it and installing

Re: Unable to connect to remote mysql server.

2002-06-11 Thread Gerald Clark
1. What does this have to do with ssh? 2. Does root@yourmachine have permission to connect to mysqld on 202.157.188.2? ally wrote: > Dear all, > >I hv mysql server running on a remote machine(ip 202.157.188.2) and i'm >trying to connect to it by ssh from another machine(ip 202.157.137.97) as >f

Re: Database renaming?

2002-06-11 Thread Gerald Clark
Any permissions set for users on the database will be invalid. Martin Rode wrote: >Hi there, > >I was wondering if I can rename a MySQL instance (MyISAM) by simple >stopping the server and rename the data directory? A quick test did not >show any problems. I am now wondering if I can get other p

Re: mysql auto_increment question

2002-06-11 Thread Gerald Clark
Taylor Lewick wrote: >Hi all. I have searched the documentation, and i found some info, but I wanted to ask >the lsit a little more about auto_increment. > >First, if I use auto_increment, and then delete a field, I assume mysql leaves the >remaining fields with the original numbers... >i.e.

Re: Errno 13 on starting mysqld (Suse 8)

2002-06-11 Thread Gerald Clark
MySQL doesn't own the files. chown -R mysql /var/lib/mysql eh wrote: >Errno 13 on starting mysqld > >I am using SUSE 8.0 >on a 586 computer >I installed MYSQL 3.23.48 from the Suse-CD (By the while four times) > >At first I was running (as described in >/usr/share/doc/packages/mysql/README.Su

Re: not able to edit table:((

2002-06-11 Thread Gerald Clark
The mysql user was not granted write permission on the database? Anil Garg wrote: >The persmissions seems to be ok. >ne other ideas!! >- Original Message - >From: "Kiss Dániel" <[EMAIL PROTECTED]> >To: "Anil Garg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> >Sent: Tuesday, June 11, 2002 12:

Re: easy question

2002-06-13 Thread Gerald Clark
chad kellerman wrote: >Hello, > I am sure this is an easy question but I am not thinking clearly for some >reason. :^) > > If you set a column to auto_Increment. You do not have to put the >auto_increment # in the insert statement to get it to be inserted. Mysql >does this automat

Re: Any way to make a "top ten" query?

2002-06-13 Thread Gerald Clark
ORDER BY mountainheight DESC LIMIT10 Yrjö Mäenpää wrote: >As there is no TOP operator nor nested selects in MySQL, I wonder if there >still exists some clever way to make"top ten" type of a query , i.e. to >select ten best selling products or ten highest mountains for example. > >thanks > > >

Re: Why does Key==Mul in DESCRIBE TABLE for unique key?

2002-06-13 Thread Gerald Clark
CREATE TABLE X (FLD1 INT PRIMARY KEY); or CREATE TABLE X (FLD1 INT, UNIQUE(FLD1)); UNIQUE applies to an index, not a field. Andy Sy wrote: >- Original Message - >From: "Paul DuBois" <[EMAIL PROTECTED]> >To: "Andy Sy" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> >Sent: Friday, June 14, 20

Re: Nulls and unique indexes.

2002-06-18 Thread Gerald Clark
That is correct. Use NOT NULL in the definition to force unique keys. [EMAIL PROTECTED] wrote: >>Description: >> > If a null column is used in a unique index then mysql fails to throw a > key violation when multiple identical inserts (with nulls) are > performed. > >>How-To-Repeat: >> > create

Re: Can't create a new thread (errno 12). ( 3.23.49 and Linux )

2002-06-20 Thread Gerald Clark
perror 12 Error code 12: Cannot allocate memory. Either : 1. Add memory ( good ) 2. Add swap ( Not so good ) 3. Tune for less memory usage. David BORDAS wrote: >Hi list, > >just have this when connecting to my mysql dedicated server :( >The server is like this : >bi PIII 1 Ghz >1Go of ram >Ra

Re: file permissions

2002-06-21 Thread Gerald Clark
The manual says: chown -R mysql.mysql /usr/local/mysql You did not do that. Do the same for MySQL's data directory. Michael Sellers wrote: >I'm very new to mysql. Just learning. I'm trying to correctly set up the >permissions for the files under the mysql/ directory. I've included a >lis

Re: please modify init.d script

2002-06-21 Thread Gerald Clark
Or better yet, add a sleep 2 to the beginning of the init.d program you are starting that expects to connect to mysql. Why slow down the booting for everybody when some other daemon that expects to connect to mysql can not handle a failed connect properly? Florin Andrei wrote: >The init.d scr

Re: Chinese character error

2002-06-24 Thread Gerald Clark
Your string contains special characters, and must be properly escaped before storing. Use the appropriate string escaping function in your language ( if it exists ) or write a routine to escape them for you before storing them. The manual lists the special characters. henry lee wrote: > Dear

Re: Need last 100 records...

2002-06-25 Thread Gerald Clark
ORDER BY whatever DESC LIMIT 100 Mark S Lowe wrote: >Is there a nifty way to select just that last 100 records with MySQL? In >Oracle I use Maxrows and date to accomplish this. Can¹t seem to figure this >out with MySQL. > >Please advise! Thank you! > >Mark > -

Re: configure won't configure

2002-06-27 Thread Gerald Clark
With linux you would: Add /usr/local/lib to your /etc/ld.so.conf file and run ldconfig. Sun should have something similar. [EMAIL PROTECTED] wrote: >>Description: >> > what do I have to do to get configure to use correct gcc options like: >-I/usr/local/include -R/usr/local/lib ??? > >I u

Re: mysql & /var dir

2002-06-27 Thread Gerald Clark
shutdown the mysqld, move the data direectory, and set up a symbolic link. Rahadul Kabir wrote: >Hi, >I have MySQL3.23.47 running on a Cobalt RaQ4 System. The mysql >installed datadir turned out to be /var/lib/mysql. /var directory has >it's own partition (/dev/hda3) and total space available i

Re: SubQueries and Temp Tables

2002-06-27 Thread Gerald Clark
You brought it up. You made the comparison. Give us a break. Dave Morse wrote: >Looks like you want to bring up something that doesn't have anything to >do with the original question which is your perogative. But please >don't compare MySQL with Oracle and mainstream SQL RDBMSs. Give us a >bre

Re: MySQL Question involving AUTO INCREMENT and PRIMARY IDs. - sql

2002-06-27 Thread Gerald Clark
That is a difference in the behavior of isam and myisam tables. jason wesley upton wrote: >EXPLANATION: > >here's the pertinent piece of my sql create statement: > >ID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (ID)); > >i have used this create statement numerous times without this "problem". in

Re: Can't find file ./mysql/host.frm

2002-07-02 Thread Gerald Clark
chown -R mysql /var/lib/mysql [EMAIL PROTECTED] wrote: >>Description: >> > When starting safe_mysqld mysqld shutsdown immediately with no error >message. However looking at /var/lib/mysql/matrix.err gives the following >error messages:- >mysqld started >/usr/libexec/mysqld: can't find

Re: installing 3.23.49 on solaris 5.8 fails

2002-07-02 Thread Gerald Clark
It looks like you configured it to install in the source directory. Pushkar Pradhan wrote: >I used gnu's make as recommended, make was successful, however gmake >install gives the foll. error: > /usr/local/gnu/bin/install -c copy-db >/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/copy-db >/usr

Re: Problem with DB backup

2002-07-08 Thread Gerald Clark
They are not SQL statements. They are both command line tools. You don't run them from inside the mysql client. hlam wrote: >I'm trying to do a backup of my DB using "mysqldump" >and "mysqlhotcopy" but both functions are sending me an error on SQL >syntax. >Could someone tell me what's the cor

Re: Drop keys does not stop indexes being created

2002-07-09 Thread Gerald Clark
You check index files, not table names. myisamchk -k 0 -rq $MYSQLDIR/test/BestGuess.MYI Archer Barrie wrote: >>Description >> >Having followed the instructions in section 5.2.8 to create a table using >LOAD >DATA INFILE *without* its indexes, the indexes are *still* created at the >end >of th

Re: auto-increment usage question

2002-07-10 Thread Gerald Clark
That is the normal behavior for ISAM type files. Convert them to MYISAM. Richard Fox wrote: >>Hi, >> >>I have a mysql table which has a run_id which together with user_id forms >> >the > >>primary key for the table. run_id is not null and auto-increment. I delete >>records from this table, and a

Re: slave server in readonly

2002-07-10 Thread Gerald Clark
Well, if it is read only, it won't be able to update from the master. GRANT your users no write permission. Pierre Baridon wrote: > > is it possible to start a server in 'read only' mode ? > so that users cannot write in my slave server ? > > thanks, > > Pierre > > > > > > > --sql,query > > >

Re: error

2002-07-11 Thread Gerald Clark
No, those are termcap database entries. Configure is looking for libtermcap or libterminfo int .the /lib directory. If you are running RedHat Linux you need to install the ncurses rpm. David Johnston wrote: >When running ./configure I am getting the error no termcap libraries but in >/usr/lib/te

Re: Query realted to Mysql access.

2002-07-11 Thread Gerald Clark
Naathan wrote: >Hello, > >Greetings! > >I am trying hard to connect to MySQL database stored on Linux machine >through a >VB program running on windows on another machine. > >My problems are .. > >Problem No1: > >My Windows machine is under a Windows NT domain. >Linux machine is under another W

Re: MAC OS X Server

2002-07-11 Thread Gerald Clark
A. John Peters wrote: > New error msg, I think I have permissions right No you don't. Mysql must own the database directories and files. > > > 020711 08:37:57 mysqld started > 020711 8:37:57 /usr/libexec/mysqld: Can't create/write to file > '/usr/var/e-mac > .pid' (Errcode: 13) > 020711

Re: Query realted to Mysql access.

2002-07-11 Thread Gerald Clark
OOPS! Bob Bell wrote: >On Thu, Jul 11, 2002 at 08:32:28AM -0500, Gerald Clark ><[EMAIL PROTECTED]> wrote: > >>Naathan wrote: >> >>>I am getting the following error message like . >>> >>>" [TCX][MyODBC]Host is not allowed to conn

Re: chown: 'mysql': invalid user

2002-07-11 Thread Gerald Clark
Use adduser, or the appropriate command for your version of UNIX to create the mysql account. Alex Jarvis wrote: > To summarize: I was getting a "cannot connect through >socket..." error. It would appear that the server is not running and the >socket doesn't exist. So I tried to start t

Re: Permissions problem

2002-07-12 Thread Gerald Clark
Since -p="" is not valid syntax, it should not work. There is no equal sign after the -p, and no space between the p and the password which needs no quotes. If you have no password leave out the -p option. Derek Fountain wrote: >Hi, > >I have a server running 3.23.41 on Redhat 7.1. The probl

Re: SELECT performance

2002-07-12 Thread Gerald Clark
What would you expect? You ask for the whole file, and then ask that it be sorted by two fields. How do you expect this to happen without a temp file? Tiago Antao wrote: > Hi! > > I have a very simple query > SELECT a, b FROM t ORDER BY a, b > I also have an index on t(a) > I have run ANALYZE >

Re: auto-increment usage question

2002-07-12 Thread Gerald Clark
I verified his problem with 3.23.38 here using myisam files. The key here is that the unique index is across TWO integer fields, one of which is auto_increment. Victoria Reznichenko wrote: >Richard, >Thursday, July 11, 2002, 7:26:00 PM, you wrote: > >RF> But the default table type is already MyI

Re: Problem dealing with load data

2002-07-12 Thread Gerald Clark
The server must be able to read the file, and since the server normally runs as the user 'mysql', it will not be able to read files sitting in root's home directory. Put the file in /tmp, and make it readable by others. Sofiane FAESSEL wrote: > hello everybody > I have a problem using mysql and

Re: Replication problems

2002-07-12 Thread Gerald Clark
Did you copy the master.info file over too? Santiago Alba wrote: >Hi All, > >I had a system replication on Linux consisting of MASTER and only one SLAVE. >I stopped replication, I did a backup on my slave and it recreated in >another machine so now I have two SLAVES connected to database MASTER

Re: Can access DBs when started w/ safe_mysql but not with mysqld????

2002-07-12 Thread Gerald Clark
The mysql user should own the databases and files, not root. David Kramer wrote: >I am able to access all of the database instances that I have created when >starting Mysql with safe_mysql(as root user). As soon as I start mysql any >other way, I keep getting the Access Denied Error. Can root

Re: Can access DBs when started w/ safe_mysql but not with mysqld ????

2002-07-12 Thread Gerald Clark
t. Do I " chown " the binaries and database files to >my new user? Or Do the binaries always stay to root? > >Thanks much! > >DK > >-----Original Message- >From: Gerald Clark [mailto:[EMAIL PROTECTED]] >Sent: Friday, July 12, 2002 11:08 AM >To: David K

Re: query

2002-07-16 Thread Gerald Clark
Difficult to answer without knowing what the "unix-socket problem" is. p shah wrote: >Hi, > >I want to know one thing about MYSQl, >Why does this software always give the unix-socket >problem when compiled and installed. > >I am installing on redhat 7.1. > >Is there a remedy to this or this will

Re: Permissions problems

2002-07-17 Thread Gerald Clark
If mysql owns them, 0770 should be fine. System Administrator a.k.a. The Root of the Problem wrote: >USually all the databases sets up fine BUT recently, I have >had to adjust databases to 0777 in order to get them to >work and change the ownership. > >I prefer the more secure model of mysql. >

  1   2   3   4   5   6   >