mySQL question...

likeglue

I used mySQL to create a practice database called petCatalog. In it I made a table called Pet with various fields. I'm trying to load a data file called pets.txt to populate the table, so I put the file in my webserver documents (I'm viewing on "localhost" on internet explorer). When I tried to load it, I got an error saying the file "...petCatalog/pets.txt could not be found." So obviously I have the pets.txt file in the wrong place. So here's my problem... I can't find where the petCatalog database is on my harddrive to put the pets.txt file in the same directory. I did a search for petCatalog and nothing came up. I also searched around manually, but I can't seem to find it. Can anyone help?

thorpe

mysql is a database server. doesnt quite work like that. you'll need to read the file with php, then insert it into the db.

not quite sure what you meen by;

I'm trying to load a data file called pets.txt

what does the contents of this file look like?

likeglue

Here's the file. I know there's an upload command in mySQL where you can load text files to populate a table instead of typing in the data manually (usually tab or comma delimited text). Just wondering where to put the damn thing to get it to work.

likeglue

Also, I'm on a Mac if that makes any difference (no "C" drive and all of that nonsense).

Drakla

if you txt file is in the same directory as your script use something like this

$thisDir = dirname($_SERVER['SCRIPT_FILENAME']);

$myFilePath = $thisDir . '/myfile.txt';

You can also use dirname(FILE) and if you've got magic quotes on the original version will have double backslashes in the path on a windows machine, don't know if Macs use forward or backslashes for paths, but just letting you know