Migrating MySql to larger disk on primary home system

Sunday, August 9, 2026 at 07:27:40

Stop mysql

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.

libredtail

Friday, May 15, 2026 at 17:12:20

Getting scanned on one of the system by libredtail-http. So I’m blocking it on that server.

I tried adding this to apache2.conf, didn’t work:

<IfModule mod_rewrite.c>
    RewriteEngine On
    RewriteCond "%{HTTP_USER_AGENT}" "libredtail-http" [NC]
    RewriteRule ^ - [F,L]
</IfModule>

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>

That seems to have done the trick.

Another new VPS server

Saturday, October 18, 2025 at 02:25:34

svpsdev.e5l.co -
Followed the installations I’ve done in the past, plus the following (main reason for the additional server):

  • apt install cpanminus
  • apt install build-essential
  • apt install libpng-dev
  • apt install ./google-chrome-stable_current_amd64.deb
  • cpanm install WWW::Mechanize::Chrome

Setting up some Git server things

Thursday, May 8, 2025 at 17:09:50

  • Created git user 
    adduser gituser
  • Made starting directory 
    mkdir /usr/local/gitpath
chown git:git /usr/local/gitpath
  • changed to git user 
    su - gituser
  • Created bare repository 
    cd /usr/local/gitpath
git init --bare newrepositoryname

To use on same machine:

  • Log in as user (not gituser) 
  • cd /home/thisuser/
  • mkdir gitstuff
  • cd gitstuff
  • git config --global user.email "thisuser@localhost"
  • git config --global user.name "thisuser"
  • git clone /usr/local/gitpath/newrepositoryname
  • At this point, you have an empty directory. Add files, do ‘git add *’, then ‘git commit’, and it will be pushed to main git path.

To use on different machine (linux anyway): 

  • cd /where/you/want/the/git/stuff/to/go
  • git clone ssh://gituser@gitmachine.com/usr/local/gitpath/newrepositoryname

Additional issues from mysql updates

Sunday, August 4, 2024 at 09:03:09

There was a system hang AGAIN this morning, appears due to memory full issues. The primary thing using memory on the system is mysqld.

System was restarted via VPS console. mysqld was using 47% memory after reboot.

I dug around, found a mysqld setting that should reduce the memory usage. I put the following into /etc/mysql/my.cnf

performance_schema=0

and then performed a restart

systemctl restart mysql

After restarting the process, mysql is using about 18% memory.

Top of Page