mysql backup command code example

Example 1: mysql backup database

mysqldump database_name > database_name.sql

Example 2: import mysql dump database command line linux

mysql -u<user_name> -puser_password> <database_name>
source /path/db.sql

Example 3: mysql backup query

#Take backup of database
mysqldump database > backup-file.sql; 

#Restore database
mysql database < backup-file.sql;