Forums

I have been trying migrate from MySQL to Postgres but nothing seems to working. Please I need help. I want to host my database somewhere else. How can I successfully run this command

pgloader mysql://username:password@username.mysql.pythonanywhere-services.com/username$dbname postgresql://**:postgres://*:mVPJVw7PwhL@**hi4h0-a.oregon-postgres.render.com/mydatabase

You will need to run that somewhere that has pgloader installed and you will need to use an SSH tunnel to access your MySQL database from outside of PythonAnywhere: https://help.pythonanywhere.com/pages/AccessingMySQLFromOutsidePythonAnywhere/#manual-ssh-tunnelling