Thanks. Just thought of my first suggestion for reviewpost. You have install.php and upgrade.php scripts. Why not have one standalone script called transfer.php which you can manually specify the new databasename and when loaded it will pull up the existing paths (old paths) with a field to change that path for each location that needs changing - domainpath/data paths etc ?
Would make transfers alot easier
1. mysqldump reviewpost tables reviewpost.sql
2. backup /reviewpost directory
3. backup destination database
4. import reviewpost.sql backup into destination database
5. copy /reviewpost directory to destination site
6. edit config.inc.php and config.intr.php to new paths and destination database
7. edit transfer.php to destination database, run transfer.php to update rest of the paths
Would help for those test installing on a local staging server before going live
