What process do you guys usually follow when upgrading your version of
MySQL? I have yet to perform an upgrade, but my first thought would be to
dump the databases, uninstall the old version (remove all the files),
install the new version, and import the dump file. Is this a good plan, or
is the
>From this feature list, it sounds like you are creating methods
(multi-deletes, updates from joins) that will take the place of
transactions. Is this the direction that MySQL is heading? Do you believe
that these methods will be preferred over traditional rollback/commit
transactions with BDB o
How exactly does the BEGIN/COMMIT/ROLLBACK transaction process work? The
examples I have seen are like:
BEGIN;
statement 1;
statement 2;
statement n;
COMMIT;
Does this imply that if any of the statements fail then a ROLLBACK will be
called, otherwise it will COMMIT?
--