Export all keys from a database #mysql

export_keys.sql

SELECT CONCAT(
    'ALTER TABLE ', fks.quotedSourceTableName, ' ',
    'ADD CONSTRAINT ', fks.quotedConstraintName, ' ',
    'FOREIGN KEY (', GROUP_CONCAT(fks.quotedSourceColumnName), ') ',
    'REFERENCES ', fks.quotedTargetTableName, ' (',
        GROUP_CONCAT(fks.quotedTargetColumnName),
    ') ',
    'ON DELETE ', fks.deleteRule, ' ',
    'ON UPDATE ', fks.updateRule, ';'
)
FROM (
    SELECT
        CONCAT('`', kcu.CONSTRAINT_NAME, '`') AS quotedConstraintName,
        CONCAT('`', kcu.TABLE_NAME, '`') AS quotedSourceTableName,
        CONCAT('`', kcu.COLUMN_NAME, '`') AS quotedSourceColumnName,
        CONCAT('`', kcu.REFERENCED_TABLE_NAME, '`') AS quotedTargetTableName,
        CONCAT('`', kcu.REFERENCED_COLUMN_NAME, '`') AS quotedTargetColumnName,
        rc.DELETE_RULE AS deleteRule,
        rc.UPDATE_RULE AS updateRule
    FROM information_schema.KEY_COLUMN_USAGE AS kcu
    INNER JOIN information_schema.REFERENTIAL_CONSTRAINTS AS rc ON
        kcu.CONSTRAINT_NAME = rc.CONSTRAINT_NAME AND
        kcu.TABLE_SCHEMA = rc.CONSTRAINT_SCHEMA
    WHERE
        kcu.TABLE_SCHEMA = '<database name>' AND
        kcu.REFERENCED_COLUMN_NAME IS NOT NULL
    ORDER BY 
        kcu.ORDINAL_POSITION DESC
) AS fks
GROUP BY
    fks.quotedConstraintName,
    fks.quotedSourceTableName,
    fks.quotedTargetTableName,
    fks.deleteRule,
    fks.updateRule;