First up, there’s a plugin, rss_admin_db_manager by Rob Sable AKA Wilshire One
However, as Rob’s no longer working with this, it needs a tweak to work with the current TextPattern version, as described in the forum and solved by Colak
Finally, there’s a wall-through at Graphic Push NB There’s a key part written as a comment:
- Navigate to Admin > Preferences > Basic. Verify “Site URL.”
- Navigate to Admin > Preferences > Advanced. Verify “File directory path” and “Temporary directory path.”
- Navigate to Extensions > DB Backup; modify “msqldump” and “mysql” paths if needed.
- Navigate to Extensions > DB Manager, and Repair all tables.
- Navigate to Admin > Diagnostics. View “Pre-flight check.”
- Select “View Site.”