Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Location
    timisoara, romania
    Posts
    2

    Unanswered: using a select in mysqldump

    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.

  2. #2
    Join Date
    Dec 2004
    Posts
    26
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •