Hi, does anyone know how to fix this error mentioned in the title? My entire app works fine locally when i run it but for whatever reason, it deploys fine but does not work at all and displays the above error message. Any help would be appreciated.
I take it that you have MySQL installed and running on your local machine. As far as I know, there is no option to host databases on shinyapps.io. Your app would need to make a connection to a remote MySQL server. This article describes how to handle persistent data storage (i.e., working with data that does not disappear when the session ends).