unfortunately truncate tables

2010-12-03 Thread kranthi kiran
Hi all unfortunately some body truncate the 2 tables , in this data we did not enable log-bin file.how can recovery that data.i am using innodb engine , plz help me its urgent , thanks advance

Re: Speed Up Query

2010-11-19 Thread kranthi kiran
#x27;t use NOT IN (), but use IN () if you want > performance > > On Nov 19, 2010, at 9:46 AM, kranthi kiran wrote: > > Hi All, > > Following query take 25 minutes time,in this table having 3 core > > records,how to speed up this query,please help me.thanks

Re:Speed Up Query

2010-11-19 Thread kranthi kiran
Hi All, Following query take 25 minutes time,in this table having 3 core records,how to speed up this query,please help me.thanks advance SELECT b.circle_name, COUNT(a.mob), a.pack_price, DATE(a.req_date) FROM user_info_table a, circle_info_table b WHERE a.

Re:How to install multiple instances in windows

2010-10-19 Thread kranthi
Hi all, How to install multiple instances in windows??? Thank you.

Re:Incremental Backup Script

2010-10-13 Thread kranthi
Hi Please be send sample incremental backup script (bash Shell script Easy to understand) Thanks & Regards, Kranthikiran

Re: Backup

2010-10-10 Thread kranthi
Sent: Sunday, October 10, 2010 4:46 AM To: kranthikiran@gmail.com Subject: Re: Backup hmm a yesterday backup? MySqldump using where clauses? Why do you only want yesterday? -- Sent from my HTC Desire on 3 -- - Reply message - From: "ext kranthi" Date: Sun, Oct 10, 20

Re:Backup

2010-10-09 Thread kranthi
Hi , My database size is 900GB.i don't want full database backup. I need only yesterday backup. how can I take, please help me. Thanks & Regards, Kranti

kranthi kiran wants to chat

2010-08-31 Thread kranthi kiran
--- kranthi kiran wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-7b9f42b217-2ea453372e-yAnBROFNjKN29DW37cRa_kmftE8 Y

kranthi kiran wants to chat

2010-08-31 Thread kranthi kiran
--- kranthi kiran wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-7b9f42b217-34446b6de3-Dp2zHVPU5AhNWkYs9pgMnHMgaM0 Y

RE: Performance Tunning

2010-08-31 Thread kranthi kiran
Hi All, In performance tunning what are the steps can follow,please help me Thanks & Regards, Kranthi kiran

RE: Recover Records

2010-08-26 Thread Kranthi
Thank u Janqita, I can get Regards , Kranthi -Original Message- From: Jangita [mailto:jang...@jangita.com] Sent: Thursday, August 26, 2010 3:33 PM To: mysql@lists.mysql.com Subject: Re: Recover Records On 26/08/2010 11:35 a, Kranthi wrote: > Hi all, > > My data

RE: Recover Records

2010-08-26 Thread Kranthi
records. Thanks & Regards, Kranthi

RE: Mysql BestPractices

2010-08-15 Thread Kranthi
Hi all, Please send sample mysql best practice document. Thanks & Regards, Kranthi kiran

RE: Migration

2010-08-13 Thread Kranthi
EmployeeID`) ) ENGINE = INNODB; Thanks & Regards, Kranthi -Original Message- From: Lenz Grimmer [mailto:l...@mysql.com] Sent: Friday, August 13, 2010 3:56 PM To: mysql@lists.mysql.com Subject: Re: Reg: Migration Hi, On 08/13/10 09:34, Kranthi wrote: > I am migra

Reg: Migration

2010-08-13 Thread Kranthi
mpany varchar(30) NOT NULL, contact_name varchar(60) NOT NULL, address varchar(30) NOT NULL, city varchar(30) NOT NULL, state_province varchar(10) NULL, country varchar(20) NOT NULL, ) GO Thanks & Regards, Kranthi