Title: DATABASE ERROR: database error write
Last modified: February 25, 2023

---

# DATABASE ERROR: database error write

 *  Resolved [bigbankclub](https://wordpress.org/support/users/bigbankclub/)
 * (@bigbankclub)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/database-error-database-error-write-2/)
 * I am starting to get this error, and it has only happened in the last while.
 * I have used this plugin for years and this is the 1st for such an error.
 * What’s the fix?
 * **DATABASE ERROR: database error write**
 * DATABASE ERROR: ‘You have an error in your SQL syntax; check the manual that 
   corresponds to your MariaDB server version for the right syntax to use near ‘
   WARNING: Forcing protocol to TCP due to option specification. Please explic…’
   at line 3′
   [SQL=/* DUPLICATOR-LITE (MYSQL-DUMP BUILD MODE) MYSQL SCRIPT CREATED
   ON : 2023-02-25 11:02:51 */
 * WARNING: Forcing protocol to TCP due to option specification. Please explicitly
   state intended protocol.
   …]
 * DATABASE ERROR: ‘Variable ‘time_zone’ can’t be set to the value of ‘NULL”
   [SQL
   =/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;…]
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdatabase-error-database-error-write-2%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Support [mohammedeisa](https://wordpress.org/support/users/mohammedeisa/)
 * (@mohammedeisa)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/database-error-database-error-write-2/#post-16515505)
 * Hi [@bigbankclub](https://wordpress.org/support/users/bigbankclub/) ,
 * The error states that there is something wrong with your database.
   So, this is
   either an error in the original database, and this can’t be fixed from our side.
   Or, there is something went wrong with the exported package.Can you try to import
   the database manually to check if it works without Duplicator?If you need to 
   check the exported package, please upload (not copy/paste) the package build 
   log file to an uploading platform like Google Drive and share the file link here
   with me. 
 * For instructions please see:
 *     – How do I read the package build log?
       – [https://snapcreek.com/duplicator/docs/faqs-tech/#faq-trouble-005-q](https://snapcreek.com/duplicator/docs/faqs-tech/#faq-trouble-005-q)
 * Looking forward to your reply!
 *  Thread Starter [bigbankclub](https://wordpress.org/support/users/bigbankclub/)
 * (@bigbankclub)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/database-error-database-error-write-2/#post-16518266)
 * Thank you for the reply. I took it 1 step back and I saw this notice. I am copying
   to the same server and have 100’s of installs — they have the same type of error,
   I tested the 1st 25 and this show:
 * STATUS
   This server’s database does not support the source site’s character set[
   utf8], so the installer is going to use default character [utf8mb3].
 * DETAILS
   Settings used in the current installationDB_CHARSET = utf8mb3DB_COLLATE
   = utf8mb3_general_ci
 * —
 * So when installing WordPress, by default the system is setting to utf8 ?
 *  Plugin Support [mohammedeisa](https://wordpress.org/support/users/mohammedeisa/)
 * (@mohammedeisa)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/database-error-database-error-write-2/#post-16518330)
 * Hi [@bigbankclub](https://wordpress.org/support/users/bigbankclub/) ,
 * Duplicator by default sets the Charset to utf8mb4 and the collation to utf8mb4_0900_ai_ci.
   
   Please try the following if you need to change these settings:– Click Advanced
   in **Step 1** of the installer– In Step 2, Click **Charset & Collation**– Choose
   the values you prefer for the **Charset **and **Collation **fields
 * About this error:
   This server’s database does not support the source site’s character
   set [utf8], so the installer is going to use default character [utf8mb3].I think
   you could contact your hosting to check this issue before you try the installation.
   I hope this helps.Thanks.

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

The topic ‘DATABASE ERROR: database error write’ 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/)

## Tags

 * [Database Error](https://wordpress.org/support/topic-tag/database-error/)

 * 3 replies
 * 2 participants
 * Last reply from: [mohammedeisa](https://wordpress.org/support/users/mohammedeisa/)
 * Last activity: [3 years, 1 month ago](https://wordpress.org/support/topic/database-error-database-error-write-2/#post-16518330)
 * Status: resolved