I am trying to connect to a mysql database being hosted on a remote site. I am able to connect to mysql on the remote host using mysql_connect() but when I try to select the database using mysql_select_db() it fails. My first question since I am new to both mysql and PHP is can I just ftp a copy of the mysql database from the data directory of mysql on on my local machine and have the hosting administrator put the database folder where it needs to be on his server.
If so;
My second question is where should he put the database on his server so that I can access it.
Thanks,
Jerry