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.

 Leave a Reply

(required)

(required)


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

   
© 2014 Developers Corner Suffusion theme by Sayontan Sinha