Sync data from MySQL to MariaDB

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


More about MySQL to MariaDB converter

See also:

MySQL → MariaDB reference

Command line

SideCommand
MySQLmysqldump, or mysql -e "SELECT ..." > out.csv
MariaDBmariadb-dump
MariaDB (load)mariadb-import, or LOAD DATA INFILE
MySQL (load)mysqlimport, or LOAD DATA INFILE

Convert your data online, free

Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.


Posted

in

by

Tags: