Replace MySQL with MemCP
Jump to navigation
Jump to search
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:
sudo apt install python3-mysql.connector
- in
memcp
:./mysqldump-to-json.py -h localhost -u USER -p PASSWORD database > dump.jsonl
- in memp's scheme console: (loadJSON "database" "dump.jsonl")