{"id":3814,"date":"2025-08-29T05:29:23","date_gmt":"2025-08-29T05:29:23","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=3814"},"modified":"2026-07-25T05:14:01","modified_gmt":"2026-07-25T05:14:01","slug":"copy-mysql-table","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/mysqlcopier\/copy-mysql-table.html","title":{"rendered":"Copy table in one MySQL or between MySQL databases"},"content":{"rendered":"<p>Want to clone  <a href=\"https:\/\/www.mysql.com\/\">MySQL<\/a>  table, or copy data between  <a href=\"https:\/\/www.mysql.com\/\">MySQL<\/a>  table?<\/p>\n<p>Using Withdata <a href=\"https:\/\/www.withdata.com\/db-copier\/\">DB Copier<\/a>, a desktop MySQL data transfer for Windows, MacOS, and Linux, Clone MySQL table, or copy data between MySQL table, in one MySQL, or between MySQL databases, Easy 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 table from one MySQL database to another<\/h2>\n<p><a href=\"#login\">Login to source and target MySQL<\/a> -> <a href=\"#source\">Choose source MySQL table<\/a> -> <a href=\"#target\">Set target MySQL table<\/a> -> <a href=\"#do\">Copy MySQL data<\/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) - Choose MySQL and logon\" width=\"430\" height=\"442\" style=\"max-width:100%;height:auto;display:block;\" \/><\/p>\n<p>Click &#8220;Convert From Table&#8221; at task dialog.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_a_1.png\" alt=\"Load data from one MySQL table to another MySQL table - 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. Open a source MySQL table.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_open_table_has-schema.png\" ALT=\"Import data from one MySQL table to another MySQL - Open Source\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<h3 id=\"target\">2. Select or create a destination MySQL table and config fields.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/wizard_select_table_has-schema.png\" ALT=\"Move data from one MySQL table to another MySQL - select table\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<h3>3. Preview data, Config rows.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/table-to-table-preview.png\" ALT=\"Transfer data from one MySQL table to another MySQL - preview\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<h3 id=\"do\">4. Copy MySQL table data.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/dbcopier\/table-to-table-convert.png\" ALT=\"Send data from one MySQL table to another MySQL - copy\" 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 table, or copy data between MySQL table? Using Withdata DB Copier, a desktop MySQL data transfer for Windows, MacOS, and Linux, Clone MySQL table, or copy data between MySQL table, in one MySQL, or between MySQL databases, Easy and Fast. Can run in GUI mode, Step by Step, just a few [&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":[13307,1323],"class_list":["post-3814","post","type-post","status-publish","format-standard","hentry","category-mysqlcopier","tag-copy-table","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3814","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=3814"}],"version-history":[{"count":21,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3814\/revisions"}],"predecessor-version":[{"id":45113,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3814\/revisions\/45113"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=3814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=3814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=3814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}