Skip to main content

Database Migration Guides

This section covers database-specific migration guides for popular database systems. Each database type has unique migration considerations and tools.

Supported Database Migrations​

MySQL Database Migration​

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

Elestio provides a robust migration tool for MySQL databases with minimal downtime and comprehensive validation.

→ Complete MySQL Migration Guide

Key Features:

  • Built-in migration tool with real-time monitoring
  • Connection validation before migration
  • Multi-master and replica cluster support
  • Automated backup and recovery options

PostgreSQL Database Migration​

Comprehensive PostgreSQL migration with support for complex schemas and data types.

→ Complete PostgreSQL Migration Guide

Key Features:

  • Schema and data validation
  • Support for PostgreSQL extensions
  • Incremental migration options
  • Connection pooling optimization

MongoDB Migration​

Document database migration with support for collections, indexes, and aggregation pipelines.

→ Complete MongoDB Migration Guide

Other Supported Databases​

General Database Migration Process​

All database migrations on Elestio follow a consistent three-step process:

Step 1: Configure​

  1. Navigate to your database service overview in Elestio
  2. Click on the "Migrate Database" button
  3. Ensure your target service has sufficient disk space
  4. Click "Get started" to begin the migration wizard

Step 2: Validation​

  1. Provide source database connection details:
    • Hostname/IP address
    • Port number
    • Database name (if required)
    • Username and password
  2. Click "Run Check" to validate the connection
  3. Review any warnings or compatibility issues

Step 3: Migration​

  1. If validation passes, click "Start migration"
  2. Monitor progress through real-time migration logs
  3. Receive notification upon completion
  4. Perform validation tests on the migrated data

Migration Best Practices​

Pre-Migration Checklist​

  • ✅ Verify source database is accessible and stable
  • ✅ Ensure sufficient storage space on target instance
  • ✅ Create backup of source database
  • ✅ Test connection parameters
  • ✅ Plan maintenance window for minimal disruption

During Migration​

  • ✅ Monitor migration logs for any errors
  • ✅ Avoid making changes to source database
  • ✅ Keep migration credentials secure
  • ✅ Have rollback plan ready if needed

Post-Migration Validation​

  • ✅ Compare record counts between source and target
  • ✅ Test application connectivity
  • ✅ Verify data integrity and consistency
  • ✅ Update application connection strings
  • ✅ Monitor performance metrics

Legacy MySQL Migration Method​

For reference, here's the traditional MySQL migration process using phpMyAdmin:

Prerequisites​

  1. Create an account on Elestio
  2. Log in to your MySQL admin dashboard account where your current database is hosted
  3. Make sure the UI for the application is working fine and there are no critical errors detected in the application logs
  4. Use the same software version when deploying on Elestio

Export Process​

  1. Access your phpMyAdmin UI with admin credentials
  2. Select your database to see all tables
  3. Click on the "Export" option from the top menu
  4. Choose "Quick" export or "Custom" for advanced options
  5. Select SQL format and click "Export"
  6. Save the .sql file to your local machine

Import Process​

  1. Deploy MySQL service on Elestio
  2. Access phpMyAdmin using provided credentials
  3. Create a new database for your imported data
  4. Click on the database and select "Import"
  5. Choose your .sql file and configure import settings
  6. Click "Import" to start the process
  7. Verify tables and data after import completion

Troubleshooting Common Issues​

Connection Issues​

  • Problem: Cannot connect to source database
  • Solution: Verify firewall settings, credentials, and network accessibility

Version Compatibility​

  • Problem: Migration fails due to version mismatch
  • Solution: Ensure source and target versions are compatible or use compatibility mode

Large Database Migration​

  • Problem: Migration times out or fails with large datasets
  • Solution: Consider incremental migration or contact support for assistance

Data Integrity Issues​

  • Problem: Data appears corrupted after migration
  • Solution: Verify source database integrity before migration and check migration logs

Need Help?​

For database migration assistance:

  • Create a support ticket
  • Our database experts will provide personalized guidance
  • We offer assisted migration services for complex scenarios