copy some tables from one to another host
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
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.
mysqldump is exactly what you're looking for
[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
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.
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.
Originally Posted by stymiee
now i can try to make single one command . too
anywayz thanks a lot for helping me on time .