Sync data from MySQL to MariaDB

by

Want to sync data from MySQL to MariaDB?

Try Withdata DBCopier, a MySQL to MariaDB converter for Windows, Mac, and Linux, Synchronize MySQL to MariaDB, Easy and Fast.

Download Withdata DBCopier Download DBCopier

Synchronize data from MySQL to MariaDB

Login to MySQL and target MariaDB -> Select source MySQL tables -> Set target MariaDB tables -> Sync MySQL data to MariaDB

Choose source MySQL database and logon.

sync MySQL to MariaDB - Choose MySQL and logon

Choose target MariaDB database and logon.

sync MySQL to MariaDB - Choose MariaDB and logon

Click “Wizard – Import All Tables” at task dialog.

sync from MySQL to MariaDB - Task Window

then show the wizard.

1. Select source MySQL tables to sync.

sync from MySQL to MariaDB - Open source database

2. List target MariaDB tables.

Set “Import Type” to “Replace”, it will do a full synchronization.

sync data from MySQL to MariaDB - full synchronization

Or set “Import Type” to “Upsert”, it will do a upsert synchronization.

sync data from MySQL to MariaDB - upsert synchronization

3. Select MariaDB tables to sync.

sync from MySQL to MariaDB - select tables

4. Sync MySQL data to MariaDB.

sync from MySQL to MariaDB - sync

Synchronize data from MySQL to MariaDB in command line

Save “MySQL to MariaDB” session, then you can:

Set scheduled tasks for synchronizing data from MySQL to MariaDB

You can schedule and automate this “MySQL to MariaDB” conversion task by:

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “Sync MySQL to MariaDB” conversion.
  2. Set scheduled task for “Sync MySQL to MariaDB” conversion.

FAQ


More about Withdata DBCopier MySQL to MariaDB Converter

See also: