unfortunately truncate tables

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

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

Re: Speed Up Query

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 advance SELECT b.circle_name, COUNT(a.mob

Re:How to install multiple instances in windows

Hi all, How to install multiple instances in windows??? Thank you.

Re:Incremental Backup Script

Hi Please be send sample incremental backup script (bash Shell script Easy to understand) Thanks Regards, Kranthikiran

Re: Backup

, 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 kranthikiran@gmail.com Date: Sun, Oct 10, 2010 04:51 Subject

Re:Backup

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

RE: Performance Tunning

Hi All, In performance tunning what are the steps can follow,please help me Thanks Regards, Kranthi kiran

kranthi kiran wants to chat

--- 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 You'll

kranthi kiran wants to chat

--- 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 You'll

RE: Recover Records

records. Thanks Regards, Kranthi

RE: Recover Records

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 database size

RE: Mysql BestPractices

Hi all, Please send sample mysql best practice document. Thanks Regards, Kranthi kiran

Reg: Migration

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

RE: Migration

`) ) 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 migrating the database from