Create database outside of the root directory

austenr

Hi,

Can you create a database that does not reside in the root directory? I have my root directory in C: and I would like to create a database in my network shared drive. Can you do that? Thanks

bradgrafelman

I'm confused by what you mean... what do you mean a "database" ? Are you talking about a database server, such as MySQL/MSSQL/Oracle/etc. ?

As far as accessing network drives, if you have a drive mapped (e.g. "W:\" mapped to a network resource), then yes, PHP can access that network drive. If you're talking about accessing a network resource via a UNC path, then the answer is still yes.

* - This is assuming that the user account that PHP is running under has permissions to access the remote folder.

austenr

I completed a project for a work collegue in PHP that searches a table I built in mySQL using my WAMP server.

The project is complete and she needs it to get up and running. Having no help from our wonderful IT department I am trying to see if the following is possible:

Determine what database is on our intranet, Oracle SQL Server, etc.

I know there is one because there are other PHP pages running. I was hoping I could create my own DB on our intranet server with WAMP that is running on my machine.

Probably too much to ask for though.

bradgrafelman

If you have access to the DB, then of course you can use it. [man]mysql_connect/man asks for a "server" parameter for a reason.

austenr

I will give it a try. Thanks

austenr

OK I think I understand the concept here. What would my mysql_connect need to be if my php app is on say the z: drive and my localhost is in C:/wamp/www?

<?php

//mysql_connect("localhost");

//mysql_select_db("cpdata" user="root" password=" ");
$link = mysql_connect('localhost', 'root', '');
if (!$link) {
    die('Not connected : ' . mysql_error());
}

// make cpdata the current db
$db_selected = mysql_select_db('cpdata', $link);
if (!$db_selected) {
    die ('Can\'t use cpdata : ' . mysql_error());
}

//mysql_query("LOAD DATA LOCAL INFILE '/Webcdm.csv'
mysql_query("LOAD DATA INFILE '/wamp/www/Webcdm.csv'
INTO TABLE cpddata
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(description,defaultcpt,industrial,federal)") or die ("Query failed: " . mysql_error());

?>

cahva

It doenst matter what drive is PHP and MYSQL. If the mysqlserver is running on the same machine, you just connect to localhost.

austenr

One last question I know it may be stupid. If I move my php app to another drive can anyone on another machine access it by http://localhost/blahblah.php?

bradgrafelman

Again, it doesn't matter where the content is stored. You can store it on a floppy disk for all that we care; what matters is: Is the webserver (Apache/IIS/etc.) configured to serve content from that location? That's all that matters. You can point the webserver off to any ol' drive you want, as long as you configure it properly.

austenr

That is the problem I guess. I don't know how to configure the server correctly. Can you please point me to resources on how to do that.