Database

Installing sqlitebrowser on RHEL7 / CentOS7

The cmake3 instructions at https://github.com/sqlitebrowser/sqlitebrowser didn’t work on my RHEL7 dev box, but I tripped across a comment here to use qmake instead: https://github.com/sqlitebrowser/sqlitebrowser/issues/1439 I’ll update the exact package configuration when I try this on a “fresher” system (less build packages already added), but this is what worked for me… sudo yum -y install added …

Installing sqlitebrowser on RHEL7 / CentOS7 Read More »

Transferring all MySQL/MariaDB databases

This command will export everything… mysqldump -u root -p –all-databases –skip-lock-tables > everything.sql This command will import everything (and overwrite old stuff)… mysql -u root -p < everything.sql