Migration from MySQL and PostgreSQL

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

Connection to MemCP from PostgreSQL

For postgresql, just switch over to a mysql connector (odbc and PDO both support multiple databases) and sendSET syntax = "postgresql (TODO: not yet implemented)

Or, switch over to the REST connector.

Import data from MySQL and PostgreSQL

To import data from MySQL into MemCP, you have to perform the following command inmemcpconsole:

(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 mysqldumpor pg_dump.