Title: Database errors during writing Last modified: August 24, 2016 --- # Database errors during writing * Resolved [alex.mqt](https://wordpress.org/support/users/alexmqt/) * (@alexmqt) * [11 years ago](https://wordpress.org/support/topic/database-errors-during-writing/) * Hi, * I’ve installed Duplicator on my local website to copy it to my server. After, when I want to install it on the server, there are hundreds of errors of writing in the database. And when I want to access to the website, it needs a WordPress installation again (impossible to do because of database errors at the end of it). However, WordPress seems to be copied to the server as there are the folders of wp in it. * I’ve tried with Duplicator version 0.5.18 and 0.5.19 (development), with WordPress( 4.2.2) installed on the server and without. Always the same errors. * Thanks in advance for your help! * [https://wordpress.org/plugins/duplicator/](https://wordpress.org/plugins/duplicator/) Viewing 15 replies - 1 through 15 (of 38 total) 1 [2](https://wordpress.org/support/topic/database-errors-during-writing/page/2/?output_format=md) [3](https://wordpress.org/support/topic/database-errors-during-writing/page/3/?output_format=md) [→](https://wordpress.org/support/topic/database-errors-during-writing/page/2/?output_format=md) * [Cory Lamle](https://wordpress.org/support/users/corylamleorg/) * (@corylamleorg) * [11 years ago](https://wordpress.org/support/topic/database-errors-during-writing/#post-6129203) * I believe this may be related to the database build mode. Are you using mysqlsql dump? If so after generating a package click on the Details of the package, it will be a link like [View NN], then click on the SQL button and see if the SQL file was built. If its mostly blank then there is a bug with writing to mysql via the shell. Let me know what you find. * Thanks * Thread Starter [alex.mqt](https://wordpress.org/support/users/alexmqt/) * (@alexmqt) * [11 years ago](https://wordpress.org/support/topic/database-errors-during-writing/#post-6129205) * Thanks for your reply. * No, the SQL file is well filled. After the try of implementation of the database, there’s no tables created in the database, and hundreds of errors for each table, like we can see in installer-log.txt : * ``` -------------------------------------- DATABASE RESULTS -------------------------------------- **ERROR** database error write 'Unknown collation: 'utf8mb4_unicode_ci'' - [sql= CREATE TABLE wp_commentmeta ( meta_id bigint(20) unsigned NOT NULL A...] (etc...) ``` * Thanks * Thread Starter [alex.mqt](https://wordpress.org/support/users/alexmqt/) * (@alexmqt) * [11 years ago](https://wordpress.org/support/topic/database-errors-during-writing/#post-6129225) * I’ve finally found what the problem was! * Like I said, after the launching of the installer.php on the new website, another installation of WordPress was needed. And when I did it, the error was like written below for all the creations of tables : `Unknown character set: 'utf8mb4'` * So the solution was to edit the SQL (found in the archive) by replacing every` utf8mb4` character set with `utf8`. The problem was certainly because of the use of an old version of MySQL by the server (`5.3.16`), and the character set` utf8mb4` has been introduced with `5.5.3`. * I don’t know if you could change something in your plugin to avoid this kind of problem… * Thanks anyway! * [Cory Lamle](https://wordpress.org/support/users/corylamleorg/) * (@corylamleorg) * [11 years ago](https://wordpress.org/support/topic/database-errors-during-writing/#post-6129329) * Thanks for the update Alex. I’ll do some research to see if this is something that I can integrate… * Cheers~ * [Life_O_Brian](https://wordpress.org/support/users/life_o_brian/) * (@life_o_brian) * [11 years ago](https://wordpress.org/support/topic/database-errors-during-writing/#post-6129405) * Oh thank God for you, alex.mqt!!! I’m using IX Webhosting and I had the exact same problem. I couldn’t figure out why it wasn’t creating my tables! * [ShriniKannan](https://wordpress.org/support/users/shrini/) * (@shrini) * [10 years, 12 months ago](https://wordpress.org/support/topic/database-errors-during-writing/#post-6129427) * [@alex](https://wordpress.org/support/users/alex/).mqt thank you very much * [ShriniKannan](https://wordpress.org/support/users/shrini/) * (@shrini) * [10 years, 12 months ago](https://wordpress.org/support/topic/database-errors-during-writing/#post-6129428) * still I get One Deploy Error……….please anyone help in this * ******************************************************************************** DUPLICATOR INSTALL-LOG STEP1 START @ 11:22:45 NOTICE: Do NOT post to public sites or forums ******************************************************************************** VERSION: 0.5.22 PHP: 5.4.41 | SAPI: cgi-fcgi SERVER: Apache Phusion_Passenger/ 4.0.10 mod_bwlimited/1.4 mod_fcgid/2.3.9 DOC ROOT: /home/kanvipno/public_html/ new/skc DOC ROOT 755: true LOG FILE 644: true BUILD NAME: 20150529_skcet_556d8ec5bd8f34236150602110853 * ******************************************************************************** ARCHIVE SETUP ******************************************************************************** NAME: 20150529_skcet_556d8ec5bd8f34236150602110853_archive.zip SIZE: 25.44MB ZIP: Enabled (ZipArchive Support) EXTRACTING ZipArchive Object ( [status] => 0 [statusSys] => 0 [numFiles] => 1895 [filename] => /home/kanvipno/public_html/ new/skc/20150529_skcet_556d8ec5bd8f34236150602110853_archive.zip [comment] =>) COMPLETE: true * WEB SERVER CONFIGURATION FILE RESET: – Backup of .htaccess/web.config made to. orig – Reset of .htaccess/web.config files * UPDATED FILES: – SQL FILE: ‘/home/kanvipno/public_html/new/skc/installer-data. sql’ – WP-CONFIG: ‘/home/kanvipno/public_html/new/skc/wp-config.php’ * ARCHIVE RUNTIME: 54.5108 sec. * ******************************************************************************** DATABASE-ROUTINES ********************************************************************************————————————– SERVER ENVIROMENT ————————————– MYSQL VERSION: 5.1.60-rel13.1-log TIMEOUT: 300 MAXPACK: 1048576 ————————————– DATABASE RESULTS ————————————– **ERROR** database error write ‘MySQL server has gone away’ – [sql=/* DUPLICATOR MYSQL SCRIPT CREATED ON : 2015-06-02 11:09:53 */ * SET FOREIGN…] ERRORS FOUND: 1 DROP TABLE: Database already empty. Ready for install. QUERIES RAN: 782 * sk_commentmeta: (0) sk_comments: (1) sk_duplicator_packages: (1) sk_links: ( 0) sk_options: (160) sk_postmeta: (403) sk_posts: (132) sk_term_relationships:( 41) sk_term_taxonomy: (5) sk_terms: (5) sk_usermeta: (20) sk_users: (1) skc_commentmeta:( 0) skc_comments: (2) skc_duplicator_packages: (0) skc_links: (0) skc_options:( 121) skc_postmeta: (406) skc_posts: (110) skc_term_relationships: (42) skc_term_taxonomy:( 5) skc_terms: (5) skc_usermeta: (22) skc_users: (1) Removed ’30’ cache/transient rows * SECTION RUNTIME: 0.8957 sec. * ******************************************************************************** STEP1 COMPLETE @ 11:23:41 – TOTAL RUNTIME: 55.4083 sec. ******************************************************************************** * ******************************************************************************** DUPLICATOR INSTALL-LOG STEP2 START @ 11:23:49 NOTICE: Do not post to public sites or forums ******************************************************************************** CHARSET SERVER: latin1 CHARSET CLIENT: utf8 * ————————————– SERIALIZER ENGINE [*] scan every column [~] scan only text columns[ ^] no searchable columns ————————————– sk_commentmeta^ (0) sk_comments~ (1) sk_duplicator_packages ^ (0) sk_links^ (0) sk_options~ (128) sk_postmeta~ (403) sk_posts~ (132) sk_term_relationships ~ (41) sk_term_taxonomy~ (5) sk_terms~ (5) sk_usermeta~ (20) sk_users~ (1) skc_commentmeta ^ (0) skc_comments~ (2) skc_duplicator_packages^ (0) skc_links^ (0) skc_options ~ (121) skc_postmeta~ (406) skc_posts~ (110) skc_term_relationships~ (42) skc_term_taxonomy ~ (5) skc_terms~ (5) skc_usermeta~ (22) skc_users~ (1) ————————————– SEARCH1:‘ [http://localhost/skcet’](http://localhost/skcet’); REPLACE1: ‘[http://kanvismedia.com/new/skc’](http://kanvismedia.com/new/skc’); SEARCH2: ‘C:/xampp/htdocs/skcet/’ REPLACE2: ‘/home/kanvipno/public_html/new/skc/’ SCANNED: Tables:24 | Rows:1450 | Cells:10380 UPDATED: Tables:1 | Rows:144 |Cells: 184 ERRORS: 0 RUNTIME: 1.194300 sec * ******************************************************************************** START FINAL CLEANUP: 11:23:51 ******************************************************************************** UPDATE `sk_blogs` SET domain = ‘kanvismedia.com’ WHERE domain = ‘localhost’ * ————————————– WARNINGS ————————————– No Warnings Found * WEB SERVER CONFIGURATION FILE BASIC SETUP: created basic .htaccess file. If using IIS web.config this process will need to be done manually. ******************************************************************************** STEP 2 COMPLETE @ 11:23:51 – TOTAL RUNTIME: 1.2096 sec. ******************************************************************************** * [Cory Lamle](https://wordpress.org/support/users/corylamleorg/) * (@corylamleorg) * [10 years, 12 months ago](https://wordpress.org/support/topic/database-errors-during-writing/#post-6129431) * Hey Shrini, * You will need to make sure you remove the package an installer from your system you reference in the log above as it contains sensitive info. As far as your error you may have to try the process again, it looks like mysql somehow lost connection during the process: * > **ERROR** database error write ‘MySQL server has gone away’ – [sql=/* DUPLICATOR > MYSQL SCRIPT CREATED ON : 2015-06-02 11:09:53 */ * [Connection lost issues](https://dev.mysql.com/doc/refman/5.0/en/gone-away.html) can be difficult to isolate. * [ShriniKannan](https://wordpress.org/support/users/shrini/) * (@shrini) * [10 years, 11 months ago](https://wordpress.org/support/topic/database-errors-during-writing/#post-6129432) * Thanks Cory Lamle * [Cory Lamle](https://wordpress.org/support/users/corylamleorg/) * (@corylamleorg) * [10 years, 11 months ago](https://wordpress.org/support/topic/database-errors-during-writing/#post-6129442) * Glad to help, hope you get things going… * [james.cdd](https://wordpress.org/support/users/jamescdd/) * (@jamescdd) * [10 years, 11 months ago](https://wordpress.org/support/topic/database-errors-during-writing/#post-6129452) * Thanks alex.mqt for the solution. For me I had a similar situation, The above solution was nearly enough to fix, I then had to go in the wp-config file and update the db charset to utf8 * Good to go! * [readonly](https://wordpress.org/support/users/readonly/) * (@readonly) * [10 years, 9 months ago](https://wordpress.org/support/topic/database-errors-during-writing/#post-6129472) * I had the same issue, and the solution provided by alex.mqt worked as well. For what it’s worth, I host with Dreamhost and they provide MySQL version 5.1.56. Would love to see this solution integrated with Duplicator. * [Gnurps](https://wordpress.org/support/users/gnurps/) * (@gnurps) * [10 years, 9 months ago](https://wordpress.org/support/topic/database-errors-during-writing/#post-6129474) * I had the same issue and this thread got me fixed. I am very grateful for the support, both by Cory and this community. I had a very different experience with WP Migrate DB. Its author refuses to provide an ounce of support for his free version and his minimum price is more than twice Duplicator Pro’s. So when I go pro, I’ll go Duplicator! Meanwhile, I sent in a donation. * Thanks and good luck to all. * Gary S. * [Cory Lamle](https://wordpress.org/support/users/corylamleorg/) * (@corylamleorg) * [10 years, 9 months ago](https://wordpress.org/support/topic/database-errors-during-writing/#post-6129475) * Hey Gary, * Thanks for the contribution! Glad you were able to get your issue worked out… * Cheers~ * [bkjproductions](https://wordpress.org/support/users/bkjproductions/) * (@bkjproductions) * [10 years, 9 months ago](https://wordpress.org/support/topic/database-errors-during-writing/#post-6129476) * Hi Cory, Do you think you could massage that SQL file and change the UTF stuff automatically? Alex above had mentioned that he hand-edited the SQL file: * > So the solution was to edit the SQL (found in the archive) by replacing every > utf8mb4 character set with utf8. * I’m running into a problem with CanvasHost where they haven’t bothered to update MySQL to the latest, and this seems to be a big issue. I’m assuming that having“ utf8mb4” is not such an important thing, if “utf8” works? So just a search/replace of the SQL automatically before you wrap up the package. Maybe you could have an option for “Make package less compatible” if it IS important to have the mb4 stuff. * BTW I had donated back in December; thanks for the continual updates you’ve been doing for this plugin. We’ve given up on trying to use it over at MediaTemple and are just doing it the hard way, but for other hosts like SiteGround (and until recently CanvasHost) your plugin works like a charm! Viewing 15 replies - 1 through 15 (of 38 total) 1 [2](https://wordpress.org/support/topic/database-errors-during-writing/page/2/?output_format=md) [3](https://wordpress.org/support/topic/database-errors-during-writing/page/3/?output_format=md) [→](https://wordpress.org/support/topic/database-errors-during-writing/page/2/?output_format=md) The topic ‘Database errors during writing’ 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](https://wordpress.org/support/topic-tag/database/) * [errors](https://wordpress.org/support/topic-tag/errors/) * [server](https://wordpress.org/support/topic-tag/server/) * [writing](https://wordpress.org/support/topic-tag/writing/) * 38 replies * 16 participants * Last reply from: [Cory Lamle](https://wordpress.org/support/users/corylamleorg/) * Last activity: [10 years, 3 months ago](https://wordpress.org/support/topic/database-errors-during-writing/page/3/#post-6129517) * Status: resolved