I have seen this error when
untarring a gz file with:
tar -xvf 'file.gz on the 4.08 distr.
that was just my mistake, and when i did
tar -xvzf mysql-4.0.9-gamma.tar.gz
everthing went smooth
Jim
-Original Message-
From: Defryn, Guy [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 13, 20
MY EXPERIENCE WITH MYSQL GAMMA 4.08 on win2000 professional SP 3
was not too bad:
PREPARE
A shutdown mysqlmax-nt (3.23.53) running as NT service,
B downloaded mysql-4.0.8-gamma-win.zip to desktop
C extracted zip to e:\mysql408
D installed to e:\mysql408\install
E opened the html manual
F skimmed 2
i was playing around with ideas below,
so they may be worthless chatter :-)
what i was
thinking "I'll just assume the wine world is not
wildly un-uniform..." and see where that gets me... :-)
and "wine is just an object..."
but the wine has many grape varieties sounds a hell
of a lot like "one
If it was me I would simplify the problem:
A. tear out apache and php and
B. Get mysql installed and working
C. shut down Mysql and install apache and get it working
D. shut down apache, keep mysql shut down and install Php and get it
working.
then start up each, and test as you bring up the full
to fit your
tastes (see downloads / links page) that come in both Open Source and
proprietary and can run on a multitude of operating systems.
Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388
-Original Message-
From: JamesD [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003
In perl,
a. setup dsn in a separate module (sep.pm) with a method "connect(parameters
to setup db...)"
make sure the directory is not under the webserver doc path
sub connect {
return (DBI->connect ($dsn, "$user","$pass",
{
take out the last two sentences.
scares people away.
suggest last sentence:
"MySql's CLI tools give you full access and control
to all the the power of MySQL. If you prefer a visual tool
to manage your data in MySQL, like Access & Paradox tools see the
downloads/links
page, as you learn MySQL's c
-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 01, 2003 5:31 AM
To: JamesD; David T-G; mysql users
Subject: Re: An Idea
James,
> something that can be based upon pages of htm and
> emails that exists, and that can sit under
we find people just like to ask questions,
and no matter how good our FAQ's and help are,
many people have circumstances that make it more
efficient to push the question into the queue, and wait
for an answer to pop back later.
lists work, and faq's work, some like to call...etc.
personally, I'd p
we are all in sales, 24/7. :-)
Jim
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 9:24 PM
To: JamesD; Peter Lovatt; [EMAIL PROTECTED]
Subject: RE: An Idea (really: MySQL and Perl for the Web)
At 17:35 -0800 12/29/02, JamesD wrote:
>wh
while Paul probably wouldnt say it, I would:
his book: "MySql and Perl for the Web" ISBN 0-7357-1054-6 "New Riders
Publishing"
answers the questions you are getting at below, and
IMHO the book is excellent as a "how do i get started..." and more...
$44.99 SRP - a low cost compared to the 'deep b
thanks Mike,
I think i'll go climb another learning curve :-)
...
Jim
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 9:49 PM
To: JamesD; Frank Peavy; [EMAIL PROTECTED]
Subject: RE: Fulltext search of words < 3 chars in 3.23
in sql use perl regular expression:
select 'field(s)' from 'table' where 'field' REGEXP '^[a-z]{1,2}$';
Jim
-Original Message-
From: JamesD [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 9:48 PM
To: Frank Peavy; [EMAIL PROTECTED]
S
You need to use the REGEXP capability instead of "Like" in a where clause
select 'field(s)' from 'table' where 'field' REGEXP '^[a-z]{1,3}$';
Jim
-Original Message-
From: Frank Peavy [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 6:55 PM
To: [EMAIL PROTECTED]
Subject: Fullt
seems like it would be easier to
write a perl script
#repeated SQL selects
$count=0;
$sth = $dbh->prepare(qq(select * from table LIMIT ?,?));
while ($sth){
$sth->execute($count,1);
$ref =$sth->fetchrow_arrayref();
print FILEHANDLE "my item is $ref->[0],$ref->[1]...etc\n";
$count+=5;
}
#or use
Thanks Dean.
-Original Message-
From: Dean Harding [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 21, 2002 12:46 AM
To: 'JamesD'; [EMAIL PROTECTED]
Subject: RE: Can MySQL handle 120 million records?
It's just that the number of rows in a table is stored directly in t
rocess is idling and stuffing
results into variables that can be called in an instant, saves
us all time and money...
Jim
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 20, 2002 3:28 PM
To: JamesD
Cc: [EMAIL PROTECTED]
Subject: Re: Can MySQL handle
[mailto:[EMAIL PROTECTED]]
Sent: Friday, December 20, 2002 3:28 PM
To: JamesD
Cc: [EMAIL PROTECTED]
Subject: Re: Can MySQL handle 120 million records?
On Wed, Dec 18, 2002 at 08:05:46PM -0800, JamesD wrote:
>
> i like mySQL, but it has a long way to go to gain the level of
> 'confidenc
i like mySQL, but it has a long way to go to
gain the level of 'confidence' that oracle, db2 or mssql or sybase
have when it comes to frontline mission
critical stuff. I think it will in time...thats why i stick with
it. besides, confidence is often just a synonym for 'knowledge'
select count(*)
I've read limits are based on the filesize your OS can handle,
the HDD size, memory, how fast your RISC
or CISC processors are...and how the stars are aligned...
i think 4 billion records will need some horses pullin...
8 x 2.4 XEON/2 at least. I've run simple queries on
80 million records and it
do this at the prompt...
echo $PATH
whereis mysql
and compare the results.
when in the bin directory type ./mysql as root... without ./ the shell
wont find it...
Jim
-Original Message-
From: Gary Hostetler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 17, 2002 8:33 PM
To: [EMAIL P
yea, me too. but being second just isnt as good...
but did you grant the user permissions on the database
they want to connect too? can you connect to anything listening on
3306? htttp?
when i connect from remote over tcp its
>mysql -h "hostIP" -p -u "someuser" somedatabase
the firewall accepts
A timestamp is just a scalar. Perl could care less
about field types, because everything is ultimatly
just a scalar or a list to perl.
there may be module on cpan.org that handles intricacies of
mySQL timestamps...
#perl -MCPAN -e shell
cpan>i mySQL
or
cpan>i timestamp
etc
Jim
-Original M
they can do it. they just dont want to.
firewall rules can be established to allow
connects to the mysql port from only the ip's
assoc with your remote offices, etc etc
the answer is you can do what you want. You
just need a business partner who can service
his customer properly.
mysqlODBC can do
"grant all on "somedatase.*" to "user@host" identified by "somepassword" "
needs to be run on your database, it appears, by a user with authority.
Jim
-Original Message-
From: Matthias Dorn [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 7:18 PM
To: [EMAIL PROTECTED]
Subjec
Hello,
BTW the ^ symbol means "search at the very beginning of the string"
or maybe SELECT * FROM `table_name` WHERE Email REGEXP "(^[a-z0-9]+)\@(.*)
this puts the name in $1 and the domain in $2, if you are running
the select from a perl script -
:-)
Jim
-Original Message-
From: Rober
26 matches
Mail list logo
