Database Exports

Database Exports

Do you need to download a copy of a database? There are a few of ways that you can do it. Let's start with through the Hosting platform.

Log in to the Hosting platform:

https://app.nimbushosting.co.uk/

From the Dashboard you can select the site you need to export the database from and then select PHP & Databases on the left hand side. Here you will see all your current databases listed. We've made a handy button to help you download a copy of one of them, click the button and, providing the database is smaller than 100MB, it will download to your device.

If your database is larger than 100MB in size then you may be able to download it via phpMyAdmin instead. To log in to phpMyAdmin click on the cog icon next to the database you want to download (please note that your IP address will need to be on the Allow List to access this)

You'll see a pop up displaying the username and password that you need to use to log in to phpMyAdmin and you can click on either one to copy so you can paste it into the login screen. Click on the Open phpMyAdmin button and enter the username and password on the login screen.

Once logged in, select the database on the left hand side and then select the Export button along the top.

The settings can all be left as is, you just need to press Go and a copy of the database will download to your device.

This option can have issues if your internet connection is slow or if the database is large. If you're not successful using either of the above methods then it may be best to resort to creating a MYSQL dump via SSH.

Log in via SSH

Here's how you find your SSH log in details and how to connect via SSH:

Accessing your SSH details

How to Connect Via SSH

Change directory to the folder where you want to create your databasedump and run your dump command. Here's a suggestion, but there are others out there that you can use:

mysqldump -u -p > <DBDumpname.sql>

Example: mysqldump -u dbusername -p dbname > dbdump.sql

In my example when you hit enter it will ask you for the database password and then create a dump of the database in the folder you're in.