Batch copy data from one MySQL tables to another MySQL without programming

by

Posted on by

Want to batch copy data from one MySQL tables to another MySQL?

Using Withdata software DB Copier, a MySQL data transfer for Windows, MacOS, and Linux, you can copy data from one MySQL tables to another MySQL in a batch, easily and fast.

Download DBCopier Download DBCopier

Batch copy tables data from one MySQL database to another

Login to source and target MySQL -> Select MySQL tables to copy -> Copy data between MySQL databases

Choose source/target MySQL database and logon.

copy data between MySQL (MariaDB, Percona) databases - Choose MySQL and logon

Click “Convert All Tables” at task dialog.

Batch copy data from one MySQL tables to another MySQL - Task Window

then show the wizard.

1. Select source MySQL tables.

Batch copy tables data from one MySQL to another - select tables

2. List target MySQL tables.

Batch convert data from one MySQL tables to another MySQL - select destination schema

3. Select target MySQL tables to copy data.

Batch import data from one MySQL tables to another MySQL - select tables

4. Copy data between MySQL.

Batch transfer data from one MySQL tables to another MySQL - import

Copy MySQL tables in command line

Save “Copy MySQL tables” session, then you can:

Set scheduled tasks for coping MySQL tables

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

1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.

2) Set scheduled task.

FAQ

More about DBCopier – MySQL Copier