sudo systemctl stop mysql
sudo systemctl status mysql
Rsync to new location
sudo rsync -av /var/lib/mysql /mnt/new_disk/
mv original dir
sudo mv /var/lib/mysql /var/lib/mysql.bak
edit the mysql.cnf file
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
find datadir and change to new location
datadir = /mnt/new_disk/mysql
edit apparmor file (for ubuntu)
sudo nano /etc/apparmor.d/tunables/alias
change/add the following line
alias /var/lib/mysql/ -> /mnt/new_disk/mysql/,
restart everything
sudo systemctl restart apparmor
sudo systemctl start mysql
Of course, I forgot that the mounted drive is ntfs so I could access from my dual boot windows side (rarely if ever used), so the owner of the files/directories can’t be changed. Sigh… putting everything back.
😵😵😵😵😵😵😵😵😵😵😵😵😵😵😵😵😵😵😵😵😵😵
So, I ended up resizing the ntfs partition, making an ext4 partition in the leftover space, and moving mysql to that partition. Also, before doing all that, I rsync’d all the data to another system/drive.
So i tried moving it within the file, I tried adding the same thing to global-redtailban.conf in apache2/conf-available and running a2enconf global-redtailban, also didn’t work.
So I finally found something that said to add this to the apache2.conf file (replacing BadBot with the one I want to ban):
<If "%{HTTP_USER_AGENT} == 'BadBot'">
Require all denied
</If>
After discovering a number of issues, and having to fix network problems, I again tried to get the dual-wan up and running. I was successful, but the speed dropped from either WAN connection from about 900Mbps download (and 40Mbps upload) to 80Mbps give or take 15 for download, and 10-20Mbps upload. So I ran some more testing, and finally came up with a compromise setup, where everything can stay the same, except the gateway used will need to be changed on systems from 10.0.0.1 to 10.0.0.2. All else can remain the same. Oh, and it needs to be updated on local LAN dns server pintobean.
Something that runs around 6:19am on vps is shutting down apache2, then trying to restart/graceful restart it, but the restart fails because it runs BEFORE apache2 shuts down.
I’m currently attempting to edit /etc/needrestart/needrestart.conf (found this after hours of searching):
changed this:
#$nrconf{restart} = ‘i’;
to this:
$nrconf{restart} = ‘a’;
Fingers crossed.
Also, added this block to /etc/apt/apt.conf.d/50unattended-upgrades