Hello!
I need some advice please.

I have to extract a light version of a quite big database, which has to be used for development.
I have to change-replace fields like email, physical address with dummy values.
The second thing is to change the records with files (blobs) to have a dummy doc inside instead of the original one.

I do not have too much space left on the db machine, so i was thinking about extracting the contents of the db in text format. I studied mysqldump options, but none seems to allow somehow the use of a select in it.

Thank you very much.

Maybe you could use INSERT INTO temp_table SELECT ... (http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html) then REPLACE the data in temp_table then SELECT INTO OUTFILE (http://dev.mysql.com/doc/mysql/en/SELECT.html) from the temp_table out to a file. Then development can easily LOAD DATA INFILE that file.