database query?

[geoplast]

Hi people,
After taking over the administration of a shared hosting server, I need to move several hundred accounts to a different machine. But, the hosting platform still only uses mysql4.0.25, so to restore databases with InnoDB tables, I need to add SET FOREIGN_KEY_CHECKS=0; to the dumpfile first. I'd like to know which databases I need to do this for. Is there an easy way to query mysql to find what databases contain InnoDB tables?
Thanks, -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Saggie]

Try to create and drop innodb_table_monitor to dump the internal InnoDB data dictionary to the error log: [dev.mysql.com]

The table names will be of the form "<database_name>/<table_name>". -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --