: _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" wrote:
> MySQL Serve
BI 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 advan
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-
-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 M
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
, 2009 at 6:50 PM, Hagen 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
>
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
ISCO 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-
+---+-
-+--++++-+
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 t
e\', \'$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
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
| 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 ki
You can try to use two "subqueries" and an union ala
SELECT * FROM tab where c>0 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
--
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
pache 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 Proble
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]
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
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 spec
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.): onc
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
wo
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.
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.
Qu
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?
27;
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
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 ins
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
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 t
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
>
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
This is a permissions issue. Check the directories mysql is located in
and grant executable permissions. Also verify ownership requirements for
each of these directories.
Charles Hagen
On Mon, 12 Mar 2001, Russ Heaton wrote:
>
> I just installed RH 7.0 selecting the 'install
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
I agree.
Charles
- Original Message -
From: "Cal Evans" <[EMAIL PROTECTED]>
To: "Dave Brown" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, March 10, 2001 11:20 AM
Subject: RE: no libmysqlclient.so in binary distribution
> Dave,
>
> Just guessing here but I would say yes,
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&#x
al 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.
w.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
>
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.
> Th
ql
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
0103
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]
Can anyone email who knows how to set up MySQL? I attempted an RPM install and am
having troubles.
E-mail me at [EMAIL PROTECTED]
if you can help.
Charles Hagen
ction 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
---
Tested on the following versions of mysql: 3.22.32, 3.23.31 on Linux
Description:
"where not field like pattern" gives empty set, while
"where field not like pattern" return what i expect
How-To-Repeat:
create table testtabell(test varchar(10));
insert into testtabell values('test.com')
41 matches
Mail list logo
