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
: _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
:
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
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
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
(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
, 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
, $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
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
\', \'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
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
|
++--+-+---+
| 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
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
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
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
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]
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
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
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.):
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
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.
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.
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?
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
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
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
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
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
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
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
]# 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
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
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
]
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
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]
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
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
37 matches
Mail list logo