Jun
17
2016

how to take db dump in mysql

MySQL_db_dump

Very often developer needs DB backup before deploying new changes on production environment or any other environment.  In this post we will see how to take backup in mysql db. It is very simple.

mysqldump -u dbusername -p DBname | gzip > filename.sql.gz
Enter password:

That all. It is very simple.

 

About the Author: devender kumar

java/j2EE developer

Comments are closed.