Re: hi help to take backup-mysql-windows-xp

Hi Murali, You have to execute it outside mysql prompt i.e command prompt. Thanks Suresh Kuna MySQL DBA Sent from BlackBerry® on Airtel -Original Message- From: muralikrishna g Date: Tue, 2 Feb 2010 12:17:24 To: Suresh Kuna Cc: Subject: Re: hi help to take backup-mysql-windows-xp hi t

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

Give the ful path of file name with in '' and try it out Thanks Suresh Kuna MySQL DBA --Original Message-- From: Colin Streicher To: mysql@lists.mysql.com Cc: kebede teferi ReplyTo: co...@obviouslymalicious.com Subject: Re: I NEED HELP ON 'SOURCE(\.) MYSQL Sent: Feb 2, 2010 7:33 AM what

Re: Selecting Dates

Hi What is the datatype of the column order_date. Give the full form of the date for the between condition. Thanks Suresh Kuna MySQL DBA --Original Message-- From: ML To: mysql@lists.mysql.com Subject: Selecting Dates Sent: Feb 1, 2010 7:05 AM Hi All, Switching from Oracle to MySQL, I s

Re: How to change mysql default database directory

As Carlos said, mention your required path in the my.ini file and restart the MySQL or move your current datadir to your required path and restart MySQL by mentioning the variable as below in the configuration file. Datadir=path In MySQLD section of your cnf file. Thanks Suresh Kuna MySQL DBA -

Re: Problem with mysql

Hi, The grant stmt has to be as below. Grant all on databasename.tablename to usern...@iporhostname identified by 'password'; Use as above Grant stmt doesn't require a flush stmt. Suresh Kuna MySQL DBA --Original Message-- From: Jørn Dahl-Stamnes To: mysql@lists.mysql.com ReplyTo: sq.

Re: Are there any difference between max_connection and max_user_connection?

If the queries are identical then Yes. If not it will degrade the query performance. Sent from BlackBerry® on Airtel -Original Message- From: "F.A.I.Z.A.L" Date: Thu, 7 Jan 2010 15:51:19 To: Suresh Kuna Cc: Subject: Re: Are there any difference between max_connection and max_

Re: table export in cron

Hi, You can use an external replication tool like Golden gate for replication between MySQL and Oracle. Thanks Suresh Kuna MySQL DBA Sent from BlackBerry® on Airtel -Original Message- From: Mikhail Berman Date: Wed, 06 Jan 2010 10:42:14 To: machiel.richards Cc: Subject: Re: table expor

Re: Exporting the result of a Query into excel

We have to use outfile with select stmt, not with show. Suresh Kuna Sent from BlackBerry® on Airtel -Original Message- From: ishaq gbola Date: Tue, 5 Jan 2010 13:45:44 To: Subject: Re: Exporting the result of a Query into excel As test i tried this and I got the result below mysql> sh

Re: Exporting the result of a Query into excel

Ok. In windows, Use winscp tool, connect to the server and copy the file to local machine and import it in excel. Thanks Suresh Kuna Sent from BlackBerry® on Airtel -Original Message- From: ishaq gbola Date: Tue, 5 Jan 2010 13:42:20 To: Subject: Re: Exporting the result of a Query into

Re: Exporting the result of a Query into excel

Hi What is the OS you are using on the remote and local server. Is there a mysql client on local server? Thanks Suresh Kuna Sent from BlackBerry® on Airtel -Original Message- From: ishaq gbola Date: Tue, 5 Jan 2010 13:31:59 To: Subject: Re: Exporting the result of a Query into excel T

Re: High Overhead On Active Insert And Delete Table

My first impression after looking at the table structure is 1 the number of indexes present are very huge and each insert or delete will act as an extra insert or delete of each and every index created. 2 what type of select stmts are going to hit this table. 3 if it is a primary key select, drop

Re: High Overhead On Active Insert And Delete Table

Hi Willy, What is the engine you are using for the table? Paste the table structure. Thanks, Suresh Kuna --Original Message-- From: Willy Mularto To: mysql@lists.mysql.com Subject: High Overhead On Active Insert And Delete Table Sent: Jan 3, 2010 4:22 PM Hi list, I have a table which is ve