Support » Plugin: Backup and Staging by WP Time Capsule » WPTC cannot create the triggers to backup the queries, Please contact hosting pr

  • What is needed or the requirements to enable Real-time backups? the wordpress user has full mysql privileges on it’s database and can write to both .htaccess and wp-config.php files. Can you help me figure out why I keep getting the error:

    WPTC cannot create the triggers to backup the queries, Please contact hosting provide to enable triggers.And Backup Schedule set to 6 hours.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author WPTimeCapsule

    (@wptimecapsule)

    Hi,

    Thanks for taking the time to reach out to us here. WPTC use triggers to backup the changes on your WordPress database in real-time.
    From the error message, it seems that the hosting provider of your WordPress site installed server has disabled triggers on your MySQL server.

    I kindly request you to contact your hosting provider and ask them to enable triggers on your MySQL server. I hope that they can get this problem sorted out for you.

    Feel free to write us back if you got any other questions or concerns further.

    I AM the hosting provider. The mysql server is my own. The database user that WordPress uses has full privileges, include GRANT TRIGGER.

    I found this in the apache log files:
    “ERROR 1419 (HY000) at line #: 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)“.

    I cannot grant the SUPER privilege as that would grant the user full access to the mysql server, not just it’s own database, which we can’t do due to security policies. I ended up running as query on mysql:

    set global log_bin_trust_function_creators = 1;

    Even though, i don’t use Amazon RDS, this article actually helped me rather than the unhelpful reply to ‘contact your hosting provider’

    Reference: https://techtavern.wordpress.com/2013/06/17/mysql-triggers-and-amazon-rds/

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WPTC cannot create the triggers to backup the queries, Please contact hosting pr’ is closed to new replies.