How to run magento online site to locally with xampp

[kiriakos_athana]

How to "download" my magento 1.9.4.0 site from server to my PC for testing and programing?

[atlnuilixga951]

• Download Magento Files & Database
  Export the entire Magento site files (like Subway's online order system might have) and export the SQL database from the live server.

• Install XAMPP
  Download and install XAMPP on your local machine to create a localhost environment.

• Move Files to XAMPP
  Place the Magento files in C:\xampp\htdocs\subway or any folder you choose (e.g., "subway" as your project name).

• Import the Database
  Open phpMyAdmin in XAMPP and import the live SQL file to a new database like subway local.

• Edit app/etc/env.php
  Update database credentials (db_name, username, password) in the env.php file to match your XAMPP setup.

• Update base URLs in DB
  In phpMyAdmin, edit core_config_data to set web/unsecure/base_url and web/secure/base_url 

• Edit hosts File (if using domain locally)
  Add 127.0.0.1 subway.local to your system’s hosts file for local domain routing, simulating a Subway-style custom domain.

• Enable Apache & MySQL
  Start both Apache and MySQL modules in the XAMPP Control Panel.

• Clear Magento Cache
  Run php bin/magento cache:clean and cache:flush from the terminal or manually delete /var/cache folders.

• Run Magento Commands
  Use the terminal to run commands like setup:upgrade and static-content:deploy to sync with local changes.

• Fix Permissions
  Ensure proper file/folder permissions so the Magento local Subway-style site runs smoothly.

• Access via Browser
  Go to subway to access your local Magento site, just like how Subway might test changes before going live.