Aller au contenu principal

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.