Hosting Knowledge Base

Home » Knowledge Base » Control Panel » Advanced Tools » Database Manager » How to export a database?

Knowledge Base

How to export a database?

The easiest way to export a database is through phpMyAdmin or SSH.

phpMyAdmin
The phpMyAdmin method requires you to access your database through the Control Panel -> Database Manager section and from the “All Databases” tab use the “phpMyAdmin” link available in the “Management” column for your database. Once you log into phpMyAdmin, select “Export” from the navigation pane and select your “Export” options, then click “Go”.

SSH
Before you connect with SSH, you need to create an SSH account. You can use the How to create an SSH account guide.
The SSH method requires you to first successfully connect through SSH (You can use the How to connect through SSH? guide) and then you can execute the following command to export your database:

mysqldump -h DB_HOST -u DB_USER -pDB_PASS DB_NAME > /home/www/database.sql

The variables DB_HOST, DB_USER, DB_PASS, and DB_NAME should be replaced with the settings of your database. You can find these settings in your Control Panel -> Database Manager section, select “Options” for your database and choose the “Information” tab. If you wish to export your database to a specific directory, replace database.sql with your desired exporting location.