Mysql Perl DBI DBD Version Compatability for MAC OS 10.6

2009-10-05 Thread Hagen
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

Re: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6

2009-10-05 Thread Hagen Finley
: _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

MAC OS 10.6 Snow Leopard Breaks MySQL - Resolved

2009-09-05 Thread Hagen
: 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

MAC OS 10.6 Snow Leopard Breaks MySQL

2009-09-04 Thread Hagen
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

2009-09-04 Thread Hagen
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

Group by column and Sum another

2009-07-20 Thread Hagen
(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

2009-07-20 Thread Hagen
, 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

Date Translation Issues

2009-07-14 Thread Hagen Finley
, $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

2009-07-14 Thread Hagen Finley
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

Re: Date Translation Issues

2009-07-14 Thread Hagen Finley
\', \'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

Record IDs

2009-02-23 Thread Hagen Finley
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

2008-12-06 Thread Hagen Finley
| ++--+-+---+ | 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

Re: Mysql Performance

2004-11-23 Thread Hagen Hoepfner
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

Re: order by question

2004-11-23 Thread Hagen Hoepfner
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 - 1

Re: Basic Problem Facing towards..

2004-11-19 Thread Hagen Hoepfner
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

Structure of .frm-Files ...

2004-11-19 Thread Hagen Hoepfner
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..

2004-11-19 Thread Hagen Hoepfner
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

RE: [Mysql] mysqld ended

2003-11-17 Thread Matthew Hagen
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

Flush logs, binary log index file

2003-08-14 Thread Jean Hagen
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.):

Check table script

2003-08-04 Thread Jean Hagen
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

mysql_history file?

2003-07-31 Thread Jean Hagen
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.

Backup conventions

2003-07-31 Thread Jean Hagen
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.

Indizes abschalten.

2001-04-19 Thread Hagen Schmieder
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

2001-03-16 Thread Charles L Hagen
cript" -- 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 thre

Re: System requirements for MySQL?

2001-03-15 Thread Charles L Hagen
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

Re: Upgrading RPM 3.23.33 to 3.23.34

2001-03-14 Thread Charles L Hagen
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

Webmin

2001-03-14 Thread Charles L Hagen
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

Re: Installation on RH7 box

2001-03-12 Thread Charles L Hagen
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

Re: Reinstallation HANG

2001-03-12 Thread Charles L Hagen
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

Re: configure fails on linux-2.2.14 (Redhat 7.0), mysql-3.23.33

2001-03-11 Thread Charles L. Hagen
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

Re: installation problem

2001-03-09 Thread Charles L Hagen
]# 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

RE: Connect Apache

2001-03-09 Thread Charles L Hagen
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

Re: Reporting Software

2001-03-07 Thread Charles L Hagen
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

Re: Appointment Book

2001-03-07 Thread Charles L Hagen
] 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

trying to install on RedHat 7.0 and need help

2001-03-05 Thread Charles L. Hagen
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

2001-03-05 Thread Charles L Hagen
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, pl

MySQL 3.23.32 / SuSE Linux 7.1 / php and normal user

2001-02-21 Thread Hagen Hoepfner
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