New “DATABASE ERROR: database error write” just started appearing

  • Resolved lychee128

    (@lychee128)


    4 years, 7 months ago

    Hi,

    I’ve been using Duplicator to clone my site a few times but the last couple of times I’ve gotten the below DATABASE ERROR. I haven’t made any changes to my database so not sure what is causing the error.

    The site still seems to run fine but wanted to see how I can best address this error.

    Thanks!

    ——————————-

    DATABASE ERROR: database error write

    **ERROR** database error write ‘You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privile’ at line 1′ – [sql=mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS pr…]

    **ERROR** database error write ‘Variable ‘character_set_client’ can’t be set to the value of ‘NULL” – [sql=/*!40101 SET character_set_client = @saved_cs_client */;…]

Viewing 5 replies - 1 through 5 (of 5 total)

  • Hey @lychee128,

    You might try and build the package in PHP mode, see Settings > Packages. It looks like the script that is being generated by mysqldump on one instance is working on the other. In some cases, you can simply remove that line from the .sql file as well.

    Let me know if that helps~

    Thread Starter lychee128

    (@lychee128)

    Hi,

    That did help! I don’t get the errors anymore so that’s for the guidance.

    1) What’s the difference between the 2 methods? To the extent it’s straightforward to explain… under what circumstances might I choose one versus the other. I’m assuming if I don’t get an error it’s good either way?

    2) This error only recently started appearing. Is this indicative of something wrong with my database or some other problem?

    Thanks.

    Hey @lychee128,

    1. One uses pure PHP code the other one uses the mysqldump option. Mysqldump is better (typically because it can be faster) in the event your servers are cross-compatible.

    2. It’s possible your host updated to a different version of MySQL or updated how it’s used on their servers.

    Hope that helps~

    Thread Starter lychee128

    (@lychee128)

    Thanks for the explanation! I’m all set now.

    Excellent, thxs for the update!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘New “DATABASE ERROR: database error write” just started appearing’ is closed to new replies.