| Bug #42142 | BLOB data does not transfer | ||
|---|---|---|---|
| Submitted: | 15 Jan 2009 22:17 | Modified: | 12 Apr 2018 17:27 |
| Reporter: | Scott Noyes | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
| Version: | 1.1.15 | OS: | Windows |
| Assigned to: | CPU Architecture: | Any | |
[19 Oct 2009 13:47]
Susanne Ebrecht
Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Migration Toolkit into MySQL Workbench and won't fix this anymore. But we will consider this during implementation into Workbench.
[12 Apr 2018 17:27]
Christine Cole
Posted by developer: Bug affects no released version. No changelog entry needed.
Description: The SQL generated by the migration tool kit does not include the values for BLOB data. For the test shown, the general query log from the target server contains the following statement: INSERT INTO `test`.`t1`(`b`) VALUES ('') How to repeat: I ran the following on the source server: CREATE TABLE t1 (b BLOB); INSERT INTO t1 VALUES ('test'); I ran the Migration Toolkit to copy this table from one MySQL server to another, leaving all defaults. I also tried it with the 'BLOB streaming' option, and no UPDATE statement was generated. Suggested fix: The generated SQL ought to contain the blob values.