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 .. SELE

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 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 are all used this

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

Re: how to dump database or tables

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: 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 apprecia

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 wrote: > On 17/03/2010, at 9:10 PM, Anand kumar wrote: > > you are right

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 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 while > befor

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, wrote: > In the ReadMe.pdf that came with

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 wrote: > I download

Re: Error in mysql replication with LOAD DATA INFILE

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 process some csv files and

Re: Error in mysql replication with LOAD DATA INFILE

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 wrote: > >> On Mon, D

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 P

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 *.