To export a mysql database you should use the following command. You can get the name of the database by login into mysql and using the command "show databases" mysqldump -u YourUser -p YourDatabaseName > output.sql you will be prompted with a password and after successful authentication the SQL file

First you will have to install unzip package using apt. sudo apt install unzip To zip a folder you will have to use the following command zip -r output_zipfilename.zip This command will create a zip of the folder and will generate a zip file of the folder To

In some cases we will have to move whole folders or files from one server to another. its not always practical to download the file and upload it to the new location. If you are dealing with a VPS server and you have the shell access on both the systems,