[geeklog-devel] mysql innodb & backup
Dwight Trumbower
dwight at trumbower.com
Wed Oct 13 00:53:08 EDT 2004
After doing some reading, it looks like innodb, should not be the
default for a database. Mainly, you can't backup without shutting down
mysql. You can use mysqldump --single-transaction, but that will lock
everyone out of the database. If you have an active site, people will be
locked out.
I'm doing some more reading to get more farmilar with innodb, but for
the majority of users, myisam should handle there needs.
Any thoughts?
Dwight
More information about the geeklog-devel
mailing list