James200410 Posted October 30, 2009 Report Share Posted October 30, 2009 Hi Guys, At the moment I have a development site and a live site using two separate databases in case something goes wrong. Is it safe for me to work both sites from the one database using a _prefix ? If so, since I already have them set up, how do I go about doing it ? Any advice would be mostly appreciated. Regards Adam Quote Link to comment Share on other sites More sharing options...
Tom Posted October 30, 2009 Report Share Posted October 30, 2009 Im sure when you install phpvms it lets you chose a table prefix, just make them different and it's totally fine. Quote Link to comment Share on other sites More sharing options...
James200410 Posted October 30, 2009 Author Report Share Posted October 30, 2009 Ok thanks, so now that I have both already installed, how do I go about changing the _prefix on one of the sites ? Any ideas ? Nabeel ? Quote Link to comment Share on other sites More sharing options...
Tom Posted October 30, 2009 Report Share Posted October 30, 2009 Wait, you have them both installed in one database or seperate databases? If theyre in the same db and you havent already entered seperate prefixes then theyre running from the same tables.. Otherwise, export the data and.. i suppose you could just open it in some form of editor, and do a find and replace (i.e. find "phpvms_" replace with "phpvms2_") Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted October 30, 2009 Administrators Report Share Posted October 30, 2009 You'll have to export the database, in the export file, change all the table prefixes (you'll see phpvms_, change to phpvmsdev_ or something), and then in local.config.php, point it to the right database, and change the TABLE_PREFIX parameter there Quote Link to comment Share on other sites More sharing options...
James200410 Posted October 30, 2009 Author Report Share Posted October 30, 2009 Ok thanks, will give it a try. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.