HOW TO COPY THE SQL DATE BASE FROM ONE PRESTASHOP TO ANOTHER?

[tintamundo]

Hello,

is it possible to copy one data base from en existing web site to another one?

both are belong to me.

 

I just want to save time that take to insert all the data.

 

thank you for any help that i can get

[El Patron]

do you have access to phymyadmin for both databases?

 

if so:

1. via phpmyadmin export your entire source db

2. create new db

3. via phpmyadmin (in your new db) import your original source db

4. modify your new db as follows:

(your prefix_)configuration

PS_SHOP_DOMAIN --> your domain name (no http://)

PS_SHOP_DOMAIN_SSL --> --> your domain name (no http://)

 

You will also require modification to the (your root)/config/settings.inc.php