Sinisa Milivojevic wrote:
Jörgen Winqvist writes:
I run RH supported kernel 2.4.7-10enterprise on such a server with
similar problems. All four CPU's runs off with a lot off system. I can
provoke this behaviour by generating disk i/o. A 'cp' might be it. I
often get it when the full backup
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 possible, yes.
Is there any way to do it with a single instance of MySQL (replicating
Hi,
I tried to set the root password in the mysql db;
update user set Password='password' where User='root';
The user table looks like this;
| localhost | root | password | Y | Y
| Y
| Y | Y | Y | Y | Y
| Y
| Y
Hi,
I tried to set the root password in the mysql db;
update user set Password='password' where User='root';
MySQL encrypts passwords, so your update statement is
useless. Try using GRANT... :)
Regards,
Sasa
-
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 000 euro. Now,
At 22:14 19/01/2002 +0200, Saulius Kavoliunas wrote:
Hello mysql,
I have a problem with starting mysql, I'm using winXP and when I try
to start mysql on administrative tools\services I get a box with an
error 1067, nothing else is written :(, what is the problem can you
suggest me
Hello,
I'm experience the same problem. I use a query like this:
SELECT publ,fak,id,COUNT(*) FROM ftxt_stat WHERE year LIKE '2001' AND
month LIKE 'Oct' GROUP BY publ,fak,id;
If I remove COUNT(*) I don't get the error.
The table I use look like this:
CREATE TABLE ftxt_stat (
year
Hi
I want to secure our MySQL DB as much as possible.
In the freshly installed DB I have found two records in
the mysql.user which has no value in the User and
Password field;
--+---++-+++
| Host | User | Password |
Hi all,
I need to save my database (comma separated)in file which i can do by
mysql..admin commandnow what i want to do is that this file gets
auto-emailed once a week to the concerned personthe site that uses mysql
is hosted on a linux machine.
I can add a process that does the above
Hello again,
ERROR 1169: Can't write, because of unique constraint, to table
is a bug that have been fixed in release 3.23.44, look at the page
http://www.mysql.com/doc/N/e/News-3.23.44.html .
/Johan
-
Before posting,
I need to save my database (comma separated)in file which i can do by
mysql..admin commandnow what i want to do is that this file gets
auto-emailed once a week to the concerned personthe site that uses
mysql
is hosted on a linux machine.
I can add a process that does the above in
Jatin Nansi wrote:
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 expect to see the suse server go faster than RH,
Goodday, I have been able to successfully install
Apache, Php and, MySQL in windows environment. But now i want to do the same in linux,
I'm using slackware8, and I installed apache, and php first I tested it and it run
fine, then i started to install mysql package, the one included in my
and it comleted without any errors and warnings. But when i tried to run
# mysql
or
#safe_mysqld
I get this message...
ERROR 2002: Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (111)
then when i check my /var/lib/mysql/myhostname.err is see the
On Sat, 19 Jan 2002 23:03:38 -0800
Jeremy Zawodny [EMAIL PROTECTED] wrote:
I'm working on the section of my book which deals with MySQL
configuration. Since my goal is to cover *at least* MySQL 4.0
(possibly 4.1 if I'm too slow), I need to make sure that I cover
things on the 4.0 TODO list.
Hi All,
I have been running MySQL 4.0.1 on Linux (RedHat 7.x) very
successfully. Now I am migrating onto OS X and manage to get the MySQL
installed and default databases created by the configuration scripts coming
with the download. However, every time mysqld is started, it just shutdown
kathalead1,
Sunday, January 20, 2002, 11:35:42 PM, you wrote:
k I have installed mysqlgui-static on my PC. Please let me know how to start it, so
that I can use it.
For which OS?
k 2. Have you or anyone else developed any utility to make it easy to
k populate the tables? The default method
Attila,
Sunday, January 20, 2002, 4:59:14 AM, you wrote:
AS I have a new dual cpu server with debian 2.2.19 smp kernel
AS and with 1G ram.
AS my question is: need i apply the threads-patch or the fork-patch
AS from mysql manual 2.6.1 before i compile my kernel and
AS the mysql source? (i use
Joe,
Sunday, January 20, 2002, 8:47:12 AM, you wrote:
JB Here is the problem. Normally I type mysql at the command line and get the
JB mysql promt. On some of my servers I use mysql -p database and then enter
JB the password and get the prompt.
JB On this new installation when I type mysql
Shinta,
Monday, January 21, 2002, 3:03:18 PM, you wrote:
SHL Goodday, I have been able to successfully install
SHL Apache, Php and, MySQL in windows environment. But now i want to do
SHL the same in linux, I'm using slackware8, and I
SHL installed apache, and php first I tested it and it run
Hello Takacs,
Monday, January 21, 2002, 1:42:06 PM, you wrote:
TI I want to secure our MySQL DB as much as possible.
TI In the freshly installed DB I have found two records in
TI the mysql.user which has no value in the User and
TI Password field;
TI
Catalin,
Monday, January 21, 2002, 7:25:30 PM, you wrote:
C does anybody knows an good ODBC like mysql driver for an java
C application on an win2k proffessiona OS?
Take a look at:
http://swfaq.mysql.com/sw/bin/17/supportwizard.cgi/60875095
C thanks!
--
For technical support contracts,
Hello everyone,
I run mysql server (3.23.43-nt) on win2k. I have a problem when I try to load a file
into a blob column from a mounted via SMB unix filesystem.
I can create and access those files with other programs from the NT box.
Any ideas how to trace the problem? I get no error and
I created the base PERSONAL.
Now I want to give permission to a user to create table, drop table and
everything!
Does anybody could help me, please?
Thanks
--
Patrick Santana
TAU CSI
[EMAIL PROTECTED]
Phone: 55 19 32514001
Mobile: 55 19 91223757
Particularly given MySQL AB's comments in 2.2.2 Operating Systems Supported by MySQL.
=dn
Jatin Nansi wrote:
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
This doesn't make much sense for the RH system to
be that much faster than the SUSE system. There are
a few things that do come to mind when I think about
this:
1) GLIBC Version on RH and SUSE
2) Is mysqld stripped?
3) Are the same compile options used?
4) Kernel Version
Usually, Linux systems
Hello
I'm looking to set ft_min_wod_length to 3,
but I can't find the my.cnf file.
I did find a my.conf file, but it's empty.
So I tried it there, but when I (after restarting MySQL) did show
variables, it still wasn't in there...
Can anyone help me with this?
Thanks
Frederic
Frederic
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
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,
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
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='root';
[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, kindly
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
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
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
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 or
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
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
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: RE:
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,
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,
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
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
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
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
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/
-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
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 on a
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
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
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
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.
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. 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
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 growing
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
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
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
[ 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 not
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
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 package. Try to
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* (!?!?!?)
echoplusAT
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/
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
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 possible, yes.
Is
Title: ³×À̹ö ¸ÞÀÏ
¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ Re: replication between two databases on single server?
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã
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
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
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:
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
greetings.
i am trying to use the benchmarking suite...got the perl dbi and dbd fine -
but:
C:\mysql\benchrun
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)'
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
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 was able
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 ...
...
commit;
In
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 your path? I
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
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
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 package-name
Do an 'rpm -qa |
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,
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 000 euro.
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
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
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
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 expect to
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 running on
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 wrong?
How did
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
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
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
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:
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
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
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
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
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 wanted 18 000
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
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!
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
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
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
1 - 100 of 125 matches
Mail list logo