This topic is locked

How to change server/db/user... without messing project

6/16/2007 9:07:14 PM
PHPRunner General questions
J
jmmarrs author

I have recently had to change hosts and it was easy enough to move the mysql db BUT.... I had no option except to change:

  1. the server name
  2. the data base name (only one db in this project but about 7 tables)
  3. the User name
  4. the user PW
    I successfully uploaded phprunner.php to the root directory and successfully connected.
    How do I redirect my project(s) to use the new location without rebuilding from scratch. Everything is the same except where the db is hosted. My tables are the same. the fields.... everything. I have set properties and modified via the visual editor lots of pages.
    Can I edit the the .phpr file or something??? (I actually tried this via scan/replace the connect info but with poor results.)
    Thanks,
    Mike

J
jmmarrs author 6/16/2007

I believe this is resolved... I re-edited the .phpr project file and replaced all occurrences of the 4 items with the new server/user/pw... info and it worked! My problem the first time around was that on the new host, I do not have a separate server name for the db machine vs. the web site thus I needed to use 'localhost' as the name.