beginner development process

[javaPete]

Whats the best way to develop mySql database to live server?

I've work for many years with Access file based database and development was pretty straight forward:
1. design, develop, and test database on local server.
2. after fully tested, ftp up to live server.

When comes to mySql management system, I'm not sure how to proceed. I've downloaded and learned how to use the control center and admin interfaces. I've even taken tutorials working at the command line. While this is all good its still all local how the heck do i get it up to a live server. I've read you can use admin tool to dump the data out, but once you've done that what do you do with it? And once you have it up to the server how do you get it back to your machine to back it up or work on it?

obviously im a beginner so any help would be appreciated. thx

pete

[raf]

see the sticky about creating and importing dumpfiles

[javaPete]

thx that sticky thread helped.

Part of my confusion was the nature of the mysql admin tool, I was under the assumption that it was a client app that could only be run locally. When i visited my host's cpanel page I discovered that admin tool has web based interface too. I starting to get use to running a remote application.