Title: ³×À̹ö ¸ÞÀÏ
¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
-
[EMAIL PROTECTED] wrote:
>
> [Image]
>
> ¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ
> ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
>
>
> ¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
>
> -
On Tue, Jan 22, 2002 at 01:07:09PM +0530, Chetan Lavti wrote:
> thanks again ,
>
> yes, I have seen that but isn't it MySQL's default feature.. I will
> explore it more and talk to you for further queries..
Hmm. Not sure what you mean. Every version of MySQL released in the
last couple years
thanks again ,
yes, I have seen that but isn't it MySQL's default feature..
I will explore it more and talk to you for further queries..
Thanks and regards,
Chetan
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 12:58 PM
To: Chetan La
Title: ³×À̹ö ¸ÞÀÏ
¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
-
Title: ³×À̹ö ¸ÞÀÏ
¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
-
On Tue, Jan 22, 2002 at 12:57:12PM +0530, Chetan Lavti wrote:
>
> Is there any other way (except query cache) using which the database
> can be made memory resident. Actually I want a database which is to
> be used by a lookup server(something like a dns server). The
> database lookup delay can
Hi
Try to check your query by this command
explain select * from holder, management where holder.id=management.id or
(holder.name=management.name and holder.surname=management.surname) order
by holder.no
and let take a look the result if they say the result come from ALL record
it mean you can'
Title: ³×À̹ö ¸ÞÀÏ
¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
-
Thanks for the quick reply.
I need some further inputs from you.
Is there any other way (except query cache) using which the database can
be made memory resident.
Actually I want a database which is to be used by a lookup
server(something like a dns server). The database lookup delay can
become a
Hi
You can use load_file() such as
sql="insert into xxx (fld_blob) values (load_file('xxx.jpg')"
Kittiphum Worachat ,MT.
www.hatyailab.com
> How can I insert a picture into blob field of a database?
>
> Thanks
>
> ST Ooi
> Malaysia
>
>
> ---
On Tue, Jan 22, 2002 at 12:30:56PM +0530, Chetan Lavti wrote:
>
> I am using (open source) MySQL-3.23.47, I wanted to know, is the
> feature of caching of the data in RAM is available in this version
> ?If yes , then what is the limit of that in terms of size. What I
> have Understood is that thi
Title: ³×À̹ö ¸ÞÀÏ
¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
-
Hello,
if get this, try install the _SAME_ package(rpm -i or rpm -Uv) a then
run rmp -e.
if above failed try manualy delete all files created by this rmp (rpm
-ql) and then run rpm -e --noscripts --notriggers --nodeps.
Michal aka Lampa
mysql, table, query
---
On Mon, Jan 21, 2002 at 05:18:35PM +0100, Roger Baklund wrote:
> Hi,
>
> Also, I wonder what is the best order for my primary keys:
>
> a intThis is the 'main' id, very many distinct values
> b tinyintThis is a source code, possible values are 1 or 2
> c smallint Some counter
> d t
hi,
I am using (open source) MySQL-3.23.47, I wanted to know, is the feature
of caching of the data in RAM is available in this version ?If yes ,
then what is the limit of that in terms of size. What I have Understood
is that this feature will be available with the version 4.0 and if so,
how thi
Title: ³×À̹ö ¸ÞÀÏ
¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
-
On Mon, Jan 21, 2002 at 06:32:28PM -0800, Eric Mayers wrote:
> I have a large amount of date that I need to select from in order to
> generate reports (might take 20 minutes). I also have data
> continuously being inserted.. I don't mind if the select results
> doesn't contain the recently added
On Tue, Jan 08, 2002 at 06:56:32PM -0600, John Raahauge wrote:
>
> Probably an allready asked question, but I couldn't find it
> anywhere.
>
> When is MySql 4.1 going to arrive ? I am really looking forward to
> Stored Procedures. It said somewhere December/January, but is that
> going to happen
On Mon, Jan 21, 2002 at 10:50:10PM +0200, Heikki Tuuri wrote:
>
> this is a known 'feature' which is also mentioned in the
> manual. SHOW TABLE STATUS will set an exclusive lock to the end of
> table to look at the current auto-inc column value, which SHOW TABLE
> STATUS has in its output. Since
On Mon, Jan 21, 2002 at 10:34:03PM -0500, Wendell Dingus wrote:
>
> I've tried this a bunch of times and different ways and can confirm
> that in the 3-server setup I described an alter table does NOT
> propogate. Can't see it in the binary log at all. No reference to
> the table name, nothing..
On Mon, Jan 21, 2002 at 11:02:47PM -0500, James Riordon wrote:
> Hi All,
>
> I have our new client up and running and have come upon another
> question. When I get extended-status I get the following:
>
> | Bytes_received | 53553199 |
> | Bytes_sent | 664736462 |
Hi,
Select person from persons as p, person_skills as ps
where p.personid = ps.person_id
And ps.skill_id in (id1,id2..);
Anvar.
At 09:40 PM 21/01/2002 -0500, you wrote:
>I have three tables as follows (simplified):
>
>persons (person_id,person)
>skills( skill_id,skill)
>person_skills( person_
How can I insert a picture into blob field of a database?
Thanks
ST Ooi
Malaysia
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To req
Hi,
I have problem with these query:
select * from holder, management where holder.id=management.id or
(holder.name=management.name and holder.surname=management.surname) order
by holder.no
It take a long time (more than 1 minute) with thousand record. I have
index wi
Hi All,
I have our new client up and running and have come upon another
question. When I get extended-status I get the following:
| Bytes_received | 53553199 |
| Bytes_sent | 664736462 |
If I am correct this mean about 664MB sent to the client from MySQL. The
Hi,
A compound index creates an index in the order specified. If
key is (a,b,c,d) then the index is in the order a,b,cd. That is
the index file keeps these columns ordered with a pointer to
the actual row in the data table.
Since b can have only two values, making it the first column in the
in
I have three tables as follows (simplified):
persons (person_id,person)
skills( skill_id,skill)
person_skills( person_id,skill_id)
A person can have one or more entries in the person_skills table, indicating
their skills.
I need to select persons where there skills match ALL skill_id's in a set
I've tried this a bunch of times and different ways and can confirm that in
the 3-server setup I described an alter table does NOT propogate. Can't see
it in the binary log at all. No reference to the table name, nothing..
Create table and drop table show up and propogate just fine... Just adding
Hi,
Having some problems with a particular BDB table, which crashes once in a
while. Just wondering if anyone has experienced such BDB table crashes?
The relevant info is included below for troubleshooting. Let me know if I
need to send anything else. Appreciate any help. Thanks!
>D
I have a large amount of date that I need to select from in order to
generate reports (might take 20 minutes). I also have data continuously
being inserted.. I don't mind if the select results doesn't contain the
recently added rows (or it can -- I don't care).
I've searched the archive and foun
Bob Hall wrote:
>>>We've requested a database from different companies, and specifically
>>>said we wanted MySQL or PostgreSQL because of the open source angle
>>>and we're a library.
>>>One company offered MS SQL as the platform and said that they can later on
>>>port it to MySQL. For this they
Probably an allready asked question, but I couldn't find it anywhere.
When is MySql 4.1 going to arrive ? I am really looking forward to Stored
Procedures. It said somewhere December/January, but is that going to happen
?
/John
--
3.23.43 master running on quadproc E450 solaris sparc 7, with following
du -sk in mysql data dir:
3504lsac1-0-s08-bin.001
1 lsac1-0-s08-bin.index
5 lsac1-0-s08.err
1 lsac1-0-s08.pid
2 my.cnf
68 mysql
166860 sc_metrics
78 scnet
7823shoutcast
569 shou
I am having trouble with this error:
"Found option without preceding group in config file: c:\WINNT\my.ini
line: 1 Program aborted"
Before this I got the infamous 1067 error where the service would go to
start on Win2000 and then stop unexpectedly.
Some background that will hopefully be helpful
I was trying to run the "run-all-tests" as suggested after finishing
installation. However I do no see this program and other related program
that mentioned in the README file in sql-bench directory except:
8 ChangeLog 16 README*
8 ./ 8 Comment
Hi,
Do anyone know whether 4.0.1 is better than the 3.23.47, eventhough
4.0.1 is not a stable version. Is 4.0.1 would do the same thing as the
3.23.47?
thanks
--rahad
-
Before posting, please check:
http://www.mysql.com/man
hi Jason,
Thanks so much for your help. but it only worked for "client" and "devel"
package. When I tried to uninstall the MySql Server package i get an error
message as
[root java]# rpm -qa | grep -i mysql
MySQL-3.23.47-1
[root java]# rpm -e MySQL-3.23.47-1
error reading information on service m
Hi,
I am a newby on MySql and more less a week ago I tried to install it on my
SuSE 7.1. I followed the instruction in the manual, but when I run the
command 'safe_mysqld --user=mysql &' the daemon mysqld didn't start. So I
tried with the command 'safe_mysqld --skip-grant-tables &' and the dae
On Mon, 2002-01-21 at 22:15, lawrence wrote:
> Support
> I am new to mySQL and would like to use the MySQLGUI .
> I can see the download page but are there any instructions for installing
> and setting the GUI up under windows 2000
get mysqlfront from mysqlfront.de it's IMHO better.
--
Henrik H
Egor Egorov <[EMAIL PROTECTED]> writes:
> Nasser,
>
> Friday, January 18, 2002, 12:01:02 PM, you wrote:
>
>
> NR> By the way I run my application which should run on MySQL, I get the error
> NR> message which includes that libmysqlclient.so.6
> NR> could not find!!!
> NR> What I have down wron
"Robert Cross" <[EMAIL PROTECTED]> writes:
> 2. Check what else the Suse system has installed and is running in the
> background. I've migrated my two systems,
> (Athlon-based 'base' station and PII/266 laptop) to Suse 7.3 from RH7.0,
> and there appears to be way more background
> systems runn
Jatin Nansi <[EMAIL PROTECTED]> writes:
> Hi list,
>
> I have 2 servers 1 running redhat 7.2 and the other running suse 7.3.
> the hardware config is :
>
> RH7.2: Fast desktop (IDE HDD/128 MB memory PIII 550 MHz).
> Suse 7.3: Low end server (Ultra SCSI 2, PIII 850 MHz, 256 MB RAM).
>
> Now i e
Hi Heikki and All,
Yes, it seems to be a cache problem, it happens to both MyISAM
and innodb table types but simply updating one row in the table maks
the error go away. The table names also seems to change (supporting
the cache idea) and it seems to be mostly readonly tables. Also it
only
Hello all,
Oops, I overlooked to change the my.cnf. All is working 100% Thank you.
However, please advise whether I can run 3.23 and 4.0.1 interchanging on
same data without putting the data at risk? BTW, I use InnoDb.
Kind regards
Emmanuel
> -Original Message-
> From: Emmanuel van
Hello Monty,
I downloaded and installed 4.0.1 for the SQL_CALC_FOUND_ROW option.
However, the query runs 600% longer, so the saving I get with FOUND_ROWS()
running in 0.0 secs does not serve me. Am I maybe doing something wrong?
Here is what I did;
I ran the query without SQL_CALC_FOUND_ROW an
> > We've requested a database from different companies, and specifically
> > said we wanted MySQL or PostgreSQL because of the open source angle
> > and we're a library.
> > One company offered MS SQL as the platform and said that they can later on
> > port it to MySQL. For this they wanted 18 00
Support
I am new to mySQL and would like to use the MySQLGUI .
I can see the download page but are there any instructions for installing
and setting the GUI up under windows 2000
Many thanks
Lawrence Wharton
-
Before posting, pl
On Monday 21 January 2002 04:09 pm, you wrote:
> hi,
> can some one tell me how to Uninstall MySQL3.23.47-1from linux machine.
> I installed it and it went all wrong, so i want to start over.
> thanks.
If you installed it using the binaries it's as simple as,
rpm -e
Do an 'rpm -qa | grep -i m
hi,
can some one tell me how to Uninstall MySQL3.23.47-1from linux machine.
I installed it and it went all wrong, so i want to start over.
thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
Hello all,
Could someone please advise what is further required to upgrade from
3.23.46 -> 4.0.01. Here are the steps I followed;
1. Download mysql-4.0.1-alpha-win.zip
2. unzipped
3. ran set-up & installed into d:\mysql-4.0.1\
4. start mysql-max with a bat file, maxstart and this is what ha
At 02:41 PM 1/21/2002 -0600, jon-david schlough wrote:
> >>yep. perl is all good - got activestate perl fer windoze and the
>dbi and the dbd - everything went fine as i went thru the tutorial in the
>manual...i was able to: perl -v and get the version info...
Great. So perl is in yo
Chris,
>Hi there,
>
>I've been experimenting with InnoDB and replication and now have a few
>questions...Firstly, is it a known bug that "SHOW TABLE STATUS" screws up
InnoDB
>transactions? To insert data into my innoDB table I've been using:
>set autocommit=0;
>INSERT ...
>INSERT ...
>...
>comm
Christopher Thompson wrote:
Have you installed perl? You need it (and the Perl MySQL drivers)
installed before you can benchmark.
>>yep. perl is all good - got activestate perl fer windoze and the
dbi and the dbd - everything went fine as i went thru the tutorial in the
manual...i w
Have you installed perl? You need it (and the Perl MySQL drivers)
installed before you can benchmark. Also, you'll want to modify the batch
files such that it uses a different user (possibly the root user if you
haven't changed the password on that yet).
Note that running the benchmark takes
greetings.
i am trying to use the benchmarking suite...got the perl dbi and dbd fine -
but:
C:\mysql\bench>run
C:\mysql\bench>\mysql\bin\mysqladmin refresh
\mysql\bin\mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'ODBC@localhost' (Using password: NO)'
C:\m
Another option might be ursql (http://www.urbanresearch.com/ursql). This
tool has the ability to generate MySQL-compatible CREATE TABLE scripts
from a connected MS Access database. Once the basic CREATE TABLE scripts
are generated, you can easily tweak the data types to your liking.
In my exper
>Description:
I think I just found a bug in mysql 3.23.41 (as shipped with
RedHat Linux 7.2 x86). I have a database "tcg" which contains
two tables: "edition" (3 columns, 1 primary key) and "card"
(several columns, about 6500 lines, 1 primary key). I just
st
Hi
Can someone please tell me how I apply a schema/or what the command is to a
mysql DB? I'm running my mysql server on a win2k platform if that helps.
Thanks
Peter
-
Before posting, please check:
http://www.mysql.com/man
I'm trying to do the same SELECT query in 3 tables. Those tables are
equal in structure and data but different in table type:
Table_orig - a big MyISAM table
Table_raid - RAID table (mysql compiled with --with-raid)
Table_merge - MERGE table
It all worked well, except for Table_merge: when i do
I too am researching how to do this. I've found plenty of products that will
do this, of course, I'd rather do it myself.
here's some links i've found:
http://www.convert-in.com/acc2sqlp.htm
http://ultradev.buzzinet.co.uk/mysql/tutorials/converting_data/index.asp
http://www.winmysql.com/
i hope
Title: ³×À̹ö ¸ÞÀÏ
¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
-
On Mon, Jan 21, 2002 at 10:14:42AM +0100, Myk Melez wrote:
> Jeremy Zawodny wrote:
>
> >On Fri, Jan 18, 2002 at 03:12:22PM +0100, Myk Melez wrote:
> >
> >>Is it possible to replicate between two databases on a single
> >>server, and if not, then what is the next best solution?
> >>
> >
> >It is p
Hello Brian,
Monday, January 21, 2002, 7:24:42 PM, you wrote:
BT> Hello. I recently installed MySQL and had a few questions
BT> in regard to the save directories. I see by default, MySQL
BT> saves the files in a /data/ folder on the main hard drive.
BT> What I am trying to
BT> setup is this:
I'm looking for a program, standalone, or web-based, to convert a current
access database to mysql. any hints?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
At 19:29 21/01/2002 +0100, e c h o p l u s A T w o r k wrote:
Hi!
Try to run the setup program from a DOS prompt:
setup -SMS
Regards,
Miguel
>Hi Victoria,
>
> >> echoplusAT> *I can't run a 16 bit program the file setup.exe is
>damage. Try to
> >> echoplusAT> reinstall* (!?!?!?)
> >>
> >
Hi Victoria,
>> echoplusAT> *I can't run a 16 bit program the file setup.exe is
damage. Try to
>> echoplusAT> reinstall* (!?!?!?)
>>
>> echoplusAT> I've never seen this error ... anyone can help me in order to
solve this
>> echoplusAT> prob?
>
> May be you have a corrupted installation packa
On Fri, 19 Jan 2001, Byron Albert wrote:
> Hello,
>
> I have a few questions. First I work on a very high traffic site that
> uses vbulletin 1.1 to run its bb. The bb is very high traffic around
> 60-200 concurrent users. We are starting to run into some serious
> locking issues, and I am t
[ filter fodder: mysql database - is this case-sensitive?]
Erv Young wrote:
> It seems to me that if AOL Time Warner had not only Netscape, but also
> the whole Linux-Apach-MySQL-PHP brigade in their hands, they would
> indeed have a powerful armamentarium for challenging Microsoft.
>
> I am
Hello e,
Monday, January 21, 2002, 5:20:39 PM, you wrote:
echoplusAT> Hi,
echoplusAT> I've a problem in order to install Mysql server 3.23.47 on NT 4 box
echoplusAT> when I try to run the file setup.exe, I get an error msg like this:
echoplusAT> *I can't run a 16 bit program the file s
Hello all,
When downloading the pdf manual, I do not get sections;
6.9.1 How The Query Cache Operates
6.3.6.2 Miscellaneous Functions (or there is a 6.3.5.2 Miscellaneous
Functions) but its different)
Could someone please advise how the manual sections obtained by serching on
topics and the dow
>
> Hi Brett and Monty,
>I think I can provide some advice here. I have been meaning to
> help and update the manual but I am not good at documentation! First,
> there are bugs on BSDi 4.1 in the threads library that cause crashes,
> they MUST be patched in order to run a stable server. Thi
Hi!
On Jan 21, Steve Rapaport wrote:
> Okay, does anyone know how long this will take?
> 22 million records, fulltext index on a single field, first 40 chars.
> record length 768 chars, variable.
>
> It's been running for 2 days, processlist quotes time at around 10.
> Index file still growi
Hello. I recently installed MySQL and had a few questions in regard to the save
directories. I see by default, MySQL saves the files in a /data/ folder on the main
hard drive. What I am trying to setup is this: I have two hard drives on my computer.
One is the main one where server installation
Everton,
Monday, January 21, 2002, 6:59:39 AM, you wrote:
EBY> i'm running a sql query from a php page:
EBY> if($DEl && $cid && $sid && $did) {
EBY> $d0->query("SELECT id FROM crd_favorites WHERE did='$did' AND
EBY> uid='$uid'");
EBY> if($d0->num_rows()<1) {
EBY>
Hello Patrick,
Monday, January 21, 2002, 4:20:29 PM, you wrote:
PS> I created the base PERSONAL.
PS> Now I want to give permission to a user to create table, drop table and
PS> everything!
PS> Does anybody could help me, please?
GRANT and REVOKE can help you to manage permissions for a user.
Erv,
Monday, January 21, 2002, 5:56:01 AM, you wrote:
EY> I have searched the online manual in vain for mySQL system
EY> requirements. Can anyone give me the precise URL? Is there one?
Take a look at:
http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#Table_size
If
Noah,
Sunday, January 20, 2002, 1:55:00 AM, you wrote:
NS> The problem is that 20,000 tables can be a bit unwieldy for mysql to
NS> handle.
I don't think it will be a sore work for MySQL to support more than 20,000
tables, but it's up to a inode limit on the filesystem on your OS.
As Russel K
Monday, January 21, 2002, 11:46:19 AM, you wrote:
TI> I tried to set the root password in the mysql db;
TI> update user set Password='password' where User='root';
TI> So, it has set the passwords and then I made a
TI> flush privileges;
TI> I don't understand. What's wrong with this?
The correct
JC> Pretty much as the subject states, I am not a member of this list yet, as I
JC> am sure my mail server cant handle the amont of messeges that come through
JC> so please reply directly at [EMAIL PROTECTED]
JC> I need to limit the max size of a database in MySql that is created for a
JC> user o
-Original Message-
From: Bret Ewin [mailto:[EMAIL PROTECTED]]On Behalf Of Bret Ewin
Sent: Monday, January 21, 2002 12:03 PM
To: 'Russell King'
Subject: RE: Help with Database structure..
You may also want to break the URL into pieces (protocol, domain, path,
file) and index each piece.
I don't seem to be able to connect to MySQL from behind the AnalogX
proxy.
Any help will be appreciated.
TIA,
laszlo
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi there,
I've been experimenting with InnoDB and replication and now have a few
questions...
Firstly, is it a known bug that "SHOW TABLE STATUS" screws up InnoDB
transactions? To insert data into my innoDB table I've been using:
set autocommit=0;
INSERT ...
INSERT ...
...
commit;
In total
> "Therefore, to use BDB or InnoDB, you must"
For InnoDB, get or build the Mysql-MAX distribution of the MySQL Server-- if
you are using RPMs, this just means installing the one MAX rpm and you will
have InnoDB capability in addition to the standard MyISAM.
c
--
Chris Lott
http://www.chrislo
Bonjour Christophe,
> I have a 200Mhz + 64 mo + 2Go
>
> I want install php + mysql + apache => easyPhp
>
> But what is better ? Windows ( which?) or Linux ( which?)
NB I have re-attached the MySQL list address, because I think others will be able to
offer better advice than
can I. Has anyone c
Hi,
I have some compound primary keys, all integer fields (a,b,c,d). In one
table we have by mistake made the key (b,a,c,d). We allways use at least
field a and field b in all lookups, and it seems to be working, but I wanted
to ask: does it matter? Should we change the 'wrong' primary key to
(a,
Is this variable linked to some functionalities which are not in every mysql
distribution?
But, anyway, the my.cnf file gives you some guidelines where to put what.
-Original Message-
From: Frederic Hecq [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 21, 2002 4:51 PM
To: Achim, Cateri
Hi Erv,
Hi Erv,
You can check www.innodb.com.
Caterina
-Original Message-
From: Erv Young [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 21, 2002 4:44 PM
To: [EMAIL PROTECTED]
Subject: How to get BDB or InnoDB
In the manual at http://www.mysql.com/doc/N/e/News-3.23.x.html, immedia
But that variable isn't there in the first place :-)
Should I just add it then?
(under the [mysqld] section?)
> -Original Message-
> From: Achim, Caterina [mailto:[EMAIL PROTECTED]]
> Sent: maandag 21 januari 2002 16:49
> To: 'Frederic Hecq'; Achim, Caterina; [EMAIL PROTECTED]
> Subject:
I think it would be better to copy all the content and uncomment the
variable you need.
-Original Message-
From: Frederic Hecq [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 21, 2002 4:42 PM
To: Achim, Caterina; [EMAIL PROTECTED]
Subject: RE: mysql: ft_min_wod_length
One more question
One more question,
When I copy my-medium.cnf to my.cnf, should I include all that is inside? Or
just the set-variable that I want?
(basically, have only one line in my.cnf, or leave the existing config
unchanged?)
Frederic
> -Original Message-
> From: Achim, Caterina [mailto:[EMAIL P
In the manual at http://www.mysql.com/doc/N/e/News-3.23.x.html, immediately
after introducing MyISAM, BDB, and InnoDB, it says:
"Note that only MyISAM is available in the standard binary distribution."
This assumes that I am able to complete the necessary next sentence:
"Therefore, to use BDB
Hi Brett and Monty,
I think I can provide some advice here. I have been meaning to
help and update the manual but I am not good at documentation! First,
there are bugs on BSDi 4.1 in the threads library that cause crashes,
they MUST be patched in order to run a stable server. This fixes the
c
I forgot to cc the lists...
-Original Message-
From: Achim, Caterina
Sent: Monday, January 21, 2002 4:21 PM
To: 'Frederic Hecq'
Subject: RE: mysql: ft_min_wod_length
As far as I know, mysql will look for this file first in /etc and then in
/usr/local/mysql/var (or where your var direct
Hello Caterina,
I use Redhat 6.2
So in the same path as these three files, I make a forth one? e.g.
"my-veryown.cnf"
How does the system know that it has to use that particular file?
Will MySQL start up with that file automatically then?
Please let me know,
Thanks
Frederic
> -Original M
[EMAIL PROTECTED] writes:
> Dear Sirs and Madams,
> I have installed mysqlgui-static on my PC. Please let me know how to start it, so
>that I can use it.
> 2. Have you or anyone else developed any utility to make it easy to populate the
>tables? The default method is too cumbersome. If so, kindl
You did not properly invoke the PASSWORD() function:
UPDATE user SET password=PASSWORD('somepass') WHERE user='root';
On Mon, 21 Jan 2002 11:04:57 +0100, Aleksandar Bradaric wrote:
>Hi,
>
>> I tried to set the root password in the mysql db;
>> update user set Password='password' where User='ro
Hi,
I've a problem in order to install Mysql server 3.23.47 on NT 4 box
when I try to run the file setup.exe, I get an error msg like this:
*I can't run a 16 bit program the file setup.exe is damage. Try to
reinstall* (!?!?!?)
I've never seen this error ... anyone can help me in order t
Frederic,
you should have 3 files (my-small.cnf, my-medium.cnf, my-large.cnf) -
depends what OS you use. You can copy one of this files and uncomment there
what configuration you'd like to have.
Caterina
-Original Message-
From: Frederic Hecq [mailto:[EMAIL PROTECTED]]
Sent: Monday, Jan
I have to agree with the below. Clearly they want to get you into mssql
and keep you there. There's really no point in switching databases, so
(I know, this is too neutral) if you like these guys for some reason
(good haircuts or whatnot), then go with mssql. If you can find people
with good ha
1 - 100 of 127 matches
Mail list logo
