Hacker News new | ask | show | jobs
by sciurus 4312 days ago
For those curious, on PostgreSQL it executes

    CREATE DATABASE "snapshot" WITH TEMPLATE "source";
and on MySQL it loops creates the new database and loops over all the tables running

    INSERT INTO snapshot.table SELECT * FROM source.table;
https://github.com/fastmonkeys/stellar/blob/master/stellar/o...