mysql database

[delvedesigns]

While I learn php, I have signed up for a free database to use at spaceports. I am wondering if the php sites that I put on my powweb account will be able to communicate with the mysql spaceports database.

Also, after I learn php and decide to pay the 30 dollars activation fee and use mysql on powweb, can I some how switch my database at spaceports over to my powweb account? Is it easy to save and then upload on the powweb account?

Thanks for your help.

[wwuud]

I would reccomend doing all your testing on spaceports and avoid the complications that might arise going cross-server. I did a test version of PostNuke on spaceports and had little problem transferring the system to PowWeb.

I used phpMyAdmin to do a dump of the MySQL tables, and after editing the table names in the sql file, pasted the sql query into a copy of phpMyAdmin running on PowWeb. There is also a utility program available in the MySQL distribution (win binaries) called mysqldump that does a similar function. It's DOS command-line program - great for automated batch files, a bit of a pain otherwise. I use it for doing automated MySQL 'mirrors' of databases from one server to another (on some academic servers, not on PowWeb).

Even though i did some learning on Spaceports, the extremely slow response of their servers makes going ahead and forking out the $30 setup to PowWeb a good idea. It's a one-time charge and otherwise costs you nothing extra, so unless you have a critical site running here, go ahead & test here....
(or test here anyway, just carefully!).