Since I came across this issue several times I thought of blogging about it to save my time and to help any one who might need this advice.

MySQL by default has a row size limit of 64K as at MySQL 5.0. Therefore if you save a file larger than that anything after the max size will not be saved. So do not be surprised if you find the data that is saved to be corrupted.

Obvious solution to this would be to increase the MySQL max_allowed_packet variable to a very high size.

But a more elegant solution would be to break up the large file in to separate rows.Another advantage of this approach is you can read one chunk at a time and stream vs reading the
entire file in to memory.

If you noticed , there were no new posts for the last few months. The reason is I made a big change in my life.

I moved to Canada !!!!!

It is fall now and I can smell the winter coming. I am sure that I will not like winter :(

well, now I am more or less settled and will continue sharing my knowledge!

Why I mentioned it as full remastering is, DSL now offers a convenient way to create your own DSL flavor using DSL extensions. But I prefer full remastering since it gives me more control.

Its mainly through trail and error that I found the steps to significantly change DSL to suit my needs. Of course few links helped me. But nearly at the end of my quest I came across a wonderful book by the creators of DSL, and I think that is the definitive guide you should read if you are interested in remastering.

Negus Live Linux Series The Official Damn Small Linux® Book: The Tiny Adaptable Linux® That Runs on Anything
by Robert Shingledecker; John Andrews; Christopher Negus