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

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.