Migration from MySQL and PostgreSQL - Revision history

Wikiservice: Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference

2026-08-28T10:14:01Z

Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference

← Older revision		Revision as of 12:14, 28 August 2026
Line 15:		Line 15:
	== Live import ==		== Live import ==

	<~~syntaxhighlight lang="scheme"~~>; MySQL: host/port nil use 127.0.0.1:3306		<pre>; MySQL: host/port nil use 127.0.0.1:3306
	(mysql_import nil nil "import_user" "secret" "source_db" "target_db")		(mysql_import nil nil "import_user" "secret" "source_db" "target_db")

	; PostgreSQL: database, source schema, target database		; PostgreSQL: database, source schema, target database
	(psql_import nil nil "postgres" "secret" "source_db" "public" "target_db")</~~syntaxhighlight~~>		(psql_import nil nil "postgres" "secret" "source_db" "public" "target_db")</pre>
	Optional trailing arguments select or rename individual tables. Use a least-privilege read-only source account and protect credentials from shell and process listings.		Optional trailing arguments select or rename individual tables. Use a least-privilege read-only source account and protect credentials from shell and process listings.

Line 27:		Line 27:
	<code>load_sql</code> reads MySQL SQL; <code>load_psql</code> reads PostgreSQL SQL and supported pg_dump/archive inputs. A compressed input must be decompressed (<code>zcat</code>/<code>xzcat</code>), not passed through the <code>gzip</code>/<code>xz</code> compression functions.		<code>load_sql</code> reads MySQL SQL; <code>load_psql</code> reads PostgreSQL SQL and supported pg_dump/archive inputs. A compressed input must be decompressed (<code>zcat</code>/<code>xzcat</code>), not passed through the <code>gzip</code>/<code>xz</code> compression functions.

	<~~syntaxhighlight lang="bash"~~>gzip -dk dump.sql.gz		<pre>gzip -dk dump.sql.gz
	# Then in the MemCP console:		# Then in the MemCP console:
	# (load_sql "target_db" (stream "dump.sql"))</~~syntaxhighlight~~>		# (load_sql "target_db" (stream "dump.sql"))</pre>

	For large or live migrations, prefer the importer functions above rather than assuming every vendor-specific dump statement is accepted.		For large or live migrations, prefer the importer functions above rather than assuming every vendor-specific dump statement is accepted.
Line 36:		Line 36:
	== Application connection ==		== Application connection ==

	<~~syntaxhighlight lang="php"~~>$db = new PDO(		<pre>$db = new PDO(
	'mysql:host=127.0.0.1;port=3307;dbname=target_db',		'mysql:host=127.0.0.1;port=3307;dbname=target_db',
	'root',		'root',
	'strong-password'		'strong-password'
	);		);
	echo $db->query("SELECT 'it works'")->fetchColumn();</~~syntaxhighlight~~>		echo $db->query("SELECT 'it works'")->fetchColumn();</pre>
	PostgreSQL SQL syntax is available over <code>/psql/<database></code>; MemCP does not expose a PostgreSQL wire-protocol port.		PostgreSQL SQL syntax is available over <code>/psql/<database></code>; MemCP does not expose a PostgreSQL wire-protocol port.

Wikiservice: Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference

2026-08-28T09:59:33Z

Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference

@@ Line 1: / Line 1: @@
-[[File:Ports.svg|thumb|none|640x640px]]
+<!-- Copyright (C) 2026 Carl-Philip Haensch -->
-=== Connection to MemCP from PostgreSQL ===
+<!-- SPDX-License-Identifier: GPL-3.0-or-later -->
-Or, switch over to the  [[SQL over REST|REST connector]].
+<span id="migration-from-mysql-and-postgresql"></span>
-===Import data from MySQL and PostgreSQL===
+Migration is a compatibility and operations project, not only a data copy. MemCP can import through live MySQL/PostgreSQL connections or supported dump formats, while applications connect through the MySQL protocol or the HTTP SQL endpoints. It does not expose a PostgreSQL wire-protocol server and does not claim complete syntax, metadata, type, or administration compatibility with either source system.
-=== Further Reading ===
+Keep the source database authoritative until schema translation, row counts, constraints, representative queries, writes, timezone behavior, and restart recovery have been validated. Measure import duration and application latency with successful results, retain a rollback path, and separately design ongoing change capture when the source continues receiving writes during a staged migration.
-* [[Deployment]]
+[[File:Ports.svg|thumb|none|640px|MemCP client and import connection paths]]

Carli at 18:33, 20 November 2024

2024-11-20T18:33:41Z

← Older revision		Revision as of 20:33, 20 November 2024
Line 13:		Line 13:

	===Import data from MySQL and PostgreSQL===		===Import data from MySQL and PostgreSQL===
	To import data from MySQL into MemCP, you have to perform the following command in<code>memcp</code>console:		To import data from MySQL into MemCP, you have to perform the following command in[[MemCP Console\|<code>memcp</code>console]]:
	(load_sql "database" (stream "dump.sql")) /* for PostgreSQL mode, use load_psql instead */		(load_sql "database" (stream "dump.sql")) /* for PostgreSQL mode, use load_psql instead */
	When the sqldump is zipped, use:		When the sqldump is zipped, use:

Carli: /* Connection to MemCP from PostgreSQL */

2024-11-20T18:31:37Z

Connection to MemCP from PostgreSQL

← Older revision		Revision as of 20:31, 20 November 2024
Line 8:		Line 8:

	=== Connection to MemCP from PostgreSQL ===		=== Connection to MemCP from PostgreSQL ===
	For postgresql, just switch over to a mysql connector (odbc and PDO both support multiple databases) and send<code>SET syntax = 'postgresql'</code>		For postgresql, just switch over to a mysql connector (odbc and PDO both support multiple databases) and send<code>SET syntax = 'postgresql'</code>at the very beginning of your session

	Or, switch over to the [[SQL over REST\|REST connector]].		Or, switch over to the [[SQL over REST\|REST connector]].

Carli at 18:20, 20 November 2024

2024-11-20T18:20:52Z

← Older revision		Revision as of 20:20, 20 November 2024
Line 20:		Line 20:
	(load_sql "database" (xz (stream "dump.sql"))) /* for PostgreSQL mode, use load_psql instead */		(load_sql "database" (xz (stream "dump.sql"))) /* for PostgreSQL mode, use load_psql instead */
	The dumps can be created with <code>mysqldump</code>or <code>pg_dump</code>.		The dumps can be created with <code>mysqldump</code>or <code>pg_dump</code>.

			=== Further Reading ===

			* [[Deployment]]

Carli: /* Connection to MemCP from PostgreSQL */

2024-11-20T18:19:41Z

Connection to MemCP from PostgreSQL

← Older revision		Revision as of 20:19, 20 November 2024
Line 8:		Line 8:

	=== Connection to MemCP from PostgreSQL ===		=== Connection to MemCP from PostgreSQL ===
	For postgresql, just switch over to a mysql connector (odbc and PDO both support multiple databases) and send<code>SET syntax = 'postgresql'</code> ~~(TODO: not yet implemented)~~		For postgresql, just switch over to a mysql connector (odbc and PDO both support multiple databases) and send<code>SET syntax = 'postgresql'</code>

	Or, switch over to the [[SQL over REST\|REST connector]].		Or, switch over to the [[SQL over REST\|REST connector]].

Carli: /* Connection to MemCP from PostgreSQL */

2024-11-20T18:19:29Z

Connection to MemCP from PostgreSQL

← Older revision		Revision as of 20:19, 20 November 2024
Line 8:		Line 8:

	=== Connection to MemCP from PostgreSQL ===		=== Connection to MemCP from PostgreSQL ===
	For postgresql, just switch over to a mysql connector (odbc and PDO both support multiple databases) and send<code>SET syntax = "postgresql</code> (TODO: not yet implemented)		For postgresql, just switch over to a mysql connector (odbc and PDO both support multiple databases) and send<code>SET syntax = 'postgresql'</code> (TODO: not yet implemented)

	Or, switch over to the [[SQL over REST\|REST connector]].		Or, switch over to the [[SQL over REST\|REST connector]].

Carli: /* Connection to MemCP via MySQL Connector */

2024-11-20T18:18:29Z

Connection to MemCP via MySQL Connector

← Older revision		Revision as of 20:18, 20 November 2024
Line 6:		Line 6:

	// outouts: it works		// outouts: it works

			=== Connection to MemCP from PostgreSQL ===
			For postgresql, just switch over to a mysql connector (odbc and PDO both support multiple databases) and send<code>SET syntax = "postgresql</code> (TODO: not yet implemented)

			Or, switch over to the [[SQL over REST\|REST connector]].

	===Import data from MySQL and PostgreSQL===		===Import data from MySQL and PostgreSQL===
	To import data from MySQL into MemCP, you have to perform the following command in<code>memcp</code>console:		To import data from MySQL into MemCP, you have to perform the following command in<code>memcp</code>console:

Carli: Created page with "640x640px ===Connection to MemCP via MySQL Connector=== MemCP can be connected with any compatible MySQL connector: $db = new \PDO`"mysql:host=localhost;port=3307;dbname=system", 'root', 'admin');` echo $db->query("SELECT 'it works'")->fetchColumn(); // outouts: it works ===Import data from MySQL and PostgreSQL=== To import data from MySQL into MemCP, you have to perform the following command in`memcp`console: (l..."

2024-11-20T18:15:24Z

Created page with "thumb|none|640x640px ===Connection to MemCP via MySQL Connector=== MemCP can be connected with any compatible MySQL connector: $db = new \PDO<code>"mysql:host=localhost;port=3307;dbname=system", 'root', 'admin');</code> echo $db->query("SELECT 'it works'")->fetchColumn(); // outouts: it works ===Import data from MySQL and PostgreSQL=== To import data from MySQL into MemCP, you have to perform the following command in<code>memcp</code>console: (l..."

New page

[[File:Ports.svg|thumb|none|640x640px]]
===Connection to MemCP via MySQL Connector===
MemCP can be connected with any compatible MySQL connector:
$db = new \PDO<code>"mysql:host=localhost;port=3307;dbname=system", 'root', 'admin');</code>
echo $db->query("SELECT 'it works'")->fetchColumn();

// outouts: it works
===Import data from MySQL and PostgreSQL===
To import data from MySQL into MemCP, you have to perform the following command in<code>memcp</code>console:
(load_sql "database" (stream "dump.sql")) /* for PostgreSQL mode, use load_psql instead */
When the sqldump is zipped, use:
(load_sql "database" (gzip (stream "dump.sql"))) /* for PostgreSQL mode, use load_psql instead */
or:
(load_sql "database" (xz (stream "dump.sql"))) /* for PostgreSQL mode, use load_psql instead */
The dumps can be created with <code>mysqldump</code>or <code>pg_dump</code>.