Backup Database Using Command Line in LinuxHow to backup a database using command line - Linux
To create a backup of a database you need to SSH into the server.
ssh -p <portnumber> 'firstname.lastname@example.org
Then enter the following command replacing DATABASE_NAME with the name of your database in order to generate your backup which will be called BACKUP.sql.
mysqldump DATABASE_NAME > BACKUP.sql