Want to sync data from MySQL to Percona?
Try Withdata DBCopier, a MySQL to Percona converter for Windows, Mac, and Linux, Synchronize MySQL to Percona, Easy and Fast.
- Can run in GUI mode, Step by Step, just a few mouse clicks.
- Can run in Command line, for Scheduled Tasks and Streams.
- Support Windows, Linux, and macOS.
Synchronize data from MySQL to Percona
Login to MySQL and target Percona -> Select source MySQL tables -> Set target Percona tables -> Sync MySQL data to Percona
Choose source MySQL database and logon.
Choose target Percona database and logon.
Click “Wizard – Import All Tables” at task dialog.
then show the wizard.
1. Select source MySQL tables to sync.
2. List target Percona tables.
Set “Import Type” to “Replace”, it will do a full synchronization.
Or set “Import Type” to “Upsert”, it will do a upsert synchronization.
3. Select Percona tables to sync.
4. Sync MySQL data to Percona.
More about MySQL to Percona converter
Download Withdata DBCopier
See also:
MySQL → Percona reference
Command line
| Side | Command |
|---|---|
| MySQL | mysqldump, or mysql -e "SELECT ..." > out.csv |
| Percona | mysqldump |
| Percona (load) | mysqlimport, 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.
