Friday, April 27, 2012

MySQL Tips

1) Restore DB
a) mysql --user=root --password=root maheshsql_db < "C:\mydbbkp.sql"


2) MYSQL Get all table rows and size of each table in DB
a) SELECT table_schema "Data Base Name", SUM( data_length + index_length) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;
b) SELECT TABLE_NAME, table_rows, data_length, index_length, 
round
(((data_length + index_length) / 1024 / 1024),2) "Size in MB" FROM information_schema.TABLES WHERE table_schema = "schema_name";
c) SELECT SUM(round(((data_length + index_length) / 1024 / 1024),2)) "Size in MB" FROM information_schema.TABLES WHERE table_schema = "schema_name";


3) Count no of tables in DB
a) SELECT count(*) FROM information_schema.tables WHERE table_schema  = "schema_name";


4)  Can not load from mysql.proc. The table is probably corrupted
a) Run this Command
           a.1) mysql_upgrade 
                 OR
           a.1) mysql_upgrade --user=my_username --password=my_password

5) ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10061)
        step 1) Open your my.cnf file OR my.ini   file in mysql/bin folder
         step 2) Comment the bind-address
              #bind-address="127.0.0.1"

Tuesday, April 17, 2012

Bharat Gas Online Refill

If you are a Bharat Gas (from Bharat Petroleum) customer, you can book your cylinder online. Just visit this page and register your details (your Consumer number can be found in any previous cylinder booking slip).
After that, you can choose your login ID and Password and proceed to book your cylinder online by visiting the same website. One additional feature, which would be useful for the consumers would be the inclusion of ‘expected date of delivery’, which is missing currently.
Apart from Online refill booking, you can book your cylinder through SMS or IVRS.
To book cylinder through SMS, you first have to register your mobile number. You can either register by visiting the above link and providing your mobile number or send an SMS as:
REG DistributorSAPcode ConsumerNumber
And send it to 52725 (Airtel, Tata, Vodafone, Idea or MTNL) or to 57333 (for others).
For example, type REG 123456 789012 and send it to above numbers
Once you are done with registering your mobile number, every time you want to book cylinder, you just have to send an SMS as LPG to the same numbers as above. You’ll instantly receive booking confirmation.
For Bharat Gas customers in Delhi, you can dial the IVRS number 1712 and make your cylinder booking.

#1045 - Access denied for user 'root'@'localhost' (using password: NO/YES)

#1045 - Access denied for user 'root'@'localhost' (using password: NO)
                                      OR
#1045 - Access denied for user 'root'@'localhost' (using password: YES)

If you were restored the MySQL Database, then set the password which is current restored Database at phpMyAdmin\config.inc file

1)
    $cfg['Servers'][$i]['user'] = 'root';
    $cfg['Servers'][$i]['password'] = 'maheshRestoredDBPassword';

2) You can try Login from command line

C:\xampp\mysql\bin>mysql --user=root --password=maheshRestoredDBPassword