How do I backup a Database?
We highly recommend that you try and let Site Backup add the database itself. Navigate to the following in your Blacknight Control Panel to do this:
Click on the "Site Backup" tab and at the bottom, click the "Add Missing Web/DBs" button (applicable on our Minimus, Medius, and Maximus plans only)
If anything is found, then the database would be added to Site Backup and would be backed up at the next scheduled interval.
If that does not work, or you want to manually add a database, then you need to carry out the following:
If you have not backed up any website or database yet, you would see the backup website button on the dashboard. Sign in to your end user dashboard from your customer control panel
Click on the “Add Database” button.
Select your database kind which you want to backup. We currently support MS-SQL, MySQL, PostgreSQL and MongoDB database.
Enter the port number of your database connection. The default port is 3306. Enter the host name, username and password for your database server and click on “Next”
Enter the name of the database you wish to backup.
Enter the username and password for a user with read, write and execute access to your database. If there is no such user please create the user and then input it here.
Once your connection has been tested, you will be asked to schedule your backup.
Set a name for your profile and confirm your settings and then click on “Save” and your database will be scheduled for backup.