TYPO3 Core

We use an export script (see attachment) in typo3conf/export to make dumps of specific tables into typo3conf/*.sql files. This way we can for example easily export templavoila tables to another instance of a website.

Problem with DBAL is that the default mysqldump file output can't be imported in the install tool anymore. Even with the extra parameters in the documentation of DBAL it's no fit.

So I extended the script a bit to remove charset declarations (which don't matter in our case anyway), add a DROP TABLE command automatically and remove the backticks in CREATE TABLE definitions.

The actual cleanup methods accepts a file, and writes the cleaned up content back into the same file.

Feel free to use this script if useful.