Db on Live Site and Replica on Development PC

Hi Folks, I'll bet someone here has fixed this challenge in the past.

I have a Db on my live site, I use DW to manage the site and phpMyAdmin to
manage the mySQL Db, and I'd like to do the following:

1. Replicate the Db on my Dev PC, to modify then reset the live version on
the site to match it.

2. Set phpMyAdmin config to look at the PC version of the Db when developing
and the Live version when its up on the site.

Hope these make some sort of sense - just new to the world of php and mySQL
(actually an MS developer). Any suggestions appreciated.

Cheers

--
Kahuna
------------

1. If you want to replicate, then look at a master slave config.

2. phpMySqlAdmin can handle multiple DB servers. look in the config
file
--
Jay
http://d2t2fish.blogspot.com