I’ve added an external (legacy) mysql database to config.yml by importing databases.yml with the connection details. I know it is connecting, after various times it didn’t, but now it’s throwing this error when I try to access a page
An exception occurred while executing 'SELECT id FROM redirects WHERE active = 1 ORDER BY `priority` DESC': SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mydbname.redirects' doesn't exist
Why is it doing this? What is the right way to access a remote mysql database by pimcore/symfony/doctrine best practice? I could have done this hours ago with plain php but I’m trying to do it right and learn. It’s only to import some data (I could have exported it as a csv file but I want to be able to easily replicate it in the future).