[SOLVED] MySQL ERROR 1114 (HY000) The table is full – How To Solve in XAMPP?

MySQL ERROR 1114 (HY000) The table is full - How To Solve in XAMPP

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.

innodb_data_file_path=ibdata1:25M:autoextend:max:512M

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
Click the Config button to open the MySQL config file

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.

Share This Post

Subscribe To my Future Posts

Get notified whenever I post something new

More To Explore

How To Use Google SIgn In In Flutter
Blog

How To Use Google Sign In Flutter?

This topic is divided into 2 parts. The parts are as follows: 1 – Creating a Firebase Project 2 – Configuring the Flutter app and