Auto import data from localhost to webhost

[babu21]

How to import data from local server to web server's database. Please help me anyone.

[r937]

use mysqldump (or equivalent) to dump the data, then run the .sql file into the web server's database

[babu21]

But its a manual process. I want to do this automatically. Do you have any suggestion.

[K. Wolfe]

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?