MySQL Workbench: Remove default schema at export

Currently it is not possible to export a database in MySQL Workbench without default schema. This is a problem if you want to import the sql file into another database.

Editing very large sql files is not even possible. For Linux the following commands may be useful. It replaces all schema names in all sql files in the current directory.

find . -name "*.sql" -print | xargs sed -i 's/NOT EXISTS `olddatabase`/NOT EXISTS `newdatabase`/g'
find . -name "*.sql" -print | xargs sed -i 's/USE `olddatabase`;/USE `newdatabase`;/g'

 

Sven Wappler

TYPO3 Experte, symfony, Magento, SEO, Frontend und Backend

Das könnte Dich auch interessieren …

Schreibe einen Kommentar