Replace MySQL with MemCP

From MemCP
Jump to navigation Jump to search
Ports.svg

Connection to MemCP

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

To import data from MySQL into MemCP, you have to perform two steps:

  1. sudo apt install python3-mysql.connector
  2. in memcp: ./mysqldump-to-json.py -h localhost -u USER -p PASSWORD database > dump.jsonl
  3. in memp's scheme console: (loadJSON "database" "dump.jsonl")
Retrieved from "https://www.memcp.org/index.php?title=Replace_MySQL_with_MemCP&oldid=162"