I am Migrating The EE from Local Server to Remote Server but I have Installed EE using Defult DB Prefix exp_ but now i need to change Prefix exp_ to abc_ how can I do that?
This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
December 24, 2011 12:42am
Subscribe [2]#1 / Dec 24, 2011 12:42am
I am Migrating The EE from Local Server to Remote Server but I have Installed EE using Defult DB Prefix exp_ but now i need to change Prefix exp_ to abc_ how can I do that?
#2 / Dec 30, 2011 9:20am
——-
#3 / Dec 30, 2011 9:21am
I think you must change all your database tables name from exp_ to abc_
then change :
$db['expressionengine']['dbprefix'] = "exp_"; To $db['expressionengine']['dbprefix'] = "abc_";
$db['expressionengine']['swap_pre'] = "exp_"; To $db['expressionengine']['swap_pre'] = "abc_";in /system/expressionengine/config/database.php
but first get backup your files and database