Re: Script need for dropping databases

[Mohan L]

On Fri, Nov 18, 2011 at 1:32 PM, a bv vbavbal...@gmail.com wrote:

 Hi,
 I have a linux box running mysql plus  phpmyadmin  which has tables
 getting montly data and when a new month starts a new table is
 created. I want to store only 2 years of data  so when a new month
 starts  i need to drop the table which became the data container of 2
 years previous data. So to make this job auto, i need a linux/mysql
 script which will run on cron etc . Can you please help me
 for a correct script ? (i cant say im a database guy :-)

 It may help :
http://www.cyberciti.biz/faq/how-do-i-empty-mysql-database/

and you can also use something like :

#!/bin/bash
mysql dbnaneEOFMYSQL
DROP table table_name;
CREATE TABLE table_name;
EOFMYSQL

Thanks  Rg
Mohan L

innodb system variable

[Mohan L]

Dear All,

I have the following two system variable set in my MySQL configuration file
under mysqld section.  But I am not fully understand what the two variable
internally does.
innodb_rollback_on_timeout=1
innodb_lock_wait_timeout=600

Any help will be appreciated.

Thanks for Your Time
Mohan L

sub query to daily usage subtraction

[Mohan L]

Dear All,

My Mysql Table contain 5 column id,data,storage,bandwidth_sent,
bandwidth_received , like this : http://pastebin.com/ghXWMZ7V.  The storage
and bandwidth information is accumulated one. I need to fetch my daily usage
from data bases.  I need to subtract  today's storage -yesterday storage
bases on date .Here id is same. I am new to witting mysql query (learning).
I think this can be done using sub query.  any help will be really
appreciated .

Thanks  Rg
Mohan L