Re: Databases not seen in MySQLCC

2004-06-18 Thread Hans-Peter Grimm
Marvin Cummings wrote: Have a strange problem where only one of my databases shows up in the MySQLCC console, yet if I look in the MySQL Admin console all databases are seen. Anyone experience this before? If you right-click the server entry in MySQLCC and select Edit, there is a Databases tab

Re: load data into 2 tables and set id

2004-06-18 Thread J S
Mos forgot to populate the url_id column in your user table. I would use his same process but re-arrange it like this: 1) create table BIG_TABLE 2) load data infile 3) create table URL_TABLE ( url_id bigint not null auto_increment, url varchar(25) not null primary key,

ODBC error

2004-06-18 Thread jschung
From a Windows2000 machine, I use ODBC Data Source Administrator to connect to mysql server on RedHat ES 3. I got the following message. [MySQL][ODBC 3.51 Driver] Host 'IP_address' is not allowed to connect to this MySQL server Any idea? Thanks, Joseph -- MySQL General Mailing List For list

Re: ODBC error

2004-06-18 Thread Cemal Dalar
You should check your privileges in mysql server. Look at the Host field in mysql.user table. Probably that is the problem and change the value to the Windows IP address. And don't forget to make FLUSH PRIVILEGES.. Ref: http://dev.mysql.com/doc/mysql/en/User_Account_Management.html Best

strange query result

2004-06-18 Thread Alex
Hi, ppl! I have a MySQL-server on FreeBSD-5.2.1 computer and a client on another computer under windows xp. I have the following simple query SELECT internal_number,page_no FROM pages WHERE docs=307 ORDER BY page_no that results in 587 lines with two integers only. Simple query with low

Losing some records

2004-06-18 Thread Sergey . Chistyakov

RE: Losing some records

2004-06-18 Thread Willem Roos
Losing some message body too :-? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 18 June 2004 13:11 To: [EMAIL PROTECTED] Subject: Losing some records Disclaimer http://www.shoprite.co.za/disclaimer.html -- MySQL General Mailing List For list

Group Query

2004-06-18 Thread shaun thornburgh
Hi, The following table produces a query that shows all bookings that user has made and groups the number of bookings by the users location code. mysql SELECT COUNT(B.Booking_ID), User_Location FROM Bookings B, Users U WHERE U.User_ID = B.User_ID GROUP BY(U.User_Location); At the momnet if no

Re: Group Query

2004-06-18 Thread Johan Hook
Hi, you can use: SELECT COUNT(B.Booking_ID), User_Location FROM Users U LEFT JOIN Bookings B ON U.User_ID = B.User_ID GROUP BY(U.User_Location); /Johan shaun thornburgh wrote: Hi, The following table produces a query that shows all bookings that user has made and groups the number of bookings by

RE: Group Query

2004-06-18 Thread Paul McNeil
You can use a Left Outer Join. Left Outer Join will include all that matches as well as that which doesn't. The resulting NULL entries for the count will evaluate to 0. SELECT COUNT(B.Booking_ID), U.User_Location FROM Users U LEFT OUTER JOIN Bookings B ON U.User_ID = B.User_ID GROUP

tricky timetable based query

2004-06-18 Thread Sam Russo
I recieve a delimited file whose fields are: day,slot,subject,room An example of this file is: 2,1,Mat,R1 3,1,Sci,R6 1,2,Sci,R6 3,2,Mat,R3 1,3,Eng,R2 2,3,Eng,R5 1,4,Mat,R7 3,4,Eng,R9 I need a mysql query that will generate a timetable which looks like: Day1Day2Day3

RE: strange query result

2004-06-18 Thread Victor Pendleton
Your explain plan should not change based on the client you are using. The explain plan is the path for the query not the return of data to the client. Are you using sockets when connecting locally on the Free-BSD machine? Sockets are normally faster than using the tcp/ip port. -Original

Re: load data into 2 tables and set id

2004-06-18 Thread SGreen
No problem!! Please post the structures of your big_table and your url_table (whatever you called them) and I will help you to rewrite step 4 to count how many times a URL appears in the big_table. Is this bulk import a process you need to do repeatedly? if so we need to worry about updating

Re: load data into 2 tables and set id

2004-06-18 Thread J S
Shawn, Thanks for helping on this. I really appreciate it. No problem!! Please post the structures of your big_table and your url_table (whatever you called them) and I will help you to rewrite step 4 to count how many times a URL appears in the big_table. mysql desc internet_usage;

MySQL Web Clustering...

2004-06-18 Thread Roy Nasser
Hi All, We have recently acquired some new machines for our ASP service, and I am investigating different options and setups to optimize everything. We currently have one large DB server, with RAID5, etc, running mysql and a few smaller servers for web applications, and e-mail. These smaller

Re: tricky timetable based query

2004-06-18 Thread SGreen
What you are trying to do is an example of what is called pivoting a table or creating a pivot table. SELECT slot , max(if(day=1, concat(subject,' ',room), '')) as day1 , max(if(day=2, concat(subject,' ',room), '')) as day2 , max(if(day=3, concat(subject,' ',room), '')) as day3

RE: Replication - promoting slave to master

2004-06-18 Thread stanner
I would need log-bin and log-slave-updates enabled on the slave, correct? So to automate the process it would be better to start both servers without the Master-host info in the conf file, letting Heartbeat issue the commands on startup to convert one box to slave. During a fail-over,

RE: Replication - promoting slave to master

2004-06-18 Thread Victor Pendleton
If the server has log-bin enabled it will log writes. If you have a daisy-chained master, one that serves as a master to other slaves, you will need to have log-slave-updates enabled. If this server is just another machine pulling from the master it is not necessary to log slave updates but it is

skip through records (dbf-mysql)

2004-06-18 Thread Tom Horstmann
Hi all, i try to simulate dBase-like record-skips through a compound (dbf-) order. Anybody did that before? Please give me a hint. thx in advance, TomH -- PROSOFT EDV-Lösungen GmbH Co. KG phone: +49 941 / 78 88 7 - 121 Ladehofstraße 28, D-93049 Regensburg cellphone: +49 174 / 41 94 97 0

Re: MySQL Web Clustering...

2004-06-18 Thread Cemal Dalar
Go for a simple MySQL master - slave configuration. I'm runing 1 master 3 slaves for performance issues and doesn't have any problem at all for 1 year.. Of course in this case you should change some code in your webservers to direct SELECT queries to slave machine to gain performance on the

Re: tricky timetable based query

2004-06-18 Thread Harald Fuchs
In article [EMAIL PROTECTED], Sam Russo [EMAIL PROTECTED] writes: I recieve a delimited file whose fields are: day,slot,subject,room An example of this file is: 2,1,Mat,R1 3,1,Sci,R6 1,2,Sci,R6 3,2,Mat,R3 1,3,Eng,R2 2,3,Eng,R5 1,4,Mat,R7 3,4,Eng,R9 I need a mysql query that will

Re: load data into 2 tables and set id

2004-06-18 Thread SGreen
JS, I need one more piece of information to help make that query work for you, I need the structure of the table that you use (or would use) to bulk import those logs into. If you are running out of room you may consider further normalizing you data (which saves space, but creates more data

Re: load data into 2 tables and set id

2004-06-18 Thread J S
Shawn, Thanks for the email below - I will go through it over later tonight in more detail (going home time now!) although I can already see good points there. JS, I need one more piece of information to help make that query work for you, I need the structure of the table that you use (or would

problems with 4.0.20 (icc)

2004-06-18 Thread Michael Spindler
Hi, yesterday I installed the 4.0.20 binaries, compiled with Intel C++ Compiler from mysql.com. I tried to transfer one of our (small) databases from the production-system (4.0.20 gcc binaries installed) to the test-system and came across the following problem: I did a mysqldump --opt ... |

RE: Replication - promoting slave to master

2004-06-18 Thread Alec . Cawley
[EMAIL PROTECTED] wrote on 18/06/2004 15:09:58: I would need log-bin and log-slave-updates enabled on the slave, correct? So to automate the process it would be better to start both servers without the Master-host info in the conf file, letting Heartbeat issue the commands on startup

Re: MySQL Web Clustering...

2004-06-18 Thread Peter J Milanese
I currently run LVS (pre-distribution) on my farm, which gets about 100M hits/month. Good points about LVS are that it is completely rock solid, and runs on minimal hardware. I have never run MySQL behind it, as I think that would be a bit flaky for a live site. Probably worth checking out

ERROR 1045: Access denied for user: 'foo@host' (Using password: YES)

2004-06-18 Thread Marc Tardif
I'm using mysql-3.23.58-1.9 installed from RPM on Red Hat Linux release 9 (Shrike). First, I create a database and user to connect to this database using the following commands: mysql CREATE DATABASE foo; mysql GRANT ALL PRIVILEGES ON foo.* TO foo@'%' IDENTIFIED BY 'password' WITH GRANT

Re: tricky timetable based query

2004-06-18 Thread Michael Stassen
Harald Fuchs wrote: Sam Russo [EMAIL PROTECTED] writes: I recieve a delimited file whose fields are: day,slot,subject,room An example of this file is: 2,1,Mat,R1 3,1,Sci,R6 1,2,Sci,R6 3,2,Mat,R3 1,3,Eng,R2 2,3,Eng,R5 1,4,Mat,R7 3,4,Eng,R9 I need a mysql query that will generate a timetable which

Re: MySQL Web Clustering...

2004-06-18 Thread Mike Miller
Unless you have a specific need for it, you could save yourself a lot of trouble by putting select tables or databases or even clients on each server. This also means you don't incur the added overhead of keeping the database in sync, creating actions if a master goes down, etc. Then just

MySQL SQL Case Stetement

2004-06-18 Thread Rafi Sheikh
Hi list. Can someone give me a working example of a SQL CASE statement(in SELECT)? I have examples for stored procedures, but none for use within the DML side of SQL. I am trying to in my SELECT (used in PHP) create a variable/col for example: status='high' where value in a other col is

Re: MySQL Web Clustering...

2004-06-18 Thread Jeff Smelser
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 June 2004 11:05 am, Mike Miller wrote: Unless you have a specific need for it, you could save yourself a lot of trouble by putting select tables or databases or even clients on each server. This also means you don't incur the added

Re: Ask again about comparing cast string to date

2004-06-18 Thread Michael Stassen
Cao, Wenhong wrote: I am trying to select the records where the field activationtimestamp is within a certain range. Unfortunately the field activationtimestamp is defined as character(14) in the table. Perhaps you should change the type of activationtimestamp: ALTER TABLE SubscriptionVersion

RE: MySQL SQL Case Stetement

2004-06-18 Thread Paul McNeil
I have used the CASE statement for ordering many times. It's very useful... SELECT myDATA, CASE WHEN data2 = SomeValue THEN 0 ELSE WHEN data2 = SomeOtherValue THEN 1 ELSE 2 END AS mySort from MyTable Where myConstraints. God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web

Re: MySQL Web Clustering...

2004-06-18 Thread Mike Miller
The meaning of that was client-side being sending inserts/updates to the master server. This would be done in the program/script upon an insert query. A daemon could forward insert/update requests to a master and all others round-robin and simply pass packets. This is if you have to make it

Re: MySQL SQL Case Stetement

2004-06-18 Thread Michael Stassen
The CASE function is documented in the manual http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html. SELECT CASE WHEN other_col 100 THEN 'low' WHEN other_col BETWEEN 100 AND 1000 THEN 'medium' WHEN other_col 1000 THEN 'high' END AS col FROM your_table; Michael Rafi

Clustered Index - Where is data inserted ?

2004-06-18 Thread Paul Chu
Hi, Can someone explain how the data is stored in a table using a clustered index. Does this mean that the data is inserted in the .myd file in sorted index order ? If so, how is space made to insert the new records ? Does this make inserting records slow because data is being inserted in

Full Text Index on Large Tables

2004-06-18 Thread Paul Chu
Hi, If I have a table with 100 - 200 million rows and I want to search For records with specific characteristics. Ex. Skills varchar(300) Skill id's 10 15 Accounting finance etc. Is it advisable to created a field with skill ids and then use the

Fastest way to load a master table removing duplicates

2004-06-18 Thread Paul Chu
Hi all, I want to load a Master table millions of rows for other sources with a unique index on e.g. ssn social sec number. If inserted records have a duplicate SSN I don't want to insert those but put them in a duplicate table or flag them. . The primary key will be an auto-increment

Re: Dying query ....

2004-06-18 Thread Heikki Tuuri
Ivan, - Original Message - From: Ivan Latysh [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Thursday, June 17, 2004 7:44 PM Subject: Dying query Hello! I am running: Server version 4.1.2-alpha-max-log On linux RedHat. When I execute a simple select,

Fresh 4.1.2 install on Redhat 9

2004-06-18 Thread jabbott
Hello List, I have done some googling around but can't find an answer to this one. Brand new box, installed with RedHat 9 and trying to run 4.1.2. This is what I get. --ja [EMAIL PROTECTED] mysql]# scripts/mysql_install_db --user mysql --log Installing all prepared tables 040618 11:06:51

RE: DROP TEMPORARY TABLE and implicit commits

2004-06-18 Thread Michael McTernan
Hi, I guess since it is documented, it is a new feature - I agree with the principal of not backporting it. Many thanks for the reply - can't wait for 4.1 to mature :-) Thanks, Mike -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED] Sent: 15 June 2004 13:00 To: Mysql

RE: Mysqld stalls

2004-06-18 Thread Michael McTernan
Dear Mark, You should be tweaking your mailer such that your mails originate fom [EMAIL PROTECTED], and not my own email address. Thanks, Mike -Original Message- From: Michael McTernan Sent: 27 May 2004 10:00 To: [EMAIL PROTECTED] Subject: Mysqld stalls I've been trying to fine

RE: MySQL4 and phpBB

2004-06-18 Thread Michael McTernan
Dear Mark, Is anyone experiencing problems with MySQL 4.0.17-max (other versions) and a lot of I/O type errors on large databases or especially running phpBB? This can be fixed by sending emails from your own email address ([EMAIL PROTECTED]), and not mine. Thanks, Mike -Original

Professional certification

2004-06-18 Thread Brian Mansell
I took the certification exam this morning and passed. When should I expect to receive the certificate (and other items) in the mail? --bmansell -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: PHP + MySQL Not Playing Nice Any More

2004-06-18 Thread Michael McTernan
Dear Mark, Please set your from address to [EMAIL PROTECTED], and don't use my email address. Thanks, Mike -Original Message- From: Michael McTernan Sent: 16 April 2004 10:21 To: Joseph A. Nagy, Jr.; MySQL General Subject: Re: PHP + MySQL Not Playing Nice Any More On 4/15/04

RE: Dumping mass inserts?

2004-06-18 Thread Michael McTernan
Dear Mark, And when I go to move them to the new db, I do use the mysqldump command since I am dumping to the new db? You need to correctly setup your mailer such that the from address is [EMAIL PROTECTED], and not my email address. Thanks, Mike -Original Message- From: Michael

RE: Corruption and my.cnf

2004-06-18 Thread Michael McTernan
Dear Mark, I think your emailer has also experienced corruption since your from address is actually mine. Please set it to your own email address, such as [EMAIL PROTECTED] Thanks, Mike -Original Message- From: Michael McTernan Sent: 09 April 2004 12:18 To: [EMAIL PROTECTED]

RE: Using PHP to copy tables

2004-06-18 Thread Michael McTernan
Dear Mark, You also seem to have used my email address before. Please correctly configure your mailer such that the from address is correctly reported as [EMAIL PROTECTED], and not mine. Thanks, Mike -Original Message- From: Michael McTernan Sent: 08 April 2004 18:36 To: [EMAIL

RE: Too Many Connections

2004-06-18 Thread Michael McTernan
Dear Mark, The best way to fix this is by correctly setting your from address in your mailer to [EMAIL PROTECTED] Thanks, Mike -Original Message- From: Michael McTernan Sent: 08 April 2004 10:33 To: [EMAIL PROTECTED] Subject: Too Many Connections What is the best way to

Best practice question

2004-06-18 Thread Randy Paries
Hello All, I have a design question I have a table that represents a Newsletter page. This newsletter can be single or 2 columns Here is my question. Currently the table is defined as Int articleID Int pagenum Texttitle Textbody Texttitle2 Textbody2 So here is my

Re: load data into 2 tables and set id

2004-06-18 Thread SGreen
welcome to a basic overview of bulk importing and normalizing as you go [ author's note: if you are seeing this thread for the first time and certain items seem to be introduced out of context, please review all previous posts in this thread. There has been a lot of

RE: GROUP BY across UNION

2004-06-18 Thread Michael McTernan
Hi John, Depending on the size of your datasets, you could merge the data into a TEMPORARY table and then compute from there? If the temp table is small enough it will fit in RAM as a heap table, and will probably be more efficient than fetching all the results and computing them in code. Of

RE: GROUP BY across UNION

2004-06-18 Thread John McCaskey
Hi Mike, This is a good suggestion. We ended up changing the requirements to not require the functionality I was trying to develop at the time. However, I did just change a temporary table I'm using for a similar process to HEAP and saw a very nice perfomance improvement. Should have thought

RE: GROUP BY across UNION

2004-06-18 Thread SGreen
I agree with Mike. In order to use the aggregate functions across both tables' worth of data you will have to combine them into one large table. That can be a real table or a temporary one but in either case you are stuck combining them BEFORE the calculations or MySQL won't be able to crunch

DBD::mysql problem

2004-06-18 Thread Kairam, Raj
I am unable to install DBD::mysql in my environment shown below RedHat Linux 9 perl v5.8.0 DBI-1.42 mysqld Ver 4.0.18-standard After unzipping and untarring the DBD-mysql-2.9003.tar.gz ( obtained from CPAN ), in the DBD-mysql-2.9003 directory I tried the following mkdir /tmp/mysql-static cp

Tuning mysql performance

2004-06-18 Thread Paolo Audiberti
Hello, I need some help tuning mysql. I'm running 3.23.58-Max-log on a Red Hat Linux Enterprise server with 1 gig of memory and 4 cpus. The database is used by a web application which runs on a separate machine. The performance is not so good. Can anybody tell me if my configurations are

Re: Fresh 4.1.2 install on Redhat 9

2004-06-18 Thread gerald_clark
It looks like mysql does not own the data directory. [EMAIL PROTECTED] wrote: Hello List, I have done some googling around but can't find an answer to this one. Brand new box, installed with RedHat 9 and trying to run 4.1.2. This is what I get. --ja [EMAIL PROTECTED] mysql]#

Re: Recommendation on god MySQL books

2004-06-18 Thread Lou Olsten
I really like the Certification Study Guide we just ordered last week. Great info that I'd wish I had when I started. I have no plans to take the test, but I love the way the info is presented and the questions at the end help ensure I got it. Lou - Original Message - From: Bartis,

EXISTS/NOT EXISTS

2004-06-18 Thread Anton Ivanov
Hi, I'm trying to figure out how to apply these from the manual, but to no avail. Is it possible that my version (4.0.18) does not implement these? I have two tables: products and products_by_product_area. Both have a field product. I try SELECT product from products WHERE NOT EXISTS (SELECT

Re: MySQL Installation Problem

2004-06-18 Thread Kofirowster
First, you'll get more help if you post to the list (Mysql General mailing list [EMAIL PROTECTED]) All the --console does is directs error messages to the console, i.e., the dos window you have open. If you leave it off the error messages go to a file. What you describe below without --console

Re: EXISTS/NOT EXISTS

2004-06-18 Thread Andrew Pattison
You are using a subquery. Subqueries are only supported in version 4.1 and later. You will eithe rneed to rewrite your query so that it doesn't use a subquery, or upgrade. Cheers Andrew. - Original Message - From: Anton Ivanov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June

Re: EXISTS/NOT EXISTS

2004-06-18 Thread Michael Stassen
Subqeries require mysql 4.1. The manual offers some suggestions on rewriting subqueries as JOINs http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html. In your case, you want something like: SELECT product FROM products p LEFT JOIN products_by_product_areas a ON p.product = a.product

DBD::mysql::db do failed: Table 'xxxxx' is read only

2004-06-18 Thread Michael Klama
I hope someone can help me with a problem. I recently changed one of my web servers over to a new box and this server has an internal MySQL server which is used to store several web queried databases. My old server ran Apache 1.3.27 and my new one is running 2.0.49 - Old MySQL was 3.2.23 and

RE: EXISTS/NOT EXISTS

2004-06-18 Thread Anton Ivanov
Thanks, I just found that relevant section in the manual, too. I wish it was clearer what version the manual documents -- I am using (almost) the latest stable release, and I should expect that the manual documents that. -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED]

DBD::mysql::db do failed: Table 'xxxxx' is read only

2004-06-18 Thread Michael Klama
I hope someone can help me with a problem. I recently changed one of my web servers over to a new box and this server has an internal MySQL server which is used to store several web queried databases. My old server ran Apache 1.3.27 and my new one is running 2.0.49 - Old MySQL was 3.2.23 and

REPOST: DBD::mysql::db do failed: Table 'abcd' is read only

2004-06-18 Thread Michael Klama
Sorry about the characters in the last post. Spambots didn't like it I hope someone can help me with a problem. I recently changed one of my web servers over to a new box and this server has an internal MySQL server which is used to store several web queried databases. My old server ran Apache

AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a one byte index :)

2004-06-18 Thread Kevin Brock
We have a table with a primary index which is INT NOT NULL AUTO_INCREMENT. After inserting ~87,000,000 entries, we started seeing error 1062, ER_DUP_ENTRY. We can get going again after doing an ALTER TABLE to reset the auto_increment starting point, but this takes about an hour... I've seen

Re: AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a one byte index :)

2004-06-18 Thread Scott Haneda
on 06/18/2004 05:16 PM, Kevin Brock at [EMAIL PROTECTED] wrote: We have a table with a primary index which is INT NOT NULL AUTO_INCREMENT. After inserting ~87,000,000 entries, we started seeing error 1062, ER_DUP_ENTRY. We can get going again after doing an ALTER TABLE to reset the

RE: Fastest way to load a master table removing duplicates - Not Answered

2004-06-18 Thread Paul Chu
Appreciate any help at all Thanks, Paul -Original Message- From: Paul Chu [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 10:16 AM To: [EMAIL PROTECTED] Subject: Fastest way to load a master table removing duplicates Hi all, I want to load a Master table millions of rows

RE: Full Text Index on Large Tables - Not Answered

2004-06-18 Thread Paul Chu
Appreciate any help at all Thanks, Paul -Original Message- From: Paul Chu [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 10:16 AM To: [EMAIL PROTECTED] Subject: Full Text Index on Large Tables Hi, If I have a table with 100 - 200 million rows and I want to search For

RE: Clustered Index - Where is data inserted ? Not Answered

2004-06-18 Thread Paul Chu
Appreciate any help at all Thanks, Paul -Original Message- From: Paul Chu [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 10:16 AM To: [EMAIL PROTECTED] Subject: Clustered Index - Where is data inserted ? Hi, Can someone explain how the data is stored in a table using a

Re: Too Many Connections

2004-06-18 Thread Jeff Smelser
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 June 2004 12:52 pm, Michael McTernan wrote: Dear Mark, The best way to fix this is by correctly setting your from address in your mailer to [EMAIL PROTECTED] Your email software seems to be wrong. All these people can't be doing

Re: DBD::mysql problem

2004-06-18 Thread Jeff Smelser
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 June 2004 03:00 pm, Kairam, Raj wrote: After unzipping and untarring the DBD-mysql-2.9003.tar.gz ( obtained from CPAN ), in the DBD-mysql-2.9003 directory I tried the following mkdir /tmp/mysql-static cp /usr/lib/mysql/*.a

Question about MySQL 4.0.20 and make test failure on Linux

2004-06-18 Thread Tom Williams
Hi! I'm trying to build MySQL 4.0.20 on RedHat 5.2 (I think) Linux system with glibc-2.2.5 and gcc-3.4.0 (which I recently upgraded to). The compile runs smoothly, but make test fails. Here is my configure command: $ ./configure --prefix=/usr/local/mysql-4.0.20 --enable-assembler

Re: Question about MySQL 4.0.20 and make test failure on Linux

2004-06-18 Thread Jeff Smelser
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 June 2004 11:48 pm, Tom Williams wrote: Hi! I'm trying to build MySQL 4.0.20 on RedHat 5.2 (I think) Linux system with glibc-2.2.5 and gcc-3.4.0 (which I recently upgraded to). The compile runs smoothly, but make test fails. Here is