Page 1 of 1
dynamic site building on your pc? or on the server?
Posted: Thu Jul 01, 2004 10:20 pm
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.
Posted: Thu Jul 01, 2004 10:40 pm
by feyd
Dev locally, with php/apache/mysql
Posted: Thu Jul 01, 2004 10:48 pm
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?
Posted: Thu Jul 01, 2004 10:50 pm
by feyd
nothing major, that I know of.
Posted: Thu Jul 01, 2004 11:03 pm
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?
Posted: Thu Jul 01, 2004 11:12 pm
by feyd
you mean the mysql binaries, or the export of your database?
Posted: Thu Jul 01, 2004 11:16 pm
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.
Posted: Thu Jul 01, 2004 11:19 pm
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.
Posted: Thu Jul 01, 2004 11:23 pm
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
Posted: Thu Jul 01, 2004 11:24 pm
by bradles
thanks...I think I understand what you are saying.