Dear Sir,
I have downloaded DBI-1.15. I tried installing it. The tests failed.
I am using PMAKE to prepare an install program.
The error is as follows:
"can't locate loadable object for module DBI in @INC."
I am also providing you with the procedure i adopted to install DBI
Hi,
I'm having that same problem, but I only have about 1.3 million rows in my
table, and the size is only about 190MB or so.
This started with 3.23.21 (Which had this problem, look in the changelog),
but it is also continuing after upgrading to 3.23.36.
I have a 3.23.36 slave that is replicatio
Andrzej,
As I understand it,
MySQL does not have the concept of tablespaces like in Oracle. Databases are
subdirectories underneath the /var/lib/mysql directory and files are tables
within those subdirectories, so you can put an entire database or individual
files on a different disk by creating
I get the following error when i type "make". Don't have the slightest clue
:/
thanks in advance..
l,/usr/local/mysql/lib/mysql
creating thread_test
make[2]: Leaving directory `/usr/local/mysql-3.23.37/client'
Making all in strings
make[2]: Entering directory `/usr/local/mysql-3.23.37/strings'
g
j'ai eu le meme probleme mais en environnement de développement, ce que je
sait c'est que ca dépend du characterset de votre base de donnée faut
demander à votre hebergeur le characterset (dans les "environnement
variables") du serveur mysql ou votre base est hebergée
At 23:33 21/04/01 +020
There are probably several changes to be made...
1- store characters in 'binary' fields and not text or char fields;
2- convert them into html entities before sending to the client (e.g. à is
converted to à). most languages can do it easily;
3- include charset as outlined previously, possibly add
Where may I find more detail information about MySQL DBA?
How MySQL handle very large table (>10,000,000 records)?
How can I give direction where store data files?
example:
/var/lib/mysql
|
MYDATABASE
Hi,
I have got a problem while connecting to MySQL. While I am trying to connect
to mysql it shows an error 'Acces denied for user [EMAIL PROTECTED] (USING PASSWORD :
NO), but mysql server is still running. I have written a CGI program using PERL to
connect to the mysql database. Using
i doubled checked things, the problem is in the database server
french characters are not accepted as is, my sql converts them to , or ?
any solution for this??
At 14:06 22/04/01 +0300, you wrote:
>In order to see french characters you have to put in your php4/html page
>header the line:
>
Hi,
I'm new to MySQL and I've recently installed MySQL
(MySQL-3.23.36-1.src.rpm) and it's running ok. But, I noticed that it
seems to be consuming so much of my hard disk space. Is this normal? I'm
wondering if anyone encountered this problem before or can advise wat I
can do abt it?
Thanks,
Neo
I am using Tomcat version 3.2.1. I am trying to connect to a data base
from an applet and I am getting the following error:
2001-04-22 05:41:00 - Ctx( /examples ): 404 R( /examples +
/jsp/student/org/gjt/
mm/mysql/Driver.class + null) null
My driver is in: C:\tomcat\jakarta-tomcat-3.2.1\lib
My ap
yet another argument for sub-selects :)
Paul DuBois wrote:
>
> At 2:31 PM -0800 3/22/01, Daren Cotter wrote:
> >I have a table, which keeps track of member information (including which
> >member referred the member). To get a count of the # of referrals for member
> >25, my query is:
> >
> >SE
Hi,all
Does the latest version of mysql 3.23.37 is the binary version support
transation?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
>Hi, I need to know how to install the grant tables and
>start the server on windows platform in mysql.
>Someone please
>let me know. It's much appreciated.
The grant tables are preinstalled as part of the Windows distribution.
You don't need to install them. As for starting the server, the
rel
Hello all,
I wonder if someone could send me a java code showing how to access a mysql
databse. I will appreciate very much, actually my job is counting on that.
Thanks in advance
Siomara
_
Get Your Private, Free E-mail f
Hello all,
I wonder if someone could send me a java code showing how to access a mysql
databse. I will appreciate very much, actually my job is counting on that.
Thanks in advance
Siomara
_
Get Your Private, Free E-mail f
Hi, I need to know how to install the grant tables and
start the server on windows platform in mysql.
Someone please
let me know. It's much appreciated.
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions
I solved my own problem. A simple switch in the order of the libraries
listed in the link command did the trick.
gcc -static metamgrd.o sock.o cfgfile.o cfgitem.o err.o -o ./metamgrd \
-lstdc++ -L/usr/lib/mysql -lmysqlclient -lz -lsqlplus
On Sun, 22 Apr 2001, William Dan Terry wrote:
> On Sun,
Hi!
> "ch" == ch <[EMAIL PROTECTED]> writes:
>> Description:
ch> sql/Makefile.in has a dependency to ../bdb/build_unix/db.h at
ch> line 621. This file is not presence in mysql-3.23.37.
>> How-To-Repeat:
ch> N/A
>> Fix:
ch> delete the reference?
This reference is automatic
Graham,
What kind of files are they? (Access? M$ SQL? .DFB? other?)
Cal
http://www.calevans.com
-Original Message-
From: Graham Nichols [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 22, 2001 2:53 PM
To: [EMAIL PROTECTED]
Subject: web application integration
Hi,
Can anyone please po
Actually, I did get it figured out...it was a small mistake
SELECT DISTINCT(a.ref1) AS member_id, count(*) AS count, b.password,
concat(UCASE(SUBSTRING(b.first_name,1,1))
, LCASE(SUBSTRING(b.first_name,2,LENGTH(b.first_name AS name, b.email,
b.html_mail, b.ref1, DATE_FORMAT(b.signup_
date, '%
I have a auto increment field in a table and after doing a few operations
the flag has gone away. This is using mysql 3.23.36 on OpenBSD. Here is how
it happened:
I am using perl with DBI to interface with mysql. I have been inserting
"NULL" into this field to allow mysql to fill in the auto_incr
Hi, I am getting an
"error 2003 Can't connect MySQL server on Local Host
(10061)"
What does it mean? What should I do?
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
At 2:31 PM -0800 3/22/01, Daren Cotter wrote:
>I have a table, which keeps track of member information (including which
>member referred the member). To get a count of the # of referrals for member
>25, my query is:
>
>SELECT COUNT(*) FROM members WHERE ref1 = 25;
>
>To get a list of the top refer
At 12:37 PM -0700 4/22/01, ricky gonzalez wrote:
>Hi, I need to know how to do the various commands in
>windows.
>
>I tried
>
>c:\mysql
>
>It says
>
>Bad command or file name.
Give the correct path to the program (perhaps C:\mysql\bin\mysql)
or add the directory in which the programs are install
Hi,
Can anyone please point me toward any tutorials /. books regarding
integrating web mysql data with ,say, a LAN-based accounting system? I'm not
sure how to interface with dynamic files continually upgraded by surfers.
Any comments welcome.
regards, Graham
---
why are you using distinct(ref1)?
also count(*) is ambiguous in this case. should be count(a.*).
you have a ref1 column in both tables, but you don't join them on it. that's
kind of confusing but won't cause the problem. member_id is the primary key
on the members table, right? Otherwise you co
Hi, I need to know how to do the various commands in
windows.
I tried
c:\mysql
It says
Bad command or file name.
Someone please help me.
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
At 2:54 PM -0400 4/22/01, Kevin Xin Lin wrote:
>Hi,
>
>Does mysql query support iteration? Can I write loop logic in a mysql
>qurey? thanks.
No. You'll need to use a programming language that supports iteration
and run the query from within the language.
--
Paul DuBois, [EMAIL PROTECTED]
I have a table, which keeps track of member information (including which
member referred the member). To get a count of the # of referrals for member
25, my query is:
SELECT COUNT(*) FROM members WHERE ref1 = 25;
To get a list of the top referers and the # of referrals they have, my query
is:
S
Hi,
Does mysql query support iteration? Can I write loop logic in a mysql
qurey? thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
I try to execute "safe_mysqld --user=mysqladmin &" and the system return:
"chown: mysqladmin: usesager invalide
Starting mydqld daemon with databases from var/lib/mysgl
010422 : 17:59:25 mysqld ended"
I'm extremely newbie in Linux and I waould appreciate some help
To launch MySQL
PII 350 Mhz
This is more of a SQL question than a MySQL question, but I'll ask here.
I have a series of tables, each with widely differing structures. Each table
has an "id" and "timestamp" field, a number of other wildly different fields,
and an identifier (name, title, owner... it's different in every ta
Stephan Weißleder wrote:
> Hi - i have a problem giving names to some tables or fields. using a
> name like "select" or some predefined SQL-standard-words causes errors
> because it is not seen as a name, but as a command.
>
> any solution to this ?
http://www.mysql.com/doc/R/e/Reserved_words.ht
Yes, I try to use with softupdates or async but results is the same.
DD are SCSI U3W Disks.
Have an idea ?
spe.
--
[EMAIL PROTECTED]
- Original Message -
From: "Andrey Nepomnyaschih" <[EMAIL PROTECTED]>
To: "Sebastien Petit" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, April
Don't use mysql predefind names...
you can add one letter to each field name, or try to use '' for example: 'search' (I'm
not sure it's working like that. maybe in some versions of mysql)
You wrote:
Hi - i have a problem giving names to some tables or fields. using a
name like "select" or some p
Hi - i have a problem giving names to some tables or fields. using a
name like "select" or some predefined SQL-standard-words causes errors
because it is not seen as a name, but as a command.
any solution to this ?
-
Before pos
On Sun, 22 Apr 2001, Sinisa Milivojevic wrote:
> Wm Terry writes:
> > I seem to have a problem similar to others, but none of the suggested
> > solutions seem to solve it. It's the standard "undefined reference to
> > `compress'" while using MySQL++. What am I missing. Many solutions
> > appear t
Hi,
I have test two systems with mysql Linux Slackware 7.1 kernel 2.2.16 and
FreeBSD-4.2-STABLE. I have mysql 3.23.36 only running on this two hosts and hosts are
the same (PIII 800 Mhz Ami MegaRaid RAID 1 18.2 Go 1 Go RAM).
I copy the database from FreeBSD to Linux and I launch a same select o
On Sun, Apr 22, 2001 at 12:09:24PM -0400, Bernie Cosell wrote:
> how to get it there... I'd appreciate a 'howto' [or a ptr to the docs or
> whatever] for what I need to do to get the new datadirectory set up.
> THANKS!
mysql_install_db.sh
it's in the /path/to/your/mysql/source/scripts direct
I apologize for the newbie question, but I've been through the docs [and
the DuBois book] and I'm just not quite figuring it out I want to run
a private, local copy of mysqld so I can do some expermenting and fooling
around without getting in the way of our production use of mysqld.
I did a
Hi there
I have an application that is currently running on MSACCESS, using ADO and
Visual Basic 6.0
I am looking at alternate databases and have been testing with MYSQL for
some days now. I have noticed a couple distinct differences in some of the
SQL statements, but have managed to come around
Database configure problem:
When running configure I get the following error:
configure: error: No size for char type.
A likely cause for this could be that there isn't any
static libraries installed. You can verify this by checking if you have
libm.a
in /lib, /usr/lib or some other stan
I would appreciate pointers to scripts that parse mail files (linux mailbox
format or rmail format would be even better) and store the parsed information
in a mysql database.
Thanks,
Jim
Jim Hollan, Professor
Has anyone here used mifluz for full text indexing of TEXT columns in
MySQL?
I have a table with a "num" (MEDIUMINT, unique row identifier) and
"message" (MEDIUMTEXT, the column to be indexed) column. I'd like to be
able to do full text searches on the "message" column and get back a list
of "num
I have installed MySQL 3.23.26 on a Win 2K server.
Set up a user:
- name: Remote
- host: % and "localhost"
- password: password
The 2 user entries are confirmed when I query the user table.
The problem is:
When trying to connect to the database from another PC, if I leave the
password blank w
Samir Baghdadi wrote:
>
> Salut Mr/Mme,
>
> J'ai une question précise : Comment coder les
> caractères spéciaux (de type à, é,..) dans une BDD
> MySql
>
> Le problème c'est que j'ai developpé avec JSP un site
> en utilisant le Système d'exploitation Windows (les
> essais étaient positifs).
> Lo
On Fri, 20 Apr 2001, Siomara Pantarotto wrote:
> Date: Fri, 20 Apr 2001 19:35:52 -0300
> From: Siomara Pantarotto <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
> Subject: ERROR 1046: No Database Selected
>
> Hi all,
>
> I am getting this error
>
> mysql> cre
> Hi Everybody!
>
> Installing Mysql on a sparc sun solaris 2.7 machine.
> The manual from msyql.com mentions adding "user" and
> "group."
>
> What's the purpose of this?
> Thanks for your help!
My guess would be to have mysql running under it's own uid/gid in the event
someone uses it to gain un
I am having problem installing mysql into virtual host server.
How do I select where Mysql should be installed to? how do i set which path i
want the mysql.sock to be installed?
-
Before posting, please check:
http://www.my
hi,
i'm running mysql server version 3.23.33 on a win98 machine
using the following characterset : latin1
i have the following problem
when i enter french characters like à or é... into the database using php4
scripts they are improperly recorded and returned like ? or ,
what i want to know is w
Magnus Espeland writes:
> Well, 0 to 63 and 1 to 64 is the max, but not more than max... Shouldn't it
> work?
>
> And I reckon '1' is a string and not a number (with the quotes) ?
>
> :-)
>
> > `SET('value1','value2',...)'
> > A set. A string object that can have zero or more values, each
Hello,
I just wanted to thank everybody who helped me to understand
the topic below. I am going to unsubscribe from this list now,
so please address any further message, if any, to:
[EMAIL PROTECTED]
Thank you for your time
Marco
On 2001/04/14 20:37:15 +0100, M
Wm Terry writes:
> I seem to have a problem similar to others, but none of the suggested
> solutions seem to solve it. It's the standard "undefined reference to
> `compress'" while using MySQL++. What am I missing. Many solutions
> appear to address libmysqlclient. So I'm not sure if the problem i
In order to see french characters you have to put in your php4/html page header the
line:
Put this line in all your pages that writing or reading from mysql server.
I'm not sure about iso code - try to find your language code...
Original massege:
--
hi,
i'm running my
>Description:
Hi,
I noticed this when making a set called groups with 64 values from 1 to 64.
When inserting or updating the table with a numeric value ex 15 (should set
value 1-4),
select * from whatever doesn't show anything in that colum (not even NULL). If
usi
Hi Everybody!
Installing Mysql on a sparc sun solaris 2.7 machine.
The manual from msyql.com mentions adding "user" and
"group."
What's the purpose of this?
Thanks for your help!
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at gre
[EMAIL PROTECTED] writes:
> >Description:
> Hi,
> I noticed this when making a set called groups with 64 values from 1 to 64.
> When inserting or updating the table with a numeric value ex 15 (should set
>value 1-4),
> select * from whatever doesn't show anything in that c
Hello.
I want to create a user in mysql that can create and "grant" other users
with permissions to a specific table.
I created user with permitions of "grants", and permissions of "insert" and
"grant" to "mysql" database, and I cant add users with that user.
I want that this user could add use
Hi!
> "Andrew" == Andrew Schmidt <[EMAIL PROTECTED]> writes:
>> Description:
Andrew> tough one to describe. the step by step example shows all
Andrew> basicly once a table gets more than 1 row and doing a select with no
Andrew> result will yield a blank date... gah please see the
Peter Faulks writes:
> On Sat, 21 Apr 2001 14:12:20 +0300 (EEST), Sinisa Milivojevic wrote:
>
> >As our manual clearly describes one connection can be used for one
> >query at a time, unless you use threads and mutexes.
>
> G'day
>
> As I said, it worked fine b4 and I got it to work again. I _a
Right now, my MySQL databases are inside /var/lib/mysql.
I need to move them into /home, because there is not enough room in the
/var partition for the databases to grow much more.
This is a production server. How can I safely move the MySQL databases
into /home, with minimal downtime and no dat
62 matches
Mail list logo
