[urgent] - Problem with index_merge

2007-01-24 Thread Ratheesh K J
Hello all, I have struck with a big problem with MySQL 5.0.22 server on RHEL 3. After an upgradation from MySQL 4.1.11 to MySQL 5.0.22 almost all the queries are struggling to execute and the DB server is clogged. Below is an example of what is happening. This query usd to execute very fast

[Solved] Urgent problem

2006-05-24 Thread Peter Lauri
It was just to copy the files from the DATA folder in the installation directory. That was easier then I thought. -Original Message- From: Peter Lauri [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 24, 2006 6:52 AM To: mysql@lists.mysql.com Subject: Urgent problem Best group member, My

Re: Urgent problem

2006-05-24 Thread Michael Widenius
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 access all files.

Urgent problem

2006-05-23 Thread Peter Lauri
Best group member, My computer stopped working. And I was able to install Windows on another partition and now I face one problem. I was running Windows with MySQL 4.1. I have all C: working, and can access all files. The first question: Can I recover that data from MySQL? The second question:

Urgent problem

2003-11-13 Thread Rainer M. Krug
Hi I did something stupid: I locked myself out of the MySQL server... 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 name of my computer where the MySQL server is

Urgent problem

2003-11-13 Thread Rainer M. Krug
Hi 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 name of my

RE: Urgent problem

2003-11-13 Thread Tom Horstmann
97 0 -- -Original Message- From: Rainer M. Krug [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 10:03 AM To: [EMAIL PROTECTED] Subject: Urgent problem Hi Rainer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: Urgent problem

2003-11-13 Thread Victor Pendleton
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

Re: URGENT problem with mysql processes

2003-06-27 Thread Keith Bussey
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 --

Re: URGENT problem with mysql processes

2003-06-27 Thread Nils Valentin
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

Re: URGENT problem with mysql processes

2003-06-27 Thread Nils Valentin
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

Re: URGENT problem with mysql processes

2003-06-27 Thread Dominicus Donny
, 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 first e-mail. The failed login attempts couldn't be from your slaves trying

Re: URGENT problem with mysql processes

2003-06-27 Thread Keith Bussey
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-mail I

Re: URGENT problem with mysql processes

2003-06-27 Thread Keith Bussey
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 first e-mail. The failed login attempts couldn't be from your slaves trying to login

Re: URGENT problem with mysql processes

2003-06-27 Thread Keith Bussey
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 still be

URGENT problem with mysql processes

2003-06-26 Thread 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 up until it kills the server: | 106 | unauthenticated user |

Re: URGENT problem with mysql processes

2003-06-26 Thread Nils Valentin
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

Re: Re: Fwd: urgent: problem in deleting multi table

2002-07-29 Thread Sinisa Milivojevic
Thank you for your fine bug report, thanks to which, I was able to fix a problem. Final fix will come up in 4.0.3, but this is a patch that fixes it temporarily : = /mnt/work/mysql-4.0/sql/sql_delete.cc 1.80 vs edited = *** /tmp/sql_delete.cc-1.80-1656Tue Jul 23 18:31:17 2002

urgent: problem in deleting multi table

2002-07-23 Thread Minjie Qiu
Hello, I'm working on a purge utility to purge 3 tables: call_record, modem_call_rec and makrup. Those 3 tables are related with foreign key recid, so I used the following sql to purge data that is older than 30 days: delete call_record, modem_call_rec, markup from call_record,

URGENT - problem in inserting single quote

2002-03-07 Thread Manisha
I am inserting into the table values with single Quote (MySql table). If I give the command through text file - Insert into test values ('manisha\' test') - then this is ok, but when i try to insert the manisha ' test value through http://hostname/sqladmin using GUI then MySql is giving

urgent problem with mysql and phpmyadmin

2002-02-21 Thread Victoria Reznichenko
Andrew, Thursday, February 21, 2002, 3:31:16 AM, you wrote: AB I have created a table in the mysql db, using phpmyadmin with the following AB statement: AB create table books AB ( isbn char(13) not null,author char(30),title(60),price float(4,2),primary AB key(isbn)); AB which works fine and

urgent problem with mysql and phpmyadmin

2002-02-20 Thread Andrew Bunkell
I have created a table in the mysql db, using phpmyadmin with the following statement: create table books ( isbn char(13) not null,author char(30),title(60),price float(4,2),primary key(isbn)); which works fine and creates the table i need the problem comes when i try to insert some values into

RE: urgent problem with mysql and phpmyadmin

2002-02-20 Thread David McInnis
David McInnis -Original Message- From: Andrew Bunkell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 5:31 PM To: [EMAIL PROTECTED] Subject: urgent problem with mysql and phpmyadmin I have created a table in the mysql db, using phpmyadmin with the following statement

urgent : Problem in Group by clause

2002-02-16 Thread SankaraNarayanan Mahadevan
hi all, i have a problem in mysql query... lemme state the scenario... i have a table 'UploadDetails' in which i am storing data regd files... the fields are: FileName, Title, Designer, UploadedBy, SubmittedDate i want to get details about whose files are designed by who..etc... that is i

urgent : Problem in Group by clause

2002-02-16 Thread SankaraNarayanan Mahadevan
hi all, i have a problem in mysql query... lemme state the scenario... i have a table 'UploadDetails' in which i am storing data regd files... the fields are: FileName, Title, Designer, UploadedBy, SubmittedDate i want to get details about whose files are designed by who..etc... that is i

Re: urgent : Problem in Group by clause

2002-02-16 Thread Teri Salisbury
Subject: urgent : Problem in Group by clause hi all, i have a problem in mysql query... lemme state the scenario... i have a table 'UploadDetails' in which i am storing data regd files... the fields are: FileName, Title, Designer, UploadedBy, SubmittedDate i want to get details about whose files

Re: Urgent problem : recovering a table with no MYI file ?

2001-07-14 Thread Jeremy Zawodny
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 if

MySQL on NetApp Filer - Urgent Problem

2001-03-16 Thread Sven Huster
Hi there, i dont want to start a thread about MySQL over NFS, i did it and it runs pretty good, but now there is a problem i could not solve. the cpu on the filer goes up and up (15% per day) and i have no idea why. At the moment it hit 70% in peak time (5 min average) Seems to be the database

Re: MySQL on NetApp Filer - Urgent Problem

2001-03-16 Thread Sven Huster
Am 11:22 16.03.2001 schrieben Sie: *This message was transferred with a trial version of CommuniGate(tm) Pro* Hi there, i dont want to start a thread about MySQL over NFS, i did it and it runs pretty good, but now there is a problem i could not solve. the cpu on the filer goes up and up (15%

Re: MySQL on NetApp Filer - Urgent Problem

2001-03-16 Thread Sven Huster
Am 17:21 16.03.2001 schrieb Jeremy D. Zawodny: *This message was transferred with a trial version of CommuniGate(tm) Pro* On Fri, Mar 16, 2001 at 11:32:42AM +0100, Sven Huster wrote: Am 11:22 16.03.2001 schrieben Sie: *This message was transferred with a trial version of CommuniGate(tm) Pro*