Title: Database Error
Last modified: June 23, 2019

---

# Database Error

 *  Resolved [kektus](https://wordpress.org/support/users/kektus/)
 * (@kektus)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/database-error-291/)
 * Hi,
 * I’d like to start this by saying I’m doing an internship, and this is my first
   official website migration using Duplicator. I am no expert.
 * I’ve been trying to use Duplicator to migrate a website on a host. I get all 
   green lights up until step 3, where I get “WARNING: DATABASE ERROR: database 
   error write”,
    and a bunch of row count mismatch errors.
 * `DATABASE: table "wp_usermeta" row count mismatch; expected "493" in database"
   0" DATABASE: table "wp_users" row count mismatch; expected "22" in database"0"
   DATABASE: table "wp_wonderplugin_carousel" row count mismatch; expected "1" in
   database"0" DATABASE: table "wp_wp_topbar_data" row count mismatch; expected "
   1" in database"0" DATABASE: table "wp_yoast_seo_links" row count mismatch; expected"
   4" in database"0" DATABASE: table "wp_yoast_seo_meta" row count mismatch; expected"
   61" in database"0"`
 * It cuts off there. I tried proceeding to step 4, and I see that the database 
   has had 500+ critical errors. However, weirdly most of the site functionalities
   work, articles, pages, menus and most plugins.
 * As seen above, it seems the user database has failed to transfer, and I could
   not access the account I was using on my localserver. The only way I could access
   the site’s dashboard was with a fresh re-install and adding a new account through
   the installation.
 * How do I avoid this?

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

 *  Thread Starter [kektus](https://wordpress.org/support/users/kektus/)
 * (@kektus)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/database-error-291/#post-11664232)
 * I seem to have missed the “GTID” warning, and in my install-log file the errors
   all seem to be because of the GTID Consistency.
 * I am using 1and1 as a host, and I still have no clue how to fix this, google 
   searches don’t seem to be leading me to anything concrete…
 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [6 years, 11 months ago](https://wordpress.org/support/topic/database-error-291/#post-11665207)
 * Hey [@kektus](https://wordpress.org/support/users/kektus/)
 * If you want to submit a [support ticket](https://snapcreek.com/ticket) for this
   issue we can have a closer look at your setup. Please provide a link to this 
   thread when submitting the ticket.
 * Thanks~

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

The topic ‘Database Error’ 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/)

 * 2 replies
 * 2 participants
 * Last reply from: [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * Last activity: [6 years, 11 months ago](https://wordpress.org/support/topic/database-error-291/#post-11665207)
 * Status: resolved