Replace MySQL with MemCP

From MemCP
Revision as of 11:17, 31 October 2024 by Carli (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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")