I this tutorial I will show you how to take data base backup using command line.
You need to log in on your web server. Once you logged in just execute the below command by changing with your database name (which you want to take back up) by setting a path it will ask for your users password.
After completion of command “dump.sql” file will be created on you setted path locaton.
sudo mysqldump -u username -p databasename > path/dump.sql
Please note that mysqldump is not a MySQL command, so don’t try this after logging on mysql server. it is a command line utility. So you must call it from your shell command line.
Isn’t it taking database back-up too easy?