How To Export Database Dump From Mysql?

You can take mysqldump DB backup from Mysql with just simple steps.

• First You need to log in with your SSH server.
• After Login, Just go to your server directory location where you want to keep DB backup and that path must be writable.
• Run the given command to take DB Backup,

mysqldump -u {USERNAME} -p -h {HOSTNAME} {DATABASE_NAME} > site-backup.sql

In the above CLI Command,  Replace { } with your actual data.

1. {USERNAME} Database User Name
2. {HOSTNAME} Your Server Hostname
3. {DATABASE_NAME} The database name to take Backup

Get Database Backup from the SSH by Command line. You can retrieve DB backup by login into SSH Server.