[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.


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

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

  1. Pingback: How to access phpMyAdmin to connect to AWS Ubuntu Instance?

  2. Pingback: [SOLVED] MySQL ERROR 2002 (HY000): Can't connect to local MySQL server through socket On Amazon Lightsail - Rajiv Verma

Leave a Comment

Your email address will not be published. Required fields are marked *

Subscribe To my Future Posts

Get notified whenever I post something new

More To Explore