Import another table into a column in MySQL database. Getting error `TABLE IS FULL`

user_7354882 0
Viewed 52

I'm trying to import a 24 GB table into another table column but i get the error TABLE IS FULL every time i try to import the data. INNODB is the storage engine used and i have already set innodb_file_per_table scheme to autoextend.

I have set innodb_data_file_path to ibdata1:12M:autoextended and have also set the table_size to 512Mb and max_heap_table_size to 512Mb. I'm using MySQL version 5.7.23(64 bit). The database im trying to import contains images in long blob format. Please do let me know if more information is required. Any help is highly appreciated.

innodb mysql database
1 Answers

Your question reads as if you are shoving 24GB into a single column of a single row. That is not possible.

LONGBLOB is limited to 4GB. Furthermore, it is difficult to load anywhere near that much into a single cell due to other buffers, etc.

If you are spreading that 24GB across multiple rows in a single column or some other arrangement, please edit your Question to clarify.

Note about images: When storing an image associated with a row, and that image will be delivered to an HTML page, it is usually more convenient to put the image in a file, then construct <img src=...> to point to the file.

user_17668310
Related