Re: wbcopytables: Invalid option

[Milosz Bodzek]

Hi!

You forgot about quotation marks. It should look like:

wbcopytables-bin --mysql-source="test@127.0.0.1:5619" --target="test@localhost:5713" --source-password="xxx" --target-password="xxx" --table-range '`fmd`' '`items`' '`fmd`' '`items`' '`id`' '`id`' '`id`, `name`, `quantity`, `price`' '`id`' '3' '4'
Connecting to MySQL server at localhost:5713 with user test
12:47:50 [INF][ copytable]: Connection to MySQL opened
12:47:50 [INF][ copytable]: Connecting to MySQL server at 127.0.0.1:5619 with user test
12:47:50 [INF][ copytable]: Connection to MySQL opened
12:47:50 [INF][ copytable]: Connecting to MySQL server at localhost:5713 with user test
12:47:50 [INF][ copytable]: Connection to MySQL opened
BEGIN:`fmd`.`items`:Copying 4 columns of 2 rows from table `fmd`.`items`
12:47:50 [INF][ copytable]: Truncating table `fmd`.`items`
END:`fmd`.`items`:Finished copying 2 rows in 0m00s
12:47:50 [INF][ copytable]: Re-enabling triggers for schema 'fmd'
12:47:50 [INF][ copytable]: No triggers found for 'fmd'
FINISHED

Basically --table-rage get 3 additional arguments (comapred to --table) - 'name of key column', 'start value' and 'end value'.

Regards,

--
Milosz Bodzek
MySQL Developer Tools