me,myself,english and programming..

In life we do things….

in-life

Hello 2013

dear blog… today is 31.1.13

2013-01-31 110839

There are two ways of meeting difficulties: you alter the difficulties, or you alter yourself to meet them.

Till then…

Mysql – restore database, turn of beep on error and continue

this post it someting like reminder for me if happen to be i need this kind of command for future use. tq

mysql –no-beep –force -u root -p mynewdb < mynewdb.sql

That’s real life, enjoy it

thatslife

MySQL + Change all tables to another engine using command line

As the blog post title suggest, below is the way you can make your life easier.

FOR /F  "skip=1" %G IN ('"mysql -u root -pMyPassword -e "SHOW TABLES IN world;""') DO mysql -u root -pMyPassword world -e "ALTER TABLE %G ENGINE=InnoDB;"

Source : FOR, InnoDB and Here

Caution!! Do at your own risk.

till then…

Keep Going…Each step may get harder But don’t stop! The view is beautiful at the top !