64 | | * launch a mysql prompt with 'show innodb status;' (parsed?) |
65 | | * potentially even have mysql fix it automatically (possible for sure, but lower priority than the core) |
| 64 | * Collect MySQL username/password from /home/web2py/applications/eden/models/000_config.py |
| 65 | {{{ |
| 66 | deployment_settings.database.username = "sahana" |
| 67 | deployment_settings.database.password = "password" |
| 68 | }}} |
| 69 | * Parse output from {{{mysql -u root -p=password -e "show innodb status;"}}} |
| 70 | * Fix it automatically from the parsed output: {{{ALTER TABLE {table_name} DROP FOREIGN KEY {table_name}_ibfk_{indexid}; }}} |