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

Chris Africa wrote: Hi Gerald. Actually, mysql should have access, as it owns the entire directory. drwxr-xr-x 19 mysql wheel 646 May 30 09:41 mysql-5.0.41-osx10.4- i686 and nested inside that is drwxr-x--- 27 mysql wheel918 Jul 18 12:53 data Thanks! Error 13 is a

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'

temporary; Using filesort | | 1 | SIMPLE | t2| ALL | NULL | NULL | NULL | NULL | 1351 | | ++-+---+---+---+--+-+--+--+--+ -- ri

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

untz wrote: Gerald, I tried this and still got an error! mysql> grant all privileges on *.* to 'untz'@'localhost' identified by 'maddog'; ERROR 1045 (28000): Access denied for user 'untz'@'localhost' (using password: YES) mysql> Can

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]

Connect fails but only from this one file WHY

i am developing a php app. in the beginning of every file there is a require_once("./setup.php"); that does the housekeeping, fetches the connection credentials and connects to the database. All that worked fine until this morning I made a new file. Now I get a connection failure when I try

How to get a count from this query

SELECT avg(abs(pmd.value) - (mypmd.value))) as diff, pm.mname, pmd.uid FROM pmdata pmd, mnames pm, pmdata mypmd WHERE mypmd.uid= ? AND pmd.pmid=pm.pmid AND mypmd.pmid=pm.pmid AND pmd.uid != mypmd.uid GROUP BY pmd.pmid, pmd.uid ORDER BY pmd.uid What I would like also to return in this query is a

Re: Suppress table header when using ODBC

e the first row has a non numeric field header. and that is why I need it to go away. Gerald Taylor wrote: Hello, I am using a desktop program that imports data from a mysql database using the ODBC mysql driver and everything works fine except for one little glitch: it adds one extra row a

Suppress table header when using ODBC

Hello, I am using a desktop program that imports data from a mysql database using the ODBC mysql driver and everything works fine except for one little glitch: it adds one extra row at the beginning of the dataset with the names of the columns in it. I need for that column name row to NOT b

Re: Can't connect to mysql server from another windows box

word hashed by Old_Password(). Is ipconfig /all what you mean by lookup on the IPnumbers? That gives the name of the client box without domain.xxx. In any event, the 'technically incorrect' name did work, and adding the domain.xxx part of the name to the user record did not work. Gerald Will

Re: Can't connect to mysql server from another windows box

C Administrator, to an 'authentication protocol' message. Apparently Connector/ODBC 3.51 uses the old protocol. Gerald Williams -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can't connect to mysql server from another windows box

MySQL 5.0.12, P2P Microsoft network I cannot get the manual's instructions (24.1.9.6) to work for connecting from a mysql client on a windows machine to a mysql server running on another windows machine (xp and w2kpro repsectively) The client machine can ping the server machine by name or IP ad

Re: best practices for finding duplicate chunks

2 at doc1 and words 587-643 at doc2 with a marker. Yeah it looks ugly, and will take a lot of space for temporary data. But in the end you'll have all 20+ words duplicate chunks properly identified. On 8/14/05, Gerald Taylor <[EMAIL PROTECTED]> wrote: I just revived a database that was

best practices for finding duplicate chunks

I just revived a database that was in a version 3.23 server and moved it to a 4.1 There are big fields of TEXT based data. They have a way of compressing the amount of TEXT data by identifying common subchunks and putting them in a "subchunk" table and replacing them with a marker inside the

innodb hot backup (ibbackup) error

Hi all, I'm getting the following error when attempting to run a hot backup of a 4.0.18 MySQL database using ibbackup: ibbackup: We wait 10 seconds before starting copying the data files... 050330 14:26:33 ibbackup: Copying /mysqldata/mysqld1/ibdata1 ibbackup: Error: log scan was only able to

RE: insert was working

Richard, Explain auto_increment field please. Thanks, Jerry -Original Message- From: Richard Whitney [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 10:31 AM To: Gerald Preston Cc: mysql@lists.mysql.com Subject: Re: insert was working Gerald! Do you have an auto_increment

insert was working

Hi! I was able to insert data with the following: sub insert_sql { my ( $group_name, $me, $daily, $item, $unit, $qty, $amount, $tax, $total, $DEBUG ) = @_; print "[EMAIL PROTECTED]" if $DEBUG; ( $group_name, $me, $daily, $item, $unit, $qty, $amount, $tax, $total ) = &clean_sq

migrate from one machine to another

Hi there. I'm an Oracle DBA who know very little about MySQL. I need to migrate MySQL from one box to another. Can anybody point me to some documentation? The platform is Solaris 8, MySQL 4.0. Thanks for any pointers, it's greatly appreciated!

RE: insert data

John Trammell Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]; Gerald Preston Subject: Re: insert data Right. First, I think the logic is flawed. We should successfully prepare() or die. Period. If the call to prepare() failed ($sth is undef), we should not making dying conditional on yet anot

RE: insert data

x27;) WHERE Host = 'local_host' AND User = 'gjwpp88'; SET PASSWORD FOR 'gjwpp88'@'local_host' = OLD_PASSWORD('x'); SELECT 'local_host', 'gjwpp88', Password FROM mysql.user WHERE LENGTH('x') > 16; FL

RE: insert data

William, I tried " GRANT ALL ON *.* " and got error " 1064 <4200>: You have an error in your SQL syntax " ?? Jerry -Original Message- From: William R. Mussatto [mailto:[EMAIL PROTECTED] Sent: Monday, February 28, 2005 3:25 PM To: mysql@lists.mysql.com Subjec

RE: insert data

--- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Monday, February 28, 2005 9:29 AM To: Gerald Preston Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: insert data From perldoc DBD::mysql use DBI; $dsn = "DBI:mysql:database=$database;host=$hostname;port=$port";

RE: insert data

David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Sunday, February 27, 2005 3:27 PM To: Gerald Preston; mysql@lists.mysql.com Subject: RE: insert data Hi Gerald, The only thing I can think of is that you have a syntax error in your SQL that hasn't showed up in translation to email. Are

  1   2   3   4   5   6   7   8   9   10   >