On Sat, 9 Nov 2002, Jack Chen wrote:
I have just figured out:
kill -9 xxx (process number)
Hi!
Did you try just 'kill xxx'? How about 'mysqladmin shutdown'? 'kill -9' is
an extremely cruel way to bring a server down. You may get corrupted
databases that way, although sometimes it's the only
Greeting to all. Here is some data on my server :
[student:99] /usr/local/bin mysqladmin -u root -p version
9:18
Enter password: ***
mysqladmin Ver 8.23 Distrib 3.23.52, for hp-hpux11.00 on hppa2.0w
Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB
This software comes with
b4712.xici.net
ÓʼþÄÚÈÝÓëÒÔÏÂÎÄ×ÖÎÞ¹Ø=
ÓÅÁªÍøÂç http://www.chinamysql.com רҵÌṩ¸÷ÀàÐéÄâÖ÷»ú£¬²»ÂúÒâ¿É»ñÍË¿î¡£
Ç¿ÊÆÌײͣº100MÖ÷»úËͶ¥¼¶ÓòÃû£¬ËÍ10¸ö10MÆóÒµÓÍÏ䣬¼ÓËÍ20¸ö¶þ¼¶ÓòÃû£¬½öÐè318Ôª/Ä꣡
ÈýÁú֤ȯͶ×Ê http://3long.sayba.com
On mysql 4,0,4 running under W2K SP3, when I run the command SLAVE STOP; the
command it is not execute and it remain pending (the prompt of mysql doesn't
return); instead all is normal under 3.53.
Which is the problem ?
tks regards
-
I use navicat http://www.mysqlstudio.com/.
ing. stefano scattini
-Messaggio originale-
Da: tmb [mailto:topmailbox;yahoo.com]
Inviato: venerdì 8 novembre 2002 13.18
A: [EMAIL PROTECTED]
Oggetto: How to port MS Access to MySQL ??
Is there a tool for doing a quick port from MS Access
to
Greetings
I have problems executing very simple UPDATE query. I do not know whether it
is a bug or not, but it works in Access and also works with mySQL, but only
from access using linked tables.
Query is as followes:
UPDATE Table_name SET Field_name = Left(Field_name, 4) 'a'
Right(Field_name,
Hi,
If you really wish to kill the mysql daemon in this way :
You should try :
ps -ef |grep mysql
...show all the mysqld processes and after this must enumarate all pid of
processes in a single kill command.
E.g.
kill -9 1024 1056 ...(processes which are open).
But it's more health if you can stop
Hi,
Why not trying killall -9 mysqld ?
Regards,
Jocelyn
- Original Message -
From: Gelu Gogancea [EMAIL PROTECTED]
To: Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, November 09, 2002 12:08 PM
Subject: Re: mysqld refuse to die
Hi,
If you really wish to kill the
...because not all mysql processes are named mysql and is one (and you
know about this) which is for safe running(mysqld_safe or safe_mysqld) which
create new threads when another is killed.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent
just kill mysqld_safe and then the mysqld process :)
(but AFAIK all the mysql thread are names mysqld ??)
- Original Message -
From: Gelu Gogancea [EMAIL PROTECTED]
To: Jocelyn Fournier [EMAIL PROTECTED]; Jack Chen [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Saturday, November 09, 2002
Hi can anybody tell me how can i insert rtf data in my sql, since it
contains escape characters
like this
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0
Verdana;}{\f1\fnil\fcharset2 Webdings;}{\f2\fnil\fcharset0 MS Sans Serif;}}
{\colortbl
Yes.All processes are named mysqld...less one mysqld_safe which is main
guilty for keeping mysql daemon in life.
P.S.
Please tell me (if you wish)...what means AFAIK?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL
As Far As I Know
-Original Message-
From: Gelu Gogancea [mailto:ggelu;arctic.ro]
Sent: Saturday, 9 November 2002 23:37
To: Jocelyn Fournier; Jack Chen; [EMAIL PROTECTED]
Subject: Re: mysqld refuse to die
Yes.All processes are named mysqld...less one mysqld_safe
which is main
Also
In My Humble Opinion (IMHO)
For What It's Worth (FWIW)
-Original Message-
From: Gelu Gogancea [mailto:ggelu;arctic.ro]
Sent: Saturday, 9 November 2002 23:37
To: Jocelyn Fournier; Jack Chen; [EMAIL PROTECTED]
Subject: Re: mysqld refuse to die
Yes.All processes are named
Looks as if security got tightened and now next to no databases with
Web/php are geting accessed. What needs to be fixed?
Customers are yelling.
Rectification needed ASAP!
forwarded message --
Hi ,
I corrected the core mysql tables (there was nothing in them)
Your root password for
Eugene,
Saturday, November 09, 2002, 1:33:39 AM, you wrote:
EB May be this was reported already.
EB I have windows 2000 using mysql version 4.0.3-beta-nt
EB When I ran a query like
EB select distinct a.* from tasks a, gnrlasoc b;
EB mysqld-nt.exe crashes.
EB I know this query makes no sense
SpyProductions,
Friday, November 08, 2002, 10:50:33 PM, you wrote:
SST Well hells bells!
SST Would that be the 'Client programs (i386) (2.3M)' mentioned on the download
SST page? :)
Yes.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by
Daya,
Saturday, November 09, 2002, 2:28:07 PM, you wrote:
DKD Hi can anybody tell me how can i insert rtf data in my sql, since it
DKD contains escape characters
DKD like this
DKD {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0
DKD Verdana;}{\f1\fnil\fcharset2
Beauford,
Saturday, November 09, 2002, 8:27:58 AM, you wrote:
B I just reinstalled Slackware and now have the unenviable task of getting
B Mysql working. What a major pain in the ***. Anyway, here are the
B errors. I have read manuals, searched the web, as well as the
B newsgroups, and still
Thanks you all for your nice suggestions. The thing is, for some reason, I
could not stop the mysqld using 'mysqld stop'. Any insight about why this
would fail?
Another question, which might not be a *pure* mysql one, is: I ran a
script to load my mysql database, but it has not finished the job
since my of my customers are reporting that they are getting:
Search Results for 'T5Y1M4'
Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)No results were
found for 'T5Y1M4'.
Searching again for the two-digit postal code 'T5'.
WHAT must I do to correct his??
On Sat, Nov 09,
create the users again or whatever you had before.
Thomas
On Sat, 9 Nov 2002 09:38:32 -0700 System Administrator a.k.a. The Root of the
Problem [EMAIL PROTECTED] wrote:
since my of my customers are reporting that they are getting:
Search Results for 'T5Y1M4'
Access denied for user:
Hi,
What error you get when try to stop mysql daemon ?..or tell us what is in
mysqld.log?
Maybe we can help you.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
On 11/9/02 3:01 AM, Bruno Batarelo [EMAIL PROTECTED] wrote:
Greetings
I have problems executing very simple UPDATE query. I do not know whether it
is a bug or not, but it works in Access and also works with mySQL, but only
from access using linked tables.
Query is as followes:
UPDATE
MySQL must be the owner of the data dir. Check the owner of MySQL data
dir.
It was, but I have since changed it to root and it works fine now. Any
idea why this would be?
drwxr-xr-x 12 root mysql4096 Nov 8 18:00 ./
drwxr-xr-x 15 root root 4096 Nov 8 20:12 ../
I dont have a my.cnf file, so I touched /etc/my.conf still doesnt
work. Where do
I find a .cnf file to copy over?
and
root@rock:/var/run/mysql# ls
mysql.sock= it exists.
What could my problem be..? I even upgraded. I am using Slackware 8.1
with 2.4.19 kernel. Maybe that will help.
Thanks so
Ok.. I got the /etc/my.cnf under control, but now when I do this:
root@rock:/etc# mysqladmin -u root -h rock password *
mysqladmin: connect to server at 'rock' failed
error: 'Host 'rock.biohazard.org' is not allowed to connect to this
MySQL server'
Then I tried this:
root@rock:/etc#
On Sat, 2002-11-09 at 14:45, john wrote:
Ok.. I got the /etc/my.cnf under control, but now when I do this:
root@rock:/etc# mysqladmin -u root -h rock password *
mysqladmin: connect to server at 'rock' failed
error: 'Host 'rock.biohazard.org' is not allowed to connect to this
MySQL
OK, I lost my password. Snicker away.
I tried using the instructions I found in the MySQL manual and got hung
up on starting the MySQL server in an unsecured state. The instructions
say to start mysqld with the --skip-grant-tables option. When I do I
get a Fatal Error: Please read Security
sql, query ... just to make the filter happy.
on 11/8/02 2:30 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED]
wrote:
You are missing something, I am afraid. To quite Sun's Javadoc for the
PooledConnection class
Thank you so much for the quick reply.
Now I understand why the implementation of
hello everyone:
to begin with, I apologise for asking a question which is probably
obvious. My name is Emilio Pisanty and I and one of the two makers of my
school's website. recently we updated the database system (on mysql) from
version 3.23 to version 4. since then, any attmepts we've made
On 11/9/02 3:14 PM, 3mip1s4la-Emilio Pisanty [EMAIL PROTECTED]
wrote:
hello everyone:
to begin with, I apologise for asking a question which is probably
obvious. My name is Emilio Pisanty and I and one of the two makers of my
school's website. recently we updated the database system (on
tables have met with a 1175 error (You are using safe update mode and you
tried to update a table without a WHERE that uses a KEY column).
Nothing is obvious and is hard to advise you if you don't give us some more
info on the table structure and the update query you have trouble with.
Hi,
I don't see any group column in your table, are you displaying the right
table (describe pupils; instead of describe pupuils; ?).
A KEY column is a column which have an INDEX on it.
Regards,
Jocelyn
- Original Message -
From: 3mip1s4la-Emilio Pisanty [EMAIL PROTECTED]
To: R. Hannes
On Sat, 2002-11-09 at 19:34, 3mip1s4la-Emilio Pisanty wrote:
tables have met with a 1175 error (You are using safe update mode and you
tried to update a table without a WHERE that uses a KEY column).
Nothing is obvious and is hard to advise you if you don't give us some more
info on
Every SQL database requires the ability to locate a record which is unique
in some way. You can't have two records which look the same.
That's why you need to define a primary KEY on a column or coumns.
You need to read a primer on SQL databases
Alan
-Original Message-
From:
hello everyone:
1) in my school groups are called forms, so I used it not to confuse you
2) I hadn't learnt how to define indexes on MySQL so I hadn't defined any
3) now I have, and...
4) the query worked.
thanks for your help,
Emilio Pisanty
Hello all!
I am working on a site which is using mod_perl and a mysql database on
Linux with Apache. I am also putting cookies and user address information
into a cookies table to fill up form fields for subsequent visits.
Standard enough. Also, the database is on the same server as apache.
Now,
You don't *need* a primary key on a table. You don't a key on a table
at all, if that's what you want.
You can turn off this error message without altering your table by
specifying --safe-updates=0 when you start the mysql client. This
option apparently is turned on by default in 4.x. The
although i make a living from their products and
corereader runs under windows, i really really
hate to give macrosoft a plug. but i keep seeing
this kind of question here, so here's what i do,
if you have the tools.
1. i fire up enterprise manager for ms sql
server, because it has a
if you have a windows box that you can use as a
front end, download corereader from
http://www.corereader.com it lets you do point
and click queries, so you can quickly experiment
with simple queries.
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] writes:
Hi,
Does version
Ok, I can't figure out how to make my select sum(runtime) from list
query work properly. At the bottom is the entire page. I've tried a
few different things, but can't figure out how I'm SUPPOSED to set this
up.
Here is what I think are the relevant lines:
$dvd_time_query = select sum(runtime)
Mysql version: 3.23.53
Background: I've got a master and slave setup
and I'm switching to a new master server. In the process of switching I
need the new master to be a slave for awhile. However, after copying
over a snapshot of my data I found that mysql dies whenever the slave
thread
[HUNDREDS of lines clipped...]
PLEASE, folks, try to trim up your quotes a bit?
Adding one line while mindlessly quoting a thread that has itself been mindlessly
quoted at least a half-dozen levels deep may not bother those who get separate
messages, but those who get the digest version suffer
Rick Mann wrote:
sql, query ... just to make the filter happy.
on 11/8/02 2:30 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED]
wrote:
You are missing something, I am afraid. To quite Sun's Javadoc for the
PooledConnection class
Thank you so much for the quick reply.
Now I understand why the
I am bothers me.
It bothers me that that the MySQL people have a bias towards PHP.
PHP is an inferior language. Deal with perl instead.
Robert
-
Before posting, please check:
On 11/10/02 5:12 AM, Robert Macwange [EMAIL PROTECTED] wrote:
I am bothers me.
It bothers me that that the MySQL people have a bias towards PHP.
PHP is an inferior language. Deal with perl instead.
Robert
Ouch.Death to all fanatics!!!
Do you have any
I'd suggest that he's just trolling.
-Original Message-
From: R. Hannes Niedner [mailto:hannes.niedner;gmx.net]
Sent: Saturday, November 09, 2002 9:27 PM
To: MySQL Mailinglist
Subject: Re: PHP bias
On 11/10/02 5:12 AM, Robert Macwange [EMAIL PROTECTED] wrote:
I am bothers me.
It
All,
Anyone have any rough idea when 4.1 (with SubSelects) is due to be released?
Thanks,
Greg.
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
ok, here is my code without all of the html (sorry people). I'm trying
to get a sum of the field runtime. With this code, I get Resource id
#3 as an error. Any help getting me to the proper result would be
greatly appreciated.
?
@$db = mysql_pconnect(localhost,dviewd);
mysql_select_db(dvds);
On Sat, 2002-11-09 at 23:53, Chip Shabazian wrote:
ok, here is my code without all of the html (sorry people). I'm trying
to get a sum of the field runtime. With this code, I get Resource id
#3 as an error. Any help getting me to the proper result would be
greatly appreciated.
?
@$db =
On Sun, Nov 10, 2002 at 03:45:04PM +1100, Greg Matthews wrote:
All,
Anyone have any rough idea when 4.1 (with SubSelects) is due to be released?
Well, if you pull the source code, it's there. But I suspect it'll be
a few months before you start seeing pre-built binaries available.
There's a
On Sun, Nov 10, 2002 at 05:12:40AM -0800, Robert Macwange wrote:
It bothers me that that the MySQL people have a bias towards PHP.
They don't.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 3.23.51: up 95 days,
On Sat, 9 Nov 2002, R. Hannes Niedner wrote:
On 11/10/02 5:12 AM, Robert Macwange [EMAIL PROTECTED] wrote:
I am bothers me.
It bothers me that that the MySQL people have a bias towards PHP.
PHP is an inferior language. Deal with perl instead.
Robert
On Sun, Nov 10, 2002 at 05:49:37AM +, andy thomas wrote:
perl doesn't have anything like as much database support, which is
why PHP has become popular in the web community.
Oh, let's not go down this road. Perl and PHP both have excellent
database support. And they're both incredibly
On Sunday 10 November 2002 14:12, Robert Macwange wrote:
PHP is an inferior language. Deal with perl instead.
Looks like you're not very familar with the spirit of Open Source:
Perl, PHP, Python, Ruby etc. are very excellent languages. They all have
benefits and of course some disadvantages.
On 11/9/02 11:31 PM, Georg Richter [EMAIL PROTECTED] wrote:
Looks like you're not very familar with the spirit of Open Source:
Perl, PHP, Python, Ruby etc. are very excellent languages. They all have
benefits and of course some disadvantages. But this competition helps each
one to improve
It would be a huge help to get hold of MySql 4.1.
What's shaken out mean? Is 4.1 still mid-development, or is it in alpha,
more or less finished, and needs debugging?
Is there anyway soon that someone could build and release some binaries? I'd
be happy to do testing if 4.1 is in a semi-usable
I am bothers me.
It bothers me that that the MySQL people have a bias towards PHP.
PHP is an inferior language. Deal with perl instead.
Robert
Ouch.Death to all fanatics!!!
Do you have any question or are you just boiling?
It's just that MySQL
On 11/9/02 11:04 PM, Paul DuBois [EMAIL PROTECTED] wrote:
I agree. It's really a drag that you can't use databases very well from
within Perl very easily. I wish that someone would invent a database
inferface for Perl. And it'd be really cool if they'd do it in such
a way that the general
On 11/9/02 11:04 PM, Paul DuBois [EMAIL PROTECTED] wrote:
I agree. It's really a drag that you can't use databases very well from
within Perl very easily. I wish that someone would invent a database
inferface for Perl. And it'd be really cool if they'd do it in such
a way that the general
Hi all.
My name is Mike.
I have a Linux RedHat 7.3 with Mysql ver 3.23.49.
I want to grant access to databases and tables to users,but only to a certin
databases and tables.
I red the how-to but both grant and revoke commands does not seems to work
(he execute the command but says that 0 records
62 matches
Mail list logo