[SOLVED]Re: LEFT JOIN problem
Thanks Roger That fixed the problem.I was under the impression that I only had to put the linked columns n the ON and everything else in the WHERElive an learn I guess. Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] "There are 10 kinds of people in this world, those who understand binary and those who don't" (Unknown) - Original Message - From: "Roger Baklund" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Rory McKinley" <[EMAIL PROTECTED]> Sent: Thursday, November 20, 2003 4:23 PM Subject: Re: LEFT JOIN problem > * Rory McKinley > [...] > > SELECT a.line_number, a.category_value, IFNULL(b.parameter_trigger, 0) > > FROM DB1.Table 1 AS a LEFT JOIN DB2.Table 2 AS b ON > > a.category_name = b.parameter_value > > WHERE a.line_type = 13 AND b.parameter_ID = 13 > > > > The only problem is that the query only returns the first two > > records and not the third record - contrary to my expectations. I > > am using MySQL 4.0.15-standard together with PHPMyAdmin 2.5.3. > > > > Does anybody know what I am doing wrong? > > You have a criteria on the B table in the WHERE clause. Move it to the ON > clause: > > SELECT ... AS b ON > a.category_name = b.parameter_value AND > b.parameter_ID = 13 > WHERE a.line_type = 13 > > -- > Roger > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: unable to connect after log in
Hi Have you tried using mysql_connect instead of mysql_pconnect? Does it make any difference? Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] "There are 10 kinds of people in this world, those who understand binary and those who don't" (Unknown) - Original Message - From: "chilie palmer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 21, 2003 10:12 PM Subject: unable to connect after log in > > I have a connection problem that I have been unable to solve after searching > the web and the mysql mailing-lists. I'm connecting to a local database > using PHP. It's a pretty simple and straightfoward setup, a user logs in > and the links they have access to are displayed (change user info, update > password, etc). I can log in with the initial links displayed (database > connection is made), but after that (either by clicking a link or hitting > refresh on the same page I just logged in to) I get the following error: > > Access denied for user: '@localhost' to database 'my_DB_name' > > The only way I have been able to work around this is by giving Select, > Insert, Update, Delete permissions to the host 'localhost' (no user or > password) in the mysql.users table. If I give this host no permissions, the > script works as described above, only logging in once. Below is the PHP db > connect function that I am using (included via require_once on all pages). > I have tried to connect both with root and another user I created with all > permissions. I have also tried creating a user in the mysql.db table with > 'localhost - my_DB_name - my_DB_user' and all permissions. > > function db_connect() > { >$result = mysql_pconnect('localhost', 'my_DB_user', 'DBPASSWORD'); >if (!$result) > return false; > >if (!mysql_select_db('my_DB_name')) > return false; > >return $result; > } > ?> > > Is there something I've overlooked here in my connection setup? I can't > give the localhost host permissions in my production environment for > security reasons. Any help, suggestions, or ideas are appreciated. (Using - > MySQL 4.0.13, PHP 4.3.2) > > Thanks > > _ > Want to check if your PC is virus-infected? Get a FREE computer virus scan > online from McAfee. > http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Moving databases
Off the top of my head:) In the my.cnf file under the [mysqld] section add the following line: datadir= /path.to/new/datadir Stop mysql. Move all dbs to new datadir (if your'e only using MYISAM, this is a straight copy). Restart mysql. HTH Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] "There are 10 kinds of people in this world, those who understand binary and those who don't" (Unknown) - Original Message - From: "David Wilson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 22, 2003 5:49 PM Subject: Moving databases We are running MySQL 3.23.47 on a AIX Risc System. It is IBM's compiled version of MySQL, it does everything as far as installing and compiling it for us. But what we found is that is stores the databases where it wants and would like to move them but cant seem to figure it out. Does anybody have a clue -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [MYSQL] Combine tables from two different systems
Hi Paul If all the tables have a primary key set, you can do an INSERT IGNORE from the tables in System A to the tables in System B (either manually or write a script). Any rows form System A that already have a System B equivalent will be silently dropped and only those that do not have an equivalent will be written. e.g. INSERT IGNORE INTO system_b.table_n (columns) SELECT columns FROM system_a.table_n HTH Rory McKinley Nebula Solutions 082 857 2391 [EMAIL PROTECTED] "There are 10 kinds of people in this world, those who understand binary and those who don't" (Unknown) - Original Message - From: "PAUL MENARD" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 09, 2003 5:21 PM Subject: [MYSQL] Combine tables from two different systems > Hello All, > > I have two system, we shall call then system A (OLD) and system B (NEW), running MySQL that I want to combine their tables. The system B is the newer and most accurate. The table structure is the exact same. Some of the rows in system B (NEW) tables are also in system A (OLD). For those rows I want to leave the system B data unchanged. > > I have a select statement with a left join that will tell me the rows that are in system A but not in system B (the target). Question is how to I write a SQL statement to also insert these rows? > > System information. > > Windows NT4 (System A), Windows server 2003 (System B). > MySQL 3.23.42-nt running on both systems. > > Paul > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: newbie select statement question
I am not sure if this has any significance - but isn't 31 Dec 1969 the day before the UNIX epoch (1 Jan 1970 - i think)? Jordan, how are the dates stored in the database - as dates or unix timestamps? Also, the function fixDate isn't in the online PHP manual - is it a function defined by you? - could that not be doing something weird? Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] "There are 10 kinds of people in this world, those who understand binary and those who don't" (Unknown) - Original Message - From: "Diana Soares" <[EMAIL PROTECTED]> To: "Jordan Morgan" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTECTED]> Sent: Friday, October 10, 2003 8:58 AM Subject: Re: newbie select statement question > Look at: > > if ($tenureid=3) > > You're not comparing $tenureid with 3, you're assigning 3 to > $ternureid... If you want to compare both values, you must use the > operator "==" (and not only "="). > > > On Fri, 2003-10-10 at 05:43, Jordan Morgan wrote: > > Hi, > > > > I have the following statement: > > > > echo "$tenureid"; > > > > if ($tenureid=3) > > { > > // get faculty employment record - award date > > $sql = "select TD.Award_Date from TenureDescription TD LEFT JOIN InstitutionEmployment IE on TD.TenureDescriptionID=IE.Tenure WHERE IE.FacultyMember='$fid'"; > > $result = mysql_db_query($database, $sql, $connection) or die ("Error in query: $sql. " . mysql_error()); > > > > // obtain data from resultset > > list($tenuredate) = mysql_fetch_row($result); > > > > echo "Date Tenure Granted: "; > > echo fixDate($tenuredate); > > echo ""; > > } > > else { > > > > echo "Date Tenure Granted: Null"; > > } > > > > and I can't figure out why I always get the following result: > > > > > > 2 > > > > Date Tenure Granted: 31 Dec 1969 > > --- > > or > > > > 1 > > > > Date Tenure Granted: 31 Dec 1969 > > --- > > > > when 1) tenureid <> 3, and 2) no 31 Dec 1969 date in the database anywhere. > > > > The only thing I can think of is that I modified the dropdown box for the tenure date on the data entry page like this: > > > > > > Date Tenure Granted(in mm-dd- format) > > > > > > > > > > " . sprintf("%02d", $x) . ""; } ?> > > - > > > > > > " . sprintf("%02d", $x) . ""; } ?> > > - > > > > > > > > =1970; $x--) { echo "$x"; } ?> > > > > > > > > > > by adding to those 3 fields as I want null to be a default selection. but I can't imagine why that'll mess up the if statement evaluation. > > > > It seems that the 1st if statement just runs whatever the tenureid is. > > > > Can anyone help me on this? I'm using PHP 4.2.2 and MySQL 3.23.54 btw. > > > > Thanks millions! > > > > Jordan > > > > > > > > > -- > Diana Soares > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re[2]: date problem
Hello Don, Well, you're right ;) I change the column type to int & it just run perfect. Thanks to both of ya! Monday, March 24, 2003, 5:21:35 AM, you wrote: DR> On 24-Mar-2003 Michael Shulman wrote: >> It looks like it's in now() format, but without the punctuation. The >> line >> from your insert statement is DR> Nope, that's a MySQL timestamp. DR> UNIX_TIMESTAMPS are # of seconds from the epoch (Jan 1 1970). DR> "nobody" <[EMAIL PROTECTED]> is trying to store an INT in a timestamp column and DR> probably clobbering his values. >> >> 20030323225645 >> >> If we break this apart, we see: >> >> Year = 2003 >> Month = 03 >> Date = 23 >> Hour = 22 (or 10pm) >> Minute 56 >> Seconds 45 >> DR> Nope, that's a MySQL timestamp. DR> UNIX_TIMESTAMPS are # of seconds since the epoch (Jan 1 1970). DR> nobody <[EMAIL PROTECTED]> is probably trying to store an INT in a timestamp DR> column and clobbering his values as the timestamp updates. >> Someone else on the list: where or how is the timezone encode, or this is >> entry in GMT? Is there a way to determine the local timezone on the >> machine? >> mysql>> show variables like 'timezone'; DR> +---+---+ DR> | Variable_name | Value | DR> +---+---+ DR> | timezone | PST | DR> +---+---+ DR> 1 row in set (0.00 sec) mysql>> select sec_to_time((time_to_sec(now()) - UNIX_TIMESTAMP()) % 86400) DR> as 'offset GMT'; DR> ++ DR> | offset GMT | DR> ++ DR> | -08:00:00 | DR> ++ DR> 1 row in set (0.00 sec) >> >> -Original Message- >> From: nobody [mailto:[EMAIL PROTECTED] >> Sent: Sunday, March 23, 2003 12:56 PM >> To: [EMAIL PROTECTED] >> Subject: date problem >> >> Hello mysql, >> >> I do this: >> >> $query = "INSERT INTO news(ID, author, title, text, date) VALUES(NULL, >> '".$_SESSION["ulogged"]."', '".$title."', '".$text."', >> UNIX_TIMESTAMP(NOW()))"; >> $result = mysql_query($query, $connection) or die("problem with query"); >> >> I get this: >> >> mysql> select * from news where id='1'; >> +++--+++ >>| ID | author | title| text | date | >> +++--+++ >>| 1 | myuser | news | blah blah blah | 20030323225645 | >> +++--+++ >> 1 row in set (0.01 sec) >> >> Look at the time! It's set ... strange :) 2003 03 23 22 56 45 .. it's >> not neither now() format, neither unix_timestamp() format. >> >> mysql> select now(), unix_timestamp(now()); >> +-+---+ >>| now() | unix_timestamp(now()) | >> +-+---+ >>| 2003-03-23 23:07:30 |1048453650 | >> +-+---+ >> 1 row in set (0.01 sec) >> >> It's okay. So, why in the query from a php form the unix time date is >> saved wrong? Any ideas and suggestions? >> >> -- >> best wishes, >> Strahil Minev a.k.a. DLHelper, >> BuFu TeaM mailto:[EMAIL PROTECTED] >> DR> Regards, DR> -- DR> Don Read [EMAIL PROTECTED] DR> -- It's always darkest before the dawn. So if you are going to DR>steal the neighbor's newspaper, that's the time to do it. DR> (53kr33t w0rdz: sql table query) -- best wishes, Strahil Minev a.k.a. DLHelper, [EMAIL PROTECTED], BuFu TeaM mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re[2]: date problem
Hello Michael, The most interesting part is that it's not in NOW() format! I've tried one-two times the same query and: mysql> select * from news; +++--+-++ | ID | author | title| text| date | +++--+-++ | 1 | myuser | news | blah blah blah | 20030323225645 | | 2 | myuser | news2| yakidi shmakidi | 20001117212520 | | 3 | myuser | news3| this ain't fun | 20001118212554 | +++--+-++ 3 rows in set (0.02 sec) It's just.. random.. I don't know, is this a bug or something? [EMAIL PROTECTED]:/www/voting/vega$ date Mon Mar 24 04:36:33 EET 2003 My clock is okay. Monday, March 24, 2003, 4:03:45 AM, you wrote: MS> It looks like it's in now() format, but without the punctuation. The line MS> from your insert statement is MS> 20030323225645 MS> If we break this apart, we see: MS> Year = 2003 MS> Month = 03 MS> Date = 23 MS> Hour = 22 (or 10pm) MS> Minute 56 MS> Seconds 45 MS> Someone else on the list: where or how is the timezone encode, or this is MS> entry in GMT? Is there a way to determine the local timezone on the machine? MS> -ms MS> -Original Message- MS> From: nobody [mailto:[EMAIL PROTECTED] MS> Sent: Sunday, March 23, 2003 12:56 PM MS> To: [EMAIL PROTECTED] MS> Subject: date problem MS> Hello mysql, MS> I do this: MS> $query = "INSERT INTO news(ID, author, title, text, date) VALUES(NULL, MS> '".$_SESSION["ulogged"]."', '".$title."', '".$text."', MS> UNIX_TIMESTAMP(NOW()))"; MS> $result = mysql_query($query, $connection) or die("problem with query"); MS> I get this: mysql>> select * from news where id='1'; MS> +++--+++ MS> | ID | author | title| text | date | MS> +++--+++ MS> | 1 | myuser | news | blah blah blah | 20030323225645 | MS> +++--+++ MS> 1 row in set (0.01 sec) MS> Look at the time! It's set ... strange :) 2003 03 23 22 56 45 .. it's MS> not neither now() format, neither unix_timestamp() format. mysql>> select now(), unix_timestamp(now()); MS> +-+---+ MS> | now() | unix_timestamp(now()) | MS> +-+---+ MS> | 2003-03-23 23:07:30 |1048453650 | MS> +-+---+ MS> 1 row in set (0.01 sec) MS> It's okay. So, why in the query from a php form the unix time date is MS> saved wrong? Any ideas and suggestions? MS> -- MS> best wishes, MS> Strahil Minev a.k.a. DLHelper, MS> BuFu TeaM mailto:[EMAIL PROTECTED] -- best wishes, Strahil Minev a.k.a. DLHelper, [EMAIL PROTECTED], BuFu TeaM mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
date problem
Hello mysql, I do this: $query = "INSERT INTO news(ID, author, title, text, date) VALUES(NULL, '".$_SESSION["ulogged"]."', '".$title."', '".$text."', UNIX_TIMESTAMP(NOW()))"; $result = mysql_query($query, $connection) or die("problem with query"); I get this: mysql> select * from news where id='1'; +++--+++ | ID | author | title| text | date | +++--+++ | 1 | myuser | news | blah blah blah | 20030323225645 | +++--+++ 1 row in set (0.01 sec) Look at the time! It's set ... strange :) 2003 03 23 22 56 45 .. it's not neither now() format, neither unix_timestamp() format. mysql> select now(), unix_timestamp(now()); +-+---+ | now() | unix_timestamp(now()) | +-+---+ | 2003-03-23 23:07:30 |1048453650 | +-+---+ 1 row in set (0.01 sec) It's okay. So, why in the query from a php form the unix time date is saved wrong? Any ideas and suggestions? -- best wishes, Strahil Minev a.k.a. DLHelper, BuFu TeaM mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re[2]: Updat not Updating
Hello Andrew, Friday, March 14, 2003, 7:41:56 PM, you wrote: A> yes you are right an I am very stupid for not doing this: It is very important A> for debugging as I now have this error :):) A> Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in A> c:\program files\apache A> group\apache\htdocs\punterspower\admin\updatecompanyresponse.php on line 23 A> Error with query: You have an error in your SQL syntax near 'WHERE ItemID='01296 A> 483402'' at line 14 A> I'm not really happy because I dont know why!! A> Andrew :: cut :: >> >>A> mysql_connect("$DBHost","$DBUser","$DBPass"); >>A> mysql("$DBName","UPDATE items >>A> SET ItemSKU='$ItemSKU', >>A> ItemName='$ItemName', >>A> ItemDescription='$ItemDescription', >>A> PostCode='$PostCode', >>A> Category='$Category', >>A> CityID='$CityID' >>A> CTelephone='$CTelephone' >>A> Cfax='$Cfax' >>A> Cemail='$Cemail' >>A> Caddress='$Caddress' >>A> Cfax='$CTown' >>A> Cwww='$Cwww' >>A> WHERE ItemID='$ItemID'"); >> >> >>A> Andrew >> >>A> - >>A> Before posting, please check: >>A>http://www.mysql.com/manual.php (the manual) >>A>http://lists.mysql.com/ (the list archive) >> >>A> To request this thread, e-mail <[EMAIL PROTECTED]> >>A> To unsubscribe, e-mail <[EMAIL PROTECTED]> >>A> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> >>There are few simple steps, that everyone should do when using MySQL >>within PHP. >>1. $connection = mysql_connect('host', 'user', 'pass') or die("Error >>with connect: ".mysql_error().""); >>2. mysql_select_db('db_name', $connection) or die("Error with select: >>".mysql_error().""); >>3. $query = ""; >>4. $result = mysql_query($query, $connection) or die("Error with >>query: ".mysql_error().""); >> >>This steps will provide you information if anything goes wrong and >>most import where it goes wrong. >> >>From what you wrote, you didn't placed enough commas in the query. >>Follow the steps described above and paste the error log. >>www.php.net and www.mysql.com are your friends! >> :: cut :: >> Okay, I'm not very sure about this, but try ItemID=$ItemID. If it's not this, then look up your code above. Check if all quotes are closed properly. If it's still not working then, please, paste your code as is, 1:1 :) -- best wishes, Strahil Minev a.k.a. DLHelper, BuFu TeaM mailto:[EMAIL PROTECTED] - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Updat not Updating
Hello Andrew, Friday, March 14, 2003, 6:18:15 PM, you wrote: A> Can anyone tell me why this is not updating records for this table? A> mysql_connect("$DBHost","$DBUser","$DBPass"); A> mysql("$DBName","UPDATE items A> SET ItemSKU='$ItemSKU', A> ItemName='$ItemName', A> ItemDescription='$ItemDescription', A> PostCode='$PostCode', A> Category='$Category', A> CityID='$CityID' A> CTelephone='$CTelephone' A> Cfax='$Cfax' A> Cemail='$Cemail' A> Caddress='$Caddress' A> Cfax='$CTown' A> Cwww='$Cwww' A> WHERE ItemID='$ItemID'"); A> Andrew A> - A> Before posting, please check: A>http://www.mysql.com/manual.php (the manual) A>http://lists.mysql.com/ (the list archive) A> To request this thread, e-mail <[EMAIL PROTECTED]> A> To unsubscribe, e-mail <[EMAIL PROTECTED]> A> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php There are few simple steps, that everyone should do when using MySQL within PHP. 1. $connection = mysql_connect('host', 'user', 'pass') or die("Error with connect: ".mysql_error().""); 2. mysql_select_db('db_name', $connection) or die("Error with select: ".mysql_error().""); 3. $query = ""; 4. $result = mysql_query($query, $connection) or die("Error with query: ".mysql_error().""); This steps will provide you information if anything goes wrong and most import where it goes wrong. >From what you wrote, you didn't placed enough commas in the query. Follow the steps described above and paste the error log. www.php.net and www.mysql.com are your friends! -- best wishes, Strahil Minev a.k.a. DLHelper, BuFu TeaM mailto:[EMAIL PROTECTED] - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql@lists.mysql.com
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: mysql-3.23.36 (Linux-Mandrake MySQL RPM) >Server: /usr/bin/mysqladmin Ver 8.18 Distrib 3.23.36, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.36-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 3 hours 40 min 58 sec Threads: 7 Questions: 787 Slow queries: 0 Opens: 65 Flush tables: 1 Open tables: 59 Queries per second avg: 0.059 >Environment: System: Linux sdbl.teamshopa.com 2.4.3-20mdk #1 Sun Apr 15 23:03:10 CEST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux/2.96/specs gcc version 2.96 2731 (Linux-Mandrake 8.0 2.96-0.48mdk) Compilation info: CC='gcc' CFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math -fno-omit-frame-pointer' CXX='g++' CXXFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math -fno-omit-frame-pointer' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Nov 8 07:29 /lib/libc.so.6 -> libc-2.2.2.so -rwxr-xr-x1 root root 1216268 Feb 21 2001 /lib/libc-2.2.2.so -rw-r--r--1 root root 26366908 Feb 21 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Feb 21 2001 /usr/lib/libc.so Configure command: ./configure --enable-shared --enable-thread-safe-client --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man --with-berkeley-db --without-innobase '--with-comment=Linux-Mandrake MySQL RPM' - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php