Prerequisite: Verify if zip is installed
sudo apt install zip unzip
Now that you know your system has zip support, you can read on to learn how to zip a directory in Linux.
The syntax for using the zip command is pretty straight forward.
zip [option] output_file_name input1 input2
1. Back up the database using the following command:
mysqldump -u [username] –p[password] [database_name] > [dump_file.sql]
The parameters of the said command as follows:
[username] – A valid MySQL username.
[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 backup dump file you want to generate.