PythonAnywhere Forums

Restore from MySQL dump failing.

I am trying to restore from an SQL dump file to a new database on PythonAnywhere. Getting error message:

ERROR 1419 (HY000) at line 914: You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)

My command is:

mysql -u username -h username.mysql.pythonanywhere-services.com 'username$simpricity' < Dump20170429.sql

hmm- is your sql dump trying to do something that requires super privileges?

I think it might be that it has triggers in it. I'll take them out and try again. Other than that it is a standard MySQL restore.

ah yes- triggers are not supported for MySQL on PythonAnywhere (but we do allow that for PostGres if you upgrade)