MySQL-migrate-medo - Teh Forum

<body> <div id="header"> <span class="left"> <span class="back"><a href="lthread_list.php?webtag=DEFAULT"><span class="image mobile_back" title="Back"></span></a></span> <span class="image mobile_logo" title="Beehive Forum Logo"></span> </span> <ul> <li> <a class="reply_all" href="lpost.php?webtag=DEFAULT&reply_to=42796.0&return_msg=42796.7"> <span class="image mobile_reply_all"></span><span class="text">Reply to All</span> </a> </li> <li> <a class="navigation" href="#"> <span class="image mobile_navigation"></span><span class="text">Show messages</span> </a> </li> <li> <a class="main" href="#"><span class="image mobile_menu" title="Menu"></span> </a> </li> </ul> </div> <div class="menu main"> <ul> <li><a href="lthread_list.php?webtag=DEFAULT">Messages</a></li> <li><a href="lpm.php?webtag=DEFAULT">Inbox</a></li> <li><a href="lsearch.php?webtag=DEFAULT">Search</a></li> <li><a href="llogon.php?webtag=DEFAULT">Login</a></li> </ul> </div> <div class="menu navigation"><a href="lmessages.php?webtag=DEFAULT&msg=42796.1">1–7</a></div> <div id="page_content"> <h3 class="thread_title"><a href="index.php?webtag=DEFAULT&amp;msg=42796.7">MySQL-migrate-medo</a> </h3> <div id="messages" data-navigation="42796_7_7_10"> <a name="a42796_7"></a><div class="message" id="message_42796_7"> <div class="message_header"> <div class="message_from"> From: Matt<span class="message_time">14 Jul 2021 15:58</span> <div class="clearer"></div> </div><div class="message_to">To: ANT_THOMAS <span><span class="image post_read" title="Read: 14 Jul 2021 16:33"></span></span> <span class="message_count">7 of 7</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=42796.7">42796.7</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=42796.1">42796.1</a></div> <div class="message_body"> Never tried the differential approach.<br /> <br /> But, you should be able to copy the data between two MySQL instances using just mysqldump and the mysql client by piping the output of the former into the latter. This way it will use the native protocol over the wire and should be quicker than writing to a file, moving/copying it across the network and re-importing it.<br /> <br /> If you configure both connections using <a href="https://dev.mysql.com/doc/refman/5.7/en/mysql-config-editor.html">mysql_config_editor </a>you won't even need all the command line arguments, just enough to tell mysqldump and mysql client which connections to use from the config: <div class="quotetext"><strong>Code:</strong> </div> <pre class="code"> mysqldump --login-path=local database| mysql --login-path=remote</pre> The new server will have to allow connections from remote IP which it doesn't by default (it listens on 127.0.0.1, but you can make it listen on 0.0.0.0 for all connections)</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=42796.7&return_msg=42796.7" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="42796.7"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div></div> </div> </body>