Re: password problem

2015-07-31 Thread nikhil anand
/mysql > To unsubscribe:http://lists.mysql.com/mysql > > -- *Thanks and Regards:* *Nikhil Anand* *+91 9650024197*

Re: Error in mysql replication with LOAD DATA INFILE

2010-12-20 Thread Anand Kumar
mysql 5.1.53 after i see some post on the internet saying we have some issues in the older version , but it keeps giving the same error. thanks Anand On Mon, Dec 20, 2010 at 7:42 PM, who.cat wrote: > i wanna know you have done LOAD DATA INFILE in master ,why are you tring > to do it

Re: Error in mysql replication with LOAD DATA INFILE

2010-12-19 Thread Anand Kumar
On Mon, Dec 20, 2010 at 9:00 AM, Anand wrote: > Hi guys, > > i am facing a serious issue with my replication , i tried so many things > but no luck. > > my replication is running with mysql 5.0.51a in master and 5.0.90 in slave. > > we run LOAD DATA INFILE in master to pr

Error in mysql replication with LOAD DATA INFILE

2010-12-19 Thread Anand
server version for the right syntax to use near ''' at line 1 Error_code: 1064 101219 0:06:33 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log '.000127' position 926912155 please help me fixing this .. thanks in advance.. thanks Anand

how to find no.of transaction in mysql

2010-05-08 Thread Anand
Hi , Is it possible to find the no.of transactions happened on the database for the specified duration of time ? it could be for past 2/3 days. Thanks Anand

Re: Recommend A Backup User / Privileges?

2010-04-29 Thread Anand Kumar
Hi Carlos, I would say the below grants for a user to perform backup is the minimum grants which we can provide.. grant select , lock tables, file on *.* to backup_user'@'localhost' identified by 'somepassword'; Thanks Anand On Wed, Apr 28, 2010 at 10:28 PM, C

Re: installation

2010-04-28 Thread Anand Kumar
Hi James, Assuming your OS is linux ,you can add the mysql bin path in the environment .By adding the entry in .profile of your home directory. PATH=$PATH:/sbin:/usr/sbin:/usr/local/mysql/bin: export PATH Thanks Anand On Wed, Apr 28, 2010 at 11:44 AM, wrote: > In the ReadMe.pdf that came w

Re: Analysis of a weeks worth of general log

2010-04-20 Thread Anand Kumar
Hi Imran, you can have a look at mysqldumpslow utility to analyze the data.. Thanks Anand On Tue, Apr 20, 2010 at 5:48 PM, Jim Lyons wrote: > Has anyone tried using the log_output option in mysql 5.1 to have the > general log put into a table and not a flat file? I used it for a

Re: Disable innodb status info in err log

2010-03-17 Thread Anand Kumar
Jesper, I dont have a table called innodb_monitor on any of my databases, i gone through the links which you mentioned here.. but no luck.. Thanks Anand S On Wed, Mar 17, 2010 at 5:06 PM, Jesper Wisborg Krogh wrote: > On 17/03/2010, at 9:10 PM, Anand kumar wrote: > > you are right

Re: Disable innodb status info in err log

2010-03-17 Thread Anand kumar
p would be appreciated .... Thanks Anand On Wed, Mar 17, 2010 at 3:24 PM, RaMeSh wrote: > Greetings. > > Try with the variable innodb_status_file. > > I wont get logged in mysqlerr.log file. > > > > On 17 March 2010 15:15, Shanmugam, Dhandapani < > dhandapani.shanmu...@

Disable innodb status info in err log

2010-03-17 Thread Anand
Hi All, Innodb status information is getting logged on to my mysql error log file for every 15 seconds, can someone help in disabling it ? Thanks Anand

Re: how to dump database or tables

2010-01-29 Thread Anand kumar
it should be windows.. . On Fri, Jan 29, 2010 at 2:29 PM, Suresh Kuna wrote: > Which OS your are using ? > > Suresh Kuna > MySQL DBA > > On Fri, Jan 29, 2010 at 2:25 PM, muralikrishna g > wrote: > > > i am working on my pc with mysql-5.0.27-community-nt > > > > i have created several data bases a

Re: probably a permissions problem that I cannot figure out.

2010-01-13 Thread Anand kumar
can you give us the error , it can be found on the file "/usr/local/mysql/data/Power-Mac-G5.local.err" Thanks Anand On Thu, Jan 14, 2010 at 9:49 AM, Chris Elhardt wrote: > mySQL-5.1.34-osx10.4-powerpc-64bit > > Not sure how this happened, but mySql will not start anymore

Re: Before alter Field name in table, Things Need to check

2010-01-05 Thread Anand kumar
you can take the help from "information_schema" . --Anand On Tue, Jan 5, 2010 at 4:01 PM, bharani kumar wrote: > Hi > > For example , > > Student_TBL > > Student_id Student_Name Student_regNo , > > Am going to Alter the StudentregNo To StudentRegister_No ,

Re: Global variable for only one database

2009-12-31 Thread Anand kumar
e cached here .. SELECT SQL_CACHE ID,NAME FROM EMPLOYEE; --- > your query result will be cached here if the query_cache variable is set to ON. Hope this will clear your doubt.. Regards Anand S On Thu, Dec 31, 2009 at 2:33 PM, Jeetendra Ranjan < jeetendra.ran...@sampatti.com> wrote: >

Grants for mysqldump

2007-05-23 Thread Anand kumar
*.* to [EMAIL PROTECTED] by 'pass'; regards Anand

Re: Grants for mysqlbackup

2007-05-23 Thread Anand kumar
*.* to [EMAIL PROTECTED] by 'pass'; regards Anand

Grants for mysqlbackup

2007-05-23 Thread Anand kumar
*.* to [EMAIL PROTECTED] by 'yyy'; regards Anand

Minimal grants for backup

2007-05-23 Thread Anand kumar
PROTECTED] by 'yyy'; regards Anand

need white papers on performace tuning of full text indexing

2006-02-22 Thread Anand Sachdev
anyone know where i can get these, will highly appreciate, this is a feature of mysql 5.0 and my platform is linux.

Re: unique values across more than one column

2004-02-27 Thread Anand Buddhdev
the pointer to use locking, and for the pointer to InnoDB and BDB. I didn't know about those options. -- Anand Buddhdev Celtel International -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: unique values across more than one column

2004-02-27 Thread Anand Buddhdev
can't do in the above way. You can first check with SELECT > statement if address or alias already exists. Ok, thanks for the response. The problem with first doing a select, and then an insert, is that there exists a race condition. Between the select and insert, someone else could

unique values across more than one column

2004-02-27 Thread Anand Buddhdev
of an address and its alias in one insert, and if the insert fails, then we know there's duplication, and return an error message. I have thought of other ways around this issue, but my ideal solution would be as above. If this is not possible, then I will go back to my other (IMHO less elegan

mysql install Q... error connecting /tmp/mysql.sock

2002-09-10 Thread anand v
Hi, I have redhat linux 7.1 and I have downloaded mysql-3.23.52 and followed all the instructions as to how to install and how to bring up the database the scripts/mysql_install_db worked fine and then I did ./bin/safe_mysqld and that worked fine too but when I tried to execute the mysql prog

mysql installation error... mysql.sock file not found

2002-09-10 Thread anand v
t Thanks Anand _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check

MySQL Connector/J 2.0.14 issue

2002-08-21 Thread anand v
ect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:517) at java.sql.DriverManager.getConnection(DriverManager.java:199) at DateTest.main(DateTest.java:20) But I can connect to this database from command line prompt witho

Query optimization (Using temporary; Using filesort)

2001-12-06 Thread Anand Vaddiraju
. I am still in the development stage, and so don't mind changing the table structure if required. Thanks in advance, Anand EXPLAIN SELECT Profile.Person.name, Design_Issue.id, Design_Issue.issue, Design_Issue.chip_type_id, Design_Issue.chip_secti

MS Platform

2001-10-03 Thread Anand Agarwal
I have developed my application on MS-SQL on Win' NT platform using Powerbuilder. Can I run this application on Linux and MYSQL. Please respond immediately as we are trying to promote this combination actively. With warm regards Anand Agarwal e-mail: - [EMAIL PROTECTED] Your attitude de

SUPPORT FOR UNICODE

2001-09-12 Thread Priti Anand SA LRISD
Hi everyone, I am not a user of MYSQL yet, but shall be soon. I needed to know if MYSQL has begun to support UNICODE (UTF- 8) as rest of the RDBMS' have adopted it to meet the language needs of non-english countries. And I am just hoping that amongst so many MYSQL users probably some one wo

python and mysql

2001-03-08 Thread Anand Patel
Hi I am using python to interact with mysql and have a small problem ahich I am hoping someone can help me with: Basically I am trying to input values into a table which I have created, the value is www.breakbeat.co.uk. The way I have done this is to assign the url to a variable: url1. and

Request...

2001-02-24 Thread Anand Shelat
Hi!!! I am interested in learning MySQL from beginnning. I do not have knowledge any other database even. I have to start from scratch. Can you please guide me for the same? How to start ? BIG THANKS IN ADVANCE. Regards, Anand

System Requirements...

2001-02-05 Thread Vangipuram, Anand
> What are the system requirements for installing mysql? > > Anand Vangipuram > 414-566-6701 > This message has been scanned for viruses with Trend Micro's

buffer problem

2001-01-12 Thread prakash anand
Hi,, >From a java file,I am opening a table reading it and writing to a text-file. But when I am opening that text file,it is incomplete.Every time it stops at 8192 bytes. please help me. bye prakash

buffer problem

2001-01-12 Thread prakash anand
Hi,, >From a java file,I am opening a table reading it and writing to a text-file. But when I opened it,it is incomplete.Every time it stops at 8192 bytes. please help me. bye prakash