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.
-
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.
No data check 1.
No data check 2.
The topic ‘Wrong database export’ is closed to new replies.
