For example, the old domain name is http://www.glassespeople.com, and this shopping cart is based on Magento. Now I need to remove the cart to my local computer, say under http://127.0.0.1/cart/glassespeople/. How to then?
1. Creat glassespeople, under http://127.0.0.1/cart/;
2. Copy all files under http://www.glassespeople.com, and paste them under http://127.0.0.1/cart/glassespeople;
3. Login PHPMyAdmin of www.glassespeople.com, and export the database of www.glassespeople.com;
4. Login PHPMyAdmin of http://127.0.0.1/cart/glassespeople, and import the database;
5. Edit old URL values in database —>Table: core_config_data
web/unsecure/base_url
change its old value http://www.glasespeople.com to http://127.0.0.1/cart/glassespeople
web/secure/base_url
change its old value http://www.glasespeople.com to http://127.0.0.1/cart/glassespeople
6. Modify the old MySQL connection data to the new one:
Edit app/etc/local.xml under Magento root, and change related data
7. Edit ajexconnection.php under Magento root, and change related data.
8. Login admin panel, and go to system –> Cache Storage Management, refresh the old cache.
If you do not remember admin passwords, then go to PHPMyAdmin, and edit table admin_user, just replace the old encrypted password to 0192023a7bbd73250516f069df18b500, then the new password would be admin123.
You also can run sql command to generate a new password:
UPDATE `admin_user` SET `password` = MD5(‘PASSWORD’) WHERE `username` = ‘USERNAME’;
For example, if your username was admin and your wanted to reset the password to abcdefg111, I would do this:
UPDATE `admin_user` SET `password` = MD5(‘abcdefg111’) WHERE `username` = ‘admin’;