This has been discussed to death on the freebsd mailing lists, The over
all feeling was to add such a system would `break' most of the clients
that subscribe and would eliminate the open mailing list we have now,
Most list subscribers know that about 10/20 questions a month that come
to this
Michael, Interesting idea but I think it would problematic over all,
The mysql manual changes almost everyday (anyone that syncs the bk
tree's knows) I would suggest a better solution would be to provide the
manual as a localized application (possibly even ported to
PalmOS/WindowsCE), Anyone?
This is not a mysql error, Your paths are setup incorrectly or you
don't have GCC installed, set the environment variable `CC' to the
location of your gcc compiler,
CC=something; export CC
KFC wrote:
Hi
I have some problem with my OS system (DEC 0.4) when I ran commad
# CC=gcc
Check table didn't exist in 3.22
Werner Stuerenburg wrote:
Sorry, I don't understand from the manual how to use this
(running MySQL 3.22.32 on RedHat)
I tried to issue
CHECK TABLE tbl_name
as indicated, but get
mysql CHECK TABLE sessData;
ERROR 1064: parse error near 'CHECK
a blob is by definition case sensitive hence 'Binary Large Object' This
is not a bug but by design, If you want a non-Binary field to store
large text objects then you should be using the 'TEXT' data type not the
'BLOB' data type.
Tobias Eggendorfer wrote:
Hi,
I suppose I found a bug :-)
Ok,
The message set that I noticed this morning sparked my interest in this.
Currently I'm developing a search engine that will utilize mysql's
fulltext match technology. The problem that i've run into is, I can't
seem to find any documentation on how to force an AND search with in
MATCH
heh, my ($id) = $dbh-selectrow_array(SELECT MAX(id) FROM tbl;);
xris wrote:
Woops sorry about that last message.
Try using the following:
my $id = $sth-{insertid};
That is what I had to change it to, to get it working.. despite what the
documentation says.
Actually, I can't use
personally I don't care what select you guys feel the need to call, so
long as the dbi call is correct, rather it doesn't matter though because
selectrow_array() simply calls prepare() execute() any ways.
I'd normally use LAST_INSERT_ID() my self (only if i had to) other wise
find a better way
Can anybody help with the question about which one is the best to handle database
driven webpage, Since, we are running on ACCESS DB, and MS SQL for a long time, but,
We just have our new Lynex server it is running MySQL, my question is:
1) What's the different between MDB and MySQL. I mean
You need to escape your strings.
INSERT into mybtd(co_pe) values('Johsua\'s Brother'); cannot run...
[EMAIL PROTECTED] wrote:
Dear sir;
I have find a big error from MySQL. I have one fields like that;
co_na(Fields) = Johsua's Brother;
mybtd is the data name, co_na is
A better solution would be to use the DBI quote() function, see the DBI
perldoc for more information.
and FYI 99% of web clients pass CRLF not just LF so you'd need \r\n
Chris Thompson wrote:
Trying to get text from a CGI textarea box to go into MySQL with the br
line breaks instead on
hehe
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Mazur wrote:
This has to have been asked before, but I can't find it in the
See the security section in the manual.
Longo, Joseph wrote:
hello everyone..
RedHat LInux 6.2.
PC.
mysql.
when i start mysql with 'safe_mysqld ' i get the following:
[root@kauai bin]# safe_mysqld
[1] 872
What does this have to do with mysql?
Rene Tegel wrote:
It would help if you located the piece of source code where the bug might get
involved and post this source code.
On Thu, 31 May 2001 02:32:22 -0500
Dawn H [EMAIL PROTECTED] wrote:
Hi, folks,
The quote below -
jonbad.txt
You could always look into hacking the code that drives the `file'
application, to a point it can determine the binary data type.
David Lidström wrote:
Let's say it's an image, zip archive or a PDF-file!?
I am creating a GUI-client, so it's when a table is
listed, and the field is
Hi,
See 'BLOB' column type in the manual.
David Lidström wrote:
Is there some kind of pattern in fields containing
binary data - so you can be sure that is really IS
binary!?
I.e. if I in my database have a BLOB-field and
sometimes write a string, and sometimes a file?!
Regards
I'm sorry, but we need a little more information, Such as the query
you're using, the machine type, ram etc., the table structure. With out
those its very hard to help you optimize anything.
Bruno Faé wrote:
Hello, I´m Brazilian and a new subscriber of this list.
(sorry my english)
I´m
it all depends on your hardware, technically the MyISAM table type can
handle up to 8 terabytes of data.
Zhu George-CZZ010 wrote:
If each record is about 1K byte, how many records can MySql handle? Does anyone
have any estimation or hands-on experience?
Thank you very much in advance.
A few people have said that they've fixed it by recompiling mysql with
gcc 2.96
Daniel wrote:
Has there been any resolution the
show tables;
show databases;
my @tablenames = $dbh-tables;
etc...
not working on RedHat 7.X machines?
--
Daniel Bohling
NewsFactor Network
This is well outlined in the DBI perldoc btw ;-)
Andy Sharp wrote:
The syntax for connecting to a mysql database from perl/DBI is
my $dbh =
DBI-connect('dbi:drivername:database:host','username','passwor
d');
If host is ommitted, it presumes localhost.
Eg: $dbh =
You've also failed to provide enough information about your problem to
allow someone to figure out what it may be.
Alice wrote:
hi .. i am a new user to mysql,
i did install myODBC, but fail to create the db connection in the ODBC
...
why it fail ???
run the perror app that should of come with your distribution
perror 13
Terry Shipclark wrote:
What does this error mean?? Any help would be appreciated
!--database mysql query relational--
Terry Shipclark
Technical Support Representitave/Cati Operator
[EMAIL PROTECTED]
tel.
see GRANT in the manual.
Snehalata wrote:
Dear Sir,
We installed MySql server on one system. I have the test database, and My
own database named Gomoos. When i using to connect to the database using
java program with a jdbc driver i am not able to connect to my database
Gomoos .But i
have you tried trussing the mysqld process and then moving your system
time up to the crash point?
see what its calling right before it dies?
Stephan Skusa wrote:
Another signal 11 dump ... cutting down sort_buffer to 4194296 Bytes
seems not to be the solution for the signal 11 at 0
3.22.32 has known Join issues, the machine running that version should
be upgraded to the 3.23.32 STABLE release.
Adrian D'Costa wrote:
Hi,
I have been trying this on my localhost and this works
select special.contid, special.cityid, special.curr1, special.catalogo,
special.hf,
Err also, RAND() is a 3.23 feature ;-)
Adrian D'Costa wrote:
Hi,
I have been trying this on my localhost and this works
select special.contid, special.cityid, special.curr1, special.catalogo,
special.hf, special.curr2, special.vitofferta, special.fh, special.club,
special.stars,
hahah
Check out SecureCRT it's a wonderful product and well worth the price.
[EMAIL PROTECTED] wrote:
Any good ones for the Windozes version..When I use just regular ol Telnet I get
Smiley and clovers and hearts and the version.
Cheers
-Original Message-
FROM: Eric
Well, this really isn't a mysql issue. This is an ActiveState perl
issue, But it sounds like you've clobbered your DBD files some how and
or you're just not initializing them correctly.
Siomara Pantarotto wrote:
Hi All,
I got a code from a PERL list that inserts a row into a mysql db
installing DBD-Oracle things got messed up???
Doe anyone know how to make it work with Orcale besides mysql??
Thanks
siomara
From: Colin Faber [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Siomara Pantarotto [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Error when connecting
Validate a date?
see Date and Time functions in the manual.
Vankeerberghen, Pieter wrote:
Dear Colleagues,
How can one validate a date in mysql ?
Kind regards,
Pieter
-
Before posting, please check:
$dbh = DBI-connect($dsn, $user_name, $password, {RaiseError = 1}) ||
die (Unable to establish connection to mysqld: . $DBI::errstr);
tang jie wrote:
the user mysql is given all priviliges,
another user is given db table privileges (INSERT,
SELECT, etc.),
the database files are owned by
why not just use the LOAD DATA INFILE option?
Bombardier Systems Consulting wrote:
HELP!!!
I sent a message to this forum a couple of days ago about a problem that I
am having with MySQL 3.23.37 (and now 36) running under RedHat 7.1.
I am trying to use the mysqlimport utility and
since the outfile is being written as the user that owns the mysqld
process you'll need to make sure that, that user has write access to the
location specified.
Brian Cassidy wrote:
Redirecting file output (for user bpc) with a command such as
select * into outfile 'home/bpc/test.txt' from
A whole TODO list of things. One should really evaluate the pros and
cons of both databases to make an educated decision on which system
would better suit ones needs.
"Ciprian I. Acatrinei" wrote:
Is there something that you can do with MS SQL and you can not do with MySQL?
At 04:01 PM
You need to read the mailing list archives, This has been discussed to
death. Please try to follow the directions outlined when posting.
See the 'http://lists.mysql.com/ (the list archive)' ?
Bryan Coon wrote:
Can anyone offer some insight into the following topic?
I would
1) How was it 'installed' Did you use RPMs, the source, or a bindist?
2) Did you make sure mysqld wasn't already running? 'ps auxwww | grep
mysqld'
Mani kandan Ramachandran wrote:
Respected Sir/Madam
While i configure mysql in my RedHat 7.0,it gives problem.And i do not
know how tro
This has been discussed to death,
DO NOT RUN GCC 2.96 TO COMPILE MySQL IT IS FAR TO BUGGY
Please check the mailing list archives _BEFORE_ posting
Lyman Neuschaefer wrote:
Greetings,
The configure process fails on attempting to compile and link the executable
conftest. Below is
Yes always. :p
"Charles L. Hagen" wrote:
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
Don't forget, Microsoft and Oracle are behind it so it _MUST_ be the
greatest thing to come along since sliced bread. You folks need to keep
in mind that with the microsoft system the XML layer IS NOT part of the
database it self but an additional application which talks to the
database via
Gorjan,
Don't you think it would be a better idea to comply with ANSI SQL92 before we
start talking about adding features that are really not needed nor critical?
Gorjan Todorovski wrote:
To Ed: Why be so negative about adding new features to the DB server? Why
not make things easier and
For someone like my self having a tool to export via XML is bloatware, Any XML
handling should be delt with in the milddleware, where it will be utilized NOT
the database it self.
Michael Bacarella wrote:
Gorjan Todorovski ([EMAIL PROTECTED]) writes:
Is there support for XML in
bob,
first build the tables, to match your ascii database structure, Next use
LOAD_DATA INFILE option to load it up, See LOAD_DATA in the manual for a
detailed explanation.
g'luck
bob wrote:
I'm looking for a way to translate a database in ASCII form throw a
MySQL database.
Could you tell
Donald,
Poor administration of the server or incorrect privileges assigned to your user
account.
Donald Korth wrote:
Hello
The hosting company has given me a user name and passwd . When i log into my own
site thro' a telnet session i 'm able to view all the databases created in the
One thing to keep in mind is IDE tends to eat up processor power where as off board
scsi doesn't.
Greg Cope wrote:
mike thomas wrote:
Hi all
I am running mysql on linux (redhat 6.2) using a regular 18Gb
EIDI hard drive. Does anyone know how much (ball park figure) a
SCSI hard
It took me all of about 2 seconds to locate this;
http://www.fichtner.net/delphi/mysql.delphi.phtml
try hotbot it works great :p
Paulo Serra wrote:
I am a DELPHI developer and I need to know if exists
a MySQL driver for DELPHI.
Does MySQL have a driver for DELPHI???
If it
Its not recommended to just `cp' your data directory for use later. You should
always dump the database with mysqldump.
James Ervin wrote:
Can you restore from a backup of the mysql data directory or do you need to
dump the database in order to be able to restore? I have seen some traffic
Are you sure that your select is in fact using the index on that column? Could
you please explain select for us.
John Jensen wrote:
To: "Scott Gerhardt" [EMAIL PROTECTED]
From what I have heard from a local guru. you shoud double that
again. I had mysql working fine on 150 meg for
see LDIF parsing.
Derek Sivers wrote:
I've got a quickie project here, that's over my head, that I could pay a little
something for:
Can you set up a script that will take flat text files, (one file per record, many
files per directory) - and do some sed/regex conditional replace, and
Martin, Please check the older mailings before posting in the future, Thanks.
Martin Borg wrote:
I am trying to install Mysql 3.23.7 on a Red Hat 6.0 Server system. When
I try to install the binary rpm-distribution i get an error saying that
bin/usr/perl5 is needed. The perl version
Try http-push
Eric Fitzgerald wrote:
Beyond the other suggestion, also remember to flush your STDOUT.
flush(STDOUT);
- Original Message -
From: "Ron Beck" [EMAIL PROTECTED]
To: "Mysql" [EMAIL PROTECTED]
Sent: Friday, January 12, 2001 8:56 AM
Subject: Perl question
Hello
perldoc CGI::Push ;-)
"Aaron E. Schlesinger" wrote:
E-mail me the code. Its late and I'm grumpy. I'll e-mail you back the answer
tommorow :)
Aaron
-Original Message-----
From: Colin Faber [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 12, 2001 20:28
To: Eric Fitzgeral
201 - 252 of 252 matches
Mail list logo