Title: New “DATABASE ERROR: database error write” just started appearing
Last modified: August 10, 2020

---

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

 *  Resolved [lychee128](https://wordpress.org/support/users/lychee128/)
 * (@lychee128)
 * [5 years, 10 months ago](https://wordpress.org/support/topic/new-database-error-database-error-write-just-started-appearing/)
 * 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)

 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/new-database-error-database-error-write-just-started-appearing/#post-13232896)
 * Hey [@lychee128](https://wordpress.org/support/users/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](https://wordpress.org/support/users/lychee128/)
 * (@lychee128)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/new-database-error-database-error-write-just-started-appearing/#post-13234911)
 * 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.
 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/new-database-error-database-error-write-just-started-appearing/#post-13234937)
 * Hey [@lychee128](https://wordpress.org/support/users/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](https://wordpress.org/support/users/lychee128/)
 * (@lychee128)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/new-database-error-database-error-write-just-started-appearing/#post-13234939)
 * Thanks for the explanation! I’m all set now.
 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/new-database-error-database-error-write-just-started-appearing/#post-13238717)
 * 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.

 * ![](https://ps.w.org/duplicator/assets/icon-256x256.png?rev=2906985)
 * [Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More](https://wordpress.org/plugins/duplicator/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/duplicator/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/duplicator/)
 * [Active Topics](https://wordpress.org/support/plugin/duplicator/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/duplicator/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/duplicator/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * Last activity: [5 years, 9 months ago](https://wordpress.org/support/topic/new-database-error-database-error-write-just-started-appearing/#post-13238717)
 * Status: resolved