Skip to main content

Clone a Database

📦 Clone a Database​

Cloning allows you to create a copy of a source database into a target environment. This guide explains how to create a clone (virtual database) of your MySQL server in XLSERVER.

To perform a clone:

1. Connect to XLSERVER​

Log in to your XLSERVER instance using your browser.

2. Add Target Environment (if not already added)​

If your target environment is not already configured, add it in XLSERVER.
This will be used as the destination for the cloned MySQL database server.

Environments Page

3. Go to the Databases Page​

From the sidebar navigation, click on the Database menu.

Databases Page

4. Open the Linked MySQL Database​

Click on the Database Instance named MYSQL (the one previously linked).
You will be redirected to the database server detail page.

Database Detail

5. Start the Clone Creation​

From the ACTIONS menu, select Create Virtual Database.

6. Confirm the Operation​

A confirmation dialog will appear.
Click OK to proceed.

Clone Confirmation

7. Use the Database Clone Wizard​

Follow the wizard steps:

Step 1: Select Environment​

Choose the environment where the cloned MySQL database will be created.

  • Environment: DEV-MYSQL

Click Next.

Select Environment

Step 2: Database Configuration​

  • Port Number: 3307
  • Mount Base: /mnt/clone
  • Parallel: 1

Click Next.

Database Configuration

Step 3: Parameters​

Keep all parameters at their default values.
Click Next.

Parameters

Step 4: Summary​

Review the configuration summary.
If everything looks correct, click FINISH to start creating the clone.

Clone Summary

8. View the Clone Details​

Once the clone has been created, go back to the Database list.
Locate your new virtual clone (type VCLONEDB) and click on its Database Instance.

Clone Database Detail

From the detail page, you can view:

  • All information about the newly created database clone
  • The clone’s disk usage (only a few MB) compared to the live database server (over 2 GB)

🎉 Congratulations!​

You have successfully created your first database clone in just a few seconds.

For more details on managing database clones in XLSERVER, refer to the Database Cloning chapter.