Re: Capturing snapshots of content

[Gleb Paharenko]

Hello.

> But I will need to parse the dump output to append every single CREATE
> and INSERT statement to be the new table name. Does mysql cater for
> this or will I have to write a parse script to do this for me?

Probaly instead of parsing the INSERT and CREATE statements, it would
be easier to work with plain files (which mysqldump produces with --tab
option). See:
  http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
  http://dev.mysql.com/doc/refman/5.0/en/load-data.html



Jonathan Chong wrote:
> Hi everyone
> 
> One of the projects I am working on requires me to take snapshots of
> the Content Management System from certain points in time (usually
> before a change is made).
> 
> These snapshots contain everything (not just the page contents), from
> navigation ordering to user permissions to actual content. This is so
> the client can go back in time and see what the CMS looked like then.
> 
> I have 10 tables that I need to capture data from.
> 
> The way I'm thinking of doing this is to do a dump of those 10 tables.
> When a snapshot is requested, it writes the dump file to a snapshot
> table, whose columns is every single column from those 10 tables.
> 
> This is so I can do a select from that one table to get a snapshot of the C=
> MS.
> 
> But I will need to parse the dump output to append every single CREATE
> and INSERT statement to be the new table name. Does mysql cater for
> this or will I have to write a parse script to do this for me?
> 
> Another option would be to have a snapshot_id column in every table,
> but is slightly more messy from my point of view.
> 
> Please let me know your thoughts, thanks.
> 
> --
> Jonathan Chong
> 
> http://www.arsenal-now.com/
> http://www.arsenal-mania.com/
> http://www.ashburrn.com/
> http://www.jonathan-chong.com/
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com