mysqldump - server to server - all tables?
Posted on 2007-11-23
mysqldump tool is a new one to me, i have been reading the many many MANY uses for it, but one in particular i wish to use, to dump an entire DB to a new DB server.....
I have attemped to use the below string, but nothing happens, so as usual, i blame myself :) for likely mssing something , or miss understanding something
mysqldump --opt -h 220.127.116.11 -u root | mysql --host=18.104.22.168 --user=root -C
now since i want it to copy ALL tables, do i need to specify anything after -C ?, moving the data from server 22.214.171.124. to server 126.96.36.199
i do it in a mysql command prompt and i press enter and all i get is a new line
and nothing happens, neither DB has password on it so i didnt include the -p part.