Following are the details of the database and server:
Server1: Host Name: abc Port Num: 01 database: test
Server2: Host Name: xyz Port Num 02 database: spareparts userid: spts password: abcdefgh@123
I have to copy all tables from database test to database spareparts.
Please guide me how I can copy them. I am new in using mysql. Also please let me know if any other details are required.