How to Backup Laravel to Exoscale Using Bash
Exoscale is a modern and fully-featured S3 compatible storage solution to store the data in a central and safe place. It allows you to integrate your object storage into any existing app or workflow. It provides a simple and user-friendly web interface to manage your objects from the web browser.
In this post, we will show you how to backup Laravel to Exoscale using Bash.
Table Of Contents
- Create a Bucket on Exoscale
- Create Exoscale Credentials
- Install S3cmd Tool
- Configure S3cmd to Connect Laravel Server to Exoscale
- Use S3cmd to Backup Laravel to Exoscale Bucket
Create a Bucket on Exoscale
First, you will need to create a bucket on Exoscale where you want to store your Laravel backup. Follow the below steps to create a bucket.
Step 1 - First, sign in to your Exoscale account.
Step 2 - Click on the STORAGE on the left pane, you should see the following screen:
Step 3 - Click on the ADD button. You should see the bucket creation screen:
Step 4 - Provide your bucker name, choose your Zone and click on the Create button. Once the bucket is created, you should see the following screen:
Create Exoscale Credentials
Next, you will need to create an Exoscale credential to connect your bucket from the remote server. Follow the below steps to create an Exoscale credential:
Step 1 - On the Exoscale dashboard, click on the AMI in the left pane. You should see the following screen:
Step 2 - Click on ADD KEY button. You should see the following screen:
Step 3 - Provide your key name and click on the CREATE button. You should see your created access key and secret key on the following screen:
Install S3cmd Tool
Next, you will need to install the S3cmd tool on your Laravel server from where you want to back up your Laravel database and files.
S3cmd is a free and open-source command-line tool that allows you to upload, download and manage data in Exoscale bucket and other cloud storage service providers. Follow the below steps to install the S3cmd to your server.
First, install the Python and other dependencies by running the following command:
apt-get install python3 python3-setuptools curl -y
Next, download the latest version of S3cmd using the following command:
curl -LO https://github.com/s3tools/s3cmd/releases/download/v2.2.0/s3cmd-2.2.0.tar.gz
Next, extract the downloaded file with the following command:
tar -xvzf s3cmd-2.2.0.tar.gz
Next, navigate to the extracted directory and install it using the following command:
cd s3cmd-2.2.0python3 setup.py install
Once the S3cmd is installed, verify the S3cmd version using the following command:
You will get the following output:
s3cmd version 2.2.0
Configure S3cmd to Connect Laravel Server to Exoscale
Next, you will need to configure the S3cmd using the Exoscale Access key and Secret key. You will require the following details to configure S3cmd:
Access Key: FEO2c60fbb123a7c263cc53751d
Secret Key: KhnddL-AA8DpYRG8o_nlnsdngPosi5KfsaoSEdA1s9k
S3 Endpoint: sos-de-fra-1.exo.io
Next, run the following command to configure S3cmd tool:
You will be asked to provide your Exoscale Access Key, Secret Key, Region, and Endpoint as shown below:
Enter new values or accept defaults in brackets with Enter.Refer to user manual for detailed description of all options.Access key and Secret key are your identifiers for Amazon S3. Leave them empty for using the env variables.Access Key: FEO2c60fbb123a7c263cc53751dSecret Key: KhnddL-AA8DpYRG8o_nlnsdngPosi5KfsaoSEdA1s9kDefault Region [US]: Frankfurt-de-fra-1Use "s3.amazonaws.com" for S3 Endpoint and not modify it to the target Amazon S3.S3 Endpoint [s3.amazonaws.com]: sos-de-fra-1.exo.ioUse "%(bucket)s.s3.amazonaws.com" to the target Amazon S3. "%(bucket)s" and "%(location)s" vars can be usedif the target S3 system supports dns based buckets.DNS-style bucket+hostname:port template for accessing a bucket [%(bucket)s.s3.amazonaws.com]: %(bucket)s.sos-de-fra-1.exo.ioEncryption password is used to protect your files from readingby unauthorized persons while in transfer to S3Encryption password:Path to GPG program:When using secure HTTPS protocol all communication with Amazon S3servers is protected from 3rd party eavesdropping. This method isslower than plain HTTP, and can only be proxied with Python 2.7 or newerUse HTTPS protocol [Yes]:On some networks all internet access must go through a HTTP proxy.Try setting it here if you can't connect to S3 directlyHTTP Proxy server name:New settings:Access Key: FEO2c60fbb123a7c263cc53751dSecret Key: KhnddL-AA8DpYRG8o_nlnsdngPosi5KfsaoSEdA1s9kDefault Region: Frankfurt-de-fra-1S3 Endpoint: sos-de-fra-1.exo.ioDNS-style bucket+hostname:port template for accessing a bucket: %(bucket)s.sos-de-fra-1.exo.ioEncryption password:Path to GPG program: NoneUse HTTPS protocol: TrueHTTP Proxy server name:HTTP Proxy server port: 0Test access with supplied credentials? [Y/n] YPlease wait, attempting to list all buckets...Success. Your access key and secret key worked fine :-)Now verifying that encryption works...Not configured. Never mind.Save settings? [y/N] yConfiguration saved to '/root/.s3cfg'
Once the S3cmd is configured, you can verify your Exoscale Bucket information using the following command:
s3cmd info s3://laravel-exoscale/
You will get the following output:
s3://laravel-exoscale/ (bucket):Location: de-fra-1Payer: BucketOwnerExpiration Rule: nonePolicy: noneCORS: <?xml version="1.0" encoding="UTF-8"?><CORSConfiguration xmlns="http://s3.amazonaws.com/doc/2006-03-01/"></CORSConfiguration>ACL: snapshooter: FULL_CONTROL
Use S3cmd to Backup Laravel to Exoscale Bucket
First, log in to your Laravel server and connect to the MariaDB shell with the following command:
mysql -u root -p
Once you are logged in, list all available databases using the following command:
MariaDB [(none)]> show databases;+--------------------+| Database |+--------------------+| information_schema || laraveldb || Laravel || performance_schema |+--------------------+
Next, create a backup of Laravel database using the following command:
mysqldump -u laraveluser -p laraveldb > laravel.sql
Next, run the S3cmd command to copy the laraveldb.sql file to the Exoscale Bucket:
s3cmd put laravel.sql s3://laravel-exoscale/
You should see the following output:
upload: 'laravel.sql' -> 's3://laravel-exoscale/laravel.sql' [1 of 1]8388608 of 8388608 100% in 1s 6.28 MB/s doneupload: 'laravel.sql' -> 's3://laravel-exoscale/laravel.sql' [1 of 1]8388608 of 8388608 100% in 0s 12.27 MB/s done
Next, run the S3cmd command again to copy the Laravel website data to the Exoscale Bucket:
tar -czvf - /var/www/html/laravel | s3cmd put - s3://laravel-exoscale/laravel.tar.gz
upload: '<stdin>' -> 's3://laravel-exoscale/laravel.tar.gz' [part 1 of -, 573KB] [1 of 1]587648 of 587648 100% in 0s 858.12 KB/s done
You can now verify all Laravel backups on the Exoscale Bucket using the following command:
s3cmd ls s3://laravel-exoscale
You will get the following output:
2022-07-28 05:46 8388608 s3://laravel-exoscale/laravel.sql2022-07-28 05:46 587648 s3://laravel-exoscale/laravel.tar.gz
You can also log in to the Exoscale Bucket and verify your backup files as shown below:
In this post, we explained how to backup the Laravel database and website data to Exoscale using bash. You can now use S3cmd tool to manage your Exoscale bucket easily via the command line.
Thank you for helping us improve!