Re: wbcopytables: Invalid option
Posted by: Milosz Bodzek
Date: June 20, 2016 04:52AM

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

Options: ReplyQuote


Subject
Written By
Posted
Re: wbcopytables: Invalid option
June 20, 2016 04:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.