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 seem to allow somehow the use of a select in it.