On Thu, Dec 06, 2001 at 07:42:29PM -0800, Gustavo A. Baratto wrote:
> Hi Guys,
>
> The documentation in http://www.mysql.com/doc/R/e/Replication.html ,
> is not clear enough regarding using replication for load balancing.
>
> I understand that the load balance can just be done on SELECTS. And
>
On Fri, Dec 07, 2001 at 08:27:10AM +0100, Ruben van Gogh wrote:
> Hi,
>
> is it possible to put the mysql data base file on a users personal
> so that I can put a quota on it ??
It is possible, yes. Check the mail archives, as this comes up pretty
frequently.
Jeremy
--
Jeremy D. Zawodny, <[EM
Hi,
is it possible to put the mysql data base file on a users personal so that I
can put a quota on it ??
Thanks,
Ruben van Gogh
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
Hi,
I have mysql 3.something or other, a max edition from sometime last month.
I am having problems with startup. It will not run as a service, if i run
just mysqld-max or mysqld-max-nt both start then terminate with no error
message on screen. However if I run mysqld-max* --console it runs just
-Original Message-
From: Venu [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 12:29 PM
To: K. Satish Kumar
Subject: RE: Inserting data...
Hi,
> -Original Message-
> From: K. Satish Kumar [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 06, 2001 10:47 PM
> T
At 8:38 PM -0500 12/6/01, NDPTAL85 wrote:
>>Does anyone know if such a thing exists?
Free
phpMyAdmin
Phpwizard.net
http://www.phpwizard.net/projects/phpMyAdmin/
Webmin
James Cameron
http://www.webmin.com/webmin/index.html
Not Free
MacSQL Monitor
(and SQL Language Module for BBEdit)
Runtime La
Hi all
Which version of MySql can support J2EE well? I have ever used mysql with Jboss (open
source of EJB implementation) , it feels some limitation in comparison with using
oralce.
Why mySQL haven't been support by the BEA weblogic or other main stream EJB
implementation?
---
Hi all
Which version of MySql can support J2EE well? I have ever used mysql with Jboss (open
source of EJB implementation) , it feels some limitation in comparison with using
oralce.
Why mySQL haven't been support by the BEA weblogic or other main stream EJB
implementation?
Try to browse the database of this list, there was a huge conversation on
that about 6-7 month ago.
--
The way I see it, if you declare something portable, you'll always be
wrong, and if you declare it non-portable, you'll always be right. :-)
-- Larry Wall in <[EMAIL PROTECTE
At 18:07 -0700 2001/12/06, René Fournier wrote:
>Does anyone know if such a thing exists? (Especially a freeware one?) I'd like to be
>able to create and modify table structures without hitting Terminal everytime. I was
>using MySQLFront on Windows for this, and it was quite nice. The only probl
Hi Guys,
The documentation in http://www.mysql.com/doc/R/e/Replication.html , is
not clear enough regarding using replication for load balancing.
I understand that the load balance can just be done on SELECTS. And the
documentation says that "The extra speed is achieved by sending a part
of the
Please discuss the pros and cons of storing a file and its meta data in the
database vs file in the filesystem and the metadata in the database.
File + Metadata in DB
1. Can participate in transaction.
2. Does not get out of sync.
3. Overhead of fetching the file.
File in Filesystem and Metadata
(C:
by "demo" I mean that I am going to be using it temporarily to get user
feedback before I go live, mostly though I want to be able to test it and
conintue to develop it. I have tried using "computername" but not
"portnumber" I'll try that. I think that it may be linked to another problem
Hi DB Gurus,
I am planning to use database for one of my applications. I need to decide
between
MySQL and PostgreSQL.
I would appreciate if someone could let me know pros and cons of using these
databases. Is there a comparision information available for MySQL and
PostgreSQL?
Thanks,
jasvinder
On Thursday 06 December 2001 01:08, Karthikeyan wrote:
> Dear Members,
> I installed RedHat 7.1, Apache, PHP4 and MySQL in a Intel Pentium processor
> system.
> Everything works fine (i.e. MySQL, PHP, etc). But when I want to connect
Is phpinfo() working ?
Test on mysql support.
Check on the fil
On Thursday, December 6, 2001, at 08:07 PM, René Fournier wrote:
> Does anyone know if such a thing exists? (Especially a freeware one?)
> I'd like to be able to create and modify table structures without
> hitting Terminal everytime. I was using MySQLFront on Windows for this,
> and it was qu
Hi Erik,
- Original Message -
From: "Erik Price" <[EMAIL PROTECTED]>
> mysql> SHOW COLUMNS FROM subprojectweb;
> +-+---+--+-+-+
> | Field | Type | Null | Key | Default |
> +-+-
Hello,
No matter how hard I try, I am not able to make this query work
without using a temp table (which, as I understand from the documentation,
is not a very good thing). Here are the various details, and if anyone
can give me any pointers on optimzing this query, I will really appreciate
it.
Does anyone know if such a thing exists? (Especially a freeware one?)
I'd like to be able to create and modify table structures without
hitting Terminal everytime. I was using MySQLFront on Windows for this,
and it was quite nice. The only problem is... It's only available for
Windows.
...Ren
At 16:58 -0700 2001/12/06, Van wrote:
>Over the past weekend I pulled a server off-line and about a hundred messages
>got misrouted to the postmaster. Has anyone ever used the mysql perl scripts
>for mail to manipulate mail messages for rerouting? I'd like to strip all the
>administrative notice
I'm getting the exact same error when trying to install MySQL 4.0 on RedHat 7.0 --
both the binary distribution and the RPM.
Previous binary versions of MySQL have worked just fine on the same machine.
/Rob
At 10:07 -0800 2001/12/06, em huynh wrote:
>I also tried using the binary distribution
Thank you Todd, that works when I'm working locally, but I want to be able
to demo this to people, and I would also like to be able to continue
development from locations other than this. Using localhost does work, I
just want more. ehehhe
>From: "Todd Williamsen" <[EMAIL PROTECTED]>
>To: "'C
Hi,
Try ls -Ll cc, to check that the link is valid and to see the permissions on
the destination.
HTH
Quentin
-Original Message-
From: Peter Campbell [mailto:[EMAIL PROTECTED]]
Sent: Friday, 7 December 2001 12:57 p.m.
To: [EMAIL PROTECTED]
Subject: Symbolically linked database, "unknow
Hi!
On Dec 06, Peter M. Perchansky wrote:
> Greetings everyone:
>
> I've noticed that when mySQL runs on Sun Solaris (6, 7, and 8) there will
> be two processes running (safe_mysqld and mysqld).
>
> And this number of processes running will very rarely change, if at all,
> without concern ove
Hi again, thank you to all that helped me out with my last "query".
I'm on a linux box now (YIPEE) I have created a database, and I have
actually managed to load data in that I backed up from a win32 based mysql
database (I'm toally pumped at this point), I set some permissions on the
dir t
Other than a horrendous number of file descriptors, what other
performance issues should one be worried about when using merge
tables?
Is there an upper limit on the number of tables one can use in
generating a merge table?
Please send a copy to [EMAIL PROTECTED] as I am not a subscriber.
--
[
Hi Drew,
- Original Message -
From: "Drew Toussaint" <[EMAIL PROTECTED]>
> We have a system in place that is a LAMP application. The
> system we have it running on is a FreeBSD 4.3 on a Pentium 3
> 1Ghz with 500MB of RAM.
>
> A mysqladmin -i5 stat returns:
> Uptime: 44254 Threads: 24
Greetings:
Over the past weekend I pulled a server off-line and about a hundred messages
got misrouted to the postmaster. Has anyone ever used the mysql perl scripts
for mail to manipulate mail messages for rerouting? I'd like to strip all the
administrative notices from the messages and have t
I've created databases on a partition without problems, now I come
to create a new database on a different partition and I can't access
the database at all.
At this stage I have the following in the mysql data directory
(among others):
lrwxrwxrwx1 mysqlmysql 17 Sep 3 11:56
they're both behaving similarly, it's just that linux's implementation and
display of threads is different than solaris'. the same correlation of
threads for connections is there on solaris, you just won't see it on a
"ps" command's output.
-tcl.
On Thu, 6 Dec 2001, Peter M. Perchansky wrote:
Linux creates each new thread as a whole new process ID, where as Solaris
creates each new thread within the same process ID. If you ps -aefL | fgrep
mysql (on your Solaris box) you will see the individual threads.
I've found MySQL is extremely faster in Linux compared to Solaris..so I
wouldn't
Greetings everyone:
I've noticed that when mySQL runs on Sun Solaris (6, 7, and 8) there will
be two processes running (safe_mysqld and mysqld).
And this number of processes running will very rarely change, if at all,
without concern over the number of connections or how heavily mySQL is
bein
I haven't populated this database yet. There are actually many more
columns, this was kind of a rough draft -- I only featured the ones that
I needed to see if my JOINs were okay. I just got a little nervous when
I drafted a few sample queries and saw that much text !!
That makes me feel muc
From: Erik Price <[EMAIL PROTECTED]>
> Somehow my simple image file-organizing database has turned into
> something huge and frightening.
What you've got looks fine to me. Joins like this are not uncommon at all. I wonder,
where is your concern with this? Is it in how much text you've typed
Pack keys is the only flag that we had trouble with when we were upgrading.
As an emergency fix you could use the following to restore:
sed -e "s/PACK_KEYS=1//g" < filename.sql | mysql --user=root -p
backupdatabasename
Jon Gardiner.
> -Original Message-
> From: Steve Osborne [mailto:[E
Hi all,
We have a system in place that is a LAMP application. The
system we have it running on is a FreeBSD 4.3 on a Pentium 3
1Ghz with 500MB of RAM.
A mysqladmin -i5 stat returns:
Uptime: 44254 Threads: 24 Questions: 779657 Slow queries: 531
Opens: 213 Flush tables: 1 Open table
> But both these queries produce identical one-row results for me.
> I've tried both 3.23 and 4.0 versions.
> Isn't your MySQL version too old ?
Thanks -- sorry for being a pest!
I was using a beta 3.23 version -- I upgraded and it is fixed.
... a lesson learned :-(
-Mark
---
HELP PLEASE !!
I have run into a problem where my ISP upgraded their mysql version, and now
the dump files (.sql) from the mysqldump command cannot be restored on my
local server. Unfortunately, I have to wait for our server to be updated,
so the simplest solution is not an option. The error th
Hi,
I get difference of 15 hours when i issue select sysdate(); command on
mysql> prompt and date command on bash shell.
I am using cobalt linux. I change system time from server interface control
panel.
Can anyone tell me what would be the problem.
My time format is ICT.
I changed my forma
Hi
What about a table with logged in user ids and a timestamp (I use a sessions
table).
Update the timestamp when they access the system. Check when a user tries to
login. If that user id, but a different person, has accessed the system
within the last xx minutes or seconds then consider them lo
Hello, all --
Somehow my simple image file-organizing database has turned into
something huge and frightening. I was hoping that I could get some
input on what I have so far -- it seems correct to me but because it
links so many tables together, I wonder if I'm supposed to be doing this
much
Hi,
That may have the desired effect of two unique keys, but you stil only have
one primary key (probably id1,id2). PRI is listed against each column
involved in the Primary key.
Regards
Quentin
-Original Message-
From: Etienne Marcotte [mailto:[EMAIL PROTECTED]]
Sent: Friday, 7 Decemb
No - instead, update the password with a new, random one, and e-mail the
random one to the user.
- Jonathan
-Original Message-
From: Tyler Longren [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 1:37 PM
To: MySQL List
Subject: PASSWORD() question
Hello,
I have some userna
Hello,
I have some usernames and passwords. The passwords have had the PASSWORD()
function used on them. I need to set up an area of a site to allow users to
have their passwords e-mailed to them. I can't just say SELECT password
FROM table WHERE email='$email' AND username='$username' because
Hi,
I need to implement an access/logging system in mysql+php,
which once a user logs in, does not let another
individuals log in using the same user-password. I don´t care if users
share a user-password, the only thing I want to avoid is that this users
sharing the same user-pw combination, don´
We're having severe problems here. We've been running 2.23.3 on Redhat 6.2
for a while and all has been well. I've also installed mysql several times
with no issues. We had a hard drive go out today, and since then we have not
been able to get mysql to successfully start and accept connections. Ty
for a table in a database (just so my message makes it to the list):
can you make a concatenated primary key, then make the second one an
index?
-
Before posting, please check:
http://www.mysql.com/manual.php (the man
I found a way to have two primary key, if those keys relate on many
columns.
mysql> create table keytest(
-> col1 int not null,
-> col2 int not null,
-> unique index (id1,id2),
-> unique index (id2,id1)
Query OK, 0 rows affected (0.01 sec)
mysql> describe keytest;
+---+--
http://www.linux-mag.com/2001-03/mysql_01.html
There ya go, you can't have it better explained, as for the user access
part.
For the data transfer, that I don't know
Etienne
Curtis Gordon wrote:
>
> Hi, I have just setup a dedicated linux/php/mysql dev box in my office and I
> am gearing up t
using primary key (col1, col2) makes no index on col2... which is not
good if you lookup only in col2
primary key (col1),
unique index (col2)
don't forget to add "not null" beside your col2 definition.
Etienne
rc wrote:
>
> why not use a concatenated Primary key?
>
> create table tname
> c
mysql.sock is created by mysqld and deleted when mysqld stops
-Original Message-
From: David Phoon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 11:31 PM
To: [EMAIL PROTECTED]
Subject: does mysql.sock come with a linux 323 installation
I'd like to know if mysql.sock come
Ziying Sherwin <[EMAIL PROTECTED]> writes:
> We are interested in installing MySQL 3.23.46 from source on our Solaris
> 2.8 machine. However, we could not find berkeley DB 3.2.9a that is
> required by MySQL package. Does anyone know where to find it? Thanks.
>
> Since I am not on this mailing li
We are interested in installing MySQL 3.23.46 from source on our Solaris
2.8 machine. However, we could not find berkeley DB 3.2.9a that is
required by MySQL package. Does anyone know where to find it? Thanks.
Since I am not on this mailing list, please send the reply to
[EMAIL PROTECTED]
Thank
On 6 Dec 2001 [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> database,sql,query,table
>
> If you just reply to this message
Hi,
I am having a problem with the configuration of the mysql server or client.
I have a very large query that I need to send to MySQL from Java. The query
has approximately 5000 individual items in the where clause. (i.e. WHERE
i!='AP' AND i != 'J3' AND...to 5000).
When I try to execute the Q
At 2:46 PM -0500 12/6/01, Erik Price wrote:
>On Thursday, December 6, 2001, at 02:15 PM, Curtis Gordon wrote:
>>2) can somebody, anybody offer up some links to a quicky tutorial
>>on loading a database with existing data, and backing up an
>>existing database. I don't mean the ones in the mysql
why not use a concatenated Primary key?
create table tname
col_name1 int,
col_name2 int,
PRIMARY KEY (col_name1,col_name2)
you get the drift
On Thu, 6 Dec 2001, sherzodR wrote:
>
> As far as I know, you can't do tht. What you could do instead is
> have one Primary Key col and make
Thank you Eric and Mike, I really appreciate the help!
>From: "Mike(mickalo)Blezien" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: "Curtis Gordon" <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: just moved from windows to linux mysql
>Date: Thu, 06 Dec 2001 13:50:52 -0600
>
>Jus
As far as I know, you can't do tht. What you could do instead is
have one Primary Key col and make another one UNIQUE.
I did that several times, and it does work!
--
What they need to teach in school is for people to think for themselves. :-)
-- Larry Wall in <[EMAIL PROTECTED]>
Just to add a few side notes.
We have 2 MySQL's running on a RH/Linux 6.2 box, and it has proven to be very
stable and very reliable. :)
We have approx., 30+ clients that use the one of the MySQL servers, and we set
up each client with a .my.cnf in each of the respective root directories:
/home
Hello everyone,
I have this create table statement,
drop table IF EXISTS GROUP_CONCLUSION_GROUPING CASCADE;
CREATE TABLE IF NOT EXISTS GROUP_CONCLUSION_GROUPING(
ANALYSIS_RESULT_ID MEDIUMINT(20) PRIMARY KEY REFERENCES
PAD_ANALYSIS_RESULT(ANALYSIS_RESULT_ID),
GROUP_CONCLUSION_IDMEDIU
On Thursday, December 6, 2001, at 02:15 PM, Curtis Gordon wrote:
> Hi, I have just setup a dedicated linux/php/mysql dev box in my office
> and I am gearing up to move my databases from a windows box to the
> linux box. There are a couple of things I would like to be clear on
> before I start
The following worked in MSSQL as it could handle views.
Now i want to run it in PHP with a mysql server. I was wondering if there
is another alternative for the below then to use temporary tables.
select * from dev_device_view b inner join cch_playlist_view a on
b.source_name =a.video_source
On Thu, Dec 06, 2001 at 04:30:29AM -0800, Jeremy Zawodny wrote:
> On Mon, Dec 03, 2001 at 08:01:11PM -0800, Peschko, Edward wrote:
> > hey,
> >
> > I was wondering if you had any plans to port mysql to os-390, and
> > the open edition environment there. I think it would be a really
> > cool idea,
Hi, I have just setup a dedicated linux/php/mysql dev box in my office and I
am gearing up to move my databases from a windows box to the linux box.
There are a couple of things I would like to be clear on before I start.
1) when I am logged into linux as "user1" and I create a database, does t
I have compiled mySql before on Solaris, and never had this problem.
On this system, configure goes fine, and make chugs along until the 'sql'
directory, at which point the following occurs:
gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti
-fno-implicit-templates -fno-except
hum maybe you can cut/paste with the right button of your mouse.
this does not work under winNT4, but on my win2k it does, and you could
try it on your machine.
right click in the screen replaces the ctrl-v used for "paste" and it
automatically cuts any highlighted text (as in mIRC)
HTH
Etienne
I've been using mysqlbinlog to capture a file of inserts/updates/deletes on
numerous servers since the early 3.23.x days. I have 3.23.46-max on a pair
of servers now though where it is exhibiting some strange behavior. Based on
some emailed suggestions I've tried leaving off the "-uroot -ppassword
I can tell you how we solved this problem.
we have a 24/7 op where we need to constantly pull data from mysql
machines. This data can be updated at anytime by our tools, but the
live servers will only be reading data. So we have one machine which is
connected to our tools box, this is wher
Okay, got through that NULL problem. Thanks.
My next question is regarding using the DOS prompt. At work, I'm using
Win2000. When I'm using mySQL, if I want to repeat commands, I can just
press the up key without retyping the whole thing. But at home I use Win98.
I can't do the same thing, even t
Hi!
Sorry for delay :-(
On Dec 05, Mark J. Degallier wrote:
> >
> > I need a repeatable test case.
>
> CREATE TABLE products (
> id mediumint(6) default NULL auto_increment,
> numOfFileUploads tinyint(2) NOT NULL default '2',
> category_id text NOT NULL,
> item_no varchar(30) NOT NULL d
Well considering that you are searching for the text 'NULL' and not a null
value
haveyou tried " level2 is null" ?
:-)
- Original Message -
From: "Ward, Mark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 06, 2001 6:37 PM
Subject: NULL Strings
> I don't know
Don't use binaries cuz I prefer to roll my own...
# c++ -v
Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
# gcc -v
Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red
Hi,
I have a couple of problems with mysql 4.0.
First: I tried to compile a new binary using the online docs. The
configure script (./configure --prefix=/usr/local/mysql) when fine.
After a "make" command, it stops at libmysql stating some kind of
recurssive problem.
I also tried using the bin
SELECT * FROM classification
WHERE level1 = "FOO" AND level2 IS NULL;
IS NULL instead of = "NULL"
null is not a value, it's the abscence of value
Etienne
"Ward, Mark" wrote:
>
> I don't know how this affects anything, but, I'm running the most recent
> version of mySQL for win98.
>
> Why is
"DL Neil" <[EMAIL PROTECTED]> on 12/06/2001 05:27:55 PM
Internet mail from:
Please respond to "DL Neil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
cc: <[EMAIL PROTECTED]>
Subject: Re: select statement group by unusual results
Hi Chip,
> Thanks for the tips. So here's my latest attem
I don't know how this affects anything, but, I'm running the most recent
version of mySQL for win98.
Why is it that an SQL statement like this (or any variation)...
SELECT * FROM classification
WHERE level1 = "FOO" AND level2 = "NULL";
will return an empty set. I know that there should be resul
Hi,
I'm getting Duplicate Keys errors from mysql when i have more than one
application attempting to insert into a table. I've tried using LOCK TABLES
to no avail.
Can anyone describe how the Duplicate Keys error occurs so I can understand
how to code around it ?
regards,
Graeme Wallace
XXI
Has anyone had a similar problem? I can't figure out what I'm doing wrong.
Help!
(database description in previous post)
> THIS QUERY WORKS:
> SELECT * FROM products WHERE (MATCH
> (title,short_desc,long_desc,spec_desc,item_no) AGAINST ('rubber'))
>
> THIS QUERY DOES NOT WORK -- RETURNS NOTH
It means you're connecting to the server as an annonymous user.
If you have a username to connect to the server, run the following
query:
mysql> show grants for your_user_name@localhost;
and it will show you all the priveleges that you have for specific
databases and tables. That's the best wa
Hi,
we have a mysql server with a strange behaviour: when we execute a query, it
takes about 5 seconds, even for simple selects which should return almost
immediately.
I run "mysqladmin --sleep=1 processlist" to see what happens, and the
process is in 'sleep' mode for 5 seconds. I never see the
Steve Osborne writes:
> ERROR 2000: Access denied for user: '@localhost' to database 'dbname'
>
> Can anyone give me some insight as to why I cannot do this? Do I require
> root privileges to do this (right now I am logged in as a user, as this
> remote server is an ISP)?
What unix user you a
are you sure you don't want to UPDATE Advertisers SET PACK_KEYS=0;?
Steve Osborne wrote:
>Can anyone tell me why I am receiving the following error? I am connecting
>to a remote server via ssh, and accessed the mysql prompt by typing: mysql
> The following is the screen contents after try
I think you are overreacting with your spam thing.
Quoted from the link he gave:
===
This trial version is FULLY functional!
An unregistered copy of the EMS MySQL Manager may be used for evaluation
purposes for a period of 30 (thirty) days following the initial
installation. At the end of the TRI
Hi Chip,
> Thanks for the tips. So here's my latest attemp:
>
> select distinct Title, Details, StartDate, StopDate, City, State
> from phpCalendar_Details t1, phpCalendar_Daily t2, phpCalendar_EventLocations t3
> where t1.LocationID = t2.LocationID
> and t1.EventLocationID = t3.EventLocationID
>
Hmm
30 days trial then you have to register.
Seems like spam to me
Raymond Abel wrote:
>
> At 20:25 2001-12-06 +0500, Igor Brynskich wrote:
>
> allo
>
> Is this product free like MYSQLfront?
>
> If it is not free,
> Can I considere it as a SPAM
> (SPAM is a no sollocited commercial email)
>
I was wondering if anyone could help me converting some PostgreSQL
queries with sub-queries into a similar form usable (hopefully) by both,
or at least into a form that I can use in place of the PostgreSQL ones.
I'm going to post them - I hope no one minds. If this is the wrong
mailing list for
Bettina Ketzmerick wrote:
> Hello,
>
> I want to install mysql on my sun (solaris 2.7). But I have a problem. The
> output after configuring is:
>
> loading cache ./config.cache
> checking host system type... sparc-sun-solaris2.7
> checking target system type... sparc-sun-solaris2.7
> checking
Can anyone tell me why I am receiving the following error? I am connecting
to a remote server via ssh, and accessed the mysql prompt by typing: mysql
The following is the screen contents after trying to use the ALTER
TABLE command; 'dbname' has been sub'd for actual database name.
Welco
At 20:25 2001-12-06 +0500, Igor Brynskich wrote:
allo
Is this product free like MYSQLfront?
If it is not free,
Can I considere it as a SPAM
(SPAM is a no sollocited commercial email)
on a Mailling List?
Ray
>Dear Sirs and Madams,
>
>EMS HiTech company is announcing the next version (1.22) of
Hello,
I want to install mysql on my sun (solaris 2.7). But I have a problem. The
output after configuring is:
loading cache ./config.cache
checking host system type... sparc-sun-solaris2.7
checking target system type... sparc-sun-solaris2.7
checking build system type... sparc-sun-solaris2.7
ch
> -Original Message-
> From: Barry Roomberg [mailto:[EMAIL PROTECTED]]
A few notes:
> 1) All data is readonly. No write requirement except
> monthly load.
use myisam pack to compress the data / indexs.
Also use -rq --analyse --sort-index as myisam arguments to rebuild the index
On Thursday 06 December 2001 03:50 am, Jeremy Zawodny wrote:
> Because it's not yet perfect. ?Perhaps someone at MySQL.com and update
> the filters a bit. ?Sasha, maybe?
It is important to understand that no bot could ever get it right in 100% of
the cases regardless of how sophisticated the rul
"DL Neil" <[EMAIL PROTECTED]> on 12/06/2001 12:26:45 AM
Internet mail from:
Please respond to "DL Neil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
cc: <[EMAIL PROTECTED]>
Subject: Re: select statement group by unusual results
Chip,
> > I have a database with 12 tables. I am running
I'm trying to determine the "correct" way of
dealing with a high availability situation,
which might also be a high performance (spread queries
across multiple systems) situation.
I've "googled" for MySQL cluster, and found one
project that last seems last touched a year ago.
1) All data is rea
Dear Sirs and Madams,
EMS HiTech company is announcing the next version (1.22) 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 1.22
On 6 Dec 2001, at 9:08, Chris Withers wrote:
> > database,sql,query,table
>
> Why does this list not include SELECT and INSERT?!
Worse, why do we have to put up with the filtering at all when it's
not doing its job? The Portuguese spam got through yesterday, but
legitimate messages are block
:Now, is there any way I can quickly return the length of the
:result set withotu
:actually returning the result set itself?
:
:
:Chris
:
:(MySQL question, obviously ;-)
Dunno if this was answered cause I'm on digest but,
Try SELECT Count(*) from...
erik
st.m
__
hi,
i just upgrade mysql to newer version 3.23.45 and now the slave that is
just upgraded (the master will be the next to be upgraded but in one
week) return such error:
011206 15:29:41 Slave thread: error connecting to master: Unknown MySQL
Server Host 'hostname' (0) (76), retry in 60 sec
i
Jeremy Zawodny writes:
>
> Ah, excellent.
>
> Do you know if he's one any benchmarks with it? Those machines tend
> to have great I/O systems, so I'd expect very good performance.
>
> Any chance I could get his e-mail address via private mail?
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PRO
1 - 100 of 141 matches
Mail list logo
