-Original Message-
From: Jonas Norrman [mailto:[EMAIL PROTECTED]]
Sent: 15 March 2001 01:23
To: Andy Smith
Cc: [EMAIL PROTECTED]
Subject:
Andy Smith [EMAIL PROTECTED] writes:
Can you use a mysql database with drumbeat2000
a smith
Hello!
There's a need to design a system (something like online forum) that will be storing
huge amount of small messages in database.
There must be fast access only to messages for the last 3 days (guess this means that
main table with indexes on it must be kept small?), while other messages
Hello!
There's a need to design a system (something like online forum) that will be storing
huge amount of small messages in database.
There must be fast access only to messages for the last 3 days (guess this means that
main table with indexes on it must be kept small?), while other messages
Erling and MySQL guys,
On Fri, Mar 16, 2001 at 02:18:55AM +0100, Erling Paulsen wrote:
I just exported (via myodbc) an old access database for my sportsclub to
mysql (the tables). The ms-access database application still works nicely on
the new linked tables in mysql. However, I'm now also
On Fri, Mar 16, 2001 at 12:17:41PM +0300, wrote:
Hello!
There's a need to design a system (something like online forum) that will be
storing huge amount of small messages in database.
There must be fast access only to messages for the last 3 days (guess this means
that main table with
On Fri, Mar 16, 2001 at 10:33:05AM +0100, Fred van Engen wrote:
The mysql client doesn't know about backticks and therefore handles the #
(and '-- ') as the beginning of a comment. It wouldn't do that for quoted
and double-quoted strings.
I see no workaround other than to change the
Hi there,
i dont want to start a thread about MySQL over NFS, i did it and it runs
pretty good,
but now there is a problem i could not solve.
the cpu on the filer goes up and up (15% per day) and i have no idea why.
At the moment it hit 70% in peak time (5 min average)
Seems to be the database
Am 11:22 16.03.2001 schrieben Sie:
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hi there,
i dont want to start a thread about MySQL over NFS, i did it and it runs
pretty good,
but now there is a problem i could not solve.
the cpu on the filer goes up and up (15%
Hi,
This maybe a recurring question, but can MySQL be configured to work as a
distributed database? As a distributed database, I mean having the database
spanning several servers. For example:
Server 1 has 30 gb of free disk
Server 2 has 50 gb of free disk
Server 3 has 90 gb of free disk
My
Hi,
Can i add the Primary key for a table after i created a table?
and if this column is not null and auto_increment will there occur an
error?
t.i.a.
regards
denis
-
Before posting, please check:
Short version: mysqldump seems to produce a "KEY mid(mid)"
statement, which mysql does not understand. Using
KEY (mid) instead of KEY mid(mid) works, though.
Is this a known problem? Is this an oversight by me?
Long version:
kk@lenz ~ $ cat /etc/SuSE-release
SuSE Linux 7.1 (i386)
VERSION =
Kristian Khntopp wrote:
Short version: mysqldump seems to produce a "KEY mid(mid)"
statement, which mysql does not understand. Using
KEY (mid) instead of KEY mid(mid) works, though.
Is this a known problem? Is this an oversight by me?
Ultrashort resolution: kris is stupid and mid is a
This seems to be a competability feater, so you can load it into db2,
oracle etc.
"Kristian Khntopp" [EMAIL PROTECTED]@mail.netuse.de on 03/16/2001 01:06:30 PM
Sent by: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: mysqldump problem?
Short version: mysqldump seems to
It is a known problem, I saw a bug report go through about it a day or so ago.
One workaround I found is to rename the key. I think the problem may have
something to do with the name of the key also being column name or a
special token.
In my case, I had:
int User,
key User(User)
and I
Jerome Abela writes:
I encountered a few problems with the genuine 1.7.8-1 binary RPM for
mysql++.
- If I compile:
Connection con("temp","localhost","root","temp",3306,0,60,1,"",0);
The linker complains: undefined reference to
`MysqlConnection::MysqlConnection(char const *,
Dear All,
I am trying to build up a web based email setup on RedHat linux platform.
And for that purpose I am using a solution comprising of
IMP2.2/Horde1.2/PHP4/Sendmail/Apache Server and MySql. The problem is that
although the MySql server is running, the PHP script cant connect to the
Michael Widenius wrote:
Hi!
The 3.23.35 mainly fixes a critical bug in 3.23.34 with ORDER BY. We
don't know how the ORDER BY bug slipped through our testing suite or
how fatal it's really is, but as we have got a couple of reports about
core dumps regarding this, we recommend 3.23.34
[EMAIL PROTECTED] wrote:
This seems to be a competability feater, so you can load it into db2,
oracle etc.
But not into MySQL - great idea. :-)
Kristian
--
Kristian Khntopp, NetUSE AG Siemenswall, D-24107 Kiel
Tel: +49 431 386 436 00, Fax: +49 431 386 435 99
Pascal THIVENT writes:
Hi,
I have to mananage a very big table (about 20 Go)
A database correspond to a directory.
A table correspond to a file.
Is it possible to distribute the table on several physical partition (like
with Oracle that can use several table space to store one
"Kristian Khntopp" [EMAIL PROTECTED]@mail.netuse.de on 03/16/2001 02:02:28 PM
?Sent by: [EMAIL PROTECTED]
?To: [EMAIL PROTECTED]
?cc: [EMAIL PROTECTED]
?Subject: Re: mysqldump problem?
?
?
?[EMAIL PROTECTED] wrote:
? This seems to be a competability feater, so you can load it into db2,
Justin writes:
For some reason I cannot figure, mysqld is now leaving loads
of SQL.ISD/ISM files in /tmp/ .. perhaps 10 a minute..
there are no errors reported in the mysqld log file, other
than one or two connection aborted every hour.
the files are all owned by root, group
CAL T. DEMIER writes:
I get the subject error when running the static or semi-static linux builds on
Mandrake 7.2. My database is working fine and I am able to use another client,
KMySQLAdmin, without problems.
Cal
hi!
You are probably referring to mysqlgui.
In that case,
Scott McCool writes:
I'm experiencing a problem where mysqld is crashing every time I run a
particular query.
The specific error from the client is:
ERROR 1015: Can't lock file (errno: -30989)
ERROR 2013: Lost connection to MySQL server during query
The server error
Hi,
I have some huge databases generated from text file of a dictionary.
I would like to know if I make a query based on a field which was not metion as a
key
at the creation of the table. Is the speed of the query affected by the size of the
records and by the number of fields a
I tried to query below,
"select src_ip, byte, packet from table group by src_ip order by bytes desc limit 10"
Then DB said, "ERROR 1114: The table 'SQL2997368_0' is full."
What is problem?
Rudolf Schwaiger writes:
Hallo MySQLers
I have problems installing MySQL Version 3.23.33 on RS/6000 AIX4.3.3
Description:
exec(): 0509-036 Cannot load program ../bin/mysqld because of the
following errors:
0509-150 Dependent module
If you are repeatedly querying tables on non-key fields you can improve query speeds
by implementing indexes on those fields...
For instance, if you had a personnel table with the following fields: id, lastname,
firstname, etc Where id was an auto-increment,primary key you could index the
Hello,
I'm running into the problem below when I run configure.
Thanks,
Hani Akil
loading cache ./config.cache
checking for a BSD compatible install... ./install-sh -c
checking for bison... no
checking for byacc... no
checking for pdftex... no
checking return type of sprintf... configure:
I have a question about MySQL acces:
In order to give access to any user on my server I have to give them
"localhost', 'myserverName' and 'MyUserIP' entry in both user and db table,
I thought I only had to set '%' in the user.Host columns and db.host =
'192.168.111.%' to give access to my
I installed 3.23.27 for Mac OS X from the binaries.
When installing PHP, I ran into problems with duplicate symbol names between
libmysqlclient.a and System.framework. I also got a similar error building
DBD::mysql. In both cases, the duplicate symbols were strto* functions.
I built PHP with
Hi there,
First i have the mysql db on linux in /usr/local/
then i installed new on /var
now i get the message:
Warning: MYSQL Connection failed:
Can't connect to local MYSQL Server through Socket
'/var/lib/mysql/mysql.sock' (111) in /usr/local/httpd/htdocs/dbopen.php3 on
line 8.
This is the
On Fri, Mar 16, 2001 at 10:48:59PM +0900, Cho Bum Rae wrote:
I tried to query below,
"select src_ip, byte, packet from table group by src_ip order by bytes desc limit 10"
Then DB said, "ERROR 1114: The table 'SQL2997368_0' is full."
What is problem?
It really helps to search the list
Found this message from mysql in my root mailbox. What does it mean?
"errors occured while rotating /var/lib/mysql/mysqld.log {
^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
error running postrotate script"
I tried to query below,
"select src_ip, byte, packet from table group by src_ip order by
bytes desc limit 10"
Then DB said, "ERROR 1114: The table 'SQL2997368_0' is full."
MySQL tries to create a temporary table to handle your "order by" command.
These tables are usually created in /tmp
On Fri, 16 Mar 2001, Jason Landry wrote:
Subqueries like that won't work until version 4.0.
for now it's rather ugly and inefficient, but one way you could do it would
be like this:
select table1.*, ifnull(table2.column2,-1) as marked from table1 left join
table2 on
Hi all,
I don't know if this is a bug in mysqldump but it
behaves in a strange way. I tried to use mysqldump to
dump out the data and structure of a small database in
order to populate another database but not all records
are dumped. I tried to flush the tables from mysql
server using FLUSH
On Fri, 16 Mar 2001 13:35:18 -0500, Hardy Merrill
([EMAIL PROTECTED]) wrote:
Sure it's easier, but which is safer?
I don't have Charles first message on this topic, but I believe
his error message was from logrotate which is a cron job.
If Charles put
mysqladmin -uuser -ppassword
into a
Hi,
I am using Resin-1.2.3 engine to run my servlet and mysql database with mysql-jdbc
driverto connect to my database thru servlet ..but it shows following error
message when I run my servlet
500 SERVLET EXCEPTION:
java.lang.NullPointerException
at
Hello,
CL Okay, the Access 97 vs. Access 2000 might have something to do with my
CL particular problem now. I will check it using Access 97 later today. I
CL know for a fact, however, that when I first found this problem, I was
CL using Access 97 and the only thing that I changed was the
Description:
When i tried to run scripts/mysql_install_db i received the error:
./bin/my_print_defaults: not found
WARNING: The host 'wave.seachange.com' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary
You might want to take a look at this site:
http://www.phpbuilder.com/columns/tanoviceanu2912.php3
--Patrick
-Original Message-
From: Van [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 8:02 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Simple Multi-Master/Slave
Hello, all,
I wonder if you guys can help me to solve this problem.
In MS Access 2000, I get external data from a mysql database ,but I found I can't
change the data in Access. Every time I try to change the data in Access, I got the
following error message :
This record has been changed
On Wed, 14 Feb 2001, Dario Brignardello wrote:
Hey! That's exactly what I'm working in... is your dia's parser GPLed
?? :-) It could help me a lot... Thanks in advance :-)
I told folks at our local perl mongers ( http://norfolk.pm.org ) that I
was working on packaging up what I had to send to
Thank you for your response (I said right?!? sorry for my little english!)
what you say is very interesting!!!
Where can I read more about RAID_TYPE ecc... (the 3 solution you said?)?
Now I'm writing the program in C and I have not meet this problem but I
will :-(
Just for curiosity: I
Dear All,
I am trying to setup a web based email setup on RedHat Linux 7 platform. I
am using Horde 2.2, Imp 1.2, Php 4, Apache 1.3 alongwith the following rpms
required for the MySql setup: (I am running the entire setup on my single
host for test purposes)
1) mysqlclient9-3.23.22-3
2)
Hi again,
Theres not much written in the manual about RAID_X but you'll find
it under CREATE TABLE
Thank you for your response (I said right?!? sorry for my little english!)
what you say is very interesting!!!
Where can I read more about RAID_TYPE ecc... (the 3° solution you said?)?
Now I'm
test
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL
Hi!
"Peter" == Peter Zaitsev [EMAIL PROTECTED] writes:
cyt
Peter Well probably. But The problem is I can't backup database comfortable
Peter way doing this (I can write a script of couse but there is one which
Peter is doing almost the same thing and it's mysqldump)
Peter so it looks like
Other than the (sparse) documentation in the manual, is there any other
documentation available for INNOBASE files?
Cal
http://www.calevans.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi!
"Greg" == Greg Cope [EMAIL PROTECTED] writes:
Greg Michael Widenius wrote:
Hi!
The 3.23.35 mainly fixes a critical bug in 3.23.34 with ORDER BY. We
don't know how the ORDER BY bug slipped through our testing suite or
how fatal it's really is, but as we have got a couple of
Can anyone confirm that this is correct from a query of netstat? Should the
sock be 'connected' instead of 'connecting'? I ask because although mysql is
running in the proc list, it is not responding to any commands.
unix 0 [ ACC ] STREAM LISTENING 87380
Patrick Calkins wrote:
You might want to take a look at this site:
http://www.phpbuilder.com/columns/tanoviceanu2912.php3
--Patrick
Patrick:
Thanks. Read through the whole howto. It looks like that's what I need. Hope
it works with 5 master/slaves. :)
Best Regards,
Van
--
Am 17:21 16.03.2001 schrieb Jeremy D. Zawodny:
*This message was transferred with a trial version of CommuniGate(tm) Pro*
On Fri, Mar 16, 2001 at 11:32:42AM +0100, Sven Huster wrote:
Am 11:22 16.03.2001 schrieben Sie:
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Why the user interface of MySQL is very difficult? Why is not more friendly like MS
SQL Server user interface? I tried to use and configure MySQL and I get nothing.
Hi,
i read the manual.
but i don't know what to do.
I have a table.
only 2 columns without a primary key.
so i made the following:
alter table 'tablename'
add id auto_increment primary key;
and
alter table 'tablename'
add Misc timestamp;
But all fields are filled with #deleted.
i don't
Hi all ,
I recived few positive messages form the list ,
so I decided to make a public port of the whole thing .
Why it could be used ?
Before you start playing with all this game , you have to understand the
limitations
of my implementation .
All this only allow you to have a sort of sql
Well, there's a few things. First, I think you need to do a few things to
better normalize your data. You need a table to join a person with a job.
It would look like this:
create table peoplejob (people_id int not null, job_id not null)
Then remove the job column from people.
Then when you
you can't. You have to do 2 seperate inserts. (Sorry)
Cal
http://www.calevans.com
-Original Message-
From: Bryan Wheelock [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 3:47 PM
To: [EMAIL PROTECTED]
Subject: INSERT records into multiple tables
I'm just learning how to use
Michael Widenius wrote:
Hi!
Greg On the off chance any ideas when this (A Gemini THandler) 3.23.x release
Greg may be and when we might see a public 4.x alpha. I know the answer will
Greg probably be "When its ready" but a small clue would be nice :-)
Lets guess a bit :)
3.23.36
Michael Widenius wrote:
Hi!
Try:
mysqldump --tab=directory
This does basicly what you want.
After that, it's up to Heikki to fix Innobase to do delayed creation
of indexes.
It would be very handy if Innobase (and the GEMINI when it comes along)
where to support mysqldump in the
HI,
If I understand your question, you need two queries:
select count(*) as count, ip, value from log group by ip
select count(*) as count, ip, value from log group by ip,value
that leads to the right direction! thanks! It shows me a the ips with
their values and how many times they are in the
Hello,
I keep getting this error in my Apache error log:
(54)Connection reset by peer: getsockname
And in the MySQL error log I get:
Aborted connection 78830 to db: 'paintballforum2' user: 'dojo' host:
`10.10.1.2' (Got an error reading communication packets)
I am running a web server
Hi,
something, that gets quite near to what I want is:
select a.id, a.value, b.value
from test as a left join test as b on a.id=b.id
group by a.id, a.value having a.valueb.value;
It spits out the right data, but not the way I want...
++---+---+
| id | value | value |
Hi,
sometimes one has to have the feeling, that somebody wants to help to
get it done better! :) I think I got it:
select a.id, a.value from test as a left join test as b on a.id=b.id
where a.value b.value group by a.id,a.value;
Its good to check logtables!
Of course I would appreciate
Ok, I supposed Monty forwarded this to me so I could comment on it.
Michael Widenius wrote:
We plan to use the following algorithm on top of our current
replication code to achieve this:
http://www.fault-tolerant.org/recall/
Regards,
Monty
Greetings All:
2 Parts...
On Fri, Mar 16, 2001 at 07:39:01PM -0700, Sasha Pachev wrote:
Here is what you can do:
server1 - server2- server3 - server4 - server5 -
^ |
| |
When I populate a table with a LOAD DATA LOCAL INFILE file, it says
there are some warnings... where can I find these warnings? Are they in
a log file? Thanks.
Additional info, I'm using 3.23.32 on Redhat Linux 7.0. safe_mysql
starts my server...
Phil
--
Insanity Palace of Metallica
Title: Blank
Has any one heard of a good way to import
from MS SQL Server into a new mysql database.
I have a small (120 MB) database that I
would like to convert to mysql and I was hoping that there was some sort of tool
that will allow me to do it while maintaining the DDL
Any
On Friday 16 March 2001 19:46, Jeremy D. Zawodny wrote:
On Fri, Mar 16, 2001 at 07:39:01PM -0700, Sasha Pachev wrote:
Here is what you can do:
server1 - server2- server3 - server4 - server5 -
^ |
|
Dear All,
I am trying to setup a web based email setup on RedHat Linux 7 platform. I
am using Horde 2.2, Imp 1.2, Php 4, Apache 1.3 alongwith the following rpms
required for the MySql setup: (I am running the entire setup on my single
host for test purposes)
1) mysqlclient9-3.23.22-3
2)
Dear Sir,
We have installed redhat 7.0 server on one machine and want to run mysql
server on that. The installation is default. After that only the root is
allowed to connect to the server and if login as different user i am
getting the error as error 111 connection refused.
If anybody has
71 matches
Mail list logo
