{"id":3842,"date":"2025-08-29T05:32:38","date_gmt":"2025-08-29T05:32:38","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=3842"},"modified":"2026-07-25T05:14:01","modified_gmt":"2026-07-25T05:14:01","slug":"copy-mysql-tables","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/mysqlcopier\/copy-mysql-tables.html","title":{"rendered":"Copy MySQL tables between databases"},"content":{"rendered":"<p>Want to clone  <a href=\"https:\/\/www.mysql.com\/\">MySQL<\/a>  tables, or copy data in  <a href=\"https:\/\/www.mysql.com\/\">MySQL<\/a>  tables from one database to another?<\/p>\n<p>Try Withdata <a href=\"https:\/\/www.withdata.com\/db-copier\/\">DB Copier<\/a>, a desktop MySQL data transfer for Windows, MacOS, and Linux, Clone MySQL tables, Copy data in MySQL tables between databases, East and Fast.<\/p>\n<ul>\n<li>Can run in <span id=\"gui\">GUI<\/span> mode, <a href=\"#copy\">Step by Step<\/a>, just a few mouse clicks.<\/li>\n<li>Can run in <a href=\"\/tools\/db-to-db\/copy-between-mysql-cmd\" target=\"_blank\">Command line<\/a>, for <a href=\"\/tools\/db-to-db\/copy-between-mysql-task\" target=\"_blank\">Scheduled Tasks<\/a> and Streams.<\/li>\n<li>Support <a href=\"\/tools\/db-to-db\/copy-between-mysql-windows\" target=\"_blank\">Windows<\/a>, <a href=\"\/tools\/db-to-db\/copy-between-mysql-linux\" target=\"_blank\">Linux<\/a>, and <a href=\"\/tools\/db-to-db\/copy-between-mysql-macos\" target=\"_blank\">macOS<\/a>.<\/li>\n<\/ul>\n<p><a href=\"#download-top\" onclick=\"dtv.style.display = 'block';\">Download Withdata DBCopier<\/a>  <a href=\"#download-top\" onclick=\"dtv.style.display = 'block';\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/download_3.jpg\" alt=\"Download DBCopier\" width=\"80\" height=\"22\" style=\"max-width:100%;height:auto;\" \/><\/a> <span id=\"dtv\" style=\"display: none;\"><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=win64\">Windows 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=win32\">Windows 32 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=deb\">Linux .deb (For Debian, Ubuntu) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=rpm\">Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=pkg\">MacOS 64 bit<\/a><br \/>\n<\/span><\/p>\n<h2 id=\"copy\">Copy MySQL tables between databases<\/h2>\n<p><a href=\"#login\">Login to source and target MySQL<\/a> -> <a href=\"#source\">Select MySQL tables to copy<\/a> -> <a href=\"#do\">Copy data between MySQL databases<\/a><\/p>\n<p id=\"login\"> Choose source\/target MySQL database and logon.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/logon\/choose_mysql_logon.png\" alt=\"copy data between MySQL  (MariaDB, Percona) databases - Choose MySQL and logon\" width=\"430\" height=\"442\" style=\"max-width:100%;height:auto;display:block;\" \/><\/p>\n<p>Click &#8220;Convert All Tables&#8221; at task dialog.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_a_1.png\" alt=\"Batch copy data from one MySQL tables to another MySQL - Task Window\" width=\"636\" height=\"479\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>then show the wizard.<\/p>\n<h3 id=\"source\">1. Select source MySQL tables.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_batch_source_has-schema.png\" alt=\"Batch copy tables data from one MySQL to another - select tables\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<h3>2. List target MySQL tables.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_batch_target_has-schema.png\" alt=\"Batch convert data from one MySQL tables to another MySQL - select destination schema\" width=\"724\" height=\"573\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<h3>3. Select target MySQL tables to copy data.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_batch_map.png\" alt=\"Batch import data from one MySQL tables to another MySQL - select tables\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<h3 id=\"do\">4. Copy MySQL tables between databases.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_batch_convert.png\" alt=\"Batch transfer data from one MySQL tables to another MySQL - import\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<hr style=\"clear: both;\" \/>\n<p>More about <a href=\"\/tools\/db-to-db\/copy-between-mysql\">MySQL Copier<\/a><\/p>\n<div id=\"download-bottom\" style=\"clear: both;\">\n<p>Download Withdata DBCopier<a href=\"#download-bottom\" onclick=\"dbv.style.display = 'block';\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/btn_download_green.png\" alt=\"Download DBCopier\" width=\"165\" height=\"50\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/><\/a> <span id=\"dbv\" style=\"display: none;\"><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=win64\">Windows 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=win32\">Windows 32 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=deb\">Linux .deb (For Debian, Ubuntu) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=rpm\">Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBCopier&#038;ver=pkg\">MacOS 64 bit<\/a><br \/>\n<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Want to clone MySQL tables, or copy data in MySQL tables from one database to another? Try Withdata DB Copier, a desktop MySQL data transfer for Windows, MacOS, and Linux, Clone MySQL tables, Copy data in MySQL tables between databases, East and Fast. Can run in GUI mode, Step by Step, just a few mouse [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1462],"tags":[13305,1323],"class_list":["post-3842","post","type-post","status-publish","format-standard","hentry","category-mysqlcopier","tag-batch-copy","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3842","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=3842"}],"version-history":[{"count":19,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3842\/revisions"}],"predecessor-version":[{"id":45120,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3842\/revisions\/45120"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=3842"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=3842"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=3842"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}