https://htyp.org/mw/index.php?action=history&feed=atom&title=MySQL%2Fmigration%2FCLI 2026-06-24T22:44:59Z Revision history for this page on the wiki MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=MySQL/migration/CLI&diff=29346&oldid=prev 2026-02-25T01:44:36Z

<p>Created page with &quot;{{fmt/title|MySQL migration using CLI}} ==About== There are two parts to the migration process: exporting data (generating an importable file from the source database server)...&quot;</p> <p><b>New page</b></p><div>{{fmt/title|MySQL migration using CLI}}<br /> ==About==<br /> There are two parts to the migration process: exporting data (generating an importable file from the source database server) and importing data (converting a file into a database on the server).<br /> * &#039;&#039;&#039;Export&#039;&#039;&#039;: There is a utility program, [[mysqldump]], which is specifically for handling this task. (It may be possible to replicate everything it does via SQL, but there&#039;s a lot of information in comments, and perhaps even pragma-code, which would be difficult to replicate precisely; I&#039;m not sure if this is documented anywhere.)<br /> * &#039;&#039;&#039;[[/Import/]]&#039;&#039;&#039;: This is basically just running mysql from CLI and then piping in the entire contents of the exported &lt;code&gt;.sql&lt;/code&gt; file.</div>

Woozle