Tag Archives: php

mysqldump database backup for mixed InnoDB and MyISAM tables

By pixelbyter | Published: January 22, 2010
Backing up a collection of MyISAM and InnoDB tables within a database via mysqldump can cause problems. MyISAM tables require locking, whereas InnoDB tables need to remain unlocked and can also take advantage of single transactions to speed up the backup process. I decided to write the following PHP script to list all of the [...]
Posted in Uncategorized | Also tagged , | Leave a comment