Re: URGENT: Change Default Location of where Database Files get written?

2011-05-13 Thread Andrew Moore
There absolutely is; there is a configuration file belonging to MySQL named `my.cnf`. It can exist in many places and there's a hierarchal order of precedense. The most common of which is /etc/my.cnf. Within this file you may specify the `datadir` option to identify location you wish your data to

Re: URGENT: Change Default Location of where Database Files get written?

2011-05-13 Thread Larry Martell
On Fri, May 13, 2011 at 9:21 AM, Tina Matter wrote: > I have a MySQL question that I'm hoping someone can help answer. > > We have a linux machine which has MySQL 5.5.8 installed. > It is currently installed in this location:    /opt/mysql > > When creating a new database, a folder (with the name

Re: URGENT: Change Default Location of where Database Files get written?

2011-05-13 Thread Wm Mussatto
On Fri, May 13, 2011 08:21, Tina Matter wrote: > I have a MySQL question that I'm hoping someone can help answer. > > We have a linux machine which has MySQL 5.5.8 installed. > It is currently installed in this location:/opt/mysql > > When creating a new database, a folder (with the name of the

RE: URGENT: Change Default Location of where Database Files get written?

2011-05-13 Thread David Brian Chait
Add: datadir=/path/to/datadir/mysql to your my.cnf file and restart mysql. -Original Message- From: Tina Matter [mailto:ti...@umich.edu] Sent: Friday, May 13, 2011 8:22 AM To: mysql@lists.mysql.com Subject: URGENT: Change Default Location of where Database Files get written? I have a

URGENT: Change Default Location of where Database Files get written?

2011-05-13 Thread Tina Matter
I have a MySQL question that I'm hoping someone can help answer. We have a linux machine which has MySQL 5.5.8 installed. It is currently installed in this location:/opt/mysql When creating a new database, a folder (with the name of the databas) gets created in this location: /opt/mysql/da

Hello-NEED ASSISITANCE URGENT!!!!

2011-01-14 Thread leece320
I wondered if you can get me started on selling MANY mailing list to potential clients who are in need of millions of e-mail names and addresses. This has collected for some time. I am needing to start a business doing this Here in the United States and out of country yet I am not sure how to

Re: cannot alter table - rather urgent

2009-05-21 Thread Peter Brawley
>I cannot insert values into the tables What is the error message? Has the smallint key run out of values? >and I cannot alter or delete the primary key (which should not exist) Eh? Without a PK, it ain't a table. >or delete the foreign keys nor remove the constraint. G search doesn't help.

Re: cannot alter table - rather urgent

2009-05-21 Thread Michael Dykman
On Thu, May 21, 2009 at 11:06 PM, PJ wrote: > I have a seemingly impossible situation. I cannot insert values into the > tables and I cannot alter or delete the primary key (which should not > exist) or delete the foreign keys nor remove the constraint. G search > doesn't help. > > CREATE TABLE `b

cannot alter table - rather urgent

2009-05-21 Thread PJ
I have a seemingly impossible situation. I cannot insert values into the tables and I cannot alter or delete the primary key (which should not exist) or delete the foreign keys nor remove the constraint. G search doesn't help. CREATE TABLE `book_categories` ( `bookID` smallint(6) unsigned NOT NUL

Re: URGENT! up2date -u deleted mysql...safest way to recover on production server

2008-05-04 Thread Ian M. Evans
Glyn Astill wrote: I'd back up the data directories then try and then re-install mysql (sorry, I know little about red hat and it's package management). It shouldn't overwrite your data if it's already present anyway. Great. Thought that would be the case, but without sleep, I wasn't sure. :-

URGENT! up2date -u deleted mysql...safest way to recover on production server

2008-05-04 Thread Ian M. Evans
Decided to run up2date -u I noticed that our website was tossing off mysql errors. Quickly realized that mysql was down. Went to restart but it couldn't find mysqld_safe, mysqld, mysqladmin, etc. I used locate and it couldn't find the binaries anywhere...it appears that up2date -u had someho

Replication - urgent

2007-12-09 Thread Ratheesh K J
Hello All, I set up replication between 2 servers recently. I just need one db to be replicated and the SHOW SLAVE STATUS shows this: Relay_Master_Log_File: gyana01-bin.02 Slave_IO_Running: Yes Slave_SQL_Running: No Replicate_Do_DB: tallydb,tallydb Now the problem is that there is anoth

Replication - urgent

2007-11-05 Thread Ratheesh K J
Hello All, I need to add a couple of more tables to the list of tables to be replicated from a particular db in the salve my.cnf. Can this be done without restarting the mysql server on the slave? Thanks & regards, Ratheesh

Re: Replication - urgent

2007-10-16 Thread Baron Schwartz
Running this statement on the master should do it: DROP TABLE table1, table2...; That will remove the tables. Baron Ratheesh K J wrote: Hello all, I cannot afford to stop my slave server. I have list of tables of the master that are being replicated on the slave. Now I want to remove a cou

Replication - urgent

2007-10-16 Thread Ratheesh K J
Hello all, I cannot afford to stop my slave server. I have list of tables of the master that are being replicated on the slave. Now I want to remove a couple of tables from this list without affecting the master and slave. How is this possible? Thanks & regards, Ratheesh

Re: [Replication] - urgent

2007-10-03 Thread Jan Kirchhoff
Ratheesh K J schrieb: Thanks, It helped me a lot. I wanted to know 1. what are the various scenarios where my replication setup can fail? (considering even issues like network failure and server reboot etc). What is the normal procedure to correct the failure when somethi

Re: [Replication] - urgent

2007-10-02 Thread Ratheesh K J
uot;Ratheesh K J" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, October 02, 2007 4:16 PM Subject: Re: [Replication] - urgent > Ratheesh K J schrieb: >> Hello all, >> >> I issued a create table statement on the master for a table which was not >> present on the mast

Re: [Replication] - urgent

2007-10-02 Thread Jan Kirchhoff
Ratheesh K J schrieb: Hello all, I issued a create table statement on the master for a table which was not present on the master but present on the slave. I did this purposely to see the error on slave. I am a newbie to replication. Now when i see SLave status on the slave machine it shows th

[Replication] - urgent

2007-10-02 Thread Ratheesh K J
Hello all, I issued a create table statement on the master for a table which was not present on the master but present on the slave. I did this purposely to see the error on slave. I am a newbie to replication. Now when i see SLave status on the slave machine it shows that the SQL Thread has st

Urgent: mysql_history on windows ?

2007-05-03 Thread Abhishek Jain
Hi, I need to track the mysql commands executed on mine system , I am running windows with mysql 5.x I know there is a file .mysql_history and hopes there must be a similar file on windows too. Pl. help me urgently, Thanks, -- Regards, Abhishek Jain

Re: need help urgent

2007-03-30 Thread Ananda Kumar
se.Such that suppose the field name is ID and I want to retrieve > data > from another field LAT such that at a time LAT values for ID's 1,2,3 are > taken then for 3,4,5 then for 4,5,6 so on till table ends. > -- > View this message in context: > http://www.nabble.com/need-help

Re: need help urgent

2007-03-30 Thread Ananda Kumar
ntext: http://www.nabble.com/need-help-urgent-tf3491135.html#a9749875 Sent from the MySQL - General mailing list archive at Nabble.com.

need help urgent

2007-03-30 Thread raksha
this message in context: http://www.nabble.com/need-help-urgent-tf3491135.html#a9749875 Sent from the MySQL - General mailing list archive at Nabble.com.

[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 on

Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently

2007-01-22 Thread ViSolve DB Team
D]> To: Sent: Tuesday, January 23, 2007 11:59 AM Subject: Urgent - MySQL 5 - mysqld using a lot of memory consistently Hello all, Recently we upgraded from MySQL 4.1.11 to MySQL 5.0.22. The queries are taking a lot of time to execute in the newer version. The queries which were executing within 1

Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently

2007-01-22 Thread Ratheesh K J
M` (`FLD_TICKET_NUM`), KEY `FLD_MARK_AS_DELETED` (`FLD_MARK_AS_DELETED`), KEY `FLD_ACC_ID` (`FLD_ACC_ID`), KEY `FLD_BLOCK_STATE` (`FLD_BLOCK_STATE`), KEY `FLD_FWD_FLAG` (`FLD_FWD_FLAG`), KEY `FLD_ISSUE_CLOSED` (`FLD_ISSUE_CLOSED`), KEY `FLD_REPLY_FLAG` (`FLD_REPLY_FLAG`), KEY `FLD_SUBJECT` (`FL

Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently

2007-01-22 Thread Alex Arul
: FLD_MSG_ID key_len: 4 ref: tallydb.TFMM.FLD_MSG_ID rows: 1 Extra: Using where - Original Message - *From:* Alex Arul <[EMAIL PROTECTED]> *To:* Ratheesh K J <[EMAIL PROTECTED]> *Sent:* Tuesday, January 23, 2007 11:57 AM *Subject:*

Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently

2007-01-22 Thread Ratheesh K J
age - From: Alex Arul To: Ratheesh K J Sent: Tuesday, January 23, 2007 11:57 AM Subject: Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently you threads connected is 38 but your thread cache has only 8. So please do bump it up. Also generate explain plan on both versio

Urgent - MySQL 5 - mysqld using a lot of memory consistently

2007-01-22 Thread Ratheesh K J
Hello all, Recently we upgraded from MySQL 4.1.11 to MySQL 5.0.22. The queries are taking a lot of time to execute in the newer version. The queries which were executing within 10 secs are now taking more than 100 secs. Running an expalin on the queries showed that an index_merge optimization i

RE: URGENT: Question on table storage

2006-12-19 Thread Tom Horstmann
Hi, > I have the following table in mysql 5.0.20... > > employ > == > empid > date_time > site > > I am using this table to store all the websites accessed by each > employees. There is no primary key on that table since the same > employee will access more than 100 sites per day. If there i

Re: URGENT: Question on table storage

2006-12-19 Thread Christian Hammers
On 2006-12-19 Prem wrote: > I am using this table to store all the websites accessed by each employees. I hope you're aware that your country might have data privacy laws, too.. > There is no primary key on that table since the same employee will access > more than > 100 sites per day. If ther

URGENT: Question on table storage

2006-12-19 Thread Prem
Hello, I have the following table in mysql 5.0.20... employ == empid date_time site I am using this table to store all the websites accessed by each employees. There is no primary key on that table since the same employee will access more than 100 sites per day. If there is 100 employees t

Re: Innodb log sequence error - urgent

2006-12-16 Thread Heikki Tuuri
, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php . From: Ratheesh K J Date: December 11 2006 10:23am Subject: Re: Innodb log sequence error - urgent Get Plain Text Thanks, I hav

Re: Innodb log sequence error - urgent

2006-12-11 Thread Ratheesh K J
h K J - Original Message - From: "Jan Kirchhoff" <[EMAIL PROTECTED]> To: "Ratheesh K J" <[EMAIL PROTECTED]> Cc: Sent: Monday, December 11, 2006 1:25 PM Subject: Re: Innodb log sequence error - urgent > Ratheesh K J schrieb: >> Hello all, &

Re: Innodb log sequence error - urgent

2006-12-10 Thread Jan Kirchhoff
Ratheesh K J schrieb: Hello all, yesterday we seperated our app server and db server. We moved our 70GB of data from our app server to a new DB server. We installed MySQL 4.1.11 on the DB server. Now the following happened. On the DB server the ibdata1 and all the databases are the old ones

Innodb log sequence error - urgent

2006-12-10 Thread Ratheesh K J
Hello all, yesterday we seperated our app server and db server. We moved our 70GB of data from our app server to a new DB server. We installed MySQL 4.1.11 on the DB server. Now the following happened. On the DB server the ibdata1 and all the databases are the old ones (which were copied from

Re: Urgent please..

2006-11-15 Thread Renish
Thank you very much..excellent support - Original Message - From: "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> To: "Renish" <[EMAIL PROTECTED]> Cc: ; "Joshua J. Kugler" <[EMAIL PROTECTED]> Sent: Thursday, November 16, 2006 1

RE: Urgent please..

2006-11-15 Thread Logan, David (SST - Adelaide)
l.com Subject: Re: Urgent please.. Ocourse i read the manual . I was unable to do so..ie the reason I asked...I also knew this location mysql@lists.mysql.com - Original Message - From: "Joshua J. Kugler" <[EMAIL PROTECTED]> To: Cc: "Renish" <[EMAIL PROTECTED]&

Re: Urgent please..

2006-11-15 Thread Renish
er 16, 2006 11:20 AM Subject: Re: Urgent please.. On Wednesday 15 November 2006 18:14, Renish wrote: Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on php.exe and nothing seems to happen. I have intalled 1) webserver-Apache2 2) MySql-41.1 Please read the documentation befor

RE: Urgent please..

2006-11-15 Thread Logan, David (SST - Adelaide)
@lists.mysql.com Subject: Urgent please.. All, Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on php.exe and nothing seems to happen. I have intalled 1) webserver-Apache2 2) MySql-41.1 I want to use PHP as sever side scripting. Cheers, Renish. -- MySQL General Mailing List For

Re: Urgent please..

2006-11-15 Thread Joshua J. Kugler
On Wednesday 15 November 2006 18:14, Renish wrote: > Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on > php.exe and nothing seems to happen. > I have intalled > 1) webserver-Apache2 > 2) MySql-41.1 Please read the documentation before asking questions such as these. Thanks.

Urgent please..

2006-11-15 Thread Renish
All, Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on php.exe and nothing seems to happen. I have intalled 1) webserver-Apache2 2) MySql-41.1 I want to use PHP as sever side scripting. Cheers, Renish. -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Besoin d'aide urgent

2006-11-13 Thread Leandro Guimarães Faria Corcete DUTRA
Em Sat, 11 Nov 2006 16:03:41 +0100, Yannick Landry ANTONIO escreveu: > Je viens au pres de vous solliciter une aide en ce qui concerne le > demarrage du serveur mysql. Eſt-ce qu’il n’y a pas de liſte francophone ? > J'ai installe sur ma machine la version mysql suivant: mysql-4.0.20a-wi

Besoin d'aide urgent

2006-11-11 Thread Yannick Landry ANTONIO
Je viens au pres de vous solliciter une aide en ce qui concerne le demarrage du serveur mysql. J'ai installe sur ma machine la version mysql suivant: mysql-4.0.20a-win Je constate qu'il n'y a pas un racourcie pour la source graphique. J'ai tente de demarrer le server en ligne de commande en me met

Re: Urgent: How to decode base64 via mysql V 5.0.x

2006-10-27 Thread abhishek jain
http://firestuff.org/wordpress/wp-content/uploads/2006/03/base64.sql On 10/17/06, abhishek jain < [EMAIL PROTECTED]> wrote: > Hi, > I want to decode base 64 string via mysql . > Also i am using aspx .net . > Pl. help me. > Urgent reply will be appreciated > -- > Regards, > Abhishek jain > >

Re: Urgent: How to decode base64 via mysql V 5.0.x

2006-10-17 Thread abhishek jain
006/03/base64.sql On 10/17/06, abhishek jain <[EMAIL PROTECTED]> wrote: > Hi, > I want to decode base 64 string via mysql . > Also i am using aspx .net . > Pl. help me. > Urgent reply will be appreciated > -- > Regards, > Abhishek jain > >

Urgent: How to decode base64 via mysql V 5.0.x

2006-10-17 Thread abhishek jain
Hi, I want to decode base 64 string via mysql . Also i am using aspx .net . Pl. help me. Urgent reply will be appreciated -- Regards, Abhishek jain

Urgent plsss

2006-10-11 Thread Renish
Can anyone tell me how can I import the *.gra (oracle db file) files to Navicat or Acess. Pls let me know in steps as I am v new to this field. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query...Urgent

2006-10-09 Thread Renish
Hi all, I have installed MySql 4.1 in my system. when I tried to run Mysql , I always gets this error. Could not start MySql service on a local computer Error 1067: the process terminated unexpectedly. Any help is highly appreciated. Regards, Renish -- MySQL General Mailing List For lis

Query. Urgent!

2006-10-09 Thread Renish
Hi all, I have installed MySql 4.1 in my system. when I tried to run Mysql , I always gets this error. Could not start MySql service on a local computer Error 1067: the process terminated unexpectedly. Any help is highly appreciated. Regards, Renish -- MySQL General Mailing List For lis

Urgent: parameter of my_hash_sort_simple

2006-09-26 Thread ViSolve DB Team
Hello, Could anyone explain me the parameter of the function my_hash_sort_simple in MySQL 5.0.20a. Which is called under strings/ctype-simple.c. Thanks, Prem

Re: InnoDB Crash RECOVERY HELP (Urgent)

2006-09-21 Thread Eric Bergen
The error message says to go to http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html to learn how to set the different recovery options for innodb. On 9/21/06, Sayed Hadi Rastgou Haghi <[EMAIL PROTECTED]> wrote: Dear all, our DB server crashed and when I try to start Mysql /etc/init.d/my

InnoDB Crash RECOVERY HELP (Urgent)

2006-09-21 Thread Sayed Hadi Rastgou Haghi
Dear all, our DB server crashed and when I try to start Mysql /etc/init.d/mysql/start I get these lins in my error log 060921 13:00:14 mysqld started 060921 13:00:14 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ib

Re: MySQL performing too badly under heavy load - urgent hlp needed

2006-07-27 Thread Brent Baisley
cache, so can can do some things without taking MySQL down. - Original Message - From: "Ratheesh K J" <[EMAIL PROTECTED]> To: Sent: Thursday, July 27, 2006 8:38 AM Subject: MySQL performing too badly under heavy load - urgent hlp needed Hello all, Stuck up with a

Re: MySQL performing too badly under heavy load - urgent hlp needed

2006-07-27 Thread rouvas
t; e) any combination of the above f) not enough memory, that forces major swapping activity -Stathis > > Ratheesh K J wrote: > > Hello all, > > > > Stuck up with a major problem. Urgent hlp required > > > > MySQL seems to be performing too bad during heavy load o

Re: MySQL performing too badly under heavy load - urgent hlp needed

2006-07-27 Thread Miles Thompson
At 09:38 AM 7/27/2006, Ratheesh K J wrote: Hello all, Stuck up with a major problem. Urgent hlp required MySQL seems to be performing too bad during heavy load on the server. Queries which normally take around 5 secs to complete are taking more than 1000 secs to complete during load. What

Re: MySQL performing too badly under heavy load - urgent hlp needed

2006-07-27 Thread Martin Jespersen
(use explain to check) c) non-optimized configuration of the server (have you tuned the server parameters to the way you use the server?) d) insufficient hardware for your needs e) any combination of the above Ratheesh K J wrote: Hello all, Stuck up with a major problem. Urgent hlp required MyS

MySQL performing too badly under heavy load - urgent hlp needed

2006-07-27 Thread Ratheesh K J
Hello all, Stuck up with a major problem. Urgent hlp required MySQL seems to be performing too bad during heavy load on the server. Queries which normally take around 5 secs to complete are taking more than 1000 secs to complete during load. What could be the reason. Show processlist shows

Urgent: Please Confirm Interest in China Business Opportunity

2006-06-28 Thread Steven Forsberg
This is a text part of the message. It is shown for the users of old-style e-mail clients

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 acces

[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

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:

Re: Need to replicate my DB on 5 branches into 1 DB at HO - Urgent

2006-05-23 Thread balaraju mandala
If u need this in urgent, i think my suggestion may help you. try to do replication in this way Branch-A will be update in Branch-B and Branch-B will update in Branch-C . Branch-E(which got total data of A,B,C,D) will update in Main Office.

Re: Need to replicate my DB on 5 branches into 1 DB at HO - Urgent

2006-05-22 Thread Kishore Jalleda
On 5/22/06, Winanjaya - CBN <[EMAIL PROTECTED]> wrote: > Dear Expert, > > I am very new to MySQL replication, I need to replicate my DB on 5 branches into 1 DB at Head Office. > > eg. > > MyDB at Branch A need to be replicated to MyDB at Head Office > MyDB at Branch B need to be replicated to MyD

Re: Need to replicate my DB on 5 branches into 1 DB at HO - Urgent

2006-05-22 Thread sheeri kritzer
Only with MySQL 5.0 is multi-master replication possible. Guiseppe Maxia has a wonderful article about it at: http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html -Sheeri On 5/22/06, Winanjaya - CBN <[EMAIL PROTECTED]> wrote: Dear Expert, I am very new to MySQL repli

Need to replicate my DB on 5 branches into 1 DB at HO - Urgent

2006-05-22 Thread Winanjaya - CBN
Dear Expert, I am very new to MySQL replication, I need to replicate my DB on 5 branches into 1 DB at Head Office. eg. MyDB at Branch A need to be replicated to MyDB at Head Office MyDB at Branch B need to be replicated to MyDB at Head Office MyDB at Branch C need to be replicated to MyDB at H

Re: Urgent Fetch and updation in single step/query

2006-04-21 Thread Barry
WEBBEE . BIZ wrote: Hi all, Can we run a query like UPDATE table_name set abc='1'; and still fetch the value from a column from table . I mean Can we run select And update query in one statement. If yes how. Pl. tell me for versions 4.x and 5.x Pl. do help me. Hmm should work with PROCEDURE in

Re: Urgent Fetch and updation in single step/query

2006-04-21 Thread WEBBEE . BIZ
Hi all, Can we run a query like UPDATE table_name set abc='1'; and still fetch the value from a column from table . I mean Can we run select And update query in one statement. If yes how. Pl. tell me for versions 4.x and 5.x Pl. do help me. -- Regards Abhishek Jain On 4/20/06, abhishek jain <[EMA

Re: Reserevd Error -7776 -- Urgent

2006-04-09 Thread Daniel Kasak
C K wrote: Dear Friends, I have linked tables from MySQL through ODBC DSN in Access 2003. when I go for updating any record in any linked table then it gives me error as follows: Reserved Error (-7776); there is no message for this error. What will be the problem? Please help. Is this error from

RE: Reserevd Error -7776 -- Urgent

2006-04-07 Thread Gordon
[EMAIL PROTECTED] > Sent: Friday, April 07, 2006 1:50 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED] > Subject: Re: Reserevd Error -7776 -- Urgent > > I also tried folloing and got results as below: > 1) I updated the

Re: Reserevd Error -7776 -- Urgent

2006-04-07 Thread C K
I also tried folloing and got results as below: 1) I updated the default for timestamp filed as CURRENT TIMESTAMP as mentioned in MySQL 5.1 manual. But this not worked. 2) I dropped timestamp fiield from that table and refreshed link, then I can ork properly. Now I can insert and update reocrds wit

Re: Reserevd Error -7776 -- Urgent

2006-04-07 Thread SGreen
"C K" <[EMAIL PROTECTED]> wrote on 04/07/2006 01:59:39 PM: > On 4/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > > > "C K" <[EMAIL PROTECTED]> wrote on 04/07/2006 01:35:22 PM: > > > > > > > Dear Friends, > > > I have linked tables from MySQL through ODBC DSN in Access 2003. > > > wh

Re: Reserevd Error -7776 -- Urgent

2006-04-07 Thread C K
On 4/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > "C K" <[EMAIL PROTECTED]> wrote on 04/07/2006 01:35:22 PM: > > > > Dear Friends, > > I have linked tables from MySQL through ODBC DSN in Access 2003. > > when I go for updating any record in any linked table then it gives me > > erro

Re: Reserevd Error -7776 -- Urgent

2006-04-07 Thread SGreen
"C K" <[EMAIL PROTECTED]> wrote on 04/07/2006 01:35:22 PM: > Dear Friends, > I have linked tables from MySQL through ODBC DSN in Access 2003. > when I go for updating any record in any linked table then it gives me > error as follows: > Reserved Error (-7776); there is no message for this error. >

Reserevd Error -7776 -- Urgent

2006-04-07 Thread C K
Dear Friends, I have linked tables from MySQL through ODBC DSN in Access 2003. when I go for updating any record in any linked table then it gives me error as follows: Reserved Error (-7776); there is no message for this error. What will be the problem? Please help. Is this error from MS ACCESS or

Re: Need Update Query Help (Urgent)

2006-02-20 Thread Peter Brawley
I wrote this below Query but it shows error how to write UPDATE table_1 SET col_3 = 'bbb' WHERE col_1 = (SELECT max(col_1) FROM table_1) See the docs for Update at http://dev.mysql.com/doc/refman/5.0/en/update.html. You cannot refer to the update table in a subquery. PB - Veerabhad

Re: Need Update Query Help (Urgent)

2006-02-20 Thread Jeff Shapiro
On Monday 20 February 2006 03:27, Veerabhadrarao Narra wrote: > Hi > > i ahve one table table_1 and columns like col_1,col_2,col_3 > > col_1 col_2 col_3 > 1 aa aaa > 2 bb > > Now i want to update my table table_1 SET col_3 as bbb where max of col_1 > > I wrote thi

Need Update Query Help (Urgent)

2006-02-20 Thread Veerabhadrarao Narra
Hi i ahve one table table_1 and columns like col_1,col_2,col_3 col_1 col_2 col_3 1 aa aaa 2 bb Now i want to update my table table_1 SET col_3 as bbb where max of col_1 I wrote this below Query but it shows error how to write UPDATE table_1 SET col_3 = 'bbb'

Re: A difficult query- urgent for me

2006-01-15 Thread Rhino
To: Sent: Sunday, January 15, 2006 10:21 AM Subject: A difficult query- urgent for me Dear Friends, I have a problm, try to solve that. Actually there is a table with columns a and b . So i want if a contains a particular word than a's value should return else 'b' value should re

Re: A difficult query- urgent for me

2006-01-15 Thread Jochem van Dieten
On 1/15/06, [EMAIL PROTECTED] wrote: > > Actually there is a table with columns a and b . > So i want if a contains a particular word than a's value should return else > 'b' value should return. SELECT CASE WHEN a = 'Good' THEN a ELSE b END FROM table Jochem

A difficult query- urgent for me

2006-01-15 Thread [EMAIL PROTECTED]
Dear Friends, I have a problm, try to solve that. Actually there is a table with columns a and b . So i want if a contains a particular word than a's value should return else 'b' value should return. And there must be one and only one column returning. I have mysql 4.x and i think the logic will be

Re: Urgent help using logon to mySQL

2005-12-28 Thread SGreen
Aftab Khan <[EMAIL PROTECTED]> wrote on 12/28/2005 02:15:33 PM: > Can some one please tell me what I am doing wrong here I have installed > and configured users in the database. I am using ODBC driver to logon. > When I use the password, it does not work but surprisingly the logon is > allow

Urgent help using logon to mySQL

2005-12-28 Thread Aftab Khan
Can some one please tell me what I am doing wrong here I have installed and configured users in the database. I am using ODBC driver to logon. When I use the password, it does not work but surprisingly the logon is allowed without a password. I have tried to use MySQL Administrator to logon r

RE: urgent : PLEASE HELP - problems with back up and restore

2005-11-24 Thread Barak Mery
o: Barak Mery Cc: mysql@lists.mysql.com Subject: RE: urgent : PLEASE HELP - problems with back up and restore I saw both views and stored procedures in the dump file. What error do you get if you process the script with the "source" command within the MySQL CLI? mysql -uroot -pmypa

Re: LEFT JOIN not working on 5.0.16 - urgent help

2005-11-23 Thread SGreen
Terence <[EMAIL PROTECTED]> wrote on 11/23/2005 08:22:30 PM: > Hi All, > > We have upgraded from 4.1.0 to 5.0.16 and notice all left joins not > working. It works fine on 4.1 but 5.0.16 gives us an error: > > > How to reproduce: > > CREATE TABLE `user_master` ( >`user_id` int(5) unsigned

RE: urgent : PLEASE HELP - problems with back up and restore

2005-11-23 Thread SGreen
t;myback1.sql > > it now restore the tables but not the views or sp’s > > here is the backup file > > thanks > Barak > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 23, 2005 9:30 PM > To: Barak Mery > Cc: mysql@lists.m

Re: LEFT JOIN not working on 5.0.16 - urgent help

2005-11-23 Thread Peter Brawley
Terence, >SELECT um.username,rm.role_name,dm.department_name >FROM user_master um, role_master rm >LEFT JOIN department_master dm ON um.department_id = dm.department_id >WHERE um.role_id = rm.role_id; >J Your query joins rm to dm on a um column = a dm column. Recent 5.0 releases rightly object t

Re: LEFT JOIN not working on 5.0.16 - urgent help

2005-11-23 Thread Simon Garner
On 24/11/2005 2:22 p.m., Terence wrote: SELECT um.username,rm.role_name,dm.department_name FROM user_master um, role_master rm LEFT JOIN department_master dm ON um.department_id = dm.department_id WHERE um.role_id = rm.role_id; 1054 - Unknown column 'um.department_id' in 'on clause' Query: S

LEFT JOIN not working on 5.0.16 - urgent help

2005-11-23 Thread Terence
Hi All, We have upgraded from 4.1.0 to 5.0.16 and notice all left joins not working. It works fine on 4.1 but 5.0.16 gives us an error: How to reproduce: CREATE TABLE `user_master` ( `user_id` int(5) unsigned NOT NULL auto_increment, `department_id` int(5) default NULL, `role_id` int(5

RE: urgent : PLEASE HELP - problems with back up and restore

2005-11-23 Thread Barak Mery
Thanks Marko :) -Original Message- From: Marko Knezevic [mailto:[EMAIL PROTECTED] Sent: Thursday, November 24, 2005 12:29 AM To: MySQL list Subject: Re: urgent : PLEASE HELP - problems with back up and restore Dear Barak, Save yourself year or two of your life and try using MySQL Front

RE: urgent : PLEASE HELP - problems with back up and restore

2005-11-23 Thread Barak Mery
Thanks again, I will try this and read the manual again. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 23, 2005 9:30 PM To: Barak Mery Cc: mysql@lists.mysql.com Subject: RE: urgent : PLEASE HELP - problems with back up and restore There

RE: urgent : PLEASE HELP - problems with back up and restore

2005-11-23 Thread SGreen
MAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 23, 2005 9:07 PM > To: Barak Mery > Cc: mysql@lists.mysql.com > Subject: Re: urgent : PLEASE HELP - problems with back up and restore > > > > "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/

RE: urgent : PLEASE HELP - problems with back up and restore

2005-11-23 Thread Barak Mery
EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 23, 2005 9:07 PM To: Barak Mery Cc: mysql@lists.mysql.com Subject: Re: urgent : PLEASE HELP - problems with back up and restore "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM: > Hi, > >

Re: urgent : PLEASE HELP - problems with back up and restore

2005-11-23 Thread SGreen
"Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM: > Hi, > > > > I'm really desperate on this on. > > After struggling with some really weird bugs I finally finished my project. > > > > Buut I can't perform a good backup and restore. > > > > I'm using : > >

urgent : PLEASE HELP - problems with back up and restore

2005-11-23 Thread Barak Mery
Hi, I'm really desperate on this on. After struggling with some really weird bugs I finally finished my project. Buut I can't perform a good backup and restore. I'm using : MySql 5.0.16-nt (essentials version) Windows xp The DB contains tables, vw's and sp's. It is a v

RE: Killing a thread -- Urgent

2005-10-16 Thread Sujay Koduri
ssage- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Sunday, October 16, 2005 12:53 AM To: mysql@lists.mysql.com Subject: Re: Killing a thread -- Urgent Hello. Do you have other queries which are running at this moment on the server? The show-processlist.html says that thread could

Re: Killing a thread -- Urgent

2005-10-15 Thread Gleb Paharenko
Hello. Do you have other queries which are running at this moment on the server? The show-processlist.html says that thread could be in Killed state if it is locked by another thread. What version of MySQL do you use? What storage engine does your table have? Sujay Koduri <[EMAIL PRO

Killing a thread -- Urgent

2005-10-15 Thread Sujay Koduri
hi all.. I started a select count(1) command on a table in mysql, assuming it will end soon within the off peak time.. But now the peak load time is about to start, so i tried to kill that query.. logged into mysql as root. show processlist for getting the thread id. kill 85300 (thrad_id) Aft

Re: URGENT --- OSX 10.4 ODBC driver error

2005-09-11 Thread Josh Chamas
it was reopened, max OSX and other applications are not effected etc. etc." its version : 3.51.11-1 so this ODBC driver will not work on the 10.4 machine? as right next to the download it states OSX v10.3 (installing on 10.3 works no problem) Sorry, I can't help here, but noted t

RE: please help .........very urgent

2005-09-07 Thread Edwin Cruz
Kane Wilson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 07, 2005 1:40 AM To: mysql Subject: please help .very urgent hi , I wanted to check the following condition and if it is success i wanted to display a massage.I tried as follows. but no luck. nothing displayed. $dbQuery = resu

  1   2   3   4   5   >