Shulou(Shulou.com)06/01 Report--

The solution to the error code 1114 in mysql? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

The solution to the error code 1114 in mysql: first modify [max_heap_table_size = 256m] [tmp_table_size = 256m] in [my.cnf], and then restart the MySQL service.

The solution to the error code 1114 in mysql:

1. Modify max_heap_table_size = 256m tmp_table_size = 256m in my.cnf to restart the MySQL service

2. Check the innodb_data_file_path = ibdata1:10M:autoextend original size allocation of 10m in my.cnf, and grow automatically when it is exceeded. The maximum growth can be set.

Where innodb_data_home_dir configurable ibdata1 files are stored. You can also configure directories directly in the innodb_data_file_path parameter. If you do not specify home, it will be in the data directory under the MySQL home directory.

Thank you for reading! After reading the above, do you have a general idea of the solution to the error code 1114 in mysql? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.