Calculating total data size of BLOB column in a table

mysql blob
jatinpreet picture jatinpreet · May 18, 2012 · Viewed 50k times · Source

I have a table with large amounts of BLOB data in a column. I am writing a utility to dump the data to file system. But before dumping, I need to check if necessary space is available on the disk to export all the blob fields throughout the table.

Please suggest an efficient approach to get size of all the blob fields in the table.

Answer

Bud Damyanov picture Bud Damyanov · May 18, 2012

You can use the MySQL function OCTET_LENGTH(your_column_name). See here for more details.

Related questions

How can I store and retrieve images from a MySQL database using PHP?

How can I insert an image in MySQL and then retrieve it using PHP? I have limited experience in either area, and I could use a little code to get me started in figuring this out.

Read More
How to insert image in mysql database(table)?

I want to insert image into a table like CREATE TABLE XX_SAMPLE(ID INT ,IMAGE BLOB); So can you help out form how to insert image into the above table.

Read More
What is the maximum length of data I can put in a BLOB column in MySQL?

What is the maximum length of data I can put in a BLOB column in MySQL?

Read More