Taking Mysql Dumb :

mysqldump -u username -h localhost -ppassword database >  my_database_name.sql

To avoid lock table issue use below line of code…

mysqldump --skip-lock-tables -u username -h localhost -ppassword database >  my_database_name.sql

For easy restore

mysql -u username -h localhost -ppassword database ;

Above statement will lead to mysql console.. then execute below line

\. my_database_name.sql

Remember the file must be there in that path from where you took mysql statement.

© 2014 Developers Corner Suffusion theme by Sayontan Sinha