How to export a database via SSH

You may export MySQL database via command-line using SSH by following the below steps:

  1. SSH to your domain.
  2. Run the following export command. Replace the brackets and the information within them with your database information. Your database information can be found within Manage MySQL in konsoleH.

mysqldump – – add-drop-table -Q -u[MySQL Login] -h[MySQL Server] [MySQL database] -p > dumpfile.sql

Kindly note: Prior to exporting the database, SSH will need to be enabled for your domain. Once the database has been exported, you may download the database dump file via FTP or the konsoleH File Manager.

Do you need further assistance? Contact us