Sadržaj

root@sport-plus-osijek:/var/lib/mysql# sudo mkdir -p /var/lib/mysql_backup root@sport-plus-osijek:/var/lib/mysql# sudo cp -r /var/lib/mysql/xxl /var/lib/mysql_backup/xxl root@sport-plus-osijek:/var/lib/mysql# sudo cp -r /var/lib/mysql/xxl1 /var/lib/mysql_backup/xxl1 root@sport-plus-osijek:/var/lib/mysql# sudo cp -r /var/lib/mysql/xxl2 /var/lib/mysql_backup/xxl2

sudo rm /var/lib/mysql/ibtmp1 sudo rm /var/lib/mysql/ib_logfile0 sudo rm /var/lib/mysql/ib_logfile1

sudo tail -n 150 /var/log/mysql/error.log sudo lsof -i :3306 sudo killall -9 mysql sudo killall -9 mariadb sudo killall -9 mysqld sudo killall -9 mysqld_safe

sudo systemctl stop mariadb sudo killall -9 mysqld sudo fuser -k 3306/tcp

sudo chown -R mysql:mysql /var/lib/mysql sudo chown -R mysql:mysql /var/run/mysqld

sudo chown mysql:mysql /var/lib/mysql/xxl/.ibd sudo chown mysql:mysql /var/lib/mysql/xxl1/.ibd sudo chown mysql:mysql /var/lib/mysql/xxl2/*.ibd

sudo cp /var/lib/mysql_backup/xxl/.ibd /var/lib/mysql/xxl/ sudo cp /var/lib/mysql_backup/xxl1/.ibd /var/lib/mysql/xxl1/ sudo cp /var/lib/mysql_backup/xxl2/*.ibd /var/lib/mysql/xxl2/

sudo chown mysql:mysql /var/lib/mysql/xxl/.ibd sudo chown mysql:mysql /var/lib/mysql/xxl1/.ibd sudo chown mysql:mysql /var/lib/mysql/xxl2/*.ibd