| 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}; }}} |
