Connecting Cs3 to Netfirms MySQL

Report · Feb 25, 2009

Hi!

I'm learning to build a website. I have Dreamweaver Cs3 and I have Netfirms as the website provider. I have CS3 installed and I have a MySQL account on netfirms. I want to connect the two so that I have a dynamic website.
I have seen a lot of help files for installing xampp and having everything on your local PC including the database and web server etc. But I want to connect to the Netfirms database and I certainly don't want to have a PC running 24/7 at home acting as a web server, when Netfirms can do that for me and there will be minimal web server down time? Can someone explain if I am barking up the wrong tree and if I am not, provide a step by step guide to getting my CS3 connected to Netfirms' MySQL?

I would be very grateful and appreciate your patience!

ps I also don't want to do any code and didn't think you had to with Dreamweaver, so if it's possible to do it by point and click that'd be great.

Rookie09

Report · Feb 25, 2009

"rookie09" <webforumsuser@macromedia.com> wrote in message
news:go40lj$fgf$1@forums.macromedia.com...
>
> I have seen a lot of help files for installing xampp and having
> everything on
> your local PC including the database and web server etc. But I want
> to connect
> to the Netfirms database and I certainly don't want to have a PC
> running 24/7
> at home acting as a web server, when Netfirms can do that for me and
> there will
> be minimal web server down time? Can someone explain if I am barking
> up the
> wrong tree

Yes, you're barking up the wrong tree. The purpose of installing XAMPP
or a similar local testing environment is to develop your dynamic
pages locally, and upload them to your live website only when they're
fully tested and ready. You can transfer the content of your database
to the remote server by using phpMyAdmin (which is installed with
XAMPP) to export the data, and then use phpMyAdmin on your remote site
to import it.

XAMPP is for local testing, not for running the website/database on a
24/7 basis. Although it is possible to use a remote database when
building a site with Dreamweaver, local testing is faster and
generally more secure.

--
David Powers
Adobe Community Expert, Dreamweaver
http://foundationphp.com

Report · Feb 25, 2009

Hi Dave

This is a great help - thank you - and also a swift reply. Fantastic.
I had a suspicion what you said about testing the site on a home PC was kind of the best way to go during the development stage. Great.
OK, so I will follow the instructions about xampp, get that all going, get the website nice and slick, then upload it to the netfirms server. Could you provide me with a link to instructions on doing this last part (upload to netfirms)?
Also, one final question. My website will be accepting record entries from users 24/7 and then showing those entries on other pages on my site, hopefully as soon as they have entered a record. Example, they enter their favorite colour, eg "BLUE" and then once submitted, I want this to appear on another page. If, say, 10 people say BLUE then it would say BLUE 10, but immediately, updating on a REAL TIME basis. Hence the desire to have the Netfirms server be the principal web server. So I assume that once I have uploaded my website, that it can have this funtionality without any need for manual uploading or information, which would be a bad thing.

Once again, thank you for your help and time and I look forward to your response.

cheers!

Slightly Less Rookie Than 1 hour Ago 09

Report · Feb 25, 2009

"rookie09" <webforumsuser@macromedia.com> wrote in message
news:go43l3$j2q$1@forums.macromedia.com...
> I will follow the instructions about xampp, get that all going, get
> the
> website nice and slick, then upload it to the netfirms server. Could
> you
> provide me with a link to instructions on doing this?

To export a database from MySQL with phpMyAdmin, select the database
in phpMyAdmin, and click the Export tab. This opens a page with a lot
of options, but usually all the defaults are fine. Select Save as
file, and click Go.

That creates a text file with a .sql filename extension. To import it
to your remote web server, go to your hosting company's version of
phpMyAdmin, select the database, and click the Import tab. Browse to
the .sql file on your local hard disk, and click Go. That's all there
is to it.

> So I assume that once I have uploaded my website,
> that it can have this funtionality without any need for manual
> uploading or
> information, which would be a bad thing.

Once you're using the live website, data should be saved in the remote
database. When your web pages are displayed, they access that data, so
there is no need for manual uploading once you have made the site go
live.

--
David Powers
Adobe Community Expert, Dreamweaver
http://foundationphp.com

Report · Feb 25, 2009

Brilliant!

Thank you David, your advice is excellent!

Right. Time to get to work...

Rookie09