I am trying to go about creating a mysql database on my site and then exporting a copy of it to my local machine so I can test it to write a login script. I have tried the suggestions from the following link:
viewtopic.php?t=26340&postdays=0&postorder=asc&start=0
I have managed to export a copy of the database with one table to my local machine but it is sitting in my root folder where index.php resides.
I emailed my host to find out the path to the database so I can try and mimick that on my testing server and this is the response I got:
I don't know if I should actually post the folder mentioned in the quote above so if it is a security risk, please let me know and I will modify it for safety.well although the path to the databases is /var/lib/mysql/databasename you do not have explict access to the above path. Using the phpmyadmin from your mysql feature, you can manage the mysql database and upload your database.
I have php and mysql servers set up and running fine on my local machine. Now I just need to know how to hook up this database and start testing it. Could someone give me a hand with this one please?
Brad.