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?
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?