Multithreaded?

All installations of mysql I have run ps -fax will show about 5 mysql proccess running, even at idle. I compiled on a Redhat 9 box, it did find pthreads however ps -fax show 1 mysqld process running. Is there a spot to configure spare proccess? -- Or verify that it is indeed compiled

Re: quick PHP question

things like: ?php echo strtotime(43145 seconds); ? 1062265296 -- Greg Donald http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: replication problem

Beacuse of this type of mail , i got listed on spam bag for using the mailing lists inform the linux comunity of my site , wich is a free service. If see this kind of junk on any mailing list ill make it my personal mission to have you domain fried Don't post unless it's goning to help the

Require pair of fields to be unique?

paired up paired together more than once. Maybe I'm missing a better way to setup this table. If I am, please let me know. Thanks. -- Greg Macek | Senior IT Manager Marketing Resources, Inc. [EMAIL PROTECTED] | http://www.mrichi.com -- MySQL General Mailing List For list archives: http

Re: Cloning a Database

I need to know if is there anyway to clone a existing database (structure and data)? I use mysqlhotcopy myself. http://www.mysql.com/doc/en/mysqlhotcopy.html -- Greg Donald http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Newbie questions (3) - listeners / BLOB / PHP

manuals. -- Greg Donald http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: need help

. -- Greg Donald http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: need help

Is there any way to seed a column set to autoincrement? Say I wanted it to begin at 1. alter table table_name auto_increment = 1; -- Greg Donald http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

two-field primary key update issue

but cannot find anything. Any help would be greatly appreciated. Thanks. -- Greg Donald -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: two-field primary key update issue

working. I have looked high and low for an example of such a query but cannot find anything. Any help would be greatly appreciated. Thanks. what was the value of fieldValue prior to the update? fieldValue is vertical before the update. -- Greg Donald http://destiney.com

Re: Delete orphan records

this way manually. Any help appreciated.. On Wed, Jun 18, 2003 at 10:10:57PM -0700, Jake Johnson wrote: Hello Greg, You are much better off using a not exists clause... delete from child c where not exists ( select 1 from parent p where p.id = c.id) Regards

Re: Delete orphan records

Nevermind... Just read an interesting comment in the MySQL online docs. http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html First user comment pointed me in the right direction. Thanks for your help though. Much appreciated! (Especially when I upgrade to 4.x) -- Greg On Tue, Jun 24, 2003

Re: Post-installation Testing

to setup password /usr/local/mysql/bin/mysqladmin -u root password password /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password password -- Greg Klaus -=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=- Nec Mors, Nec Requies. Carpe Noctum! -- MySQL General Mailing List For list archives: http

MySQL 3.23.57 has been released

a bug in mysqldump when it was invoked with the --master-data option: The CHANGE MASTER TO statements that were appended to the SQL dump had incorrect coordinates. (Bug #159) Regards, - Greg -- Greg Weir, Production Engineer MySQL AB, www.mysql.com Are you MySQL certified

Delete orphan records

Items_ID Any help would be appreciated. Am I left to create a php script to do the cleaning for me or delete items individually? -- Greg Nec Mors, Nec Requies. Carpe Noctum! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Query cache not working with JDBC driver?

driver, it won't use the cache when the it sends the same query. Does anyone have any clues why this is? I read somewhere that there's a problem when the driver uses compiled prepared statements and can't access the cache then, but other than that it should use the query cache, right? Thanks Greg

Red Hat linux database to Mac OS X

Hello, I was wondering if anyone has experienced moving a MySQL database from Linux/Intel X86 to Mac OS X? I plan to use mysqldump of course. I was only wondering if anyone has run into problems they might share. Thanks. Greg __ Do you Yahoo!? Yahoo! Calendar

Unable to create database using WinMySqlSdmin

to Create Database Drop Database Refresh Database Thanks, Greg Foulks

Re: MySQL v SAB DB

SAPDB doesn't have collation (i.e. case-sensitivity). Be aware of this before you make a choice. While I was trialing it, the support was exceptional with very quick response from actual SAP engineers, but the lack of case-sensitivity was a show-stopper for me. Greg - Original Message

Re: Exporting Data

How would you export your data from the mysql tables to a tab or coma delimiter. There are lots of ways, here are my favorite two: mysqldump: http://www.mysql.com/doc/en/mysqldump.html phpMyAdmin : http://phpmyadmin.sourceforge.net/ -- Greg Donald http://destiney.com

Re: InnoDB vs. MySQL performance Issue

select crap from blahblah where nobody_is_interested = 'Y' sql,query - Original Message - From: Sameh Attia [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 06, 2003 7:32 PM Subject: Re: InnoDB vs. MySQL performance Issue Sam Przyswa wrote: Sameh Attia ([EMAIL

Re: query requiring two results from one table?

Yes, this is what i ended up doing and it works just fine. I wanted the results in one record and this does the job just fine. I don't know enough about performance issues and whether this kind of query is inefficient compared to using a different database layout, but this is not a highly

Re: simple (I thought) delete question

tids_admin.id = tids.admin_id) otherwise, you'll need to issue multiple statements. e.g. 1. locate records to delete 2. delete records either in bulk using an IN (id1, id2, id3,) expression or just deleting one at a time greg. - Original Message - From: Richard Forgo [EMAIL PROTECTED

Re: simple (I thought) delete question

') - Original Message - From: Greg Matthews [EMAIL PROTECTED] To: Richard Forgo [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 9:29 AM Subject: Re: simple (I thought) delete question if you want to do it in one statement, you'll need to wait for subselects

query requiring two results from one table?

Hello, This is my first post to the list, so if I am asking in the wrong place, I apologize. I've got some trouble putting together a query with the following tables Games: Teams: gameid teamid homeid name awayid datetime i want to get all games within a certain

query requiring two results from one table?

Hello, This is my first post to the list, so if I am asking in the wrong place, I apologize. I've got some trouble putting together a query with the following tables Games: Teams: gameid teamid homeid name awayid datetime i want to get all games within a certain

RE: query requiring two results from one table?

Thanks Matthew. that works perfectly. I totally forgot you can just select the table twice. thanks for the quick response. gf Matthew Smith [EMAIL PROTECTED] 12/30/2002 11:34 AM Please respond to msmith To: [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject:

JDBC driver / JBoss

type=java.lang.Stringjdbc:mysql://dev/activelist;prop1=val1;prop2=val2/c onfig-property Thanks, Greg sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: JDBC driver / JBoss

/config-prop erty Other variations of namedPipePath, like c:/mysql/pipe also fail, and yes, there is a directory called c:\mysql Any help much appreciated, Greg. PS. Using the standard IP-based connection (i.e. not named-pipes) seems to kick MS Sql Servers arse in terms of speed. - Original

scanning for auto increment columns

on business knowledge) which tables have auto incremented columns. I've tried: 1. Going over the java.sql metadata functionality to see if I can query this through the standard java.sql functions. 2. Searching the MySql manual Any help much appreciated. Greg. sql, query

Re: scanning for auto increment columns

ok, just answering my own question here. found it. describe tablename contains auto_increment in the extra column, which gives me what I want. sql,query - Original Message - From: Greg Matthews [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, December 28, 2002 8:34 AM Subject

Disappearing records?

at a loss. Any direction is appreciated. Running Mysql 3.23.49-log on a SuSE 7.3 box running on Dell PowerEdge 2550. Lots of RAM and hard drive space. It's a MyISAM table at the moment. The machine has been running since late July w/o reboot (server and mysql itself). - Greg

Re: Disappearing records?

on the system? On Mon, 2002-11-18 at 10:37, Dan Nelson wrote: In the last episode (Nov 18), Greg Macek said: Hello, I have a problem that I could use some help with. We're running a mysql/php intranet site for time sheets (home grown solution). However from time to time a user will tell me hours

Re: Disappearing records?

for now and keep a watch on things. The table is still small ( 5000 records) so reporting speed isn't too much of a problem right now. On Mon, 2002-11-18 at 10:52, Dan Nelson wrote: In the last episode (Nov 18), Greg Macek said: That's the weird part of it. Last week in reviewing the system

Upgrading mysql with mysql binary vs. compiling

Is there any reason I should use my MySQL supplies binaries to upgrade my currently installed version? I compile the running version (3.23.49). Is there any difficulty in doing this? Any pitfalls to watch out for, or should I just continue to compile my own and upgrade via that path? - Greg

INSERT INTO ... SELECT question

and manually updating the field. Thanks. - Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

Re: INSERT INTO ... SELECT question

Well, amazingly enough, it works great! I found a test box to try it on first before implementing this on the production box. This will definitely make life easier... On Thu, 2002-11-14 at 10:14, gerald_clark wrote: Did you try it? Did it work? Greg Macek wrote: Hello, I recently

Re: INSERT INTO ... SELECT question

wrote: Hey Greg: A slightly easier way to do this is to use a timestamp field. Timestamp is just a standard mysql data type. When a record is added, it records the current time. When a record is updated, the timestamp field will be set to the time of the update. http://www.mysql.com/doc/en

Re: Reference Integrity - MySQL 4

4.0 can be downloaded now and supports RI -- if your tables are InnoDB tables, and you create indexes on the fk columns. The online mysql manual has a lot of information on how to setup InnoDB tables -- chapter 7. Greg. - Original Message - From: Hernan Seivane [EMAIL PROTECTED

Re: RE: MySql 4.1 Sub Selects and not stored procedures

, Greg. - Original Message - From: Dan Rossi [EMAIL PROTECTED] To: Victoria Reznichenko [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, November 11, 2002 11:04 PM Subject: RE: RE: MySql 4.1 Sub Selects damn , i read it was 4.1 i guess we have to wait a bit then, i wish i could program

Re: RE: MySql 4.1 Sub Selects and not stored procedures

the question was: Do any MySql coders writing subselects in 4.1 know whether EXISTS will outperform an equivalent query written as a join. = yes or no ? greg. - Original Message - From: Arthur Fuller [EMAIL PROTECTED] To: Greg Matthews [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent

Re: MySql 4.1 Sub Selects

tableB.myCol = tableA.myCol ) or select columns from tableA where exists ( select 1 from tableB where tableB.myCol = tableA.myCol and tableB.someCol in ('A','B','C') ) Regards, Greg. - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Greg Matthews [EMAIL PROTECTED] Cc

Re: MySql 4.1 Sub Selects

it works on mysql 4.0 if 4.1 will be out within a few months. Seems like I might be best to check again in a while and see how quickly you guys have progressed with 4.1. Cheers, Greg. - Original Message - From: Harald Fuchs [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, November 10

Re: MySql 4.1 Sub Selects

on 4.1 anticipate the performance of the MySql sub select functionality to be better than an equivalent query written as a join? I guess any answer to this should also include consideration of sometimes putting DISTINCT in the select statement. Thanks a lot, Greg. - Original Message - From

MySql 4.1 Sub Selects

All, Anyone have any rough idea when 4.1 (with SubSelects) is due to be released? Thanks, Greg. sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: MySql 4.1 Sub Selects

state. Greg. - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Greg Matthews [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, November 10, 2002 4:21 PM Subject: Re: MySql 4.1 Sub Selects On Sun, Nov 10, 2002 at 03:45:04PM +1100, Greg Matthews wrote: All, Anyone

RE: inserting records

ascending; Hope this helps, Greg sql, query -Original Message- From: kayamboo [mailto:[EMAIL PROTECTED]] I have a table with only one column and values are inserted by getting user request from my application. I want to display the column values in the order they are inserted. So only

RE: Query for multiple rows

should be able to get rid of the count(1) in the select list if you want. For more information on select queries and the having clause you can look at this manual page: http://www.mysql.com/doc/en/SELECT.html Greg SQL, query, duplicate, having clause -Original Message- From: Phillip S

RE: Problem with UPDATE table ... can u help plz?

The Update Syntax Manual page 6.4.5 http://www.mysql.com/doc/en/UPDATE.html doesn't mention INNER JOIN and the comments on that page seem to indicate that this is a functionality lacking in MySQL though the last comment on the page shows a kluge workaround. Greg -Original Message

RE: Date Woes

if someone wants a function to do something, can't you just write your own and then publish it for all to enjoy(hint hint Serge)? Perhaps if it's good enough it would be added to the MySQL set of core functions to everyone's benefit? http://www.mysql.com/doc/en/Adding_UDF.html Greg -Original

RE: Export of text fields from Access2000

not going to do anything about it. See Troubleshooting in Microsoft KB article Q321686. Greg -Original Message- From: Ivo Dvorak [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 6:18 AM To: [EMAIL PROTECTED] Subject: Export of text fields from Access2000 Hello, I export a table

can't insert records with ID 0

. Does anybody here use phpMyAdmin and know how I can overcome this? Many thanks for any help received! Regards, Greg Conway. This electronic transmission and any files attached to it are strictly confidential and intended solely for the addressee. If you are not the intended addressee, you must

Problem with install on Sun sparc solaris OS 5.8

of installing the tables. Error ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libstdc++.so.3: open failed: no such file or directory Killed Installation of grant tables failed! -- Greg Johnston Office 612-313-1286 Cell 917-617-4278

faster update

Hello, I was wondering if there was anyway for me to speed up my update query. I wanted to index the field that i was searching for., but i heard that indexing slows down updates or that some information might not work...is that true? thanks for any help. my update statement: UPDATE

MySQL databases lost?

used to have four databases. Any help you can provide would be appreciated. I don't know what other information would be helpful, but will do my best to provide it if anyone asks. Thank you, Greg Westin [EMAIL PROTECTED

faster update

Hello, I was wondering if there was a better way to speed up my update statement in my perl script. It goes through all the entries in the database , which is around 800, 000, and then updates the email field. The problem is that it takes to long. thanks in advance for any help here

Re: faster update

On Thursday 06 June 2002 08:53 am, you wrote: On Thursday 06 June 2002 9:51 am, Greg D. wrote: I was wondering if there was a better way to speed up my update statement in my perl script. It goes through all the entries in the database , which is around 800, 000, and then updates

data scrambles

is no longer taking place. Any help or directions to solution in docs would be appreciated. MySQL, database, etc. -- Greg Peretti web developer www.abqjournal.com (505) 823-3888

error during configuration

return type of sprintf (END) I am a newbie at MySQL, so any help would be appreciated. Thanks. Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

loading data with sub-categories

table for each class? Or should there just be more preparation of the text file to make it conform? Point me toward something similar someone else has done and I'll pursue it. for filter: MySql, database, query, Mephistopheles -- Greg Peretti web developer www.abqjournal.com (505) 823-3888

re[2]: [linux-lvm] System Suggestions

to work with XFS, please let me know. Greg Freemyer Internet Engineer Deployment and Integration Specialist The Norcross Group www.NorcrossGroup.com On Wednesday 06 March 2002 02:40 pm, Petro wrote: On Wed, Mar 06, 2002 at 11:52:30AM -0500, Anthony W. Marino wrote: Could someone, please

Fail-Safe Replication

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi! I'm about to embark on a rather large project using MySQL, and am eagerly awaiting fail-safe replication. However, due to deadline restraints, I need to get started right away... I'm willing to develop using beta, but I was wondering when

Converting Column to SET

selections are redefined? The reason behind the previous setup was to allow easy changes to the selection list and isolate the definition of the list from the database. I know SET is faster, but these are really small databases. Thanks. -- Greg Willits -- [EMAIL PROTECTED

SET Conversion Questions

list and isolate the definition of the list from the database. I know SET is faster, but these are really small databases. Thanks. -- Greg Willits -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com

Re: Joining tables using IN (...) clause returns duplicate rows

ago as Mr. Milivojevic states, wouldn't I expect it to find its way into the 3.23.X series as the production series? I really like MySQL and don't mean this as any type of a flame, just wondering what the versions mean. Thanks for any insight anyone can shed on this for me Greg Bailey

Joining tables returns duplicated rows

in (0,1,2) and event.severity in (2,3); yields a result set of 30 rows, with duplicated IDs Fix: Submitter-Id: Greg Bailey [EMAIL PROTECTED] Originator:Greg Bailey Organization: LXPRO.COM MySQL support: none Synopsis: Joined tables return duplicate rows with IN (...) construct

Determining day of year

be the 32nd day of the year, for instance. Is this simple and/or possible? -- Greg Peretti web developer www.abqjournal.com (505) 823-3888 --- The web of our life is of a mingled yarn, good and ill together. - William Shakespeare

mysql lost it's ability to perform transactions?

any options. Anybody got any ideas on what I'm doing wrong? Any help much appreciated! Regards, Greg Conway. -- +---+ | Greg Conway, Technical Director | |GML Networking Technologies| +---+ Email/MSN:mailto:[EMAIL

RE: mysql lost it's ability to perform transactions?

Wow! thanks for the responses! Here is what I think you are mostly asking for... I have run mysqladmin variables to get this. Regards, Greg

Re: print database schema

Check out this program. Just wish there was an OS X version :-( http://www.datanamic.com/dezign/index.html -- greg willits -- [EMAIL PROTECTED] From: Steven Wren [EMAIL PROTECTED] Date: Tue, 29 Jan 2002 16:22:12 +1000 (EST) To: Paul DuBois [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re

Case for Field Name Alias

to solve hairy conflicts when merging sysems or something. But does the simplification of using standardized routines like this also make for good reason to use them? Wanting to have adopt good habits from the beginning Thanks. -- Greg Willits -- [EMAIL PROTECTED

multi-master replication

from different machines back onto one database machine, where the databases from the different machines can be joined without the use of daisy chaining to bring it all back together. Is there some way to over come the single master replication limitation now? Thanks, -- Greg Donald [EMAIL

Changing part of field

month. Is there a simple way to change all home.coms to comcast.nets while retaining the front part of each email address in our database? A link to the pertinent section of the manual would be most helpful. -- Greg Peretti web developer www.abqjournal.com (505) 823-3888

Importing large text file

field is always preceded by Date: and if no Date: is found, skip the field? I'm using 3.23.44 -- Greg Peretti web developer www.abqjournal.com (505) 823-3888 --- The web of our life is of a mingled yarn, good and ill together. - William Shakespeare

Automated Failover

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi! I'm currently in the preliminary planning phases of a content delivery system. We will be generating pdfs on the fly containing our member's statements. The system will be accessible both from our internal systems and through our web-banking

re: Selecting unknown columns

How about this: update table set answer = concat_ws(, , if(left(columnA,1)=*,substring(columnA,2),), if(left(columnB,1)=*,substring(columnB,2),), if(left(columnC,1)=*,substring(columnC,2),) ) Greg I've got a 700-question multiple choice quiz that I've got

Gaps with auto increment and INSERT ... SELECT?

in the sequence? If I must lock, can I then be absolutely confident there will be no gaps? I need to update a different table based on the values assigned to the newly inserted records. Greg - Before posting, please check: http

Select with multiple records

the table contains multiple entries for any given job_id. I would like to be able to run a select on the table to retrieve the latest entry for each job_id so I can display a latest status message for every job. How do I (assuming that I can) construct the SELECT statement to do this? Thanks! Greg

time grouping in mysql

and then group by the timestamp to return only distinct seconds (timestamp). the timestamp field is multivalued. Any thoughts Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

help with a query

be appreciated. Greg PS Maybe this isn't to clear. I do have a png er diagram of the database. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Can not load database

a stab at it I will email you the isd,ism, frm files off list. 2.2megs I do not have any mdi, or mdy files for the database yet. Thanks in advance Sincerely Greg Maxwell - Before posting, please check: http://www.mysql.com

Seg faults with mysql_query mysql_ping using libmysqld

the code with the following command: gcc -g -W -Wall -D_THREAD_SAFE -D_REENTRANT -I/usr/include/mysql mysql.c -L/usr/lib/mysql -static -lmysqld -lpthread -lz -lcrypt -lnsl -lm -lrt -o mysql Greg Kurzawa [EMAIL PROTECTED] [EMAIL PROTECTED

Binary dist of 3.23.43 ok, 4.0.0 alpha fails to start

Dear All I've reverted back to 3.23.43 from 4.0.0 as I was unable to get it to start on my (patched) Redhat 6.2 box. Has anyone else managed to get the binary distro of 4.0.0-alpha to start on a Redhat 6.2 box ? Thanks Greg sql

bug (+ fix) in mysql_config ! breaks DBD::Mysql

I'm not attaching a patch. This breaks things that use mysql_config (eg perl's DBD::Mysql modules installer thingy). Thanks. Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: XML Support

a few MySQL chipped in. Sorry if this sounds a little negative and sarcastic, but I've delt with a few projects where it got over complicated because of the use of XML/XSLT, and managers whom want to use a product because its got nive brochures and buzwords . Greg Cope Regards, Gary SuperID

Do I need locking re update/retrieve id for an table with autoincrement

really be putting some sort of locking around this to avoid obtaining the wrong ID value in high load situations??? If so what locking method is recommended?? (a sample code excert would be nice). Thanks in advance Greg _ Get your

Mysql Error

not be loaded. 0509-152 Member shr.o is not found in archive. I do have zlib installed and it is in the correct place. Has anybody else had this error and have any information it get it to work? ThanX, Greg - Before

Re: backup/restore of mysql

wan't to switch to another database, but as this one grows, it's becoming incrisingly important to be able to do a complete database recovery in the event of a crash. Use a proper operating system, with RAID (either hardware or software RAID 1, or 5) Greg Kindest thanks! Pete

Re: Random Selection

I have a database of 5.6 million records and I need to choose 5000 random records. What would that query look like? select * from records order by rand() limit 5000; destiney - (des-ti-ny) - n. 1. deity of all things

problem with d/l

Hi, I can't download http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-1.zip Can you help? Been trying several times and from several places thanks bye greg - Before posting, please check: http

Re: problem with d/l

-win32-static-1.7.5-1.zip Can you help? Been trying several times and from several places thanks bye greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: mysql

I have downloaded the source file mysql-3.23.39.tar.gz But when I do gunzipmysql-3.23.39.tar.gz tar -xvf mysql-3.23.39.tar I get this eror message tar: Error exit delayed from previous errors after the tar is done Then I cd mysql-3.23.39 ./configure --prefix=/usr

Binding to one IP address on a multihomed host

Dear All I want to bind mysqld to one IP address on a multi-homed host. A search of the manual has not revealed anything - have I missed something or is this not an option ? If its not an option can it be added ? Thanks Greg

Re: Error 127?

) MySQL manual c) What have you done with myisamcheck and have you tried either -r or -o as arguments - Read the very good manual if if do not know what these do. Greg thanks again, Cesar A. Cabrera E. -- 'http://www.utp.edu.co/Lince

Re: apache/php/modperl incomp?

use this parameter ? Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e

Problems with make on redhat 7.1

I have been unsuccessful doing a make for mysql-3-23.29 using redhat 7.1 on an Intel Pentium with 64 megabytes. There seems to be a problem with file db.h. I am doing the install from the source tarball mysql-3.23.39.tar.gz , not the RPM. Here is an excerpt from the session: (lines cut,

Parameterized and spatial data

Hi all, this is probably a silly question, but as I am a student who wants to use MySQL for a project, I would like to know if MySQL supports parameterized tables and if supports spatial data. Thanks.

Re: $dbh-tables, SHOW tables, etc.

, show databases now work. I come across this problem - and its complier / optimisations related. gcc 2.92.3 + pgcc patches works OK for me. 2.92.3 plus optimisations is can fail. YMMY - but ditch 2.96 until its safe ! Greg Thanks for the heads up Colin. Daniel wrote: I'm up

No Curses/termcap library found

Help, I get this configuration error when trying to configure mysql. Any solutions. Greg Robillard

unlocking read only table

One of the tables of my database suddently became read-only; when I try to add a line, I get: ERROR 1036: Table 'Requests' is read only I'm alone working on this table, and didn't lock it. Does anyone know how I can unlock this table? TIA Greg

<    1   2   3   4   >