This may be an easy and maybe even silly question indeed, but i have to ask it anyway. i have *moderate* mysql experience, and what i mean by that is i know how to create and alter tables, and i can put stuff in them and get stuff out, no prob. im much more used to access, and for most of my projects, access works just fine.

heres my question though. with access, i have an mdb file that i just move from development to production and it works. do i have that same kind of file with mysql? or do i have to connect the two servers or something? is this what replication is for or is that just backup?

this may be newbie questions, ill admit, but the documentation isnt very clear.

Thanks in advance,