25 lines
1.2 KiB
Bash
25 lines
1.2 KiB
Bash
#!/bin/bash
|
|
if [[ ! -f /usr/local/mysql/bin/mariadbd ]]; then
|
|
echo "Baza danych nie jest zainstalowana"
|
|
exit 1
|
|
else
|
|
dbuser=$(ls -la "/usr/local/mysql" | awk {'print $3'} | uniq -c | awk 'int($1)>=2' | awk '{print $2}')
|
|
dbport=$(ps auxf | grep mariadbd | awk {'print $23'} | awk -F '=' {'print $2'})
|
|
dbver1=$(curl https://mariadb.com/kb/en/changes-improvements-in-mariadb-106/ | grep -Eo 'MariaDB 10.6.([0-9])' | head -1 | awk '{print $2}')
|
|
dbver2=$(cat /etc/db-version)
|
|
if [[ "$dbver1" == "$dbver2" ]]; then
|
|
exit 1
|
|
else
|
|
while [[ $(ps -A | grep mariadbd) ]]; do
|
|
killall -15 mariadbd
|
|
done
|
|
cd /usr/local/ && tar -czvf mysql-server.tar.gz mysql
|
|
wget https://mirror.vpsfree.cz/mariadb//mariadb-"$dbver1"/bintar-linux-systemd-x86_64/mariadb-"$dbver1"-linux-systemd-x86_64.tar.gz -O /usr/local/mysql/mariadb.tar.gz
|
|
cd /usr/local/mysql/ && tar -xzvf mariadb.tar.gz --strip-components 1
|
|
echo "$dbver1" > /etc/db-version
|
|
sleep 2
|
|
chown -R "$dbuser":"$dbuser" /usr/local/mysql
|
|
cd /usr/local/mysql && ./bin/mysqld_safe --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --user="$dbuser" --log-error=/usr/local/mysql/data/mysql.err --pid-file=/usr/local/mysql/mysql.pid --secure-file-priv=/usr/local/mysql/mysql_secure --socket=/usr/local/mysql/thesock --port="$dbport" &
|
|
fi
|
|
fi
|