Re: libexec/mysqld: unknown option '--skip-bdb'

Kris wrote: Hello, I am trying to produce an automated, reliable, and repeatable way of testing mysql releases, and I am finding an error that makes this impossible to accomplish. I am trying to compile mysql and install it in a non-standard directory. I do notwant mysql installed in /usr or /u

Re: Why can't I kill the query cache?

Little, Timothy wrote: Also titled, I want this to run slow ALL the time... I have a group of dreadful queries that I have to optimize. Some take 20-30 seconds each -- the first time that I run them. But then they never seem to take that long after the first time (taking less than a second

Re: selecting the 'best' match

blackwater dev wrote: I have a hold car data such as color, model, make, year, etc. I want to allow the user to answer some questions and I'll present them with the car that 'best' matches their criteria. How do I do this? I still want to return ones that don't match exactly but want the close

Re: mysql problem

AZZOPARDI Konrad wrote: Hello people, I do not know if this the right listI am migrating a very basic application from an older mysql version 4.1.9-standard to a new mysql version 5.0.45 {RedHat default package}. I have migrated DB data from one to the other and all data seems to be there

Re: Can't create table

Octavian Râºniþã wrote: Hello, I've tried to create these 4 test tables, but when I try to create the last one, MySQL gives the following error: ERROR 1005 (HY000) at line 20: Can't create table '.\z\favorite_link.frm' (errno : 150) It seems that the foreign keys are not created well i

Re: failed-mysql-bugreport

Bob wrote: mysql.sock doesn't exist on the hard drive. Start the server. -- Gerald L. Clark Sr. V.P. Development Supplier Systems Corporation Unix since 1982 Linux since 1992 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Basic information: MySQL Table crash?

#1 reason is powering off the computer without a proper shutdown. Get a UPS. -- Gerald L. Clark Sr. V.P. Development Supplier Systems Corporation Unix since 1982 Linux since 1992 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Join question

pened 1 or 10 times in one day just that it happened at least once on that day for a user. Chris W try DISTINCT. -- Gerald L. Clark Sr. V.P. Development Supplier Systems Corporation Unix since 1982 Linux since 1992 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: Finding gaps

SELECT a.id+1 AS `Missing_From`, MIN(b.id) - 1 AS `To` FROM tbl AS a, tbl AS b WHERE a.id < b.id GROUP BY a.id HAVING a.id < `To` -- Gerald L. Clark Sr. V.P. Development Supplier Systems Corporation Unix since 1982 Linux since 1992 -- MySQL General Mailing List For list archives: h

Re: Totaling from several tables away

SELECT sum(calories) from People INNER JOIN Meals ON People.Name=Meals.Name INNER JOIN Meal_Items on Meals.Meal_ID=Meal_Items.Meal_ID WHERE Name='Brian' AND Date='2009-09-04'; -- Gerald L. Clark Sr. V.P. Development Supplier Systems Corporation Unix since 1982 Linux since 1992 --

Re: MySQL won't start with external bind-adress in my.cnf

t. I attempt a /usr/local/etc/rc.d/mysql-server.sh restart But the server does not start until I change the address back to the LAN address. Any help would be appreciated. I have not found via Google anyone else having this issue. Does that IP address resolve to your hostname? -- Gerald L. Cla

Re: Filesort on query

), KEY `today` (`proj`,`today`,`id`), KEY `prank` (`proj`,`projrank0`,`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Regards Phil With no where clause, and aggregate functions, it is faster to do a full table read, and the sort the aggregated results. -- Gerald L. Clark Sr. V.P. Development

Re: mysqld works but not mysqld_safe

permissions error. Check all directories from / to the data directory. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqld works but not mysqld_safe

to work -- with logging!! -- Chris Africa Web Project Manager Department of Mechanical Engineering University of Michigan 734-764-8482 Fridays: 734-355-6577 AIM/iChat/Skype ID: baiewola mysql does not have write privilege in /usr/local/mysql-5.0.41-osx10.4-i686/data. Is this owned by roo

Re: why are tmp tables being created on disk?

rhaps the data is still in cache, so no read is actually made from the disc. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: error in login

‘localhost’ from the user and only leaving ‘%’ with no difference at all. I’ve also tried the –protocol=TCP option with no luck either. Any pointers? TIA Hector S. Mendoza O PS. mysqld Ver 5.0.27 Use a my.cnf file in the user's home directory. -- Gerald L. Clark Sup

Re: peformance help: preventing 'using temporary; using filesort'

ch rpt_cpc needs an index on sourceID. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Upgrading databases?

ysql' I have tried it with all different combinations for the two directory options with no luck. All tables are MyISAM. Can anyone shed some light on what I'm supposed to do? Thanks, Seth Shut the server down and run myisamchk on users.MYI -- Gerald L. Clark Supplier System

Re: index question

Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475 Use explain, and find out. MySQL may reverse the two and join A to B inorder to use A's index. Since there is no WHERE clause, only one of the tables needs an index. -- Gerald L. Clark Sup

Re: master status is null

, and how do i fix it. Please help regards anandkl -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySql Host through Heartbeat

Baron Schwartz wrote: Gerald L. Clark wrote: Ben Clewett wrote: Dear MySQL, I'm running 5.0.26 through Heartbeat. Which seems to work well, even as a replication slave and Heartbeat continously stopping and starting the server. The Heartbeat moves MySQL around from server to s

Re: MySql Host through Heartbeat

not change. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: zabbix mysql problem

ysql in 21 days book and hope to become more knowledgeable on this subject, please point me in the right direction? You are not looged in to mysql as a user with create privileges. You might need to backup a few chapters. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing L

Re: Access Denied When Trying to Create Database

anyone please help me? I am unable to use MySQL at all, at this point... -untz You have to be logged-in to mysql as a privileged user to grant permissions to others. Logout, and login as root. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archiv

Re: Access Denied When Trying to Create Database

ase people_development; >> ERROR 1044 (42000): Access denied for user 'untz'@'localhost' to >> database 'people_development' >> mysql> > > Try running SHOW GRANTS while logged in, and see what privileges > you have. You probably need

Re: Lock Tables Question

les you will use, perform your updates, and then UNLOCK TABLES. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Lock Tables Question

long list), I wondered if it is possible to just lock one table, with the gentleman's agreement that in order to modify the database, every process must first lock that particular table. You could use a string lock for this. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Ma

Re: Mysql and Textarea

ly it can’t read what is inside the Textarea box. Why?? Read the highlighted code. include ('./includes/header.html'); include( '../mysql_connect.php' ); ?> You asked this two days ago. Have you tried any php mailing lists? -- Gerald L. Clark

Re: Frequently MyISAM TABLE corruption.....Pls help

ched the file size limit of your filesystem, or the default maximum MyISAM size? -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Bin logs...

binary log. My problem is I have a query that's failing and I can't figure it, I can't read the log file. Suggestions anyone? Use the mysqlbinlog command. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: IS NULL Question

get the tuples back when I did SELECT * FROM myTable WHERE col3 = ' '; -- a space character If this is the case, you might consider using a different table type, such as InnoDB. HTH, Kevin MyISAM has no problem representing NULL. -- Gerald L. Clark Supplier Systems Corporation

Re: Should the db be shutdown before backing up?

low for select to go through the db) Best luck mysqlhotcopy does not require a database shutdown. If it did, it would not be a hot copy. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

Re: Permissions and Into Outfile

hould I change the mysql home directory to some other folder? Neither. Just make sure that mysql has permission to write in the directory you want to contain the output file. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysq

Re: Permissions and Into Outfile

; must have write permission in the target directory. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: what kind of indices to set up

mn index starts with model or tyre_type, then no. The index can be used down to, but not including the first column that is compared against '%'. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscr

Re: Stopping Replication

at else do I need to do to stop the replication process? Thanks, Jesse You have to remove the master information from the slave's my.ini file. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Trying to open a big sql script

ards, Joerg That reminds me of the story of the mailing list maintainer who decided to replace 'and' with '&'. He ended up sending mail to S&y S&erson. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Suddenly : mysqld: Can't create/write to file PID

7; (Errcode: 13) 070418 8:43:57 [ERROR] Can't start server: can't create PID file: Undefined error: 0 070418 08:43:57 mysqld ended HOw is this fixed? The mysql user must have execute and write privilege on /usr/contrib/var and all subdirectories. -- Gerald L. Clark Supplier Syst

Re: Does casing of Table names matter on Linux

not resist the change to > the Linux . > What is the remedy now i mean can something be done now to make linux be > case insensitive, > Pl. help me, > Thanks, > Abhishek jain > > So friends , If anyone know abt the sol. pl. let me know Thanks, Abhishek jain The solution is in the link given above! -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: row count inconsistency

mysql> select count(*) from fidcid; +---+ | count(*) | +---+ | 100480507 | +---+ 1 row in set (0.09 sec) If this table is InnoDB, then count(*) is just an approximation. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives:

Re: Mysql and FOREIGN KEY

laggio INT These are not the same type. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqldump on Freebsd 5 -- out of memory error

rt3 --set-variable=max_allowed_packet=256M Attachments > Attachments.sql Try adding the -q option. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Safe DB Distribution

torage and industry-leading spam and email virus protection. You will not be able to search on encrypted fields. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Date format question

date in format (-MM-00). -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [OT} How to pronounce GIF

pronouncing "graphics" as "jraphics". How do you pronounce "giraffe"? -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Instalation issues

ySQLCouldn't find MySQL manager or server[FAILED] Please advice how I can debug this error. Thanks, --Abhishek What error? -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: +1MB query gets "Out of memory"

over 1MB again. The only other value i could find that was 1MB was packet_size but that didn't help. What could i do to run this query? You have to change the maximum packet size on both the server and the client. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing

Re: mysql on a NAS

the number of servers) Never. 2) is there a better, more performant way, to install mysql in a cluster ? See 'MySQL Clustering' BY Alex Davies and Harrison Fisk MySQL Press 3) Just your general idea about this setup. Thanks Stefan "Stonki" Onken -- Gerald L. Cl

Re: Backing up large dbs with tar

the backup without affecting other db writes during this operation? Thanks, Van Look at mysqlhotcopy. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can't create database

ideas on how to solve this issue ? Any help would be appreciated. Best Regards, MG perror 28 Error code 28: No space left on device You need more disk space. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Manually Inserted Data

9', '2006-11-01', '-00-00' as z ) ORDER BY z, Start ASC, Status DESC, Time ASC a Does anyone see my mistake? Keith -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql -e "Select" Fields Enclosed By and NULL values

s a where clause. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: £ (Great Britain Pound) breaks MySQL insert and update - disastrous overwrit e

r encountered this?? I'm going mad. Turn on the querylog, and see what query mysql is actually getting. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: CREATE TABLE Inv_Id

rcodes are not sequential numbers. They are composed of a casecode prefix, a manufacturers id, a partnumber, and a check digit. You cannot use an autoincrement number as a UPC. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: Running a Staging and Development DB on the same server?

production database? Just connect to the proper database when you start your application. mysqladmin create testdata mysqldump production | mysql testdata -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: Quick way to determine existence of an index?

ounds like an extremely bad idea to me. You don't want to have any indicies you don't actually need. They will slow down all inserts and updates. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: updating table but afterwards there are duplicate entries that violate a key..

have duplicate (tagid, taggerid, objectid) rows. Is there a way to remove duplicate rows like this? Thanks for any pointers!! Peter Use ALTER TABLE IGNORE and put the key back. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysq

Re: MySQL operators

een '2006-09-14' and '2006-09-21' or Approveddate Is Null This retrurns all jobs whether they are status 6 or not, i need to have a comparison on approveddate, it is either between the two dates or null, but is status 6. ( Approveddate between '2006-09-14' and 

Re: What happened to left join under version 5?

|| | rowid | int(11) unsigned | NO | PRI | NULL| auto_increment | +--+--+--+-+-++ Server version 5.0.22 -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Conditional copy of values

id, so you cannot add a rowid that already exists. Please help. I am using MySQL version 4.1.14-standard-log. Hence subqueries are not a solution. Thanks, Ravi. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.co

Re: 2 versions of mysql on Unix: problem with the socket

s the socket. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Decimal versus Float Point Type

t you are modeling that is important. Dollars are decimal, and dollar calculations must be rounded to the nearest cent, or mill. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 1 to many relationships

m Comes up and i add the issue and Click Add issue, i need that issue to associate with that customer, every Customer Refrences the same issue table Then it is many to many. Many customers are associated with many issues. i have Customers /Issues as tables, -- Gerald L. Clar

Re: Load Data Infile and newlines

The command I used was: mysql> load data infile '/share/store/library.csv' into table library fields terminated by ',' enclosed by '"' lines terminated by '\r\n'; Any help appreciated. Mark You need to quote the actual linefeed character, not a b

Re: Tricky query

(SELECT * FROM keyval inner WHERE outer.key = inner.key AND inner.val = 9) ... Br, Morten I forgot the GROUP BY How about: SELECT DISTINCT `key`, COUNT(`key`) AS c FROM `table` WHERE `value` in (8,9,10) GROUP BY `key` HAVING c=3; -- Gerald L. Clark Supplier Systems Corporation

Re: Tricky query

(SELECT * FROM keyval inner WHERE outer.key = inner.key AND inner.val = 9) ... Br, Morten How about: SELECT DISTINCT `key`, COUNT(`key`) AS c FROM `table` WHERE `value` in (8,9,10) HAVING c=3; -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list

Re: Check out this Free software I found to document your IT infrastruct

take necessary action just like a mailing list owner will do. Feel free to send me a private email if you have more concerns. Regards, Will L Nabble.com Well, he also spammed the Centos Forums. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list

Re: [5.0] Left Join Problem

LEFT JOIN db.tab_c ON tab_c.id = tab_a.id LEFT JOIN db.tab_d ON tab_d.id = tab_a.id WHERE tab_a.id = 'value' LIMIT 1; -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql hangs on connection attempt

hind a NAT, and only their external addresses changed. this is a really tough bug, so any help would be GREATLY appreciated. thanks, steve connec -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Distinct problem

AS t1 INNER JOIN table3 AS t3 ON ??? LEFT JOIN table AS t2 ON t1.item_id = t2.item_id AND t1.dt < t2.dt WHERE t2.item_id IS NULL; -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.

Re: Allow user to create databases, but limit all privileges to other databases

is a post regarding this exact same issue, and I was originally going to add a 'me too!' response to that post, but the registration system for the forums seems to be broken and I was never able to successfully log in to post. You asked the same question 2 hours ago. -- Gerald L. Clark S

Re: Trying to understand why Select running out of memory if table not used

s... on the server also... But first try to run with '--compress' maybe this will fix... -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: datetime issue on MySQL 4.x

7;, '2', NOW())... And when I try to fetch the data using PHP with this query: SELECT operator_id, DATE_FORMAT(date_time,'%d-%m-%Y') AS tanggal, COUNT(*) AS TOTAL FROM dlr WHERE 1=1 AND dlr = 8 AND MONTH(date_time) = MONTH(NOW()) GROUP BY tanggal, operator_id ORDER BY d

Re: Multiple joins

FT JOIN, I am not sure whether you intend them to be LEFT JOINs or INNER JOINs. Try: SELECT fields FROM file1 LEFT JOIN file2 ON something INNER JOIN file3 ON something INNER JOIN file4 ON something INNER JOIN file5 ON something WHERE somecondition -- Gerald L. Clark Supplier Systems C

Re: why didn't I insert small number into table?

Could anybody give a hint why this occured and how to avoid this? Thanks in advance. Xiaobo Double defaults to double(16,4) and you have more than 4 decimal places. Try double(16,10). -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: h

Re: Recommended backup scripts for mysql databases

at least you know in advance exactly how much space it will take... Tim -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Left Join Help

Distinct| +++---+-+-++---+ I need to be able to run the full query on a daily basis without killing the DB engine. The query needs to pull in about 50,000 results. Does anyone see a way to optimize this query or rewrite it so it doesn't cause a huge system load? Thank you,

Re: Left Join Help

? Thank you, -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: error loading data from file > ERROR 1329 (02000): No data - zero rows fetched, selected, or processed

us the data, nor the command you used to load the data, we can't tell you what is wrong. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 4 Kernel Panic-ing

rsion 7.9.0: Wed Mar 30 20:11:17 PST 2005; root:xnu/xnu-517.12.7.obj~1/RELEASE_PPC How could a user space program like mysqld possibly cause a kernel panic? Sounds like bad kernel or bad hardware. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: ht

Re: Question on full text search scores, different content same score

nd these are the only two titles that are similar. I also tried IN BOOLEAN MODE as well. Thanks, Mark Perhaps because '(' and ')' are ignored, and 'MLM' is a three letter word, and not indexed. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing

Re: correct syntax

about LIKE "% %" -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: (yet another) sock issue

Charles Mégnin wrote: > > Although the my.cnf file specifies > socket = /tmp/mysql.sock > the server expects mysql.sock to reside in > /var/lib/mysql > > [mysql@localhost]$ /usr/bin/mysqladmin -u root -p password > Enter password: > /usr/bin/mysqladmin: connect to server at 'localhost'

Re: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

Well, since PHP is trying to use a socket in the wrong directory, you might check the PHP list to see if they can help you. This is not, strictly speaking a MySQL problem, so waiting here for the correct answer may not be the quickest route to the answer. I have seen several answers indicating th

Re: replace qeustion

That depends. Just the one 9, or all instances of 9 in 'C'? This is a basic SQL question, not a MySQL question. I would suggest finding a book on SQL. You could try: update Table_1 set c=20 where a=10 and b=18 and c=9; This will guarantee that only the first line ( O one just like it ) will be

Re: selecting null values

Title will never be = NULL. NULL is not equal to anything, not even NULL. SELECT * FROM table WHERE title IS NULL LIMIT 1; Peter Szekszardi wrote: > > Hi, > > I have a database which has a text field (let's name it title). The field > is NULL initially. Now I have about a hundred thousand reco

Re: Read/write table lock

Fabio Galarraga wrote: > > Yes, I think this is the problem. But how can I make a read/write lock with > only one lock? > > Best regards, > Fabio. > > > ------ > > De: Gerald L. Clark[SMTP:[EMAIL PROTECTED]] > > Enviado el: Martes, Marzo 20

Re: MySQL data structure

Asaf Maruf Ali wrote: > > Hello. > > I am interested to know the structure of MySQL. My ref book "MySQL and mSQL" by >O'Reilly states that for a table named book under a database Test following is the >structure: > > book.ISM > book.ISD and > book. frm > > On my system MySQL 3.23.27 beta the

Re: "Sending data" status

You are joining 5 tables with an OR on only two relations. Give it a year !! Surat Singh Bhati wrote: > > If I run the following query , mysql server process hangs forever and > it shows the "Sending data" status. > > select Count(*) from > Registration,Candidates,CompanyJobs,Resumes,Cand

Re: RH7 Mysql rpm intsallation problem

Get new RPMs from Redhat.com or mysql.com. Jason Baigent wrote: > > Hi, > > I'm trying to install RH7(Guiness) Mysql RPM. I installed mysql-3.23.22-6 > RPM,mysql-devel-3.23.22-6 RPM,mysql-server-3.23.22-6 RPM > > I used the GNOME RPM installer from files from the RedHat CD2. > > I tried /usr/

Re: ADVICE: Best way to store multi values

Assuming you have table staff with an id and name, and title with id and title, You create a join table. Staff_id Title_id 1 1 1 2 2 1 2 3 Then: Select name,title FROM staff s , title t, jointable j WHERE s.id=j.staff_id AND j.title_id=t.id; Mark Worsdall wrote: > >

Re: Best column type for an IP address

Jason Bell wrote: > > Hello all! > > Does MySQL have a function that converts an IP address from dotted decimal to >binary, and back > again? > > Jason Bell > INET_NTOA INET_ATON I'll leave it as an exercise to you to read Manual Chapter 7.4.12.

Re: Read/write table lock

Fabio Galarraga wrote: > > Hi to all: > Somebody knows how to make a read/writa table lock? > I'm trying with java source: > > stmt.execute("LOCK TABLES table-x READ, table-x WRITE"); > > stmt.execute("UNLOCK TABLES"); > > but it fails. > > Best regards, > Fabio Galarraga > [EMAIL PROTECT

Re: How to put and get gziped file to/from mysql db

Did you quote the data before inserting it? [EMAIL PROTECTED] wrote: > > Hello > I am looking for help how to put gziped plain data file to mysql DB > and then get it from there. > Every time I try OUTFILE to file and then gzip -d file name I got file corrupted > Any help will be appreciated >

Re: Can't connect server through socket /var/lib/mysql/mysql.sock(111)

It is more likely /tmp/mysql.sock tmp has no 'e'. denis mettler wrote: > > Hi, > > I did. but the problem is the same. > > regards > denis > > On Tuesday 20 March 2001 17:45, you wrote: > > try: > > [mysql] > > mysql.default_socket = /temp/mysql.sock > > > > > > Cal > > http://www.calevans.c

Re: Question for the mysql install..

You mus use GNU tar. ±è°æ¾Ö wrote: > > Hello!! > I have a question for the mysql install. > > Type of mysqlsource distribution > Mysql Versionmysql-3.22.32.tar.gz > My System SunOS stachyonbse01 5.7 Generic sun4u sparc SUNW,Ultra-60 > > After upload > > gunzip > mys

Re: mysql 3.22.32

houda chraibi wrote: > > Hello everybody, > I have some pb to administrate mysql, I can't create a new database error: > you are an anonymous localhost > I just can create a new tables in database already exist. > what can I do , please help m!!! Read chapter 6sss!!! --

Re: MySQL 3.22.32 and RedHat 7.0

Add execute permission to mysql.server. It is compiled without it. Tim Thorburn wrote: > > Hello, > > I'm a MySQL newbie (hopefully, there's a few others of me around so I won't > feel like I stick out so much). > > I've setup a Linux box running Red Hat 7.0 with Apache 1.3.12, PHP 3.0.18, >

Re: select ... having bug?

Having works on the result table, not the source tables. Since you did not select cnt, having can not examine it. Maybe you ment 'where' instead of 'having' ? \"Piotr Gapinski\" wrote: > > small problems with query below... > my fault? > > mysql> desc poll_answer; > +-+-+--

Re: [Fwd: Re: problems with linking]

edit /etc/ld.so.conf add a line for the directory that contains your library run ldconfig Alonso Guarisma wrote: > > Dear MySQL Sirs (or Andrew Schmidt) > Please see attachament for error messages. > Thaks in advance for any help. > > Alonso Guarisma > > Original Message > S

  1   2   3   >