Mysql dump database console mode

If you have ssh access enable, and database credentials ( user / password ) You could use the following lines.


cd /my/backup/directory
mysqldump -u myusername --password=mypassword mydatabasename > database.sql
gzip database.sql