copy some tables from one to another host

[priti]

Hello,

I wanted to know weather mysql have any functionality where it is able to transfer some tables to other remote machine db.

like on my machine i have
vehicles
style

now i wanted to transfer this set of tables to other host's db

any command line ?is mysqldump is useful in this?? Any pointer will be a great help.

Regards

[stymiee]

mysqldump is exactly what you're looking for

[priti]

[QUOTE=stymiee;3719650]mysqldump is exactly what you're looking for[/QUOTEplease give me an example

i am trying something like

mysqldump --host=localhost --opt my_com_new VehicleType Style |mysql --host 'host_ip_address' my_com_new VehicleType Style

error
Access denied for user: 'root@localhost' (Using password: NO) when trying to connect

kindly suggest some working example above is my code kindly let me know how can i correct this.

Regards

[stymiee]

You need to also provide your password as the error message suggests.

See this page for the proper syntax for doing this.

[priti]

You need to also provide your password as the error message suggests.

See this page for the proper syntax for doing this.

I have done this but not in one command i am making dump file first and then in second command running it.

now i can try to make single one command . too

anywayz thanks a lot for helping me on time .