Replace MySQL with MemCP

From MemCP
Revision as of 11:04, 31 October 2024 by Carli (talk | contribs)
Jump to navigation Jump to search
MemCP Port.png

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