I'm my own developer for my little discussion forum and commerce website. So far so good.
Now I want to create a complete/exact copy of my production site so I can do development work without putting the production site at risk. I registered a domain www.dev-foosite.com that I hope can become the copy of my site www.foosite.com
Here's the snag. I have a VPS hosting account which works great so far -- but I can't use the cpanel backup from the main site, as a restore to the dev site. My hosting company says that there is a username conflict and even if we change the username, then the mySQL databases will need to be renamed.
So before I get wrapped around the axle on this, how should I proceed? I'd rather not have to purchase another separate hosting account but if that's the only answer I guess I will.
Go to phpmyadmin and export the database. In cpanel, go and make a new database. Then in phpmyadmin. Import the database.
Now, download all of the files into a folder from the forum using an FTP client like Filezilla
Then upload the previously downloaded files to the dev site
Edit config.php with the new database and password and change the server settings in admin control panel in phpbb to your new webiste url.