fellow users, hopefully you experts too, could help...
....me to understand how, and what should be the best practice to dump database, then drop it and merge the dumps.. What I'd like to do is something probably many have done and I wonder how it's done best. A box will be dumping a database (maybe? tables if it's better) then dropping (purging the data) it and on a different system that dump swill be inserted/aggregated into the same database. It reminds me a kind of incremental backup except for the fact that source data will be dropped/purged on regular basis, but before a drop, a dump which later will be used to sort of reconstruct that same database.
How do you recommend to do it? I'm guessing trickiest bit might this reconstruction part, how to merge dumps safely, naturally while maintaining consistency & integrity? Actual syntax, as usually any code examples are, would be best.
many thanks.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Feb 29
lejeczek Re: dump, drop database then merge/aggregate
Feb 29, 2016; 15:30
lejeczek
Re: dump, drop database then merge/aggregate
Feb 29
Gary Smith Re: dump, drop database then merge/aggregate
Feb 29, 2016; 15:42
Gary Smith
Re: dump, drop database then merge/aggregate
Feb 29
lejeczek Re: dump, drop database then merge/aggregate
Feb 29, 2016; 16:12
lejeczek
Re: dump, drop database then merge/aggregate
Feb 29
Johan De Meersman Re: dump, drop database then merge/aggregate
Feb 29, 2016; 17:20
Johan De Meersman
Re: dump, drop database then merge/aggregate
Feb 29
Steven Siebert Re: dump, drop database then merge/aggregate
Feb 29, 2016; 11:32
Steven Siebert
Re: dump, drop database then merge/aggregate
Feb 29
lejeczek Re: dump, drop database then merge/aggregate
Feb 29, 2016; 17:12
lejeczek
Re: dump, drop database then merge/aggregate
Feb 29
Gary Smith Re: dump, drop database then merge/aggregate
Feb 29, 2016; 17:14
Gary Smith
Re: dump, drop database then merge/aggregate
Feb 29
Steven Siebert Re: dump, drop database then merge/aggregate
Feb 29, 2016; 12:15
Steven Siebert
Re: dump, drop database then merge/aggregate
Feb 29
Steven Siebert Re: dump, drop database then merge/aggregate
Feb 29, 2016; 12:36
Steven Siebert
Re: dump, drop database then merge/aggregate
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!