DB Migrations

Need help to migrate to Elestio? Follow the simple steps in the documentation here and get started.

Migrate to Elestio managed services

This migration document focuses on the migration of the applications supported by Elestio. Find the software list here

This document provides a step-by-step guide for migrating your existing system to Elestio. Elestio is designed to enhance performance, scalability, and overall system efficiency. Before you begin the migration process, make sure to check the pre-requisites

1️⃣ Pre-requisites

  1. Make sure the service you are trying to migrate from is being supported by Elestio. You can find the entire software catalogue here

  2. Create an account on Elestio

  3. Deploy the service you want to migrate to. Follow the simple steps to deploy your preferred services on Elestio's blogs

  4. Make sure the UI for the application is working fine and there are no critical errors detected in the application logs. If found otherwise please feel free to create a support ticket

  5. When deploying the service on Elestio, use the same software version as your present service, or your data migration will fail.

2️⃣ Exporting the Data

  1. Head over to the application you have deployed on the service

  2. There will be either of two options - Migrate or Export

  3. If it's a migration option then most probably it will make use of the API keys so you can keep an eye on the use of the API keys

  4. If it's exported then you will get a file downloaded on your local machine having the config information of the application

  5. Note that you might need to export the mounted data if you are running the service in a Docker container or personal VM.

  6. Don't forget to add mounted data to /opt/app the directory inside Elestio's file system

3️⃣ Importing the Data

  1. After your service is deployed on Elestio, you can access the dashboard using the URL, username, and password in the admin credentials. You will also receive an email containing all credentials and the necessary service settings.

  2. Once you log into the application, you can head over to migration or import settings.

  3. If it's the migration then either on the application dashboard or the Elestio dashboard you will be asked to add the application ID, API keys etc. Provide all the keys wait for it to migrate and set your application on Elestio

  4. If it's import then click on the import option and select the exported file from the previous file, wait for some time and you will find it running on Elestio!

  5. If none of the settings are found then you have to manually download the data and upload it to opt/app directory of Elestio instance using File Explorer, VScode, or Filezilla

4️⃣ Testing the Migration

  1. You have successfully migrated to Elestio, now it's time for testing if your application is running as you intended

  2. Make use of integrated tools in Elestio like File Explorer, VScode, or Filezilla to set the additional data and assets

  3. If you find any issues with the migration, try to restart your instance and restart containers using the following commands

    docker-compose down;
    docker-compose up -d --build
  4. Checkout logs if something is failing. Note that there can be a version lapse between your currently hosted application and the running instance on Elestio (Latest version) as mentioned in the Pre-requisites section

5️⃣ Need additional help?

Stuck somewhere? We are here to help you, go ahead and create a support ticket and we will get back to you in no time.

Migrate your customized application to Elestio

This migration document is only for services that are not being supported by Elestio as a fully managed option. If you are unaware of the software supported, take a look here. If Elestio is supporting the software then you can follow this migration document

1️⃣ Pre-requisites

  1. Make sure the service you are trying to migrate from is being supported by Elestio. You can find the entire software catalogue here

  2. Create an account on Elestio

  3. Make sure the UI for the application is working fine and there are no critical errors detected in the application logs. If found otherwise please feel free to create a support ticket

  4. When deploying the service on Elestio, use the same software version as your present service, or your data migration will fail.

2️⃣ Using Git Repository

If your service/application is hosted on Git repositories (public & private) you can follow the following steps to migrate easily to Elestio.

  1. Head over to the CI/CD section and choose and import your Git repository

  2. Choose the cloud of your choice, region and service plan.

  3. Select the tech-stack or docker-compose in case you have that on your git-repository

  4. You can add additional configurations to your application by going to the "Build and Deploy" option.

  5. In case you need to add something that is not available on your git repository then you can add it manually with the given steps in the "Manual Migration" from below.

3️⃣ Containerized Migration

If your application is containerized and you want to use pre-built docker images. If you have a git repository you use to build these images then you can directly use these git repositories to deploy your application to Elestio from the steps given above

  1. Go to the Elestio dashboard and use the Docker Compose option in the CI/CD section choose a custom docker-compose and click on Deploy.

  2. Choose the cloud service provider, region and service plan of your choice
  3. Add your docker-compose configuration code in the given area. Additionally, if you are using a private Docker repository then you can use the checkbox to indicate that.

     

4️⃣ Manual Migration

If you don't use containerization then you will be guided to do a manual migration. Follow the following steps to effortlessly migrate to Elestio.

  1. You should head over to the dashboard and select the template that works with your application tech stack

  2. After the service is deployed, you can go ahead to the "Tools" tab and select any method of your choice to upload the assets and data

  3. For example, the following image is from File Explorer. You should navigate to /opt/app/PIPELINE_NAME and upload your code files and other assets exactly like you have in your project directory

     

  4. After successful upload, you can update the settings in the dashboard

5️⃣ Database Migration

If you are trying to migrate the database data then follow the instructions below to complete the migration without any data loss

  1. If you are using a database that provides a UI option eg: phpMyAdmin or pgAdmin then you can go ahead with to export setting of the original database export the data in the file and import that data from the file inside the Elestio instance

  2. If the database does not have UI or provide dedicated options for import and export in UI then follow the same above steps to manually add the exported data file to the VM and then restore the file in the database

6️⃣ Testing the Migration

  1. You have successfully migrated to Elestio, now it's time for testing if your database is running as you intended

  2. Make use of integrated tools in Elestio like File Explorer, VScode, or Filezilla to set the additional data and assets

  3. If you find any issues with the migration, try to restart your instance and restart containers using the following commands

    docker-compose down;
    docker-compose up -d --build
  4. Checkout logs if something is failing. Note that there can be a version lapse between your currently hosted database and the running instance on Elestio (Latest version) as mentioned in the Pre-requisites section

7️⃣ Need additional help?

Stuck somewhere? We are here to help you, go ahead and create a support ticket and we will get back to you in no time.

Migrate Wordpress to Elestio

This migration document focuses on the migration of the applications supported by Elestio. Find the software list here

This document provides a step-by-step guide for migrating your existing system to Elestio. Elestio is designed to enhance performance, scalability, and overall system efficiency. Before you begin the migration process, make sure to check the pre-requisites

1️⃣ Pre-requisites

  1. Create an account on Elestio

  2. Log in to your WordPress account where your current site/pages are hosted
  3. Make sure the UI for the application is working fine and there are no critical errors detected in the application logs. If found otherwise please feel free to create a support ticket

  4. When deploying the service on Elestio, use the same software version as your present service, or your data migration will fail.

2️⃣ Exporting the Data

There are two primary ways to export your data from Wordpress, we will focus on the native one but you can consider using plugins like WPvivid to carry out the migration.

image.png

Screenshot 2023-11-08 at 5.28.23 PM.png

3️⃣ Setup Elestio

image.png

image.png

image.png

image.png

image.png

3️⃣ Importing the Data

Screenshot 2023-11-08 at 7.13.05 PM.png

Screenshot 2023-11-08 at 7.21.52 PM.png

Screenshot 2023-11-08 at 7.26.23 PM.png

image.png

image.png

4️⃣ Testing the Migration

image.png

5️⃣ Need additional help?

Stuck somewhere? We are here to help you, go ahead and create a support ticket and we will get back to you in no time.

Migrate MySQL Database to Elestio

This migration document focuses on the migration of the applications supported by Elestio. Find the software list here

NEW: Check our Data Migration Service for MySQL to migrate more easily

This document provides a step-by-step guide for migrating your existing MySQL database system to Elestio. Elestio is designed to enhance performance, scalability, and overall system efficiency. Before you begin the migration process, make sure to check the pre-requisites

1️⃣ Pre-requisites

  1. Create an account on Elestio

  2. Log in to your MySQL admin dashboard account where your current site/pages are hosted
  3. Make sure the UI for the application is working fine and there are no critical errors detected in the application logs. If found otherwise please feel free to create a support ticket

  4. When deploying the service on Elestio, use the same software version as your present service, or your data migration will fail.

2️⃣ Exporting the Data

  1. Head over to your Phpmyadmin UI with Admin credentials and make sure you are logged in and can see your database, table, and data
  2. For this example, we are going to migrate the Library Management database that has 2 tables: Books and Library

    image.png

  3. This is the dummy data under the Books table to verify the migration 

    image.png

  4. Here, you can choose to migrate/export specific tables or entire databases. For this tutorial, I am going to export the entire database with all the tables
  5. For this, click on your database so it shows the list of all the tables like below, and head over to the "Export" option from the above option panelScreenshot 2023-11-13 at 12.33.47 PM.png
  6. You can use the "Quick" Option like below or go to custom and tweak the setting for exports as you need

    image.png

  7. Click on "Export" and save the file to your local machine. The file being downloaded will have .sql extension because we have selected the format as SQL from above. Feel free to change the format if required.
  8. With this, your database is exported

3️⃣ Importing the Data

  1. Login to your Elestio account
  2. Go to Create Services and select "MySQL"
  3. Select your service provider, region, and machine preferences

    image.png

  4. Name your service, configurations, and support layer, and hit "Create Service"

    image.png

  5. Once running, head over to the service and use the credentials provided under "Admin UI" to access the PhpMyAdmin UI 

    Screenshot 2023-11-13 at 12.47.14 PM.png

  6. Once you are in, head over to the UI you should go ahead and create your database. We will be creating a database with Name Migrated Library to see the difference after the migration

    image.png

  7. Click on the database head over to the "Import" option from the top option bar, and choose the file from your local machine that you downloaded from the previous step.

    image.png

  8. Remember that if you used the custom settings in the import section then you might want to change the options from the default while importing too, else it will raise an error
  9. After uploading the essential .SQL file, scroll down and click on "Import"
  10. The tables and data will get imported and can be seen under the database we created on Elestio instance

    image.png

  11. Voila 🎉 you have successfully imported your tables and data to your new instance of MySQL.

4️⃣ Testing the Migration

  1. You have successfully migrated to Elestio, now it's time for testing if your application is running as you intended

  2. Head over to the tables and check if you can still see the data like your previous instance

  3. Here as you can see, my new database has successfully imported the tables and the data as I showed during the import

    image.png

5️⃣ Need additional help?

Stuck somewhere? We are here to help you, go ahead and create a support ticket and we will get back to you in no time.


Migrate Jenkins Pipeline to Elestio

This migration document focuses on the migration of the applications supported by Elestio. Find the software list here

This document provides a step-by-step guide for migrating your existing Jenkins pipelines to Elestio. Elestio is designed to enhance performance, scalability, and overall system efficiency. Before you begin the migration process, make sure to check the pre-requisites

1️⃣ Pre-requisites

  1. Create an account on Elestio

  2. Log in to your Jenkins admin dashboard account on the server where your current Jenkins is deployed
  3. Make sure the UI for the application is working fine and there are no critical errors detected in the application logs. If found otherwise please feel free to create a support ticket

  4. When deploying the service on Elestio, use the same software version as your present service, or your data migration will fail.

2️⃣ Configuring Jenkins server on Elestio

  1. Login to your Elestio account
  2. Go to Create Services and select "Jenkins"
  3. Select the Cloud Service provider, region, and service plan and click Next.
  4. Select the service support, name your Jenkins instance on Elestio, and click on "Create service", this will create an instance of Jenkins on VMs on the cloud you chose.
  5. After deployment is ready, head over to the email linked to your account or the one you added while setting up the instance.
  6. The email should contain all the details including the dashboard link and the initial password required to access the admin UI.
  7. The email should be something like this 

    image.png

  8. Copy the password with the instructions given in the email and paste it into the dashboard window here

    image.png

3️⃣ Importing Data

  1. For this tutorial, we are going to import two simple pipelines that are already created on a source server

    image.png

  2. Head over to your Jenkins instance dashboard on Elestio. Click on "Manage Jenkins" and select "Plugins"Screenshot 2023-11-19 at 1.12.54 PM.png
  3. Once you are in there install "Job import" plugin. Accordingly, you might want to restart the Jenkins tooScreenshot 2023-11-19 at 1.16.26 PM.png
  4. Now, head over to the "Manage Jenkins" and head over to "System" to update the configuration. Scroll down until you find the Job Import Plugin section and click on "add remote Jenkins"Screenshot 2023-11-19 at 1.41.17 PM.png
  5. Add your original Jenkins server information as requested, you will have to add the credentials. Click on add credentials and add the credentials of your original Jenkins serverScreenshot 2023-11-19 at 1.46.36 PM.png
  6. Select that as credentials under the drop-down and make sure you have the window looking similar to thisScreenshot 2023-11-19 at 1.47.09 PM.png
  7. Apply and save the remote Jenkins settings head over to the Jenkins dashboard and click on the new option you can see called "Job Import Plugin"Screenshot 2023-11-19 at 1.49.28 PM.png
  8. Select your server from the drop-down and click on Search into folders so you don't have to put it in the remote folder. Click on the Query button.Screenshot 2023-11-19 at 1.49.51 PM.png
  9. Now you will be able to see all the pipelines available on your source server. You can select selective pipelines if you want to. Select the needed pipelines and hit the Import buttonScreenshot 2023-11-19 at 1.50.10 PM.png
  10. Woohoo 🎉, You have successfully imported the pipelines from your source server.

4️⃣ Testing the Migration

  1. You have successfully migrated to Elestio, now it's time for testing if your application is running as you intended

  2. Head over to the Jenkins dashboard and see if all of your pipelines have been imported correctly. Additionally, try running the pipelines.image.png

5️⃣ Need additional help?

Stuck somewhere? We are here to help you, go ahead and create a support ticket and we will get back to you in no time.

Migrate Superset to Elestio

This migration document focuses on the migration of the applications supported by Elestio. Find the software list here

This document provides a step-by-step guide for migrating your existing Superset pipelines to Elestio. Elestio is designed to enhance performance, scalability, and overall system efficiency. Before you begin the migration process, make sure to check the pre-requisites

1️⃣ Pre-requisites

  1. Create an account on Elestio

  2. Log in to your Superset admin dashboard account on the server where your current Superset is deployed
  3. Make sure the UI for the application is working fine and there are no critical errors detected in the application logs. If found otherwise please feel free to create a support ticket

  4. When deploying the service on Elestio, use the same software version as your present service, or your data migration will fail.

2️⃣ Exporting the Dashboards and Data

  1. Head over to your original (source) dashboard of superset
  2. Select all the dashboards you are planning on migrating and click on Export

    image.png

  3. Similarly, head over to the charts section, select all the required charts, and click on Export

    image.png

  4. These exported files will be stored in your local machine in .zip format
  5. You will have to reconfigure your connected database with Superset after the migration so you should make sure you have all the information required for configuration
  6. If you have a database connected with the Superset then head over to Elestio's Migration Docs similar to this for migration instructions for the specific database

If you want to migrate the database to seamless integration with the Superset then head over to Elestio's Migration Docs similar to this for migration instructions for the specific databases.

3️⃣ Importing the Dashboards and Data

  1. Login to your Elestio account
  2. Go to Create Services and select "Superset"
  3. Select service provider, region, and service information

    image.png

  4. Name your service, configurations, and support layer, and hit "Create Service"

    image.png

  5. Once deployed, head over to the service details and use the credentials provided under "Admin UI" to access the Superset dashboard.

    image.png

  6. Once logged in, head over to the dashboard tab and click on the import button as shown in the imageScreenshot 2023-11-22 at 9.09.30 PM.png
  7. Click on "Select File" select the export (.zip) you exported from the previous step and click on "Import"

    image.png

  8. Additionally, you can add and configure your databases from the settings shown in the image belowScreenshot 2023-11-22 at 10.00.10 PM.png
  9. Woohoo 🎉 you have successfully imported all your dashboards and repeat the same to import the charts.

4️⃣ Testing the Migration

  1. You have successfully migrated to Elestio, now it's time for testing if your application is running as you intended

  2. Head over to the Dashboard and check if you can still see the dashboards like your previous instance

  3. Here as you can see, my new dashboards have successfully been imported  as I showed during the import

    image.png

5️⃣ Need additional help?

Stuck somewhere? We are here to help you, go ahead and create a support ticket and we will get back to you in no time.

Migrate Mastodon server to Elestio

This migration document focuses on the migration of the applications supported by Elestio. Find the software list here

This document provides a step-by-step guide for migrating your existing Mastodon database system to Elestio. Elestio is designed to enhance performance, scalability, and overall system efficiency. Before you begin the migration process, make sure to check the pre-requisites

1️⃣ Pre-requisites

  1. Create an account on Elestio

  2. Log in to your Mastodon admin dashboard account where your current server is hosted
  3. Ensure the UI for the application is working fine and no critical errors are detected in the application logs. If found otherwise please feel free to create a support ticket

  4. When deploying the service on Elestio, use the same software version as your present service, or your data migration will fail.

2️⃣ Exporting the Data

  1. Log into your Mastodon server that has been originally hosted.
  2. Head over to the preferences settings
  3. Head over to the "Import and Export" and click on the Data Export option
  4. Click on the "CSV" file section to download the data you want to migrate. The CSV files will be stored in your local machines

For exporting the additional data you should export the underlying Postgres database and also your media storage.

3️⃣ Importing the Data

  1. Login to your Elestio account
  2. Go to Create Services and select "Mastodon"
  3. Select your service provider, region, and machine preferences

    image.png

  4. Name your service, configurations, and support layer, and hit "Create Service"

    image.png

  5. Once deployed, head over to the service details URL provided under "Admin UI" to access the Mastodon Server UI 

    image.png

  6. Once you are in, head over to the UI you should head over and log in with the credentials on the server.
  7. Head over to the "Import and Export" and click on the import
  8. Now click the "Choose file" option under the data section and the "Import type" from the drop-down menu. Select the file according to the import type you have selected.
  9. Confirm your imports by clicking on the confirm button
  10. If you imported the Postgres database in the previous step then make sure to import the database in the Elestio instance by using the Postgres credentials provided on the Elestio dashboard and also import the media storage.

  11. Woohoo! Your data is successfully migrated to Elestio, wait for a couple of minutes for the data to be imported. You can check the progress for the same on the same tab

    image.png

4️⃣ Testing the Migration

  1. You have successfully migrated to Elestio, now it's time for testing if your application is running as you intended

  2. Head over to the Mastodon server and check the bookmarks, posts, and list you have imported in their respective tabs and you will notice the mention of your previous server to set the differentiations

  3. Here as you can see, my bookmarks were successfully imported into the new instance of Elestio 

    image.png

5️⃣ Need additional help?

Stuck somewhere? We are here to help you, go ahead and create a support ticket and we will get back to you in no time.