Re: Error in mysql replication with LOAD DATA INFILE

it in the slave ?The master didn't replication the data to the master ? All you best What we are struggling for ? The life or the life ? On Mon, Dec 20, 2010 at 3:32 PM, Anand Kumar sanan...@gmail.com wrote: On Mon, Dec 20, 2010 at 9:00 AM, Anand anand

Re: Error in mysql replication with LOAD DATA INFILE

On Mon, Dec 20, 2010 at 9:00 AM, Anand anand@gmail.com 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 process some

Re: Recommend A Backup User / Privileges?

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, Carlos Mennens

Re: installation

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, jamesadr...@globalfreeenterprise.comwrote:

Re: Analysis of a weeks worth of general log

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 jlyons4...@gmail.com 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

Re: Disable innodb status info in err log

you are right sir , the variables innodb_status_file will write the show innodb status information on to the file innodb_status.PID ... however for me the innodb status is logging into the default error log file... i dont have any clue on how to stop it from writing... Any help would be

Re: Disable innodb status info in err log

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 jes...@noggin.com.auwrote: On 17/03/2010, at 9:10 PM, Anand kumar wrote: you

Re: how to dump database or tables

it should be windows.. . On Fri, Jan 29, 2010 at 2:29 PM, Suresh Kuna sureshkumar...@gmail.comwrote: Which OS your are using ? Suresh Kuna MySQL DBA On Fri, Jan 29, 2010 at 2:25 PM, muralikrishna g muralikrishn...@gmail.comwrote: i am working on my pc with mysql-5.0.27-community-nt

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

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 celha...@mac.com wrote: mySQL-5.1.34-osx10.4-powerpc-64bit Not sure how this happened, but mySql will not start anymore, either

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

you can take the help from information_schema . --Anand On Tue, Jan 5, 2010 at 4:01 PM, bharani kumar bharanikumariyer...@gmail.com wrote: Hi For example , Student_TBL Student_id Student_Name Student_regNo , Am going to Alter the StudentregNo To StudentRegister_No , Am not sure who

Re: Global variable for only one database

Hello, you cannot change it in database level, it applies only to instance level. else if you dont want to use query cache for certain queries you can include SQL_NO_CACHE in your query .. ex .. SELECT SQL_NO_CACHE ID,NAME FROM EMPLOYEE; -- your query result will not be cached here .. SELECT

Minimal grants for backup

Hi i am using mysql-4.1.3-beta version in mysq server my concern is that i want to create a user that should able to take backup using mysqldump ... can any one help me out .. i tried giving the following grants but it is not works grant file,SHOW DATABASES,select,lock tables on *.* to [EMAIL

Grants for mysqlbackup

Hi i am using mysql-4.1.3-beta version in mysq server my concern is that i want to create a user(minimal grant) that should able to take backup using mysqldump ... can any one help me out .. i tried giving the following grants but it is not works grant file,SHOW DATABASES,select,lock tables on

Re: Grants for mysqlbackup

Hi i am using mysql-4.1.3-beta version in mysq server my concern is that i want to create a user(minimal grant) that should able to take backup using mysqldump ...can any one help me out .. i tried giving the following grants but it is not works grant file,SHOW DATABASES,select,lock tables on

Grants for mysqldump

Hi i am using mysql-4.1.3-beta version in mysq server my concern is that i want to create a user (minimal grant) that should able to take backup using mysqldump ...can any one help me out .. i tried giving the following grants but it is not works grant file,SHOW DATABASES,select,lock tables on