Guest vixen Posted May 7, 2005 Share Posted May 7, 2005 Hi, I have set up Cubecart 2.07. I did not enter a Prefix for my database tables. Is it possible to do so now after deleting my install.php regards Vixen Quote Link to comment Share on other sites More sharing options...
Guest Posted May 7, 2005 Share Posted May 7, 2005 No, once the database is setup, you cannot add a prefix without going back through the install process again. Quote Link to comment Share on other sites More sharing options...
Guest Posted May 8, 2005 Share Posted May 8, 2005 Actually it is possible but very tricky. Why do you need to do this? I thought the days of hosts providing only 1 mysql database were long gone. I would urge you not to do this unless you really need to as whatever else you have mixed in with your cubecart database can compromise your cubecart security. However, if you insist, you wil need to perform the following SQL on each table via phpmyadmin. Backup first!! ALTER TABLE `XXX` RENAME `prefix_XXX`; then you will need to change $config['dbprefix'] = ''; prefix in your includes/global.inc.php A similar process woul apply with cc2, but you would need to change the settings in admin/config.php 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.