Hi!
> "Peter" == Peter Lauri <[EMAIL PROTECTED]> writes:
Peter> Best group member,
Peter> My computer stopped working. And I was able to install Windows on another
Peter> partition and now I face one problem. I was running Windows with MySQL
4.1.
Peter> I have all C: working, and can acces
restart mysql with the skip-grants option
-Original Message-
From: Rainer M. Krug [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 3:03 AM
To: [EMAIL PROTECTED]
Subject: Urgent problem
Hi
I did something very stupid: I locked myself out of the
MySQL server (all accounts, inc
> I did something very stupid: I locked myself out of the
> MySQL server (all accounts, incl administrator)...
>
> My problem: I use MySQLFront to change the allowed
> hosts and did it for all users. They were 'localhost'
> and I set them to 'localhost; EcolMod1' where the
> EcolMod1 is the na
Quoting Nils Valentin <[EMAIL PROTECTED]>:
> When you said you modified the scripts, are these the scripts on the 12
> webservers (mysql clients) ?
Yes, when I mention modifying my scripts, I mean the scripts/pages on the 12
webservers
> If not, then these mysql clients (webservers) would stil
;Nils Valentin" <[EMAIL PROTECTED]>
> To: "Keith Bussey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Friday, June 27, 2003 1:30 PM
> Subject: Re: URGENT problem with mysql processes
>
>
> Hi Keith,
>
> from your last e-mail I understand no
No, the slaves replicate fine and I can see their entries in the processlist
normally (as their hostname), not as "unauthenticated user"..
--
Keith Bussey
Wisol, Inc.
Chief Technology Manager
(514) 398-9994 ext.225
Quoting Nils Valentin <[EMAIL PROTECTED]>:
> Hi Keith,
>
> from your last e-m
Bussey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, June 27, 2003 1:30 PM
Subject: Re: URGENT problem with mysql processes
Hi Keith,
from your last e-mail I understand now finally that we are talking about
replication here. Would have been a short cut to mention it in your
Hi Keith,
from your last e-mail I understand now finally that we are talking about
replication here. Would have been a short cut to mention it in your first
e-mail.
The failed login attempts couldn't be from your slaves trying to login, but
you havent set them up on the master yet ?
Just a gu
When you said you modified the scripts, are these the scripts on the 12
webservers (mysql clients) ?
If not, then these mysql clients (webservers) would still be wanting to send
to IP addres 192.168.1.71 as configured for php or in your client.
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月
Neither of these two machines send the request.
I have 12 webservers, which send the requests.
I have 5 database servers, 1 master(for updates/inserts/deletes) and 4
slaves(for selects).
Machine A below was the current Master DB server, however it is old and was
being replaced by machine B
--
Ok but that's not what I meant.
I'll try to explain better.
Machine A: IP = 192.168.1.71
Machine B: IP = 192.168.1.79
1) Scripts goto 192.168.1.71 - Everything is OK
2) Changed scripts to 192.168.1.79 - Site works at first, but processes pile up
until server is killed
3) Halt machine B
4) Gi
Hi Keith,
The wrong IP address could only avoid a client to connect to the database
server.
If you have the TCP/IP address specified in /etc/php.ini or for phpmyadmin in
config.inc.php or which ever tool you use than of course it will try to
connect to this IP address.
Best regards
Nils Val
Hi Keith,
2003年 6月 27日 金曜日 09:05、Keith Bussey さんは書きました:
> Major problem!
>
> I've installed mysql-standard 4.0.13 (from binary) a new DB server, it is
>
> - quad-xeon (500mhz each cpu)
> - 3 gig RAM
> - Linux Redhat 7.3
>
> When I start up mysql, processes looking like the following begin to pile
My guess. . .
I have seen this problem with other databases . . . don't know if it is
true for MySQL as well. Try to change to your field definition to
float(5,2) as it may be counting the (.) as part of your field size.
So if you number is xx.xx you will need 5,2. 4,2 would give you xx.x
Da
Hi Shankar,
This is your old buddy Scott S.
Try order by rather than group byThis will get you what you are looking
for
Scott Salisbury
- Original Message -
From: "SankaraNarayanan Mahadevan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 16, 2002 3:42 PM
On Sat, Jul 14, 2001 at 01:04:41AM +0200, Fournier Jocelyn [Presence-PC] wrote:
> Hi,
>
> I'm administrating a machine which has just badly crashed, and a MYI
> file has disappeared for one table. Is this possible to repair this
> table?
Try to touch the file (to create an empty one), and see i
16 matches
Mail list logo
