How to take MySQL Database Backup in Linux
By Using mysqldump
command we can take the backup of MySQL database.
1 |
mysqldump -u DB_Username –p DB_User_Password Database_Name > dump_file.sql |
DB_Username – A valid MySQL username.
DB_User_Password – A valid MySQL password for the user.
Database_Name – A valid Database name you want to take backup.
dump_file.sql – The name of the backup dump file you want to generate.