I have a raspberry pi with MySql installed which has been working fine for 4 months.
I played with 3 settings on MySql and now it will not start.
I changed innodb_log_file_size to 100MB, innodb_buffer_pool_size to 300MB and innodb_write_io_threads to 8.
Then on a reboot mysql did not restart. If I run /etc/init.d/mysql restart I get the error "the partition with /var/lib/mysql is too full"
The SD card has 19GB of space free.
So I modified the /etc/mysql/my.cnf file to set the settings back then rebooted but still no luck.
What on earth has happened?
Edit----
I am using Raspbian OS
Ok so I think my partitions are as follows
Filesystem Size Avail
rootfs 30G 19G
/dev/root 30G 19G
devtmpfs 235M 235M
tmpfs 49M 49M
tmpfs 5M 5M
tmpfs 98M 98M
/dev/mcblk0p1 56M 38M
I have now tried a new SD Card with a fresh install of raspbian and MySql. I am for some reason getting the same error despite the card only being 29% full. This is on a brand new install trying to start MySql for the first time! What on earth is going on?