I am a beginning web developer just starting to work with MySQL. My question is how closely or exactly does my development environment have to match the production environment provided by my host in regard to a MySQL database.
For example, the production environment is Linux, Apache, PHP supported, would a MySQL database developed in MySQL on a Windows machine with IIS work when moved onto the Linux server, assuming I use the same version # of MySQL and that I code in PHP?