how can i transfer prestashop from online server to local ?

[makaraci]

Hi, i want to transfer prestashop from online working server to local so that i can make upgrade tests.

I installed wamp.I created database and user on phpadmin .I chose same database name, user name and password like online server .

Then i copied all files from ftp to www folder of wamp.But when i try to go site at the local, there is the error :

"link to database cannot be established"

I also checked /config/settings.inc.php .The username and password was correct.

What is the problem ? My my shop dont work in localhost ?

[eltitos]

hi,

Did you export/import the online bdd to your local bdd ?

[makaraci]

Hi,

Sorry for my unawareness but, what is bdd ?

[eltitos]

sry, bdd it's in french, so it's database

[makaraci]

thanks, i didnt export /import.

How can i do it ? From Cpanel>backup database ?

[MrBaseball34]

Yes, that creates a SQL file that you can use to import into your database using mysql.
Restore it like this:
mysql -u user_name -p database_name < path_to_sql_script

[makaraci]

sorry , where i will write this code ?

I am really very unknowing about this .

Thanks

[MrBaseball34]

Open a command prompt, navigate to the \wamp\bin\mysql\mysql5.1.36\bin directory on the drive where you have WAMP installed
(make sure that is the correct directory where your mySQL is installed)

Then type in the command I showed with the values changed to reflect your info.

[makaraci]

Thanks pal, i succesfully imported my database, but there is still same error : " Link to database cannot be established. "

I cant understand what the problem is .

[makaraci]

hi there, i did it finally

I created a new database and new user for this databse and i defined a different password.Then i typed these to settinggs.inc.php.

Thats all !

But some product images dont work while some of them works.It is only problem for now.

I hope we can find a solution for that.

Cheers !

[eltitos]

if your online website is using URL REwrite, don't forget to recreate the .htaccess file in the local folder

[makaraci]

i deleted my old .htaccess file and i turned off firendly url because it is not working on the local machine.I tried generate .htaccess but then my site doesnt work.

I think it is not because of .htaccess

[Sundar]

Greetings,
When we back-up the database and prestashop files and try to use it in subdomain / localhost in the front panel when we click the category/product/supplier or any link the following error appears "Page not available, web address you entered is no longer available" . this problem only in the front panel, it works well in the backoffice panel ie admin panel. We have changed the database name, user name, password and base URL, in the setting.in.php in the configration folder. Also we tried to upgrade the V1.3.01 to 1.3.1.1, the upgrade option is disabled in the installation page. Please help us to rectify the above bugs/problem.
Thanks & Regards
Sundar