Is it possible to connect to your sites database with your pc?

[Darren]

Hi is this allowed or possible?

[Jonathan]

Yes and no; read here for more info:

http://forums.dathorn.com/showthread.php?t=216

[Darren]

So I cant just use a config.php file? Darn!

[Skky]

Nope, but it isn't really as hard as it seems. I think it is worth setting up, if you plan on developing large PHP/MySQL scripts, or if you plan on making changes to a database often.

[Darren]

It was so I could insert mysql info from my computer (from a script ran on my computer). Oh well

[Ihost]

No you can't do it from a script on your PC direct to the database (I think).

However you can run the script against a local copy of your database. Then do a sqldump of the database (data only if no change to structure). The upload the .sql file to your account and run it against your hosted database.

That is after backing up of course. If you set up the SSH Port Forwarding you can use some good MySQL GUI programs on your PC to do this which works really fine.