How to Manually Secure a Database Backup on AccuWeb.Cloud?

The platform streamlines the backup procedure for all certified database stacks with an easy-to-use script. Users can configure backups swiftly by providing the necessary parameters and completing the process within minutes.

Furthermore, we’ll demonstrate how you can interact with the generated backups

1. Backups Scheduling
2. Review Backups
3. Download Backup Files
4. Restore Databases

Backups Scheduling

Utilize the default backup script to automate the backup creation process and customize it according to your preferences (e.g., frequency, retention of old backups, etc.). If you haven’t established a database environment yet, refer to the Database Hosting guide for step-by-step instructions on setting one up.

Step 1. You can also find and examine the source code of the script by accessing the dashboard’s file manager from the Config button and navigating to the directory /var/lib/jelastic/bin/backup_script.sh.

Step 2. To automate the execution of the script, utilize the built-in cron scheduler within the containers. Open the file /var/spool/cron/mysql and input a cron expression in the specified format.

{frequency} {path-to-script} {script-parameters}

Step 3. To back up an entire database every 10 minutes using the default script, use the following string. In my case, the username is user-7558224. Save the changes.

*/10 * * * * /var/lib/jelastic/bin/backup_script.sh -m dumpall -c 3 -u root -p passw0rd

You can establish the correct mount point for your database configuration to store data on another node or a remote server.

Review Backups

After the script executes based on the configured cron frequency, proceed to the

/var/lib/jelastic/backup directory.

Download Backup Files

Download the Backups of the file. In my case, it is database backup. Whenever you want to take a backup of any file make sure the file extension is with bz2.

Restore Databases

Steps 1. Access phpMyAdmin using the credentials sent to your email.

Step 2. Navigate to the Import tab, check the option to browse your computer, and utilize the Choose File button to upload the necessary backup file.

Click on the Go button which you will find at the bottom.

Step 3. Once the import process is completed, you will receive the appropriate notification in the admin panel.

The database “accuwebcloud” has been successfully created, and all the SQL queries have been imported without any issues.

That concludes the process! You can now have peace of mind knowing that your data is being periodically saved and can be restored or accessed whenever necessary.