Install some dependencies I was also using devtoolset-8 for GCC 8.3 (default in CentOS 7 is GCC 4.8). I’m guessing GCC 4.8 will probably build OK, but I didn’t test this. Instructions for installing and enabling devtoolset-8 are here. Prepare, acquire, configure, build, install Now, there should be a “sqlitebrowser” command to start the app […]
Installing sqlitebrowser on RHEL7 / CentOS7 Read More »
This seems to come up frequently for me, so thought I’d keep a note up here. Usually, this comes from making a backup some where else via a command like “mysqldump dbname -uusername -ppassword > somebackupfile.sql”. To create a new DB, create a user, grant privileges to the DB, and import the back data, do
Creating MySQL/MariaDB database and user Read More »
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
Transferring all MySQL/MariaDB databases Read More »
I’ve noticed on a couple occasions (on different servers) that MariaDB will “die”. On the first server, this was related to the server running out of memory. I’m not sure about the other server I noticed this on yet. In any case, I simply wrote a small bash script to check the status of MariaDB
Automatically check MariaDB to ensure it is running Read More »