Bug #2635 Blob File Size
Submitted: 3 Feb 2004 18:18 Modified: 5 Feb 2004 13:37
Reporter: cirin cecirin Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:3.23.41 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[3 Feb 2004 18:18] cirin cecirin 
Description:
I have a few tables,1 or more of the column is of a blob datatype. The file size is big about 5 Mb and I always do directory backup so that I can transfer the db file to other fresh installation server via ftp.When I delete all existing rows in the table I notice that the db file size remains 5 Mb.This does not happen to other database that does not content blob table.

How to repeat:
Create a database. Create a table at least 1 col is blob. Insert pictures or something into the table, then delete. Observe file size before and after.
[5 Feb 2004 13:37] Alexander Keremidarski 
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php