How to take MySql dump (backups)

mysqldump –add-drop-table -a -u username -p database | gzip > prod-db-dump.sql.gz Note: The password is not passed to the command line, but it will asked at the prompt

Read more