[Solved ]Help, How to backup live database and import it to use in localhost

[nekadman]

Hi, i'm stil newbie and i would like to use live database and already compressed public_html folder and export the database through phpmyAdmin to use in my localhost. And after extract the backup file to C:\xampp\htdocs\tammiaonline folder and import the database.sql to http://localhost/phpmyadmin/ and do some minor setting in C:\xampp\htdocs\tammiaonline\config\setting.inc.php After login to back office and i click the "view my shop" but i can't open or open the shop the warning as below :

as below :

 

Object not found!

 

The requested URL was not found on this server. The link on the referring page seems to be wrong or outdated. Please inform the author of that page about the error.

If you think this is a server error, please contact the webmaster.

Error 404

localhost

Apache/2.4.3 (Win32) OpenSSL/1.0.1c PHP/5.4.7

 

 

And the link or browsing box write: http://localhost/tammiaonline/en/ <=== it should be http://localhost/tammiaonline/ (without en)

 

What should i do to make it useable in localhost again?

 

Thanks before.

Edited August 29, 2013 by nekadman (see edit history)

[vekia]

have you got an access to back office?

[nekadman]

Yes can access backoffice, but when I click 'wiev my shop' on the right top of the back office and can't open my front office shop.

 

I already can do from offline (localhost) upload to hosting (for your refference www.tammiaonline.com)

 

After upload to hosting, I add product into live and now I want to backup all the live to offline or localhost.

 

After I do backup all data from live and import it into localhost and the problem come out.

 

Thanks for your fast response.

[vekia]

can you open the preferneces > SEO & URLs tab ?

what is the definition of "domain" & "base_uri" fields ?

[nekadman]

shop domain : localhost

SSL domain : loaclhost

Base URI : /tammiaonline/

[nekadman]

[sOLVE] After edit file settings.inc.php on folder C:\xampp\htdocs\yourdomain\config change the correct DB_SERVER, DB_NAME, DB_USER, DB_PASSWD to the correct database name in phpMyAdmin and do some adjustment at shop_url table (domain, domain_ssl and physical_uri).

 

After do some adjustment, then login to localhost backoffice admin panel, go to Preferences - SEO & URLs then find the Friendly URL choose to "No" and save. Then open to view your shop (in locallhost).

 

After that you can put back the Friendy URLs to "Yes"

 

I hope my experience can help. Many thanks to Vekia.

Edited August 29, 2013 by nekadman (see edit history)