Thanks for the help! I've decided to follow the simple solution as beside the website there are quite some programs and gameservers installed on the dedicated server. Setting them all up again takes atleast a full day which I saldy can't affort as I also have a webshop and alot of traffic on both the TeamSpeak server as the Website itself.
I always respond here as last solution to a error due to many reasons one of these is simply described: I own a webshop containing "software" which I've created so I know how it's like to get a ton of "stupid" questions, not that I mind as I ask them myself way to often haha. The second one is because I usally get complicated anwsers. However, yours make 100% sense which I really like and apriciate
Anyway, the webserver transfer sounds quite good aswell. I'll try that with a copy after I've moved the datadir to /home/mysqldata I'll try googling a bit but if there's something you can add to this solution please dont hestitate
Bedankt!!
[UPDATE]
After following the steps of the simple solution I've got the following error when browsing for the website:
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /var/www/html/wp-includes/wp-db.php on line 1520
Here's what I did:
service mariadb stop
service httpd stop
cd /var/lib/mysql
cp -p -r * /home/mysql
cd /etc
vim my.cnf
Changed:
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
to:
datadir=/home/mysql
socket=/home/mysql/mysql.sock
wq!
cd /home
chown 27:27 mysql
service mariadb start
service httpd start
Here's the var/log/mariadb file:
160531 18:26:46 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
160531 18:28:41 mysqld_safe Starting mysqld daemon with databases from /home/mysql
160531 18:28:41 [Note] /usr/libexec/mysqld (mysqld 5.5.47-MariaDB) starting as process 17131 ...
160531 18:28:41 InnoDB: The InnoDB memory heap is disabled
160531 18:28:41 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160531 18:28:41 InnoDB: Compressed tables use zlib 1.2.7
160531 18:28:41 InnoDB: Using Linux native AIO
160531 18:28:41 InnoDB: Initializing buffer pool, size = 128.0M
160531 18:28:41 InnoDB: Completed initialization of buffer pool
160531 18:28:41 InnoDB: highest supported file format is Barracuda.
160531 18:28:41 InnoDB: Waiting for the background threads to start
160531 18:28:42 Percona XtraDB (
http://www.percona.com) 5.5.46-MariaDB-37.6 started; log sequence number 5620780694
160531 18:28:42 [Note] Plugin 'FEEDBACK' is disabled.
160531 18:28:42 [Note] Server socket created on IP: '0.0.0.0'.
160531 18:28:42 [Note] Event Scheduler: Loaded 0 events
160531 18:28:42 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.47-MariaDB' socket: '/home/mysql/mysql.sock' port: 3306 MariaDB Server
my.cnf
[mysqld]
datadir=/home/mysql/mysql
socket=/home/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in
http://fedoraproject.org/wiki/Systemd
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
website:
www.craftrealms.org
[SOLUTION]
as mysql user:
ln -s /home/mysql/mysql.sock /var/lib/mysql/mysql.sock