 | | | Dumping a "scrubbed " version of the database? Views? | Dumping a "scrubbed " version of the database? Views? 2005-08-23 - By Eric Raymond
Back
For testing purposes we like to get a copy of the database with
sensitive information removed or with it replaced by placeholders.
The way we do this now is to make a copy of the database (dump the
database table structure, create a temp database, dump the data and
load in the data into he temp db), run some SQL on the temp database
which scrubs the sensitive information, and then dump the database
again. The dumping and loading of data is not very efficient.
It strikes me that views would be a perfect way to handle this, but I
suspect that if you mysqldump a view, you just get it's definition. Is
there a way to dump the results of a view as a pseudo table?
--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/java?unsub=mysql@(protected)
|
|
|