How to backup database from the commandline?

[Jackk]

Hello,
How to backup the database from the commandline?

[Tommy]

Hello Jackk,

Please use the below command for taking database backup

mysqldump database_name > database_name.sql

and also restore from backup use below command

mysql database_name < database_name.sql

[steve]

Hello,

You have multiple options.. The above mentioned option is to take backup and restore the database from the commandline ( cli ). Additionally, you can take db backup using the phpmyadmin export database option, which is more convenient for normal users.