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.