I have developed a university website. I want to provide them functionality to copy database from online server to offline local system server. so that they can fill details for admit card , and center alloted. After that it should overwrite to the online database on button click.
Export the database to an SQL file: Then send it to them so they can import into an empty database: I don't know about a one-click solution for what you're trying to do, maybe others can enlighten. After above, all you need to do is repeat the process only the other way around.