PrestaShop multiple database

[PrestaNoobDev]

Hi all,

I have a site with PrestaShop e-commerce, and now I want to make copies of this website in order to have identical sites "clones" of hosting and different server on which I will translate only the language but I would use a clone site "Managerial shop" to add, edit and delete products and categories simultaneously on all the shops.

Example :

Shop

Shop Clone 2

Shop Clone 3

Managerial shop (to be used as a management)

I want to change the "Shop Management" in order to run his queries on other shop "Store" "Store Clone 2" "Shop Clone 3" I had thought to do this by changing the "settings.inc.php" file of "Shop Management" in this way:


define ( '_ DB_SERVER_', 'ip_server_shop');
define ( '_ DB_NAME_', db_name_of_shop ');
define ( '_ DB_USER_', 'db_user_of_shop');
define ( '_ DB_PASSWD_', 'db_password_of_shop');
define ( '_ DB_PREFIX_', 'ps_');
define ( '_ MYSQL_ENGINE_', 'InnoDB');

define ( '_ DB_SERVER_', 'ip_server_shop_clone_2');
define ( '_ DB_NAME_', db_name_of_shop_clone_2 ');
define ( '_ DB_USER_', 'db_user_of_shop_clone_2');
define ( '_ DB_PASSWD_', 'db_password_of_shop_clone_2');
define ( '_ DB_PREFIX_', 'ps_');
define ( '_ MYSQL_ENGINE_', 'InnoDB');

define ( '_ DB_SERVER_', 'ip_server_shop_clone_3');
define ( '_ DB_NAME_', db_name_of_shop_clone_3 ');
define ( '_ DB_USER_', 'db_user_of_shop_clone_3');
define ( '_ DB_PASSWD_', 'db_password_of_shop_clone_3');
define ( '_ DB_PREFIX_', 'ps_');
define ( '_ MYSQL_ENGINE_', 'InnoDB');


And besides i think that I should change also "DB.php" file to change the functions to run queries for each database defined in "settings.inc.php" I'm noob of PrestShop and I don't know which code I need to change to do all this, I hope you can help me.

I thank you in advance

[Mohamadou Ndiaye]

Hi,

Why do you need clones if it's just for translation.

PrestaShop by default offer you the possibility to set multiple language for your shop.

[PrestaNoobDev]

Hi Mohamadou Ndiaye,

 

It is not only for the translation , I saw the multistore of prestashop and does not provide for the creation of children sites on different servers , my clones must necessarily be on different servers and on different databse.

Can you help me ?

[PrestaNoobDev]

Plz help me ç_ç

[El Patron]

PrestaShop MultiShop = one installation (files/db) for all shops.

 

I think all you really need to do is copy existing shop into it's own space,  files/db to create a 'clone'.  You can search using google for 'prestashop copy production' or something similar to see process for creating clones.

[PrestaNoobDev]

PrestaShop MultiShop = one installation (files/db) for all shops.

 

Yes this is a big problem for me, i need to have differents files and different db on differents servers,  I can't use multishop of PrestaShop

[El Patron]

PrestaShop MultiShop = one installation (files/db) for all shops.

 

Yes this is a big problem for me, i need to have differents files and different db on differents servers,  I can't use multishop of PrestaShop

that's correct but you can manually copy it to different servers