Convert MySQL db character encoding set
Converting mysql character set type
tech notes from my desk
Converting mysql character set type
Need to backup all the databases daily mysqldump --all-databases --single-transaction --quick --lock-tables=false > full-backup-$(date +%F).sql -u root -p Then edit in home directory a login connection file .mylogin.cnf vi /home/admin/.mylogin.cnf [client] user = root password = "the db password" Limit…
Log into MySQL $ mysql -u root -p Enter the password and to select the database mysql> use wordpress;mysql> show tables; Next step is to update: mysql> update wp_options set option_value = 'http://www.kewrunner.name' where option_id = 1; Check to verify…
Connect into mysql from terminal $ sudo mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 25680 Server version: 10.3.22-MariaDB-1ubuntu1 Ubuntu 20.04 Copyright (c) 2000, 2018, Oracle,…
Ever wanted to make your own systems inventory database but just didnt really want to invest the time in making all the mysql statements (huh? no?! well me neither but this is one of those system inventory databases that we…