MariaDB Any advice on how to properly save MYSQL/MariaDB data from crash down?

One of my server has MariaDB 10.0.22 just crash, and unable to start .
What adjustment need to do on my.cnf to help this start properly?

Posting error log later.

---

 

Fixed now.

 

Now my question is, how to properly move MYSQL raw data on home folder?
Seems /dev/sda2/ is almost full now :/.

 

I have recovered it now successfully Eva :|.
But /dev/sda2/ is almost full, so next thing to do is move MYSQL data on /home/ folder.

I remember changing some config on my.cnf and manually copying the data.

 

This is hosting a VB4 Forum by the way. With 15GB of Database.
I partition /var/ with 200GB but still almost full right now :/.

 

Learned from you before .
Anything I miss on this Eva?

Code:

npstop
mysqladmin flush-tables
service mysql stop
mkdir -p /home/mysql
cp -a /etc/my.cnf /etc/my.cnf-december2015.bak
sed -i 's|datadir=\/var\/lib\/mysql|datadir=\/home\/mysql|' /etc/my.cnf
sed -i 's|slow_query_log_file=\/var\/lib\/mysql|slow_query_log_file=\/home\/mysql|' /etc/my.cnf
\cp -Rpf /var/lib/mysql/* /home/mysql/
chown mysql:mysql /home/mysql
service mysql start
npstart
mysqlrestart

 

Is it safe to delete this folder now?
/var/lib/mysql (40GB now)

Thanks!

 

I thought it's the best option?
You message seems saying it's not :|.

 

After figuring out the root cause: Nginx - How come my /usr/local/nginx/ has 99GB total? | Centmin Mod Community

All fine now


But I will leave MYSQL data on home folder.