ZoneMinder Forums

I wanted to move my ZM to a laptop, Both Linux Mint 23, ZM desktop (old) to Laptop. Mariadb 10.x
On the PC I used timeshift and restored it to the laptop, it was a horror show!
On the PC, exported db with phpmyadmin, imported it to the laptop, no go, localhost error, triggers, and duplicate keys failed.
I cant use Heidisql on Linux, not made for it.
I didn't care about the events, I exported "config, monitors, and zones." Sill failed, trigger import issue.
My main PC is Win 11 and I use nomachine. I am trying to avoid copying/paste between the two windows. Need Identical setup.

Any solutions, maybe Maria db in terminal to restore zm.sql?

Thanks, Jimmy

You have to be a super user to create the triggers, so when importing you have to be root.

Since this is Linux Mint (right?)
sudo -i
cat backup.sql | mysql --defaults-file=/etc/mysql/debian.cnf zm

Thanks, I'm not good with the terminal.
Do you know of a way to get a superuser with Heidi SQL or PhpMyAdmin? I can't find anything.
A while back, I used to be able to import, Config, monitors, and zones.
Jimmy