Nope Peter, you didn't miss a beat ;)
Just to be very clear, MyCon is the front-end GUI which auto setup scripts for MyRun to
use for backups or it can also optionally schedule MyRun to auto execute these source
scripts. The end-user hardly ever sees MyRun (except when the OS task scheduler fires it
up). All the end-user ever does, is to click on a database (or a specific table) and
click Backup, the rest just "happens". MyRun is the commandline utility which actually
does the hard yards. And to just state it again so there is no confusion; MyRun's target
script is fully capable of recreating the full schema as well as populate it with data
(insert statements) from whatever was selected in the source script.
* MyRun can also do this from a remote MySQL server.
* It can also execute the target script against another mysql server/database instead of
to a script file
* MySQL V3.23 and higher
* The target script can optionally contain "USE db;", "DROP table if exists tb1;", "CREATE
table if not exists tb1 ..." and your data using "INSERT into tb1 (..columns..) values
((...record1...),(...record2...),..);" in 100xrecord batches (so a 1,000 records will be
contained in only 10 insert statements).
These batch inserts are used because from the MySQL Manual: "This is much faster (many
times faster in some cases) than using separate single-row INSERT statements. If you are
adding data to non-empty table, you may tune up the bulk_insert_buffer_size variable to
make it even faster."
Every morning we have a scheduled MyRun which backups up our company's MySQL webdata from
our remote webhost/ISP's MySQL server to our local network using a ADSL connection. It
contains tens of tables with thousands of records each and from start to finish takes
approx. 10 seconds (our webhost and we are on different continents). And to set all this
up initially took a massive.. one click!
If our ISP drops our database by mistake, it will take us all of two seconds to recreate a
complete snapshot of the database using the latest target script.
SciBit MySQL Team