How to import data from local server to web server's database. Please help me anyone.
use mysqldump (or equivalent) to dump the data, then run the .sql file into the web server's database
But its a manual process. I want to do this automatically. Do you have any suggestion.
Are you looking to set up replication from one machine to another (changes are made to both servers at the same time), or do you want one push of a button for this to happen?