I have two MySQL servers both have the same Database structure.
I want to copy all data from Server1 to Server2.
1- You need to build a procedure that detect all tables on server1 then copies all Data of each one of them to the table that share the same name on server2.
2- I have some tables that have LongBlob fields (jpg files > 45MB)
3- The character set of both DBs are UTF-8 encoding