mysql locally

is it right to do?

[Acternaweb]

I am new to mysql and php programming for that matter. I read that I should install mysql and phpmyadmin locally. Is that right? Will I be able to "move" the local to my host?

Is it hard to load?

[slade7]

You can install it locally, but it has to be on the host as well. Having it local helps with testing & learning different things, and you can take export the data and import it to the web host, and adjust the db connection strings in the php scripts and move them up to the host as well -- this assuming your host already has php/mysql/phpmyadmin installed. Many do, but if you are hosted on a windows machine it probably doesn't.

If you install it on windows IIS as a cgi, there will be a few things you can't do compared to having on *nix/Apache as a module - but it will work basically the same. If you are used to using windows, I suggest installing phpmyadmin too. You will have to fiddle with the config files for all three to get them set up properly.