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,
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
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
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 to
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 12:20 PM
To: Michael T. Babcock; [EMAIL PROTECTED]
Subject: RE: What MySQL
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
-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 a few
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
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 breath
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:
while
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:
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]
Subject: RE: Fulltext search of words 3
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
He wants
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 120 million records
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 the
.MYD file (I
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 modulo
[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
'confidence' that oracle
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(*)
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 the
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
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
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
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
cpani mySQL
or
cpani timestamp
etc
Jim
-Original
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]
Subject:
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: Robert
26 matches
Mail list logo