In the past couple of days, I encountered this error more than once, whenever I tried to add a new user to a database on my local MySQL db.
The fix is easy if you know what and where needs to be done. You need to change the ‘max’ value for the ‘innodb_data_file_path’ key, to something larger and then restart your MySQL db after saving the config file.
For my stack, I use XAMPP and I manage my Apache and MySQL servers via XAMPP.
To fix this ‘table is full’ error, all I had to do is the following:
- Open the MySQL config file via XAMPP
- Do a ‘Ctrl + F’ for the key innodb_data_file_path
- Update the max value to something larger
- Save the file
- Restart the MySQL server
However, in my config file did not have the max data point in the config file.
All I had to do is add the max parameter and give it a significantly high value, like 512M and save the file.
This solved the issue.