If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: db lighter version extraction

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