mysql

1

Install and configure a database and a webserver – Migrated to a new server 2 of 4

Posted on by jlim0930

This is the second section in the 4 part series of migrating my server Install and configure the host machine Install and configure a database and webserver – we are here Install and configure a mailserver Install and configure vaultwarden Tie everything back to 1. for backups, misc, etc Dockerized services I will configure a database and a webserver(mainly wordpress container) to listen internally only and not exposed to the outside network. I will also configure a nginx-proxy and letsencrypt to provide the access from the world to the wordpress site and to generate the letsencrypt certificate. Wanted to note… Continue Reading →

0

mysql changing to utf8 and converting DB to utf8

Posted on by jlim0930

by default mysql is installed as latin1 and sometimes it causes problems when your data is not always latin1. Follow the steps to change mysql to utf and also convert existing databases to UTF8 #1 backup your databases and convert it to UTF8 mysqldump -uusername -ppassword -c -e –default-character-set=utf8 –single-transaction –skip-set-charset –add-drop-database -B dbname -r dbname.utf8.dump.sql do this for each of your databases. #2 shutdown mysql service mysqld stop #3 edit /etc/my.cnf ADD to [mysqld] section # init_connect=’SET collation_connection = utf8_unicode_ci’ init_connect=’SET NAMES utf8′ character-set-server=utf8 collation-server=utf8_unicode_ci skip-character-set-client-handshake also [client] default-character-set=utf8 #4 restart mysqld service mysqld start #5 import your databases… Continue Reading →