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.
3. Go to the Databases Page
From the sidebar navigation, click on the Database menu.
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.
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.
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.
Step 2: Database Configuration
- Port Number:
3307
- Mount Base:
/mnt/clone
- Parallel:
1
Click Next.
Step 3: Parameters
Keep all parameters at their default values.
Click Next.
Step 4: Summary
Review the configuration summary.
If everything looks correct, click FINISH to start creating the clone.
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.
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.