Mysql Perl DBI DBD Version Compatability for MAC OS 10.6
After installing Apple's MAC Snow Leopard OS 10.6 I haven't been able to get my DBD:mysql module to work. I am kind of beyond trying to fix that issue directly so I am requesting assistance defining a compatible version set which is known to work. Between various releases and 32/64 bit options I have to confess there are too many choices and not enough information on how to choose for me to trust my own judgment anymore. Currently, I am running: 1. mysql Server Version 5.4.1-beta MySQL Community Server 2. perl version 5.8.9 built for Darwin 2level 3. perl DBI version 1.609 4. perl DBD:mysql 4.012 I am not positive which of the above are 32 or 64 bit but help discerning which 32/64 versions are required would also be appreciated. I am happy ;-( to uninstall and reinstall any of the above to get to a working configuration. Thanks in advance. Hagen Finley Boulder, CO -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6
Here is the error I am receiving ( I posted this issue in the recent past): dyld: lazy symbol binding failed: Symbol not found: _mysql_init Referenced from: /Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle Expected in: flat namespace dyld: Symbol not found: _mysql_init Referenced from: /Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle Expected in: flat namespace Trace/BPT trap Could you send me the versions of Perl, DBD DBI you are using? Hagen On 10/5/09 1:16 PM, Gavin Towey gto...@ffn.com wrote: MySQL Server can be 32 or 64 bit and it shouldn't make a difference to PERL. However, if you can run 64 bit, you should. PERL and it's modules all need to be the same architecture. It doesn't matter if they're 32 bit or 64 bit, as long as it's consistent with itself. I see no reason why those versions should have a problem interacting; what are you trying, and what is the error you get? Regards Gavin Towey -Original Message- From: Hagen [mailto:finha...@comcast.net] Sent: Monday, October 05, 2009 11:58 AM To: mysql@lists.mysql.com Cc: finha...@comcast.net Subject: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6 After installing Apple's MAC Snow Leopard OS 10.6 I haven't been able to get my DBD:mysql module to work. I am kind of beyond trying to fix that issue directly so I am requesting assistance defining a compatible version set which is known to work. Between various releases and 32/64 bit options I have to confess there are too many choices and not enough information on how to choose for me to trust my own judgment anymore. Currently, I am running: 1. mysql Server Version 5.4.1-beta MySQL Community Server 2. perl version 5.8.9 built for Darwin 2level 3. perl DBI version 1.609 4. perl DBD:mysql 4.012 I am not positive which of the above are 32 or 64 bit but help discerning which 32/64 versions are required would also be appreciated. I am happy ;-( to uninstall and reinstall any of the above to get to a working configuration. Thanks in advance. Hagen Finley Boulder, CO -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MAC OS 10.6 Snow Leopard Breaks MySQL - Resolved
I tried creating a soft link to the /usr/local/bin/mysql but that didn't address the issues I was having. However, following a little more research I found a discussion of this problem at: http://stackoverflow.com/questions/1334272/cant-start-mysql-in-mac-os-10-6-s now-leopard which said: YOU MUST REINSTALL mySQL after upgrading to Snow Leopard and remove any previous versions as well as previous startup from the preference panel. install 86_64 10.5...I find the others did not work for me. Bummer. However, there was also a discussion suggesting the use of MacPorts: Have you considered installing MacPorts 1.8.0 (release candidate), and keeping MySQL up-to-date that way? That will build MySQL for the architecture and OS that you're using, rather than installing a 10.5 version on 10.6. I installed MacPorts http://www.macports.org/ (had to reboot) and ran the following commands: sudo port -v self update sudo port list sudo port install mysql5 The MacPort script reinstalled mysql 5 on my Mac and mysql came up properly apparently with everything where it belonged. Pretty slick and almost effortless. Hagen -Original Message- From: Hagen [mailto:finha...@comcast.net] Sent: Friday, September 04, 2009 12:24 PM To: mysql@lists.mysql.com Subject: RE: MAC OS 10.6 Snow Leopard Breaks MySQL I don't appear to have a /etc/my.cnf file - could the upgrade have removed it? Here is the error string I get when I try and start MySQL: finhagens-macbook-pro:bin finhagen$ ./mysqld [1] 4697 finhagens-macbook-pro:bin finhagen$ 090904 10:25:18 [ERROR] Can't find messagefile '/usr/local/mysql/share/english/errmsg.sys' 090904 10:25:18 [Warning] Can't create test file /usr/local/mysql/data/finhagens-macbook-pro.lower-test 090904 10:25:18 [Warning] Can't create test file /usr/local/mysql/data/finhagens-macbook-pro.lower-test ./mysqld: Can't change dir to '/usr/local/mysql/data/' (Errcode: 2) 090904 10:25:18 [ERROR] Aborting I have noted that a new path was created for mysql during the upgrade: /usr/local/mysql-5.1.31-osx10.5-86/ ...bin ...share ...data etc. Obviously that new path is resulting in the errors above. -What's the best way to inform MySQL the direct structure changed? -Is there a 5.4 version for MAC OS 10.6? -Would it make sense to reinstall with that version? (my data base is tiny and its relatively easy to export and import it and I am the only user) Hagen -Original Message- Sent: Friday, September 04, 2009 11:03 AM To: Hagen Subject: RE: MAC OS 10.6 Snow Leopard Breaks MySQL What is the connect string in the /etc/my.cnf file? -Original Message- From: Hagen [mailto:finha...@comcast.net] Sent: Friday, September 04, 2009 9:45 AM To: mysql@lists.mysql.com Subject: MAC OS 10.6 Snow Leopard Breaks MySQL I upgraded to MAC OS 10.6 Snow Leopard over the weekend and now I find that upgrade appears to have broken MySQL (5.1.31 MySQL Community Server (GPL)). When I attempt to start MySQL I get: ERROR 2002: (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock (2) Has anyone else had this issue and do you know of a fix or work around? Hagen Finley Boulder, CO -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=jgor...@westernwats.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=finha...@comcast.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MAC OS 10.6 Snow Leopard Breaks MySQL
I upgraded to MAC OS 10.6 Snow Leopard over the weekend and now I find that upgrade appears to have broken MySQL (5.1.31 MySQL Community Server (GPL)). When I attempt to start MySQL I get: ERROR 2002: (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock (2) Has anyone else had this issue and do you know of a fix or work around? Hagen Finley Boulder, CO -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: MAC OS 10.6 Snow Leopard Breaks MySQL
I don't appear to have a /etc/my.cnf file - could the upgrade have removed it? Here is the error string I get when I try and start MySQL: finhagens-macbook-pro:bin finhagen$ ./mysqld [1] 4697 finhagens-macbook-pro:bin finhagen$ 090904 10:25:18 [ERROR] Can't find messagefile '/usr/local/mysql/share/english/errmsg.sys' 090904 10:25:18 [Warning] Can't create test file /usr/local/mysql/data/finhagens-macbook-pro.lower-test 090904 10:25:18 [Warning] Can't create test file /usr/local/mysql/data/finhagens-macbook-pro.lower-test ./mysqld: Can't change dir to '/usr/local/mysql/data/' (Errcode: 2) 090904 10:25:18 [ERROR] Aborting I have noted that a new path was created for mysql during the upgrade: /usr/local/mysql-5.1.31-osx10.5-86/ ...bin ...share ...data etc. Obviously that new path is resulting in the errors above. -What's the best way to inform MySQL the direct structure changed? -Is there a 5.4 version for MAC OS 10.6? -Would it make sense to reinstall with that version? (my data base is tiny and its relatively easy to export and import it and I am the only user) Hagen -Original Message- Sent: Friday, September 04, 2009 11:03 AM To: Hagen Subject: RE: MAC OS 10.6 Snow Leopard Breaks MySQL What is the connect string in the /etc/my.cnf file? -Original Message- From: Hagen [mailto:finha...@comcast.net] Sent: Friday, September 04, 2009 9:45 AM To: mysql@lists.mysql.com Subject: MAC OS 10.6 Snow Leopard Breaks MySQL I upgraded to MAC OS 10.6 Snow Leopard over the weekend and now I find that upgrade appears to have broken MySQL (5.1.31 MySQL Community Server (GPL)). When I attempt to start MySQL I get: ERROR 2002: (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock (2) Has anyone else had this issue and do you know of a fix or work around? Hagen Finley Boulder, CO -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=jgor...@westernwats.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Group by column and Sum another
I am hoping I can get some help with a query I am trying to construct: I want to group by a 'contract' column and get the sum of the 'amlp' column values associated with each contract. I can do a select and group by on contract select contract from maintenance group by contract; and I will get each unique contract. However, I want to sum the amlp values per unique contract and I am not sure how to construct that select statement. I tried: select contract , sum(amlp) from maintenance where contract=(select contract from maintenance group by contract); But that resulted in a ERROR 1242 (21000): Subquery returns more than 1 row error. Any suggestions? Hagen Finley Boulder -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Group by column and Sum another
Thanks! That did the trick. -Original Message- From: Olexandr Melnyk [mailto:omel...@gmail.com] Sent: Monday, July 20, 2009 10:02 AM To: mysql@lists.mysql.com Subject: Re: Group by column and Sum another select contract , sum(amlp) from maintenance group by contract; On Mon, Jul 20, 2009 at 6:50 PM, Hagen finha...@comcast.net wrote: I am hoping I can get some help with a query I am trying to construct: I want to group by a 'contract' column and get the sum of the 'amlp' column values associated with each contract. I can do a select and group by on contract select contract from maintenance group by contract; and I will get each unique contract. However, I want to sum the amlp values per unique contract and I am not sure how to construct that select statement. I tried: select contract , sum(amlp) from maintenance where contract=(select contract from maintenance group by contract); But that resulted in a ERROR 1242 (21000): Subquery returns more than 1 row error. Any suggestions? Hagen Finley Boulder -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=omel...@gmail.com -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Date Translation Issues
I am using mysql Server version: 5.1.31 MySQL Community Server (GPL) on a MAC 10.5 host. I am having some strange date translation issues when I insert dates into my tables. What I do is run perl¹s Spreadsheet::ParseExcel module with Time::JulianDay to reformat excel dates to insert properly into mysql. use Spreadsheet::ParseExcel; use Time::JulianDay; To reformat the date I run a small code sequence: $sdate0 = $sdate + julian_day(1900, 1, 0); ($year, $month, $day) = inverse_julian_day($sdate0); $sdate1 = join '-', $year,$month,$day; This seems to work fine because I print my output to a file and the date format appears to be correct: +++ NUCO INC M61037841 ACTIVE 61037841 2815041 RICHARDSON TX US APM00051703278 CX-ATA-DAE DAE ATA EXPANSION FOR CX PREMIUM HARDWARE SUPPORT 5 5050.2 2005-8-5 2008-8-6 201 +++ So my dates show up in the 2008-6-15 format. The problem is when I insert those dates into my table I either get all 0s or I get a 2040 year (with the correct month and day): NUCO INC | 2815487 | RESEARCH TRIANGLE PARK | NC| TN187401264 |1 | DMX1000-P2 | DMX-2 U PERF SNGL BAY | -00-00 | 2040-08-06 | 365 | 23275 | I have had this weird year issue pop up time to time but it was easy enough to work around it. However, for my current project I really need the dates in the table to match the dates in the source spreadsheet. I do see that the dates I am inputing are not in a pure -MM-DD format- missing 0s. Its possible that that is the issue but since the date is getting converted from the underlying Julian date I am not sure how to fix that. In case it matters, here is my insert string: $dbh-do(insert into maintenance (indate, b2customer, contract, cstatus, customer, party, city, state, serial, model, mdesc, descr, qty, amlp, sdate, edate, rcsdate, rcedate, days, contractid) values (CURDATE(),\'$b2customer\', \'$contract\', \'$status\', \'$incustomer\', $party, \'$city\', \'$state\', \'$serial\', \'$model\', \'$mdesc\', \'$descr\', $qty, $amlp, $sdate, $edate, $rcsdate, $rcedate, $days, $contractid)); I have also tried inserting the data as a string but that doesn¹t seem to make any difference. Any help would be greatly appreciated. Thank you! Hagen Finley Boulder, CO
Re: Date Translation Issues
'; ++---+-+---+ -++---+-++-+ ---+-+--+--+++-- -+--+--+--+---+---+- -+--++++-+ | indate | contract | cstatus | customer | party | city | state | country | serial | model | mdesc | service | qty | amc | sdate | edate | cdate | days | due | comments | lstatus | b2customer| descr | amlp | rcsdate| rcedate| contractid | refresh | ++---+-+---+ -++---+-++-+ ---+-+--+--+++-- -+--+--+--+---+---+- -+--++++-+ | 2009-07-14 | 61420644H | ACTIVE | NUCO RICHARDSON (TACSUN) | 8200137 | RICHARDSON | TX| NULL| APM00060300673 | CX300-FD| CX300 W 2GB FIELD INSTALL | NULL|1 | NULL | -00-00 | -00-00 | NULL | 612 | NULL | NULL | Installed | NUCO INC | PREMIUM HARDWARE SUPPORT | 1400 | -00-00 | -00-00 | 742892 | NULL| | 2009-07-14 | 61420644H | ACTIVE | NUCO RICHARDSON (TACSUN) | 8200137 | RICHARDSON | TX| NULL| 0 | CX-2G10-146 | 146GB 10K 2GB FC | NULL| 15 | NULL | -00-00 | -00-00 | NULL | 612 | NULL | NULL | Installed | NUCO INC | PREMIUM HARDWARE SUPPORT | 1926 | -00-00 | -00-00 | 742892 | NULL| ++---+-+---+ -++---+-++-+ ---+-+--+--+++-- -+--+--+--+---+---+- -+--++++-+ 2 rows in set (0.00 sec) So as you can see my date inserts are returning ³-00-00². That¹s better than ³2040-07-14² but I still get those with some of the inserts. It also appears the Julian date is adding a day to the date although that doesn¹t materially impact my project. Thoughts? Hagen On 7/14/09 12:44 PM, Michael Dykman mdyk...@gmail.com wrote: Hagan, your premise looks reasonable enough (excepting that your dates must always be in quotes in your insert statement.. the system is expecting a string).. might you show us your schema and perhaps a print-out of your query after it has been rendered by perl? - michael dykman On Tue, Jul 14, 2009 at 2:23 PM, Hagen Finleyfinha...@comcast.net wrote: I am using mysql Server version: 5.1.31 MySQL Community Server (GPL) on a MAC 10.5 host. I am having some strange date translation issues when I insert dates into my tables. What I do is run perl¹s Spreadsheet::ParseExcel module with Time::JulianDay to reformat excel dates to insert properly into mysql. use Spreadsheet::ParseExcel; use Time::JulianDay; To reformat the date I run a small code sequence: $sdate0 = $sdate + julian_day(1900, 1, 0); ($year, $month, $day) = inverse_julian_day($sdate0); $sdate1 = join '-', $year,$month,$day; This seems to work fine because I print my output to a file and the date format appears to be correct: +++ NUCO INC M61037841 ACTIVE 61037841 2815041 RICHARDSON TX US APM00051703278 CX-ATA-DAE DAE ATA EXPANSION FOR CX PREMIUM HARDWARE SUPPORT 5 5050.2 2005-8-5 2008-8-6 201 +++ So my dates show up in the 2008-6-15 format. The problem is when I insert those dates into my table I either get all 0s or I get a 2040 year (with the correct month and day): NUCO INC | 2815487 | RESEARCH TRIANGLE PARK | NC | TN187401264 | 1 | DMX1000-P2 | DMX-2 U PERF SNGL BAY | -00-00 | 2040-08-06 | 365 | 23275 | I have had this weird year issue pop up time to time but it was easy enough to work around it. However, for my current project I really need the dates in the table to match the dates in the source spreadsheet. I do see that the dates I am inputing are not in a pure -MM-DD format- missing 0s. Its possible that that is the issue but since the date is getting converted from the underlying Julian date I am not sure how to fix that. In case it matters, here is my insert string: $dbh-do(insert into maintenance (indate, b2customer, contract, cstatus, customer, party, city, state, serial, model, mdesc, descr, qty, amlp, sdate, edate, rcsdate, rcedate, days, contractid) values (CURDATE(),\'$b2customer\', \'$contract\', \'$status\', \'$incustomer\', $party, \'$city\', \'$state\', \'$serial\', \'$model\', \'$mdesc\', \'$descr\', $qty, $amlp, $sdate, $edate, $rcsdate, $rcedate, $days, $contractid)); I have also tried inserting the data as a string but that doesn¹t seem to make any difference. Any help would be greatly appreciated. Thank you! Hagen Finley Boulder, CO
Re: Date Translation Issues
Micheal, Your query trouble shooting tip showed me my error - see below: Sorry here is the SHOW CREATE TABLE: mysql show create table `maintenance`; +-+- + | Table | Create Table | +-+- + | maintenance | CREATE TABLE `maintenance` ( `indate` date DEFAULT NULL, `contract` char(25) NOT NULL, `cstatus` char(20) DEFAULT NULL, `customer` char(35) DEFAULT 'CISCO SYSTEMS, INC', `party` int(11) DEFAULT NULL, `city` varchar(125) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `country` varchar(50) DEFAULT NULL, `serial` char(25) DEFAULT NULL, `model` char(25) DEFAULT NULL, `mdesc` char(50) DEFAULT NULL, `service` char(50) DEFAULT NULL, `qty` int(11) DEFAULT NULL, `amc` int(11) DEFAULT NULL, `sdate` date DEFAULT NULL, `edate` date DEFAULT NULL, `cdate` date DEFAULT NULL, `days` int(11) DEFAULT NULL, `due` int(11) DEFAULT NULL, `comments` char(50) DEFAULT NULL, `lstatus` char(20) DEFAULT 'Installed', `b2customer` char(50) DEFAULT NULL, `descr` char(50) DEFAULT NULL, `amlp` int(11) DEFAULT NULL, `rcsdate` date DEFAULT NULL, `rcedate` date DEFAULT NULL, `contractid` int(11) DEFAULT NULL, `refresh` char(8) DEFAULT NULL, KEY `contract` (`contract`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 | +-+- + 1 row in set (0.00 sec) Here are the two select statements per the two records below: insert into maintenance (indate, b2customer, contract, cstatus, customer, party, city, state, serial, model, mdesc, descr, qty, amlp, sdate, edate, rcsdate, rcedate, days, contractid) values (CURDATE(),\'CISCO SYSTEMS INC\', \'61420644H\', \'ACTIVE', \'CISCO SYSTEMS RICHARDSON (TACSUN)\', 8200137, \'RICHARDSON\', \'TX\', \'APM00060300673\', \'CX300-FD\', \'CX300 W 2GB FIELD INSTALL\', \'PREMIUM HARDWARE SUPPORT\', 1, 1400.04, \'38744\', \'39839\', \'39840\', \'40451\', 612, 742892) Doesn't look quite right - does it? ;-). Well, great trouble shooting lesson to resolve a pretty stupid error - I was using the $sdate variable for my insert which was pre-Julian reformat. I needed $sdate1 for the insert. Here is the corrected query: insert into maintenance (indate, b2customer, contract, cstatus, customer, party, city, state, serial, model, mdesc, descr, qty, amlp, sdate, edate, rcsdate, rcedate, days, contractid) values (CURDATE(),\'CISCO SYSTEMS INC\', \'61420644H\', \'ACTIVE', \'CISCO SYSTEMS RICHARDSON (TACSUN)\', 8200137, \'RICHARDSON\', \'TX\', \'APM00060300673\', \'CX300-FD\', \'CX300 W 2GB FIELD INSTALL\', \'PREMIUM HARDWARE SUPPORT\', 1, 1400.04, \'2006-1-28\', \'2009-1-27\', \'2009-1-28\', \'2010-10-1\', 612, 742892) I appear to be getting the proper dates in my table now. Thanks for your help Michael! Hagen On 7/14/09 2:08 PM, Michael Dykman mdyk...@gmail.com wrote: Hagan, Close but not quite what I asked for. The schema for your table is what you get from SHOW CREATE TABLE `mytable`. It will show all the indexes and, most imporatantly, make it trivial for someone trying to assist you in your investigation to re-create your problem. It is good to see the quotes in your perl script, but what I was hoping for was the query itself after perl has rendered it, again, so it can be run against a database without me having to write a perl-wrapper to do so. On Tue, Jul 14, 2009 at 4:02 PM, Hagen Finleyfinha...@comcast.net wrote: mysql desc maintenance; ++--+--+-++---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-++---+ | indate | date | YES | | NULL | | | contract | char(25) | NO | MUL | NULL | | | cstatus | char(20) | YES | | NULL | | | customer | char(35) | YES | | NUCO INC | | | party | int(11) | YES | | NULL | | | city | varchar(125) | YES | | NULL | | | state | varchar(50) | YES | | NULL | | | country | varchar(50) | YES | | NULL | | | serial | char(25) | YES | | NULL | | | model | char(25) | YES | | NULL | | | mdesc | char(50) | YES | | NULL | | | service | char(50) | YES | | NULL | | | qty | int(11) | YES | | NULL | | | amc | int(11
Record IDs
I have a number of duplicate records in my table which are identical hence, I can't do a delete on the columns without deleting both records. One deletion strategy I have considered is identifying the records by their table record id - but I don't know for certain that such an identifier exists or how I would show it via a select statement. Any suggestions? Hagen Finley Boulder, CO -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
captured percentage values not inserting properly into table
Hi, I am using Spreadsheet::ParseExcel, DBI DBD::mysql to capture and insert data into mysql tables. That's working out very well but I am having issues with one datatype. When I capture percentages out of excel 97 the captured value might be 0.76324095 but when I attempt to select that same data it always displays as 1 presumably rounding up. Within mysql my select statements show either a 1 or 0: mysql select de,cco,fcost,fmarg from quote; ++--+-+---+ | de | cco | fcost | fmarg | ++--+-+---+ | 1001812321 | 5885 |1228 | 1 | | 1000267698 | 656160 | 292754 | 1 | | 1001856764 |40150 | 20361 | 0 | | 1000107528 |78830 | 39677 | 0 | | 1001928870 |48062 | 16295 | 1 | where fmarg is the percentage column. When I try and update the value for fmarg I have the same issue: mysql update quote set fmarg=0.984305 where de= 1001812321; Query OK, 0 rows affected (0.10 sec) Rows matched: 1 Changed: 0 Warnings: 0 mysql select de,cco,fcost,fmarg from quote; ++--+-+---+ | de | cco | fcost | fmarg | ++--+-+---+ | 1001812321 | 5885 |1228 | 1 | The column datatype is INT(25). | fmarg | int(25) | YES | | NULL| | Should I be using a different datatype for these kind of numerical values? Thanks in advance for your kind counsel. Hagen -- Hagen Finley [EMAIL PROTECTED] Boulder, CO -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql Performance
I do not believe that your problem is based on your hardware but ... Inserting data requires to reorganize your indexes. Please try to drop them (only for testing ;-) ) Hagen Carlos Augusto wrote: Well that´s me again with a new problem. I am runnig another database with 7gb of data and this db can´t stop. All the time we have queries being inserted by a plain text file and all the time customers get information of this database. I obvserved that for a insert query is taking about 5 to 15 seconds for each insert. I saw some variables like: slow_query that output me a number of 1388 slow queries. I am new in mysql and database stuff and i have a task to improve mysql´s performance. I need help since in a simple Pentium 4 the same operations are almost 10 times higher(in time of inserting a querie) and this machine that is too slow for inserting is an dual xeon, 4gb ram and 500gb hard disk. I aprecciate if some one has a solution for improving this server performance. Thanks. Carlos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: order by question
You can try to use two subqueries and an union ala SELECT * FROM tab where c0 ORDER by C UNION ALL SELECT * FROM tab where c=0; Hagen dan orlic wrote: i have an question about ordering a set of records... ab c d - 1Tax 120001.33 1Tax 115002.5 1Tax 110003.25 1Tax 10 4.5 But I want the records to return as such: ascending by (c) with the zero being the last record: like below: 1Tax 110003.25 1Tax 115002.5 1Tax 12000 1.33 1Tax 10 4.5 any suggestions? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Basic Problem Facing towards..
It seems that you PHP was compiled without mysql-support ... please take a look at the php-documentation. Shiva wrote: Hallo Everyone, I'm facing this basic problem for connecting the Mysql4.01 Database using Php5; The browser shows the following error; mysql_connect(localhost, root) or -- Fatal error: Call to undefined function mysql_connect() in D:\Program Files\Apache Group\Apache2\htdocs\mass\connect.php on line 25 Can someone plz help me to sort out this problem. Thanx in advance Regards Shiva ps:- login.php ? if ($submit = Login) { mysql_connect(localhost, root,123sw) or die (Could not connect to database); mysql_select_db(user) or dir (Could not select database); $result=mysql_query(select * from user where username='$username') or die (cant do it); while ($row=mysql_fetch_array($result)) { if ($row[password]==$password ) { printf(Successfully Logged In!); }else{ print(Nope); } } } ? create_entry.php ?php mysql_connect(localhost, root,123sw) or die (Could not connect to database); mysql_select_db(user) or dir (Could not select database); if ($submit = = Register) { $query = insert into user (username, password) values ('$username', '$password'); mysql_query($query) or die (mysql_error()); ? h3You are now registered/h3 a href=index.htmlGo back to main page/a ?php } else { include(not.html); } ? index.html html head h2 User Login /h2 form method=post action=/login.php /head body b br Username br /b input type=text size=15 name=username br b UserPassword /b br input type=text size=15 name=password br input type=submit name=submit value=Login input type=reset name=reset value=Clear br a href=/Register.htmlRegister/a /form /body /html register.html html head h2 User Registration /h2 form method=post action=create_entry.php /head body b br Username br /b input type=text size=15 name=username br b UserPassword /b br input type=password size=15 name=password br input type=submit name=submit value=Register input type=reset name=reset value=Clear /form /body /html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Structure of .frm-Files ...
Dear list, perhaps there is some one who can help me ;-) I currently try to understand the structure of .frm-Files. As I understood the documentation correctly this file contains the data dictionary which is independend from the storage engine (MyISAM, InnoDB, etc.). Is there any online article or in which header-file i have to look? Thanx, Hagen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Basic Problem Facing towards..
Perhapts this can help: http://www.phpdiscuss.com/article.php?id=24847group=php.windows Shiva wrote: I found the below from Php Documentation * Php Manual.Chm * Windows users may enable the extension php_mysql.dll inside php.ini. Also, copy libmySQL.dll into the appropriate %SYSTEMROOT% directory, just like you do with every other bundled DLL from the dll directory My question is : How do I install or enable Mysql-support in Php5? Is there any syntax or command which has to be included in Php.ini; OR any other way to enable mysql-support; I'm using Apache 2, Windows XP , Mysql 4.1, php5; Thank you, Regards Shiva - Original Message - From: Hagen Hoepfner [EMAIL PROTECTED] To: Shiva [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, November 19, 2004 3:26 PM Subject: Re: Basic Problem Facing towards.. It seems that you PHP was compiled without mysql-support ... please take a look at the php-documentation. Shiva wrote: Hallo Everyone, I'm facing this basic problem for connecting the Mysql4.01 Database using Php5; The browser shows the following error; mysql_connect(localhost, root) or -- Fatal error: Call to undefined function mysql_connect() in D:\Program Files\Apache Group\Apache2\htdocs\mass\connect.php on line 25 Can someone plz help me to sort out this problem. Thanx in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [Mysql] mysqld ended
I executed the command: fuser -n tcp 3306 and it returned: 3306/tcp: 187 I then ran ps -ef to find what program was using this port and I found it was: root 187 1 0 Nov13 ?00:00:00 /usr/sbin/inetd Is it ok to kill this process ? If not, is there a way to specify mysqld to use another port ? Thanks for the help, Matthew -Original Message- From: Joakim Ryden [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 4:17 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [Mysql] mysqld ended On Nov 17, 2003, at 12:40 PM, [EMAIL PROTECTED] wrote: Hi, I am installing a binary version of mysql 4.0.7, but I cannot get the mysql daemon running. Mysqld ends right after I start it up. I attached the command I use and the output. I also cut and pasted the output from the log file. [...] 031117 15:09:55 Can't start server: Bind on TCP/IP port: Address already in use 031117 15:09:55 Do you already have another mysqld server running on port: 3306 ? 'fuser -n tcp 3306' should give you the process id of the process holding up the port. --Jo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Flush logs, binary log index file
I'm trying to write a script to weekly remove MySQL logs, the general, error and binary log files. Following the MySQL documentation, I've written a script that moves all current log files, then executes mysqladmin flush-logs. My question is this on the binary logs (bin.001, bin.002, etc.): once these are removed and flush logs is executed, the binary log files start over with bin.001. HOWEVER, the binary index file does not appear affected by the flush-logs command; ie, if I'm up to bin.003 in the binary.index file, remove the files and execute the flush logs command, I'm back to a file names bin.001, although the binary.index file still has entries for bin.001, bin.002, bin.003, etc. How does the binary index file stay current when you remove the logs?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Check table script
Hey, having trouble running mysqlcheck from a script. Running 4.0.13 on Linux. I can run the following command: /usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair /var/log/mysql/check_tables.log from the command line, plug in the password at the prompt, and everything works. When I put this exact command into an executable file, and add the '=[pswd]' argument, I get an access denied error message: /usr/local/mysql/bin/mysqlcheck: Got error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) when trying to connect p.s. I've used this exact method on mysqldump, and it works. Any suggestions? Anyone have a mysqlcheck script that they run via cron? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql_history file?
We're just getting started with MySQL on Linux; I was browsing my home directory and found a file called .mysql_history. It contains a history of all mysql commands I've entered - including logging on, setting passwords for users, etc. Sure enough, other users of mysql have the same file. Questions: What are these files, are they mandatory, or can I turn off this logging? Do we need to keep an eye on growth of this files, and truncate or archive them? Most importantly - yikes, seems scary to have a clear text file with a record of Mysql username and password create commands. Any thoughts on this?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Backup conventions
Hi, I'm a new user of MySQL on Linux. I have been an Oracle DBA; and know that anyone familiar with Oracle takes backup procedures very seriously Anyone have recommendations for nightly backup procedures for MySQL (transactional) databases? The literature seems a little ambiguous on this. I did 'turn on' the general, binary and error logs. Does anyone shut down the MySQL daemon regularly? Anyone use mysqldump, or do folks simply use a file system backup? We have tons of databases and tons of tables, so I'm not really considering the lock/flush procedure on tables... Any suggestions? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Indizes abschalten.
Hallo Leute, in Oracle kann man Indizes in einer Abfrage abschalten(Full-Table-Scan). Mit +0 oder ||''. z.B.: SELECT * FROM tabelle WHERE eigenschaft||'' = 'text'; SELECT * FROM tabelle WHERE id+0 = 1; Geht das bei mySQL auch?
What does this mean
Found this message from mysql in my root mailbox. What does it mean? "errors occured while rotating /var/lib/mysql/mysqld.log { ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' error running postrotate script" -- Charles L. Hagen Engineer Hagen IT 920-261-8499 - 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: System requirements for MySQL?
Cold Fusion 4.5 Server is a hog. If you can run that you probably have enough memory for MySQL. I would not run them simultaneously with less than 384 MB ram. Charles Hagen On Thu, 15 Mar 2001, Chris Peterson wrote: I cant seem to find system requirements anywhere for MySQL, even inside the hundreds of pages of the manual... I wish to run the latest stable release on MySQL on a Windows NT Workstation PC, and will also use this PC to run ColdFusion Professional 4.5 server. Where could I find recommended or minimum requirements for this? Help! Thanks, Chris Peterson -- Charles L. Hagen Engineer Hagen IT 920-261-8499 - 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: Upgrading RPM 3.23.33 to 3.23.34
rpm -Uhv ... Yes bring it down or it will not upgrade properly. You may need to upgrade Apache etc too. Need to check with your OS vendor on this. Charles Hagen On Thu, 15 Mar 2001 [EMAIL PROTECTED] wrote: Sorry for the basic-ness of my questions, but... What's the best way to upgrade an RPM installation of MySQL? Can I just run rpm -U 3.23.34-1.i386 and it will take care of the upgrade or is there another way? Also, should I bring down the server before attempting an upgrade? Is it likely I'll have to rebuild PHP or Apache after the upgrade? I'd appreciate any advice from the MySQL sages... - 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 -- Charles L. Hagen Engineer Hagen IT 920-261-8499 - 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
Webmin
Has anyone found a GUI for MySQL on a Linux box? I found Webmin, but it seems limited. Is there an HTML GUI for MySQL? -- Charles L. Hagen - 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: Installation on RH7 box
Well you need to look for updates on the RedHat site. There are conflicts with the new version, I believe, as I was never able to achieve a successful loading on my release 7.0 Linux box. I would say this may be a good time to contact them directly. Charles Hagen On Tue, 13 Mar 2001, Alec Smith wrote: As the RPMs available on the MySQL site are built against RH6.x libraries, is there someplace where I can get versions linked against RedHat 7 libraries? RedHat themselves don't seem to have anything newer than 3.23.32 whereas I'd like to use 3.23.34. Yeah yeah, I know I should have installed RH6.2 on the box... Its a little late for that now though. Thanks! Alec - 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 -- Charles L. Hagen Engineer Hagen IT 920-261-8499 - 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: Reinstallation HANG
What is your swap size? What is your drive space? It sounds like you need to upgrade to their latest. Did you load all the updates on your 6.2 box? Charles Hagen On Mon, 12 Mar 2001, Weber, Jeff wrote: Mysql is hanging when started on my Linux box (Red Hat Linux release 6.2 (Zoot) Kernel 2.2.14-5.0 on an i686 -- mysqld, Version: 3.23.21), so I thought I would reinstall mysql_install_db. This hangs too, see below... [root@myserver mysql]# mysql_install_db Creating func table Creating tables_priv table Creating columns_priv table Server doesn't come back after this, I have to kill -9 to stop it. Anyone have any idea why the install would hang this quickly? Thanks, Jeff - 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 -- Charles L. Hagen Engineer Hagen IT 920-261-8499 - 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: configure fails on linux-2.2.14 (Redhat 7.0), mysql-3.23.33
Are you always this hospitable to others? Charles - Original Message - From: "Colin Faber" [EMAIL PROTECTED] To: "Lyman Neuschaefer" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, March 11, 2001 4:46 PM Subject: Re: configure fails on linux-2.2.14 (Redhat 7.0), mysql-3.23.33 This has been discussed to death, DO NOT RUN GCC 2.96 TO COMPILE MySQL IT IS FAR TO BUGGY Please check the mailing list archives _BEFORE_ posting Lyman Neuschaefer wrote: Greetings, The configure process fails on attempting to compile and link the executable conftest. Below is some of the output generated by configdebug. 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/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 11 Jan 13 06:01 /lib/libc.so.6 - libc-2.2.so -rwxr-xr-x 1 root root 4825002 Nov 19 07:53 /lib/libc-2.2.so -rw-r--r-- 1 root root 22806158 Nov 19 07:22 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Nov 19 07:22 /usr/lib/libc.so Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory -- with-mit-threads=yes --without-perl --enable-thread-safe-client --without-be rkeley-db The following is the last 20 lines from config.log: int main() { } __inline foo() { ; return 0; } configure:6306: checking for off_t configure:6339: checking for st_rdev in struct stat configure:6352: g++ -c -O6 -DDBUG_OFF -g2 -DLINUX -DINVENTOR conftest.c 15 configure:6373: checking whether time.h and sys/time.h may both be included configure:6387: g++ -c -O6 -DDBUG_OFF -g2 -DLINUX -DINVENTOR conftest.c 15 configure:6408: checking whether struct tm is in sys/time.h or time.h configure:6421: g++ -c -O6 -DDBUG_OFF -g2 -DLINUX -DINVENTOR conftest.c 15 configure:6444: checking size of char configure:6463: g++ -o conftest -O6 -DDBUG_OFF -g2 -DLINUX -DINVENTOR -L/usr/local/LessTif/Motif2.0 /lib -L/usr/X11R6/lib -rdynamic conftest.c -lInventorXt -lInventor -lXm -lXt -lSM -lICE -lX11 -lm -lpthread 15 configure: In function `int main ()': configure:6457: `exit' undeclared (first use this function) configure:6457: (Each undeclared identifier is reported only once for each function it appears in.) configure: failed program was: #line 6452 "configure" #include "confdefs.h" #include stdio.h main() { FILE *f=fopen("conftestval", "w"); if (!f) exit(1); fprintf(f, "%d\n", sizeof(char)); exit(0); } Thanks with whatever help you can provide. Regards, Lyman Neuschaefer [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 - 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: installation problem
I just went through this. I found that it would be better to download and install the binary from mysql.com because there is scant information. With the binary install you get specific instruction sheets. Charles On Fri, 9 Mar 2001, Randall Paulk wrote: Dear Sirs: I am trying to install MySQL on Red Hat Linux 7.0. It seems to install correctly, but I am unable to test it. I follow the instructions in the manual (starting on page 96), but I get an error after the command safe_mysqld --user=mysql . The following is output to the scrreen: [1] 1299 [root@localhost bin]# Starting mysql daemon with databases from /var/lib/mysql 010309 14:01:27 mysql ended [1]+Done safe_mysqld --user=mysql Any ideas? Thank you in advance. Randall Paulk IIS, SEC Specialist Universal Computer Systems Houston, TX 77040 713-718-1800 Ext. 2126 -- Charles L. Hagen Engineer Hagen IT 920-261-8499 - 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: Connect Apache
I believe it is also something that has to be enabled and configured in the apache server. Charles Hagen On Fri, 9 Mar 2001 [EMAIL PROTECTED] wrote: On Fri, 9 Mar 2001, Jon Haworth wrote: Not sure exactly what you're after... MySQL isn't an Apache module, it's a separate program. Where can I find Apache module for mySQL ?? maybe "mysql module for apache"? regards -- Bartosz Sienkiewicz MULTINET SA - 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 -- Charles L. Hagen Engineer Hagen IT 920-261-8499 - 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: Reporting Software
Have you ever looked at Big Brother? Charles Hagen On Wed, 7 Mar 2001, jason davidson wrote: Can anyone recomend a reliable monitoring/reporting program for mysql. Im looking for something small, that will at given times, query mysql and report the results. Thanks Jason - 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 -- Charles L. Hagen Engineer Hagen IT 920-261-8499 - 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: Appointment Book
Do a search for an application called One Point. Works pretty well. Charles On Wed, 7 Mar 2001, MikemickaloBlezien wrote: Hello All, Apologize for the slightly off topic. but was wondering if any one on list knows of either a freeware or commercial program for setting up and maintaining Appointments. This is for a golf club that would like to set up a MySQL database for golfer to register and reserver tee-off times. Please respond privately and not to the list if you have some info. Save me some time of trying to create one if there's already one out there that we can use for this project or adapt it to our needs. Much thanks for your time. Mickalo Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - 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 -- Charles L. Hagen Engineer Hagen IT 920-261-8499 - 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
trying to install on RedHat 7.0 and need help
I cannot seem to get this database program to work correctly. I am asking for any help I can get. I need to start this asap. Charles Hagen [EMAIL PROTECTED]
Re: trying to install on RedHat 7.0 and need help
on delete of '/var/run/mysqld.pid' ( 010303 21:59:54 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' ( 010303 21:59:55 mysqld ended 010303 22:00:13 mysqld started 010303 22:00:13 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysql d.pid' (Errcode: 13) 010303 22:00:13 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 010303 22:00:13 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' ( Errcode: 2) 010303 22:00:13 mysqld ended 010304 10:03:53 mysqld started 010304 10:03:54 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysql d.pid' (Errcode: 13) 010304 10:03:54 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 010304 10:03:54 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' ( Errcode: 2) 010304 10:03:54 mysqld ended 010304 10:25:06 mysqld started 010304 10:25:06 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysql 010304 10:25:06 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' ( Errcode: 2) 010304 10:25:06 mysqld ended 010304 10:28:50 mysqld started 010304 10:28:51 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 010304 10:28:51 mysqld ended 010304 10:29:08 mysqld started 010304 10:29:08 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 010304 10:29:08 mysqld ended 010304 10:37:59 mysqld started 010304 10:37:59 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysql d.pid' (Errcode: 13) 010304 10:37:59 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 010304 10:37:59 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' ( 010304 10:37:59 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' ( 010304 10:37:59 mysqld ended 010304 10:38:10 mysqld started 010304 10:38:10 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysql d.pid' (Errcode: 13) 010304 10:38:10 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 010304 10:38:10 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' ( Errcode: 2) 010304 10:38:10 mysqld ended 010304 11:03:47 mysqld started 010304 11:03:47 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysql d.pid' (Errcode: 13) 010304 11:03:47 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 010304 11:03:47 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' ( Errcode: 2) 010304 11:03:47 mysqld ended 010304 11:23:23 mysqld started 010304 11:23:23 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysql 010304 11:23:23 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysql 010304 11:23:23 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 010304 11:23:23 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' ( Errcode: 2) 010304 11:23:23 mysqld ended 010304 19:03:15 mysqld started 010304 19:03:16 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysql d.pid' (Errcode: 13) 010304 19:03:16 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 010304 19:03:16 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' ( Errcode: 2) 010304 19:03:16 mysqld ended 010305 09:22:41 mysqld started 010305 9:22:42 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysql d.pid' (Errcode: 13) 010305 9:22:42 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 010305 9:22:42 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' ( Errcode: 2) 010305 09:39:28 mysqld started 010305 9:39:28 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysql d.pid' (Errcode: 13) 010305 9:39:28 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 010305 9:39:28 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' ( Errcode: 2) 010305 09:39:28 mysqld ended 010305 10:14:43 mysqld started 010305 10:14:43 /usr/libexec/mysqld: Can't create/write to file '/var/run/mysql d.pid' (Errcode: 13) 010305 10:14:43 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 010305 10:14:43 /usr/libexec/mysqld: Error on delete of '/var/run/mysqld.pid' ( Errcode: 2) 010305 10:14:43 mysqld ended That's about it. I tried doing the password change when I started but I could not. My server is "worker.hagenit.com" Be forgiving folks, Linux is new to me as is MySQL. Can you walk me through a MySQL install and initial setup? Sincerely, Charles Hagen - 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 3.23.32 / SuSE Linux 7.1 / php and normal user
Hello, I use SuSE Linux 7.1 with a 2.4 kernel. I have installed the normal SuSE-MySQL packages and creates the default tables. I can normaly use mysql if I am root. But if i'm logged in as normal user or try to connect to mysql via php i got the following error message: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /usr/local/httpd/htdocs/gutefrage/secure/statistic.php on line 19 What can I do? Hagen -- Hagen Hoepfner Uni MD / FIN / ITI / AG DB - eMail: [EMAIL PROTECTED] Homepage: http://wwwiti.cs.uni-magdeburg.de/~hoepfner - 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