MySQL Bugs: #66135: Can not copy data from source into target database

Bug #66135	Can not copy data from source into target database
Submitted:	1 Aug 2012 1:45	Modified:	26 Sep 2012 13:07
Reporter:	Riko H	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: Migration	Severity:	S2 (Serious)
Version:	5.2.41, 5.2.42	OS:	Windows (Ubuntu)
Assigned to:		CPU Architecture:	Any
Tags:	Migration MySQL Workbench

Description:
Friends,

I tried to migrate from MySQL server in my windows7 into MySQL in Ubuntu server,
All the table in database has been created successfully, but can not copy the data ( record ) inside the table, 

What configuration should I fix ?
Thanks

The Log on "Bulk Data Transfer" : 

Data copy results:

- `test`.`field_data_field_tags` has FAILED (0 of 0 rows copied)

- `test`.`menu_router` has FAILED (0 of 554 rows copied)

- `test`.`cache_image` has FAILED (0 of 0 rows copied)

- `test`.`field_revision_comment_body` has FAILED (0 of 0 rows copied)

- `test`.`date_format_locale` has FAILED (0 of 0 rows copied)

- `test`.`block` has FAILED (0 of 144 rows copied)

- `test`.`cache_views_data` has FAILED (0 of 0 rows copied)

- `test`.`authmap` has FAILED (0 of 0 rows copied)

- `test`.`cache_page` has FAILED (0 of 0 rows copied)

- `test`.`cache_media_xml` has FAILED (0 of 0 rows copied)

- `test`.`media_filter_usage` has FAILED (0 of 0 rows copied)

- `test`.`captcha_points` has FAILED (0 of 11 rows copied)

- `test`.`actions` has FAILED (0 of 12 rows copied)

- `test`.`cache_views` has FAILED (0 of 14 rows copied)

- `test`.`cache` has FAILED (0 of 0 rows copied)

- `test`.`image_styles` has FAILED (0 of 0 rows copied)

- `test`.`media_list_type` has FAILED (0 of 0 rows copied)

- `test`.`ctools_css_cache` has FAILED (0 of 0 rows copied)

- `test`.`filter` has FAILED (0 of 33 rows copied)

- `test`.`block_node_type` has FAILED (0 of 2 rows copied)

- `test`.`delta` has FAILED (0 of 1 rows copied)

- `test`.`file_managed` has FAILED (0 of 15 rows copied)

- `test`.`cache_path` has FAILED (0 of 0 rows copied)

- `test`.`node_access` has FAILED (0 of 1 rows copied)

- `test`.`field_revision_field_tags` has FAILED (0 of 0 rows copied)

- `test`.`field_config_instance` has FAILED (0 of 8 rows copied)

- `test`.`ctools_object_cache` has FAILED (0 of 0 rows copied)

- `test`.`cache_filter` has FAILED (0 of 4 rows copied)

- `test`.`cache_form` has FAILED (0 of 0 rows copied)

- `test`.`context` has FAILED (0 of 0 rows copied)

- `test`.`flood` has FAILED (0 of 0 rows copied)

- `test`.`filter_format` has FAILED (0 of 3 rows copied)

- `test`.`date_formats` has FAILED (0 of 35 rows copied)

- `test`.`blocked_ips` has FAILED (0 of 0 rows copied)

- `test`.`image_effects` has FAILED (0 of 0 rows copied)

- `test`.`file_display` has FAILED (0 of 0 rows copied)

- `test`.`cache_field` has FAILED (0 of 12 rows copied)

- `test`.`field_revision_field_image` has FAILED (0 of 0 rows copied)

- `test`.`history` has FAILED (0 of 9 rows copied)

- `test`.`cache_block` has FAILED (0 of 0 rows copied)

- `test`.`date_format_type` has FAILED (0 of 3 rows copied)

- `test`.`node` has FAILED (0 of 9 rows copied)

- `test`.`field_data_comment_body` has FAILED (0 of 0 rows copied)

- `test`.`cache_bootstrap` has FAILED (0 of 6 rows copied)

- `test`.`menu_custom` has FAILED (0 of 6 rows copied)

- `test`.`field_revision_body` has FAILED (0 of 9 rows copied)

- `test`.`field_config` has FAILED (0 of 4 rows copied)

- `test`.`captcha_sessions` has FAILED (0 of 0 rows copied)

- `test`.`comment` has FAILED (0 of 0 rows copied)

- `test`.`batch` has FAILED (0 of 0 rows copied)

- `test`.`file_usage` has FAILED (0 of 0 rows copied)

- `test`.`ckeditor_input_format` has FAILED (0 of 2 rows copied)

- `test`.`menu_links` has FAILED (0 of 437 rows copied)

- `test`.`field_data_body` has FAILED (0 of 9 rows copied)

- `test`.`cache_update` has FAILED (0 of 18 rows copied)

- `test`.`brilliant_gallery_image_arrays` has FAILED (0 of 76 rows copied)

- `test`.`block_role` has FAILED (0 of 1 rows copied)

- `test`.`cache_menu` has FAILED (0 of 70 rows copied)

- `test`.`field_data_field_image` has FAILED (0 of 0 rows copied)

- `test`.`block_custom` has FAILED (0 of 4 rows copied)

- `test`.`contact` has FAILED (0 of 1 rows copied)

- `test`.`brilliant_gallery_checklist` has FAILED (0 of 14 rows copied)

- `test`.`media_type` has FAILED (0 of 4 rows copied)

- `test`.`ckeditor_settings` has FAILED (0 of 3 rows copied)

0 tables of 64 were fully copied

Copy data to target RDBMS finished

Finished performing tasks.

How to repeat:
Database -> Migrate

Migration log

Attachment: migration log.txt (text/plain), 12.00 KiB.

Anyone has experiences ?

MySQL migration report

Attachment: MySQL Workbench Migration Wizard Report.txt (text/plain), 51.78 KiB.

In the data migration options page in the wizard, there's an option for Enable debug output for table copy.
Can you enable that and retry and then paste the log output here?

Log output from data copy

Attachment: log output.txt (text/plain), 12.02 KiB.

I put the log of the output above

Hi,
I have the same issue here.
It all seems ok before WorkBench tries to "Copy data to target RDBMS".
It will only create the tables, but it will not copy the data.
(see logfile)

(I also get an error when I try to enable the sql-ouput file during the migration steps)

Output logfile

Attachment: Output_log.txt (text/plain), 24.33 KiB.

Thanks for your report Riko
Can you please provide a little more data such as:
1. MySQL Version in from the source DB (Windows7).
2. MySQL Version in from the target DB (Ubuntu).
3. A SQL dump of the DB that you want to migrate.
Thanks.

1. MySQL on window 7 :

    Server: localhost via TCP/IP
    Server version: 5.5.16
    Protocol version: 10
    User: root@localhost
    MySQL charset: UTF-8 Unicode (utf8)
2. MySQL on Ubuntu

    Server: Localhost via UNIX socket
    Server version: 5.5.16
    Protocol version: 10
    User: root@localhost
    MySQL charset: UTF-8 Unicode (utf8)

SQL Dump from Ubuntu server

Attachment: test_ubuntu_20_august_2012_v1.0.sql (text/x-sql), 68.38 KiB.

I have exactly the same problem, the migration works fine until the bulk data transfer, that reports Data copy results as - `dbo`.`People` has FAILED (0 of 467 rows copied).

Tried this with version 5.2.42CE of the workbench but that failed in the same way.

Using Windows 7 and SQL Server 2012 Community Edition (Free version).

Thanks for the info Riko.
I tried to reproduce this bug entering data to the SQL dump that you provided without success. Can you please provide a dump of the SOURCE DB which contains all the data that you want to import?
Thanks.

Also experiencing the issue
Source is ODBC - Sql Native client 11, SQL Express 2012, Windows 7

Target is MySQL 5 on CentOS

Tables are all created correctly but the data transfer fails on every table.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".