Quick and dirty sample SQL file: test.sql

Make sure your site definition looks like this (substituting your local values for folders/names/passwords):

Setup for local info:

Setup for remote info:

Setup for testing:

Setup for MySQL connection from the Databases tab in the Application inspector: