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.
- Can run in GUI mode, Step by Step, just a few mouse clicks.
- Can run in Command line, for Scheduled Tasks and Streams.
Download DBCopier
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit
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.
Click “Convert All Tables” at task dialog.
then show the wizard.
1. Select source MySQL tables.
2. List target MySQL tables.
3. Select target MySQL tables to copy data.
4. Copy data between MySQL.
Copy MySQL tables in command line
Save “Copy MySQL tables” session, then you can:
- Copy MySQL tables in Windows command line.
- Copy MySQL tables in Linux command line.
- Copy MySQL tables in macOS command line.
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.