There's a bunch of tables in Espo that aren't exportable using the usual Mass Export features.
It'd be super handy to have phpMyAdmin available at
/phpmyadminon each app instance to save me a bunch of time managing multiple instances.
I've gone through this with Sequel Pro and MySQL Workbench with no luck either: https://forum.cloudron.io/topic/3237/remote-sql-support-on-a-per-app-basis/4
@humptydumpty I'm aware of Adminer (works well as a WP plugin). Kinda interesting that it could potentially be manually co-installed but then I'd rather stick to the way phpMyAdmin (or Adminer) is installed as a side-app in the whole app package for segregation of responsibilities and security footprint.
@marcusquinn I can help with the remote sql issue since atleast atm there is no phpMyAdmin.
A crude way is of course to go to Web Terminal and click the MySQL button at the top. That paste the command required to access mysql. You can then export import to /tmp directory and then download the dump.
@girish Thanks, that's a reasonable workaround. I think we might have luck with DBeaver, although I still need to try that personally.
I agree that most apps probably shouldn't have DB add-on apps, but as I get more into Espo I can see legitimate use-cases for it.
I'll share more on my work with it too as I think it would all be valuable to the community and potentially yourselves if you like it too.