how to backup mysql databases manually? 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
mysql -u [user] -p [database_name] < [filename].sql
mysqldump database_name > database_name.sql