[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