dynamic site building on your pc? or on the server?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
bradles
Forum Commoner
Posts: 89
Joined: Wed Jun 30, 2004 10:40 pm

dynamic site building on your pc? or on the server?

Post by bradles »

Do many of you work with your mysql databases and php straight off the server? Or do you usually work on your own computer to ensure your dynamic site runs smoothly and then upload it to your server?

I'm wondering what I should do as I am reasonably new to php/mysql. I do have apache/mysql/php installed and running ok.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Dev locally, with php/apache/mysql
bradles
Forum Commoner
Posts: 89
Joined: Wed Jun 30, 2004 10:40 pm

Post by bradles »

feyd wrote:Dev locally, with php/apache/mysql
Thanks feyd,

My server uses Apache 1.3.31, PHP 4.37 and MySQL 4.0.18-standard. I have apache 2, PHP 4.36 and MySQL 4.0.18 installed on my system...am I likely to have problems seeing that i run apache 2?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

nothing major, that I know of.
bradles
Forum Commoner
Posts: 89
Joined: Wed Jun 30, 2004 10:40 pm

Post by bradles »

feyd,

Is it fiddly to upload your site onto your web server? The reason I ask is that if I upload my mysql it will go into a /bin/lib/mysql folder on the web server...does that mean it is a good idea to set a path variable in my local database connection script and just change that when I upload to the web server?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

you mean the mysql binaries, or the export of your database?
bradles
Forum Commoner
Posts: 89
Joined: Wed Jun 30, 2004 10:40 pm

Post by bradles »

feyd wrote:you mean the mysql binaries, or the export of your database?
To give you an example:
I will be working locally on my system creating a virtual site that uses a MySQL database. When it comes to uploading the site the mysql database will go into a different directory on the web server called usr/lib/mysql. That will be a different folder to what will be on my local site...or can I make it the same. Sorry, I am fairly new to php/mysql/apache so I am learning as I go.
I just thought that I will have a php script that connects to the database and it will need to know where it is located.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

php doesn't need to know where the database files are located. In order to import your local database to the server, it's easiest to export your local database and its contents.
User avatar
ol4pr0
Forum Regular
Posts: 926
Joined: Thu Jan 08, 2004 11:22 am
Location: ecuador

Post by ol4pr0 »

I think he actually wants to upload the mysql\data directory.

In which that is not such a bright idea, it can be done tho but as feyd already said ( kinda ) you should Import/Export the data from ure local computer to the server.

mysql-front , phpadmin and prolly some more can do that easely for you
bradles
Forum Commoner
Posts: 89
Joined: Wed Jun 30, 2004 10:40 pm

Post by bradles »

thanks...I think I understand what you are saying.
Post Reply