Migration from MySQL and PostgreSQL - Revision history

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>.