backup database mysql code example
Example 1: mysql dump restore
mysql -u [user] -p [database_name] < [filename].sql
Example 2: mysql backup database
mysqldump database_name > database_name.sql
Example 3: mysql backup table
mysqldump db_name table_name > table_backup.sql
Example 4: mysql backup query
#Take backup of database
mysqldump database > backup-file.sql;
#Restore database
mysql database < backup-file.sql;