Title: Wrong database export Last modified: June 27, 2017 --- # Wrong database export * Resolved [bogdanteodoru](https://wordpress.org/support/users/bogdanteodoru/) * (@bogdanteodoru) * [8 years, 10 months ago](https://wordpress.org/support/topic/wrong-database-export/) * Hello, * So apparently when using the plugin to backup the database, all tables/columns that have data on them with 0 and 1 (varchar columns) don’t get exported correctly. * To be more exact, on the previous 3.3.7 when exporting a table that has 0 or 1 as data inside, the exported database contains the same 0 and 1 * On version 3.4.0, when exporting, 0 is converted to ” (empty string) and sometimes 1 is converted to ” (empty string) as well. * I see in the changelog that “Improved: accuracy of binary column export.” was added. This might be the thing that broke this. * This happens to me when using thrive plugin which inserts 0’s and 1’s in the database. Viewing 9 replies - 1 through 9 (of 9 total) * Plugin Contributor [Brandon Olivares](https://wordpress.org/support/users/cocreation/) * (@cocreation) * [8 years, 10 months ago](https://wordpress.org/support/topic/wrong-database-export/#post-9265914) * [@bogdanteodoru](https://wordpress.org/support/users/bogdanteodoru/), can you show me a sample create table statement for which the inserts would cause this to happen, pointing out exactly which column is problematic? * Thread Starter [bogdanteodoru](https://wordpress.org/support/users/bogdanteodoru/) * (@bogdanteodoru) * [8 years, 10 months ago](https://wordpress.org/support/topic/wrong-database-export/#post-9269267) * Hi Brandon, * So I will attach some screenshots of the queries from the database. From what I saw, the tables and data are exported in a HEX (0x11112132131 – whatever) data. I’m not sure where the bug comes from, what I can tell you is that the previous version works so probably the new MySQL driver or whatever you guys are using for the export doesn’t do the job properly. * Data in the table. ⌊Data in the table⌉ * No data check 1. ⌊lightbox_no_data_1⌉ * No data check 2. ⌊lightbox_no_data⌉ * Thread Starter [bogdanteodoru](https://wordpress.org/support/users/bogdanteodoru/) * (@bogdanteodoru) * [8 years, 10 months ago](https://wordpress.org/support/topic/wrong-database-export/#post-9269272) * P.S: Ignore the post_id. There were the same for all of them so it’s not a matter of wrong post id 🙂 Thank you. * Plugin Contributor [Brandon Olivares](https://wordpress.org/support/users/cocreation/) * (@cocreation) * [8 years, 10 months ago](https://wordpress.org/support/topic/wrong-database-export/#post-9277590) * Hi [@bogdanteodoru](https://wordpress.org/support/users/bogdanteodoru/), can you let me know if it works on 3.4.1? * Thread Starter [bogdanteodoru](https://wordpress.org/support/users/bogdanteodoru/) * (@bogdanteodoru) * [8 years, 10 months ago](https://wordpress.org/support/topic/wrong-database-export/#post-9278352) * Sure, I’ll give it a try as soon as possible and get back to you. * Plugin Contributor [Brandon Olivares](https://wordpress.org/support/users/cocreation/) * (@cocreation) * [8 years, 10 months ago](https://wordpress.org/support/topic/wrong-database-export/#post-9295616) * Hi [@bogdanteodoru](https://wordpress.org/support/users/bogdanteodoru/), just wanted to check in to see if this was working for you. * Thread Starter [bogdanteodoru](https://wordpress.org/support/users/bogdanteodoru/) * (@bogdanteodoru) * [8 years, 10 months ago](https://wordpress.org/support/topic/wrong-database-export/#post-9297620) * Hi, Brandon. Haven’t yet got a chance to test sorry. Been away and doing other stuff. I will give it a go today. * Thread Starter [bogdanteodoru](https://wordpress.org/support/users/bogdanteodoru/) * (@bogdanteodoru) * [8 years, 10 months ago](https://wordpress.org/support/topic/wrong-database-export/#post-9297649) * Hi Brandon. Seems to be fixed in 3.4.1. Thank you for all the help. * Plugin Contributor [Brandon Olivares](https://wordpress.org/support/users/cocreation/) * (@cocreation) * [8 years, 10 months ago](https://wordpress.org/support/topic/wrong-database-export/#post-9298321) * Great to hear! 😀 Viewing 9 replies - 1 through 9 (of 9 total) The topic ‘Wrong database export’ is closed to new replies. * ![](https://ps.w.org/backwpup/assets/icon-256x256.png?rev=3236141) * [BackWPup – WordPress Backup & Restore Plugin](https://wordpress.org/plugins/backwpup/) * [Support Threads](https://wordpress.org/support/plugin/backwpup/) * [Active Topics](https://wordpress.org/support/plugin/backwpup/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/backwpup/unresolved/) * [Reviews](https://wordpress.org/support/plugin/backwpup/reviews/) ## Tags * [export](https://wordpress.org/support/topic-tag/export/) * [wrong](https://wordpress.org/support/topic-tag/wrong/) * 9 replies * 2 participants * Last reply from: [Brandon Olivares](https://wordpress.org/support/users/cocreation/) * Last activity: [8 years, 10 months ago](https://wordpress.org/support/topic/wrong-database-export/#post-9298321) * Status: resolved