Click to See Complete Forum and Search --> : Issues with Test Environment


poplar
05-12-2006, 04:36 AM
Hi Guys

I have been asked to play around with the current website and make some changes etc, before i launch into it i want to get a good idea of how it is structured etc. It's written in PHP with a MYSQL backend. I have setup a test environment on my local machine and copied the files from the existing site by grabbing them via FTP ... now everything runs via localhost except i cannot connect to mysql via phpmyadmin i played around with the settings in the config.inc.php file and it allowed me into phpmyadmin but there was no database??

How do i see the actual mysql tables or at least get a .sql file dump so i can recreate an identical test db ??

Hope that's clear enough

Thx

P

afmook
05-18-2006, 10:51 AM
It sounds like you copied everything from the website except for the database that you need to mess with. FTP will not download a MYSQL database. The website is usually located in one location on a machine and the database on another, the website simply connects to it, gets the information and closes the connection. You would need to access the host machine (I'm assuming this is the only machine, if it's a full network then you'd have to access the DB machine) and get a dump of the database. Import that onto your local machine and it should be able to test properly.