Changing Database Table prefixs and Upgrade. Possible?

[albos]

Hi,

We are using prestashop for two years. And we are doing great till now and I really appreciate your work

 

Now I have 2 questions.

 

When I created it first for security reasons I changed the ps_ table prefix to ss_ .

 

1. Now If I change all tables to back to ps_ by Running SQL query/queries on database would it be any problem for my website?

 

2. Because of using a different prefix we never upgraded our prestashop and we are using the Version 1.1.0.5 .

Can we upgrade it without problems to latest version after changing table prefixes?

 

Thank you for your time and efforts.

[bellini13]

you can change the prefix using sql commands, you just need to go into your config settings and update the prefix from ss back to ps. on newer versions of prestashop it is located under config/settings.inc.php

define('_DB_PREFIX_', 'ps_');

hopefully the same exists for v1.1

 

you should also be able to upgrade without having to change the prefix back to ps. during the upgrade just make sure the settings.inc.php has the correct database connection information.

[albos]

hi, thanks for replay.

 

I made a full backup and will give it a try right now