Hi!
In 3.23.41 there was a serious BLOB bug which
corrupted the table if you updated the primary key
of a long row.
There was also another bug in 3.23.41 which could
crash a query if you selected two long columns in the
same query.
There is a special page for bug reports at
the InnoDB website:
This will get a manager of a team which contains a team which contains
individual nr 5.
SELECT I.Name FROM
TEAMREPORT T3
TEAMREPORT T2
TEAMREPORT T,
INDIVIDUAL I,
WHERE T.individualId = 5
AND t.teamid = t2.indivdualID
AND t3.IndividualId = t2.teamID
AND T3.IndividualID = I.IndividualID
AND
Hi.
I came across serious problem.
There is hierarchy among groups listed below like directory structure.
A(group)-B(group)
|
-C(group) D(group)
|
E(group)
From: Bertrand TACHAGO [EMAIL PROTECTED]
% cp /usr/local/mysql/support-files/mysql.server \
/etc/rc.d/init.d/mysql.server
% chmod 544 /etc/rc.d/init.d/mysql.server
I had done it but it doesn't work
% ln -s /etc/rc.d/init.d/mysql.server \
/etc/rc.d/rc3.d/S99mysql
Adam Douglas wrote:
1. Replication between 2 sites via the internet over a VPN or just using a
secure connection.
Chapter 11 in the manual (p. 354 of the PDF). You're set. SSH will get
you the secure connection.
2. Transaction processing capabilities with the ability to roll-back a
On Tue, Sep 25, 2001 at 01:16:05AM -0700, Rodney Broom wrote:
From: Bertrand TACHAGO [EMAIL PROTECTED]
% cp /usr/local/mysql/support-files/mysql.server \
/etc/rc.d/init.d/mysql.server
% chmod 544 /etc/rc.d/init.d/mysql.server
I had done it but it doesn't work
% ln
-Original Message-
From: Adrian D'Costa [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 12:56 AM
To: Mysql Mailing List
Subject: last week, this week
Hi,
I have a table that hold a lot of information about pricing and dates. I
would like to list the of differnce of
Why, when doing replication, would some queries to a replicated database get
logged to the binlog, but not others? Is replication still very beta, or is
it considered to be stable now?
The slave of course falls behind because of the queries that don't go to the
binlog
versions 3.23.42 and
Scott Mebberson writes:
AND (words.word LIKE '%award%' OR words.word LIKE '%section%') ## -
difference between 1 and 2 word search
What do you mean by that comment? I can't make any real sense
out of it, and it doesn't seem to have much to do with the actual
query (which returns rows
Hi,
I've just upgraded from MySQL 3.22.32 to MySQL 3.23.42 and almost all of my
date related database entry tables have broken.
I have been submitting datetime's in the format 2001 09 25 11:35:00 to a
standard Datetime field and now after upgrading to MySQL 3.23.42
datetime's entered in this
Description:
I upgraded from RedHat7.0 to 7.1. Now when I start safe_mysqld it says it
starts mysql with
databases from /var/lib/mysql, but it can't start completelety as it says it
refers to
/var/mysql/mysql.sock, which does not exist. Please help. /var/mys
How-To-Repeat:
Hi
We have a sophisticated Underwiting management system written in MS
Access.
The programs and the data are in separate mdb's.
The time has come to improve the product's client/server and
web strengths.
We came across mysql whilst investigating MS SQL server.
Can we upsize our Access
Hi
Yes very easy.
We develop database in Access and export them to MySQL all the time.
One way to do this is down load the tools that are on the web site...
Note MySQL is very fast and very reliable. It has throw to get the speed a
reduced SQL set.
Simon
-Original Message-
From:
Dear Sirs and Madams,
EMS HiTech company is announcing the next version (0.95) of MySQL Manager --
A Powerful MySQL Administration and Development Tool for
Windows95/98/ME/NT/2000/XP.
You can download the latest version from
http://www.mysqlmanager.com/download.phtml
What's new in version
Hi all,
I wish to migrate some Filemaker 5 databases over to MySQL on NT.
Some of the databases have hundreds of fields, so it would be great if I
could export in a format that I can just import without having to pre-set
all the fields.
Any experience/suggestions?
George Pitcher in Edinburgh
Is there any way to select insert at the same time? What I want to do
is select say 10 out 13 field values from one table and dump it into
another table. Would it be possible to do this via a select and an
insert at the same time and how exactly would the sql statement look? OR
do I have
Hi
We have a sophisticated Underwiting management system written in MS
Access.
The programs and the data are in separate mdb's.
The time has come to improve the product's client/server and
web strengths.
We came across mysql whilst investigating MS SQL server.
Can we upsize our
We have a table with over 27 Million rows and have had trouble with the JDBC with
large queries.
Our solution has been to use loops with a more restrictive where clause. Its not
mission critical so I
have not investigated very sincerely.
But I recently ran across the --quick option for the
Dear Anyone
I am one of the Linux user. I use the
freebsd operating system.
I have one main problem. After installation
completed , I put the command mysql in #prompt.
But some error message will shows, I don't
know how to solve it.
The Error message is
Hello
I need to setup update logging for Mysql running on Windows 2000, I read in
the manual that this cannot be done when you are using mysql as a service
(as any startup parameters are ignored).
Ideally I would like to do this, so if the machine is restarted mysql starts
automatically as a
Hi.
On Tue, Sep 25, 2001 at 08:39:01AM -0300, [EMAIL PROTECTED] wrote:
Is there any way to select insert at the same time?
Yes. Have a look at
INSERT ... SELECT
and
CREATE TABLE ... SELECT
in the manual.
Bye,
Benjamin.
What I want to do
is select say 10 out 13 field
When I try to alter a field in my table, I get the following error. I have all
permissions. Please Help
Failed to save field : SQL alter table employees modify employee_id smallint(4)
unsigned not null auto_increment failed : Can't create/write to file
'./employees/#sql-13c_ab.frm' (Errcode:
select count(*) from members where country_id = 1 and read_array is NULL ;
Daren Cotter wrote:
can anybody explain this to me?
mysql select count(*) from members where country_id = 1 and read_array not
like '%20270%';
+--+
| count(*) |
+--+
|34884 |
+--+
The file permissions are wrong. Log in as root change to the
directory where the mysql databases are stored, and reset the file
permissions. something like
cd /usr/local/var/mysql #make this line where ever you databases
are
chown -R mysqluser * # change mysqluser to the username
/usr/bin/mysql_setpermission returns the following:
Can't locate DBI.pm in @INC (@INC contains: )
Perl 5 is installed.
What do I do?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi Ashwin!
Is there any way to select insert at the same time? What I want to do
http://www.mysql.com/doc/I/N/INSERT_SELECT.html
there? Also, is there any way without me creating new tables with all
its fields all the time to copy over the fields from certain tables to
new tables? That
HiHi!
I upgraded from RedHat7.0 to 7.1. Now when I start safe_mysqld it says it
starts mysql with
databases from /var/lib/mysql, but it can't start completelety as it says
it refers to
/var/mysql/mysql.sock, which does not exist. Please help. /var/mys
It's probably in /tmp,
Hi there,
Looking at upgrading from version 3.22.27 to the current release of 3.23 on
Solaris 2.7 platform. We successfully built from built the 3.22.27 and looking
to do the same with 3.23. Are there any gottcha's out there that I should be
aware of?
I looked at the Mysql documentation and
Hi,
I have exactly the same problem as a previous list user (David Kuo Fri, 6
Jul 2001 15:28:35) except I am using 3.23.40 Sorry for re-posting but
I never saw any replies to his original so here it is again ...
I am trying to install mySQL mysql-3.23.39-sun-solaris2.7-sparc on my
Hello everyone,
We have been using the mysql
database for our placement division of our company. I
have been facing with the problem of slowness of
retrieving the results from the database.
Right now there are only 1000 records and it is taking
quiet an amount of time to
Quickly what needs to be accomplished?
On Tue, Sep 25, 2001 at 09:00:08AM -0600, Virag, Thomas wrote:
Hello,
The recently upgraded MySQL denies any access to my previously perfectly
working database. I learned that in this version new Privilege/Grant tables
have to be set up before
cedric wrote:
/usr/bin/mysql_setpermission returns the following:
Can't locate DBI.pm in @INC (@INC contains: )
Perl 5 is installed.
What do I do?
This is really a perl question.
But...
su -
perl -MCPAN -e 'install DBI'
Or d/l the DBI code from your favorite CPAN mirror and install
Chris Aitken wrote:
I am writing a perl script on FreeBSD 4.3 running PHP and MySQL, however i
get the following error message when I try and use DBI to connect to a
MySQL database to pull some data.
Can't locate DBI.pm in @INC (@INC contains: /usr/libdata/perl/5.00503/mach
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 25 Sep 2001, kurelli rajashaker wrote:
Hello everyone,
We have been using the mysql
database for our placement division of our company. I
have been facing with the problem of slowness of
retrieving the results from
Hi there,
I'm having a hard time creating a databae...
My db name is pool and my mySql username is contact.
This is what I did...
GRANT ALL ON pool.* TO contact
CREATE DATABASE pool;
The result was access denied...
What do I do?
Dear Sirs,
I have a form that gets generated based on various conditions for mysql
database; it may contain one or many independent records/rows. Each row has
unique id. I dont have any problem updating one record but having trouble
to update multiple records with one submit button. Is
Hello,
Can someone who has successfully created a MySQL database for a virtual
hosting account show me how to connect! I can always
connect as root ... but when I try to connect as the user its get a
permission error. I went to the database and gave the user of that virtual
account all
In MySQL the best (only?) solution I know of is to write a script (e.g. in
perl or python) that will traverse the tree for you.
e.g:
select a_keys from A
foreach key ( a_keys ){
select c_keys from B
... etc.
delete from b where key in ( a_keys )
If you were really looking for punishment
David Iyoha wrote:
and the above does not seem to work I am loosing my mind
Did you do a 'mysqladmin reload' after you added the permissions?
--Bill
-
Before posting, please check:
http://www.mysql.com/manual.php
Hello Bill,
NO! That might be it ... will try now
thanks
David
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adams, Bill TQO
Sent: Tuesday, September 25, 2001 12:11 PM
To: David Iyoha
Cc: [EMAIL PROTECTED]
Subject: Re: can any one help please?
You should have acess to your own MYsql DB.
Attn Mysql users, is that a change from 3.23.41 to 3.23.42?
On Tue, Sep 25, 2001 at 09:32:08AM -0600, Virag, Thomas wrote:
Probably the best would be to delete my mercury database and reset all my
(tvirag) MySQL settings.
Do I have to set up
Hi
Do you have 'the book' MySQl if so read pages 464-465. if not try deleting
the anonymous entries in the user table. They can cause this error.
Hope that helps
Richard
- Original Message -
From: David Iyoha [EMAIL PROTECTED]
To: Adams, Bill TQO [EMAIL PROTECTED]
Cc: [EMAIL
Hi
Look at the sample database.
try this
create.sql==
# Change user and password to add privileges for different user.
# Note that user with no hostname given is equivalent to specifying
# % as the hostname.
GRANT ALL ON pool.* TO contact;
DROP DATABASE IF
Jeremy Morano writes:
GRANT ALL ON pool.* TO contact
CREATE DATABASE pool;
The result was access denied...
What do I do?
A user can of course not grant himself access to things.
You need to do those things as a user with global CREATE
and GRANT privileges. Read the manual on how
Hello
I have a table that I want to sort.
I want to sort the table according to a text field
that might contain text or numbers
The sort results sould look like this:
50
100
aaa
bbb
I want the numbers to sort like numbers and text like
text.
I cannot split the content of the text field to
Thanks Bill,
That worked.
David
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adams, Bill TQO
Sent: Tuesday, September 25, 2001 12:11 PM
To: David Iyoha
Cc: [EMAIL PROTECTED]
Subject: Re: can any one help please?
David Iyoha wrote:
and
Hello.
On Tue, Sep 25, 2001 at 03:56:30PM +, [EMAIL PROTECTED] wrote:
Dear Sirs,
I have a form that gets generated based on various conditions for mysql
database; it may contain one or many independent records/rows. Each row has
unique id. I dont have any problem updating one
Hello,
I am using mm mysql JDBC driver to connect WO5 to MySQL, but I am having
a problem with INSERT. It seems like WO is executing this command for
inserting a new field.
INSERT INTO test(ID, abc, def, ghi) VALUES (129, '', 'test',
'test')
But MySQL does not understand it. It needs
Hi,
We have MySQL 3.23.27 stalled and running on a Solaris
2.7 machine. We are planning to move our server to AFS
school system (OS version is Sparc Solaris 2.7). The
AFS version is 3.5 or 3.46. Is anybody know whether
MySQL 3.23.27 is compatible with AFS 3.5 3.46? Can we
do the moving.
Have a
HELP!
I have had zero luck in finding a working example of C++ opening/connecting/anything
to a MySQL database. Now before you send me to things like example.c, references
I've found on mysql.com mention either things like sqlplus.hh or other .hh
includes (which for some reason are not
At 10:40 AM 9/25/2001 -0700, Jon Drukman wrote:
Description:
mysql apparently gets stuck when unlocking tables
i have several applications that do:
LOCK TABLES pv WRITE
LOAD DATA LOCAL INFILE 'pageview.data' INTO TABLE pv (id,count,date)
UNLOCK
Hi,
Is there anyway to do this other then copying a representation of the data
into the query string?
This just seems pretty inneffiecient (making an extra copy of the data)
error prone (getting the representation right when you copy it to the
string).
Thanks
Eric
I searched pretty thoroughly for a way to access mysql data in their native
field types (e.g. an int field I wouldn't have to use atoi()/itoa() on) and
came up with nothing. If you are processing large amounts of data you may
want to do what I did which was to make my program build a load file
What tools do people use to document their databases?
Are there graphical tools that will generate relational diagrams
of a database (like in Access)?
One of the databases I've been developing is starting to grow as I add
additional tables to hold different pieces of data. At the moment, my
Yea, that's about what I've come up with myself, but I thought I'd ask.
I have found that the strstream class works very nicely for building queries
though. If you're willing to use C++ of course.
Thanks
-Original Message-
From: Will French [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
What I did to handle global changes was have one access file on the
fileserver that everyone had a shortcut to. That way the updates
were global since they were all to the same file.
How is the speed of running Queries, Forms and Reports from Access using
linked tables to MySQL? I've found it
Hello again folks
I am using MS Access as the front end to my database, but after a while of
use, I get a prompt as follows, when I try to close a table in datasheet
view or when I try to close a form:
The action will reset the current code in break mode {blah blah blah}
Then I have to choose
I find that the sprintf function is quite accurate and very fast.
Yea, that's about what I've come up with myself, but I thought I'd ask.
I have found that the strstream class works very nicely for building queries
though. If you're willing to use C++ of course.
Thanks
-Original
MySQL Gurus:
Is there a newsgroup server for this discussion list?
Thanks,
Christopher Raymond
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Dear members,
I'm new to MySQL and I'm using MyODBC. I can connect to my MySQL localhost
from a VB5 appusing MyODBC. I can open a recordset (using RDO) and when I
try to add a new record I got the following error msg:
Run-time error 40069
Client Cursor: 40 - Assigned data exceeds defined
Hi there I was wondering how to copy tables from one db to the another?
can't find it in the manual...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
There are a number of ways to do this. Not being sure exactly what you
want, a live copy (replication) or a transfer (mysqldump), it's tough for
me to say which method would be best. Look in the manual under mysqldump
or replication and see if those fit your needs.
Steve
At 04:19 PM
hi.
i went looking all over the place for an ER diagramming tool that could read
mysql dumps, and found this:
http://www.datanamic.com/importerscripts/
which will connect to a mysql database and generate a diagram, guessing the
foreign key relationships. this script is not free. the program the
Hi,
how can i check the performance of my mysql db?
Would a MySQL DB work well as a offline machine to store a
huge amount of data (up to 2.000.000 measurements) to generate
time controlled output...
I am a Newby in using MySQL with that big amount of data, so
it would be nice if someone of u
What will this thing have? i know Union tables will be present :) . What
else? I'm very anctious to get my hands on it. thanx ^_^
**
- Deryck Henson
- http://www.comp-u-exchange.com
**
-
Before
From: Ravi Raman [EMAIL PROTECTED]
if you (or anyone else) finds/has found anything better i'd be interested to
know.
I've used Visio here and again, mostly V.6. It involves a lot of legwork since I have
to manually deal with all of the lines representing relationships, but it creates a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 25 Sep 2001 [EMAIL PROTECTED] wrote:
HELP!
I have had zero luck in finding a working example of C++ opening/connecting/anything
to a MySQL database. Now before you send me to things like example.c, references
I've found on mysql.com
Hi.
Please, excuse me for this Off topic message.
I want to develop Windows-based client to interact with linux-based
MySQL and I can't realize the best programming language suitable for
that task.
Clients must be run in Windows because customer requirement.
I need your suggestions.
Hi !!!
-Original Message-
From: Ing. Gustavo Edelstein [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 1:24 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Insert records in a VB5 recordset
Dear members,
I'm new to MySQL and I'm using MyODBC. I can
Take a look at this :)
http://www.mysql.com/doc/N/e/News-4.0.0.html
I'm currently using MySQL 4.0 on two servers, and it works great :)
Union seems also to work really fine now although it remains some features
to be added before beeing perfect.
Jocelyn Fournier
Presence-PC
- Original
On Tue, Sep 25, 2001 at 06:26:58PM -0300, Walter Omar Autalán wrote:
Hi.
Please, excuse me for this Off topic message.
I want to develop Windows-based client to interact with linux-based
MySQL and I can't realize the best programming language suitable for
that task.
Clients must
From: Walter Omar Autalán [EMAIL PROTECTED]
I want to develop Windows-based client to interact with linux-based
MySQL and I can't realize the best programming language suitable for
that task.
Clients must be run in Windows because customer requirement.
There's an ODBC driver for MySQL.
I would like to make a query that give me the following
result:
2 tables:
call
phone_number,dest_number,durantion
extention
phone_number,employee
I would like to have the
Delphi 6 is very good It has the advantage that you can use dbexpress
and write an app which will run under windows AND linux
This is what I am using (along with Visual C++ and VB)
-Original Message-
From: Rodney Broom [mailto:[EMAIL PROTECTED]]
Sent: 25 September 2001 22:50
To: [EMAIL
At 02:56 PM 9/25/2001, Walter Omar Autalán wrote:
I want to develop Windows-based client to interact with linux-based
MySQL and I can't realize the best programming language suitable for
that task.
Clients must be run in Windows because customer requirement.
Hi Walter,
I have been developing
Does anyone have a solution? The following are the compiler, utils and
O/S. I have tried using gun ld and the ld supplied by sun.
Thanks.
-Trevor
[EMAIL PROTECTED]
SunOS solo 5.8 Generic_108529-09 i86pc i386 i86pc
gcc-3.0.1
gnu fileutils-4.1
gnu autoconf-2.50
gun automake-1.4-p5
export
On Tue, Sep 25, 2001 at 02:50:09PM -0700, Rodney Broom wrote:
From: Walter Omar Autalán [EMAIL PROTECTED]
I want to develop Windows-based client to interact with linux-based
MySQL and I can't realize the best programming language suitable for
that task.
Clients must be run in
Is there any advantage of using MyODBC vs. iODBC with MySQL as the backend
and M$ Access as the front end?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
From: Doug Poland [EMAIL PROTECTED]
Have you thought about a web based app? I've successfull steered
customers from an Access/MDB or VB/MDB applications to HTML based
apps talking to *nix/apache/php/mysql.
Here, here. I think this is the way to go if you can.
---
Rodney Broom
Hi,
Just dump the tables from the original database:
% mysqldump -h yourhost -u root -p yourpass existing_dbname dbname.sql
Then import the dump into your new database:
% mysql -h yourhost -u root -p yourpass new_dbname dbname.sql
Should get you started.
Nick
-
I've just recently heard about InnoDB. Correct me if I'm wrong here
but does InnoDB just enable MySQL to have transactions and row level
locking? Is there more to InnoDB.. I went to the web site and didn't see any
explanation of what InnoDB is other then the title on the first page.
On Tue, Sep 25, 2001 at 04:11:02PM -0600, Adam Douglas wrote:
: I've just recently heard about InnoDB. Correct me if I'm wrong here
: but does InnoDB just enable MySQL to have transactions and row level
: locking? Is there more to InnoDB.. I went to the web site and didn't see any
:
Hi All,
I seen a post a few days ago on how to set the auto increment value back to one
after deleting all the data from a table. I suppose I could just re-create the
table, but thought it be simpler to just alter the table to reset the auto
increment value back to 1. what exactly is the alter
Hi listfellows!
Okay, I'm trying to make a form talk to a SELECT query using PHP. How do I
make input from a form become a PHP variable?
This is how far I've gotten:
?php
function search_records() {
?
form name=form1 method=post action=?php echo
At first I thought this was a MyODBC problem but further investigation
proved otherwise... I can't connect to my MySQL server from a Windows
box. When I run telnet server 3306, I get the following response (*
is some unprintable character):
D*Host '192.168.2.7' is not allowed to connect to
Hmm, the words table is just a table with an id field and a word field, the
word field only contains one word in it and then the id field is that words
id. There is only one word per row.
The searchwords table is a long list of keywords that relate to that field,
i.e. it contains the pdf id, the
What I say will not help you since this is a MySQL limitation. However, on
more fully-featured SQL systems, you can specify a referential constraint that
will delete child rows when the parent row is deleted.
You might have something like this on table C (assumes table A is the master):
create
Upgraded win98 to win2000. Now unable to log onto mysql as
previously did mysql -h localhost -u me -p. Have tried
several diff host names to no avail. How can I correct?
Frank
-
Before posting, please check:
Nate Fowler writes:
Okay, I'm trying to make a form talk to a SELECT query using PHP. How do I
make input from a form become a PHP variable?
This is explained in great detail in the PHP manual at
http://www.php.net
form name=form1 method=post action=?php echo
Hi all,
I have two very large tables (4 million recs each) where the records from
each have a 1-to-1 relationship. They share a primary key (int) and there
are no unmatched records in either table (i.e. it is a true 1-to-1). I am
trying to combine a few columns from each of the two tables into
90 matches
Mail list logo