RE: upgrade from version 5.0.45

Hey if you are using any archive engines in your existing database then please use (5.0.8x) if not then u can upgrade to 5.1.45 (stable). Thanks, Dilipkumar -Original Message- From: ing.baigu...@gmail.com [mailto:ing.baigu...@gmail.com] On Behalf Of Marco Baiguera Sent: Tuesday, March 30,

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

Hey guys Try using this option from the command prompt via run Mysqldump.exe -u root -p --all-database > backup.txt This should work. Thanks, Dilipkumar Database Engineering  phone: +91-44-6637 3167  mailto: dilipkumar.par...@eds.com Pager mail:9884430...@nma.vodafone.in -Original Mes

RE: Aborted_connects is incresing repidly

Set them globally. Thanks, Dilipkumar Database Engineering Pager mail:9884430...@nma.vodafone.in -Original Message- From: Jeetendra Ranjan [mailto:jeetendra.ran...@sampatti.com] Sent: Wednesday, December 30, 2009 3:08 PM To: Parikh, Dilip Kumar Cc: mysql@lists.mysql.com Subject: Re

RE: Aborted_connects is incresing repidly

--max_connect_errors=9 to avoid this error 2009/12/30 Parikh, Dilip Kumar > Jetendra, > > Can u attach your my.cnf files and also your variable status (show > variable status). This is required because we need to tune some params. > > Thanks, > Dilipkumar >

RE: Aborted_connects is incresing repidly

Jetendra, Can u attach your my.cnf files and also your variable status (show variable status). This is required because we need to tune some params. Thanks, Dilipkumar -Original Message- From: Jeetendra Ranjan [mailto:jeetendra.ran...@sampatti.com] Sent: Wednesday, December 30, 2009 11:

RE: Slave is not updated

User is not the replication it is 'root' (or) mysqladm Thanks, Dilipkumar Database Engineering  mailto: dilipkumar.par...@eds.com Pager mail:9884430...@nma.vodafone.in -Original Message- From: Shanmugam, Dhandapani Sent: Thursday, December 24, 2009 2:48 PM To: Parikh, D

RE: Slave is not updated

x'; Flush privileges; it should work. Thanks, Dilipkumar Database Engineering mailto: dilipkumar.par...@eds.com Pager mail:9884430...@nma.vodafone.in -Original Message- From: Jeetendra Ranjan [mailto:jeetendra.ran...@sampatti.com] Sent: Thursday, December 24, 2009 2:31 P

RE: Slave is not updated

You can see connecting to master means it is not able to establish the connection from slave to master, give the grants as (replication client etc..) and then try again. Thanks, Dilipkumar Database Engineering Pager mail:9884430...@nma.vodafone.in -Original Message- From: Jeetendra Ranjan

RE: DROP TABLE TOOK 39MIN

But if you restart your mysql and then drop the table, It will take only 2 min to drop the table. Thanks, Dilipkumar -Original Message- From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com] Sent: Tuesday, November 10, 2009 12:04 AM To: Michael Dykman Cc: MySQL Subject: Re: DRO

RE: Copying to tmp table

Hi Caldi, Can I knew what kind of table type you are using and also try to send me the explain plan of the query execution. I would like to know what kind of keys are being used. Thanks & Regards, Dilipkumar Mobile: +91-9884430998 E-mail: dilipkumar.par...@eds.com -Original Message- From

RE: Fwd: Why dont my query use the index keys?

believe it. Then what is the purpose of Index?? Please clarify... Thanks & Regards, Dilipkumar -Original Message- From: chandru [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2008 2:59 PM To: Parikh, Dilip Kumar Cc: Johan Thorvaldsson; mysql@lists.mysql.com Subjec

RE: Fwd: Why dont my query use the index keys?

m: chandru [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2008 12:23 PM To: Parikh, Dilip Kumar Cc: Johan Thorvaldsson; mysql@lists.mysql.com Subject: Re: Fwd: Why dont my query use the index keys? Hi Dilip, I dont think for

RE: Fwd: Why dont my query use the index keys?

<= 5 OR ad.whitelisted = 1) AND tm.is_active=1 AND ad.ad_id != 13687 GROUP BY ad.ad_id ORDER BY antal DESC LIMIT 10 ; Thanks & Regards, Dilipkumar -Original Message- From: Parikh, Dilip Kumar [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2008 12:07 PM To: Johan Thorv

RE: Fwd: Why dont my query use the index keys?

Hi johan, U can use and try to write a query to use index in it (like use index(index name) before where condition. And other variables also looks like ok seems let me check, Please try to send the output of global status. Show global status; Thanks & Regards, Dilipkumar -Original Messa

RE: delete a data from 3 tables

Hi Please let us know the table structures of all. Thanks & Regards, Dilipkumar -Original Message- From: Sebastian Mendel [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2008 1:22 PM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: delete a data from 3 tables Chandra

RE: mysqlbinlog

Hi Krishna Just do the flush logs and check the last binlogs with the mysqlbinlog xxx-bin > textfile. Thanks & Regards, Dilipkumar -Original Message- From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2008 11:11 AM To: mysql Subject: mysqlbinlog Hi

RE: Problem recovering from mysqldump

Hi , U Can try using this option. Login into database Type as :- \. /tmp/mydb_backup.sql Hope this will help you out. -Original Message- From: Alicia Amadoz [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 28, 2007 5:27 PM To: mysql@lists.mysql.com Subject: Problem recovering

RE: Oracle is acquiring...............................

Yup But it has come up with new features like Oracle's Berkeley DB 4.5 is a replication framework .etc. Dilip -Original Message- From: Jimmy G [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007 12:13 AM To: Parikh, Dilip Kumar Cc: Jeremy Cole; Shanmugam, Dhand

RE: Oracle is acquiring...............................

Hi all, Wow, the rumors were true. Oracle is snapping up Open Source Database companies now. First it was Innobase (see Oracle buys Innobase. MySQL between rock and hard place?) and now it's Sleepycat Software. The purchase of Sleepycat, which has been rumored for weeks, gives Oracle another ope