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 star
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) php-m
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 ->
> > ^ |
> > |
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 suggestio
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
http://www.
On Fri, Mar 16, 2001 at 07:39:01PM -0700, Sasha Pachev wrote:
>
> Here is what you can do:
>
> server1 -> server2-> server3 -> server4 -> server5 ->
> ^ |
> | |
>---
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:
>
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;
It´s good to check logtables!
Of course I would appreciate sugg
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.value<>b.value;
It spits out the right data, but not the way I want...
++---+---+
| id | value | value |
++--
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 an
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
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 mysqldum
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 :)
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 MyS
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 c
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 cluster
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 hav
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
- Original Message -
From: "Peter Holm" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001
1: Because by choosing MySQL over MS SQL you are choosing power over
packaging. I've got a license for MS SQL and am moving away from it.
2: There are several projects to create GUI front-ends for MySQL. I suggest
you look around, you'll probably find one you like.
3: Did you have any specific
On 15-Mar-01 Gunnar von Boehn wrote:
>
> Hi
>
> I run a database using mysql 2.23 by a webspace provider.
> I would like to keep a 1to1 mirror of it at home.
>
> Unluckiely I have no shell/ftp access to the tables directory.
I assume you have ftp access to a dump directory ?
> The database-
I'm just learning how to use MySQL and I am searching for a more simple way
of doing an INSERT query into multiple tables simultaneously.
I have done my best to nominalize my DB but that creates but I'm confused as
to how to insert data into the DB and have all the related table be updated.
I thin
Hi,
it is quite easy, I thought, but I can´t find it...
there is a table, which is used as a simple "logging table", so there is
only
ip | value | time
ip is not unique, neither is value.
ip and value in different rows can have the same values but sometimes
they differ, that´s the point!
I want
¿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.
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)
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
--
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
/var/lib/mysql/mysql.soc
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
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!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
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
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 PRO
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
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) php-m
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 hav
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
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 by
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 F
>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 M
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
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 Firstdb.doGet(Firstdb
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
>
>
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 TAB
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 cron job, then the user's(root?) password would be in
open view to anybody who
Hello Michael,
Wednesday, March 14, 2001, 4:41:21 PM, you wrote:
Peter>> Well I tried to do so but still it takes an amount of time to add the
Peter>> indexes...
Peter>> I think the good Idea would be to add to mysqldump an option to create
Peter>> the table without index, then insert all data
Nuno Ferreira wrote:
>
> Hi again.
>
> I've been reading all the archieve files about a error i get when
> trying to do any sql thing with a table.
>
> check this out ...
> mysql> select * from imp_addr;
> ERROR 1030: Got error 127 from table handler
>
> than
Please read the documentation...since it's obvious you havn't, I shall
repeat it here:
DON'T USE SOLARIS TAR! GET GNU TAR!
Sorry for the bit of a blow up there, but I am quite sure that this is well
documented, in big bold red letters on the DOWNLOAD page. And yet we still
get at least 1 perso
denis mettler wrote:
>
> Hi,
>
> i have a mysql db on suse linux 7.1
> only one table without primary key.
>
> then i inserted data via load data local infile
> everything was fine.
>
> then i altered table and added a primary key
> everythings fine, too.
>
> i'm searching for results
I think it would be easier to just go:
mysqladmin -uuser -ppassword
On Fri, 16 Mar 2001 11:09:37 -0500, Hardy Merrill
([EMAIL PROTECTED]) wrote:
>Charles,
>
>I think I know what's happening - your MySQL "root" user has
>a password, and "mysqladmin" wants a password before it will
>execute for "r
I forward my question as I didn't get any response in the myODBC mailing
list. Hope someone can help.
> Is this the best mailing list when experiencing problems when compiling
> MyODBC? While configure works make breaks. Problem is in
> connect.c, line 89:
> dbc->mysql.net.vio = 0. Compiler says:
The ''having marked=-1' clause filters out records after the entire query is
completed. The where clause modifies which recorded get included in the
first place.
> for now it's rather ugly and inefficient, but one way you could do it
would
> be like this:
>
> select table1.*, ifnull(table2.colu
Hi again.
I've been reading all the archieve files about a error i get when
trying to do any sql thing with a table.
check this out ...
mysql> select * from imp_addr;
ERROR 1030: Got error 127 from table handler
than i did what everyone says to do with a prob
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 table1.column1
Hi,
i have a mysql db on suse linux 7.1
only one table without primary key.
then i inserted data via load data local infile
everything was fine.
then i altered table and added a primary key
everythings fine, too.
i'm searching for results:
select * from 'tablename' where ID<10;
got th
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)
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*
> >Hi there,
> >
> >i dont want to start a thread about MySQL over NFS, i did it and it runs
> >pretty good,
> >but now t
Charles,
I think I know what's happening - your MySQL "root" user has
a password, and "mysqladmin" wants a password before it will
execute for "root". If you want to run mysqladmin through
cron(as a part of logrotate), you'll need to use an option file
in the unix "root" user's home account(.my
Umm I went looking for libz.a under which subdirectory? I checked lib and
gnu, and no libz.a unless I am looking in the wrong place.
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 8:59 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
S
Ok you can do 1 of 2 things:
1: recompile mysql to put your mysql.sock where php expects to see it.
2: modify your php.ini to tell it where mysql is putting it's mysql.sock.
(Optional 3 idea)
3: check the archive before posting because someone asks this question just
about daily.
Of the 3 I woul
> 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
Hello,
I was able to download the .gz file, but was not able to go any further
with the installation. Is there an installation guide available online.
Looking forward to using this tool.
*
Clyde R. Lewis
Database Mana
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"
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 l
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
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 bui
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 user
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: erro
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
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 /usr/local/li
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?
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 rec
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 ser
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,
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
"Kristian Köhntopp" <[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 db
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 o
[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 Köhntopp, NetUSE AG Siemenswall, D-24107 Kiel
Tel: +49 431 386 436 00, Fax: +49 431 386 435 99
-
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
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
serv
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 cons
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 chan
This seems to be a competability feater, so you can load it into db2,
oracle etc.
"Kristian Köhntopp" <[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 p
Kristian Köhntopp 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
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 users to
upgrade as soon as possib
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 = 7.
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:
http://www.mysql.com/manua
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 dat
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
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
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 cli
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
>
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
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
-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
-
93 matches
Mail list logo
