The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

uploading data definitions to MySQL

Hi everyone,

I am developing a site in PHP using a MySQL database and is hosted off-site. When I originally created the database tables, I used a PHP page that I created that I could cut and past the definitions of each table. It worked great.
Now I need to alter and add to the tables and doing it my original way could be too tedious, because each instance is different. If I was doing this for my version of the database at home, I would write a script, use the mysql.exe and use the script in the source command. (I hope this makes sense)
I was wondering if there is either a PHP command that would take a source script as a parameter, or if there is some way for me to interact with the off-site database directly.

Thanks, I think that is what I will end up doing. I was hoping to be able to write a VERY short php page with one command that would use a text file script to make all of the changes, instead of writing a php page that included a mysql_query for each update I wanted to make.