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
Im sure when you install phpvms it lets you chose a table prefix, just make them different and it’s totally fine.
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 ?
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_”)
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
Ok thanks, will give it a try.