mysql startet nicht und "forbidden" bei Websites

[SoFa7]

Hallo! habe da ein problem... Seitdem ich ein Datenbank Backup-Script getestet habe gehen meine Seiten sowie phpmyadmin nicht mehr ... da steht nur "forbidden". kann mich auch nicht mit dem website user per FTP anmelden ... Mysql Log :


160907 20:10:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160907 20:10:34 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
160907 20:10:34 [Note] /usr/sbin/mysqld (mysqld 5.5.50-0+deb8u1) starting as process 27449 ...
160907 20:10:34 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
160907 20:10:34 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'plugin' is read only
160907 20:10:34 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
160907 20:10:34 InnoDB: The InnoDB memory heap is disabled
160907 20:10:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160907 20:10:34 InnoDB: Compressed tables use zlib 1.2.8
160907 20:10:34 InnoDB: Using Linux native AIO
/usr/sbin/mysqld: Can't create/write to file '/tmp/ibVCxKO4' (Errcode: 13)
160907 20:10:34 InnoDB: Error: unable to create temporary file; errno: 13
160907 20:10:34 [ERROR] Plugin 'InnoDB' init function returned error.
160907 20:10:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160907 20:10:34 [ERROR] Unknown/unsupported storage engine: InnoDB
160907 20:10:34 [ERROR] Aborting

160907 20:10:34 [Note] /usr/sbin/mysqld: Shutdown complete

160907 20:10:34 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended


mit dem befehl "service mysql start" kommt nach einigen Sekunden das :

Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.


Was ist das ? was tun ? :/ Bitte um Hilfe ! Danke.

 

[akretschmer]

Was ist an "160907 20:10:34 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. " unverständlich?

Allerdings ist mir unverständlich, wie ein Backup-Script zu solch einem Fehler führt. Aber hey, MySQL ...

 

[SoFa7]

Wie starte ich das denn?

 

[akretschmer]

einfach aufrufen?

Was hast Du denn überhaupt getan? Wir können hier nur rätseln...

 

[SoFa7]

Da kommt :


root@vps:~# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Error: Failed while fetching Server version! Could be due to unauthorized access.
FATAL ERROR: Upgrade failed


Habe das Script ausgeführt :

#!/bin/bash
set -o pipefail

target_dir=/var/lib/btsync/Shares/backup/mysql

keep=5

MyUSER=backup
MyHOST=localhost
MyPASS=Bjwdh6jg
MyOPTS="--single-transaction --add-drop-database --add-locks --routines --triggers --events --default-character-set=utf8"

MYSQL="$(which mysql)"
MYSQLDUMP="$(which mysqldump)"
GZIP="$(which gzip)"

mkdir -p $target_dir
chmod 770 $(dirname $target_dir)

# do backup
$MYSQLDUMP --all-databases -u $MyUSER -h $MyHOST -p$MyPASS $MyOPTS | $GZIP -9 > $target_dir/$(date +%Y%m%d-%H%M).sql.gz

if [ $? != 0 ]; then
echo "$(hostname -s) backup_mysql 2 Backup of MySQL failed!" | /usr/sbin/send_nsca
exit 1
fi

find $target_dir -type f -mtime +$keep -exec rm {} \;
find $target_dir -depth -type d -empty -exec rmdir {}

 

[akretschmer]

Strange. Wenn davon MySQL kaputt geht dann sollte man was besseres nutzen ;-)

Sorry, ich kann hier nicht weiter helfen. Sieht aber so aus, als ob es neu installiert werden will.