> Le 5 déc. 2017 à 20:45, Timothy Penner via 4D_Tech <[email protected]> a > écrit : > > Why don't you just use SQL EXPORT SELECTION and SQL EXECUTE SCRIPT?
Hi Tim, I had to use that last month for a crashed DB in which there was no other solution after repair than export/import all. Code easy and short to write, fast, reliable: great! But I was lucky that DB had no object fields… SQL EXPORT SELECTION is fast and easy to compress (sizes in Mb): 4DB -> 27.6 compressed "normal" 4BK -> 8 not compressed 4BK -> 27.9 not compressed 4BK.zip -> 4.3 not compressed 4BK.7z -> 2.9 SQL dump -> 9.2 SQL dump.zip -> 1.8 SQL dump.7z -> 1.4 I wish I could use it as an alternate to existing backup :-( -- Arnaud de Montard ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
