Comments - I know this has been asked loads before, but...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Does the
/mnt/database/mysql/
directory exist? Try runningmkdir -p /mnt/database/mysql/
first if you're using a Linux OS.Hi Markus, Simple answer is yes. I have had no trouble getting it to work using the default installation.
Steps taken post successful default installation,
remove error log
rm /var/log/mysql/*
remove original error log
rm /var/log/mysql/*
Add Disk
nano /etc/fstab
addsave and exit
edit my.cnf
nano /etc/mysql/my.cnf
addsave and exit.
Reboot
Try setting
datadir = /mnt/database
, that way it points to the same place to where thersync
was done.Will do! I'm just rebuilding from the latest image (29/11/2017).. Yours Simon M.
OK rebuilt and same result..
here are the steps
All from root
#
#
#
#
Installing MariaDB
#
#
#
#
Installing phpMyAdmin
Test phpmyadmin in the browser:
http://raspberrypi/phpmyadmin/
Super double stop database!service mysql stop && /etc/init.d/mysql stop && systemctl stop mariadb.service && systemctl stop mysql.service && systemctl stop mariadb && systemctl stop mysql
then check for to see if its deadsystemctl is-active mariadb.service
move datarsync -a /var/lib/mysql /mnt/database/
No change, can anyone share there working my.cnf?