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
deleted-user-2641177 | 3 posts | July 16, 2017, 3:45 p.m. | permalink

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

Staff conrad | 4232 posts | PythonAnywhere staff | July 17, 2017, 11:34 a.m. | permalink

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.

deleted-user-2641177 | 3 posts | July 17, 2017, 10:38 p.m. | permalink

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

Staff conrad | 4232 posts | PythonAnywhere staff | July 18, 2017, 11:07 a.m. | permalink