Hello,
Sorry for the OT,.. but I was hoping someone may suggest a script that can
monitor multiple mysql servers. We have two running and I would like to setup a
cron to check the servers once an hour or so to make sure it running and if not,
it would be capable of restart the server
I installed Slackware 8.0 and used its pkgtool to install MySQL. After
running mysql_install_db which seems to be ok, I tried starting safe_mysql
which didn't work. No sinifiant error message was shown, so I tried
mysql.server start which also didn't work. After all this, I tried starting
via
#
On Fri, 2001-12-14 at 04:14, Peter Lovatt wrote:
Hi
I am retrieving data from a mysql table and displaying the contents in a
text box for editing.
Some of the data contains double quotes eg '15 screen'. Using php4 the data
is backslashed and stores without any problem, but when it is
* Quentin Bennett
For those that silently follow these more unusual threads, what was the
cause?
It was a bug, and it is fixed:
* Monty:
I have now fixed this; It will be in MySQL 3.23.47 and 4.0.1.
--
Roger
-
Before
Hello
I am from Hong Kong
I face an problem when I am installing the latest version of mysql
(mysql-3.23.46.tar.gz)
I have followed the manual and when I try the step
shell ./configure --prefix=/usr/local/mysql
I think I can do some and some are not
And I have doen the next step
shell make
Hi,
I am having problems loading data into a table and have 2 questions.
1)
I want to load some data from a text file in to a table by using the
following line:
LOAD DATA LOCAL INTO st.txt INTO TABLE studio;
this keeps giving me : File st.txt not found (ErrorCode: 2)
Where should I store the
I am currently trying to optimize the indexes / keys for the MySQL
schema of phpOpenTracker.
I'm wondering if multiple keys, like
CREATE TABLE pot_accesslog (
accesslog_id int(10) unsigned NOT NULL,
client_idint(10) unsigned NOT NULL,
document_id int(11)
Your cron line:
0 * * * * /home/you/mysqlcheck
Or if it's in /etc/crontab
0 * * * * root /home/you/mysqlcheck
And the script:
#!/bin/sh
# on error send e-mail to
#
adminmail=[EMAIL PROTECTED]
# or /usr/bin/safe_mysqld, etc.
#
restartCommand=/etc/rc.d/init.d/mysqld start
if [ ! `ps
--
From: Harry Munns [EMAIL PROTECTED]
Date: Sat, 15 Dec 2001 09:12:52 -0800
To: [EMAIL PROTECTED]
Subject: Error E2008, E2028
I have a remote user who's trying to use jdbc to connect to my MySql server.
I'm running Redhat Linux 7.2. He has all hosts set up with his user name
and
On Fri, 14 Dec 2001, Dan Hatchen wrote:
I have a SCO 5.0.4 system with most of the contents of the Skunkware
2000 CD (FSU Threads, GNU development tools), as well as, the official
patches from SCO/Caldera. I have the SCO Development System installed
but not licensed, so the includes and
subject: PCAnywhere like linux client - mysql data files administration
Hi,
I remember seeing a program awhile back that acts like pcanywhere or
terminal services, to connect to a linux or windows box. Anyone remember the
name?
Thanks,
Jack
i believe your talking about VNC.
http://www.uk.research.att.com/vnc/
Jack A. Fobel wrote:
subject: PCAnywhere like linux client - mysql data files administration
Hi,
I remember seeing a program awhile back that acts like pcanywhere or
terminal services, to connect to a linux or
Hi there,
this piece of software you re talking about could be VNC. You do not even
need a client. If you use a java compatible browser you can use the
terminal directly from your browser. Don t have the link on the hand, but
if you look into a search engine you should be able to find a
Hi,
I know that mysql can reference var into sql statement, I think like
@var, i cant retrieve this info.
.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
MySQL full text indexing looks attractive, but I'm puzzled as to how to
use it
for my application.
I'm storing documents that I'd like to be full-text indexed, but each
document can have multiple revisions. I'm currently storing each
revision in full. The fulltext relevance criteria don't work
Hi -
I had a nagging feeling that there was a better solution to this than
the temporary table-based solutions I saw; I created a table 'test'
with the data you have below, and played with queries a bit. I came
up with this, seems to work:
select
Hi,
I have compiled and installed as root mysql succesfully. I gave ownership of
the install to my dba account and group. when I do a mysql connect local as
the dba account I get a permission denied. Why is this and where are the
actual tables and data held.
Thanks,
Matt.
Hi!
On Dec 15, Bob Sidebotham wrote:
MySQL full text indexing looks attractive, but I'm puzzled as to how to
use it
for my application.
I'm storing documents that I'd like to be full-text indexed, but each
document can have multiple revisions. I'm currently storing each
revision in full.
set @precprest='';
select cmd.no_client,cmd.no_cmd,
@i:=@i+1,@precprest:=cmd.no_prest as b, if(@i1,0,1)
from
I can make a variable depending on the row because
@i:=@i+1 dispaly 1,2,3
but if(@i1,0,1) is always 1 the value at the end of the thread.
Can make an something to memorize the
Here is a problem I haven't been able to solve:
I have a table with a index on a column (e.g. code).
When I want to look for the code after (for
instance) I do:
select MIN(code) from table where code
This will be very fast (one value only is checked).
But when I want to llok for the
At 16:57 15/12/2001 -0500, Gary Wheeler wrote:
Hi,
shell BINDIR/safe_mysqld --skip-grant-tables
shell BINDIR/mysql -u root mysql
Make sure you run mysqladmin flush-privileges or mysqladmin reload
afterward to tell the server to reload the grant tables.
Regards,
Miguel
Hi All,
I've done a
Thanks for the note, Sergei. I admit to being confused by the
documentation on boolean search. In particular, exactly what the problem
domain for the two algorithms is supposed to be (and how relevancy is
computed with boolean search). I don't understand why boolean search has
(it seems) a
set @i=0;
set @precprest='';
select cmd.no_client,cmd.no_cmd,cmd.no_prest,eye.libelle,hair.libelle,
@precprest as b,if(@i=0,0,@precprest:=cmd.no_prest),@i:=@i+1
It s like if the if was evaluate one time.
To: [EMAIL PROTECTED]
Sent: Saturday, December 15, 2001 10:16 PM
Subject: Re: how to make a
I have a remote user who's trying to use jdbc to connect to my MySql server.
I'm running Redhat Linux 7.2. He has all hosts set up with his user name
and password. I also tried setting his host up as a host and it made no
difference. Here's the message.
E2008 Error receiving initial from
Gary Wheeler wrote:
I've done a fool thing and changed the root password to mysql server, and
evidently miss typed, because now it will not let me in. How can I get back
into mysql to change this?? Please help as this is a production server!!
See the standard documentation page at
Hi All,
I've done a fool thing and changed the root password to mysql server, and
evidently miss typed, because now it will not let me in. How can I get back
into mysql to change this?? Please help as this is a production server!!
Thanks,
Gary
Hi!
On Dec 15, Bob Sidebotham wrote:
Thanks for the note, Sergei. I admit to being confused by the
documentation on boolean search. In particular, exactly what the problem
domain for the two algorithms is supposed to be (and how relevancy is
computed with boolean search). I don't understand
Hi
I'll be working on a shopping site project which involves a complex pricing
model with discounts by product quantity threshold, product range as well as
customer specific pricing.
Has anyone got experience of this or point me in the right
direction/articles regarding the database layout and
X-obligatory-filter-fodder: database,sql,query,table
Joe Ellis wrote:
i believe your talking about VNC.
http://www.uk.research.att.com/vnc/
Jack A. Fobel wrote:
I remember seeing a program awhile back that acts like pcanywhere or
terminal services, to connect to a linux or windows
29 matches
Mail list logo