I need to automatically make copies of a mysql database with only InnoSetup tables. mysqldump with the single-transaction parameter could do the job.
I think this tool will read all tables one after another. The single-transaction parameter causes the StartTransaction and Begin commands beeing called at the beginning of the dump process.
My question: Will StartTransaction secure all tables at once so that while reading the first table all changes to e.g. to the last table (which will be only read after 2 minutes) from another db connection will not be visible when mysqldump reaches this table?
Does anybody know what mysql is exactly doing on StartTransaction and Begin? Does it secure all tables in the db for the calling connections? I always thought that it only makes a internal snapshot of the records already read. Is mysqldump 100% save against other connections writing in tables mysqldump did not already read?