Next Webinar: Maximizing Magento - Get the Most out of Promotions. Register Today!

Magento

Open Source eCommerce Evolved

Magento Forum

   
Page 4 of 4
Existing DB not working with new install
 
Crucial
Guru
 
Avatar
Total Posts:  496
Joined:  2007-11-07
Phoenix, AZ
 

I’ll repost what I mentioned to Mike in my PM just in case anyone else is wondering:

It sounds like the base URL for the unsecure/secure sections is still set to the development domain. You’ll have to open up phpMyAdmin (from cPanel) and edit the rows in the core_config_data table.

When you click on that table name, select the SQL tab and run this query:

SELECT *  FROM `core_config_dataWHERE `valueLIKE '% http:// %'

NOTE: Magento is messing with the code I’m pasting, make sure you REMOVE the space after the first % sign, and before the second % sign!

You should get 1-2 results back. Just edit those and update the values. What these rows are, are the fields that would show up in System -> Configuration -> Web for the base Unsecure and Secure URLs.

Basically, before you do a transfer, if you’re going to be changing URLs, make sure you either update the Unsecure/Secure URLs in the backend BEFORE you move anything over, otherwise you’ll have to manually edit the rows in the table.

I wrote the instructions under the assumption that the store URL would remain the same, but you would be moving from one host to another or something similar.

 Signature 

Crucial Web Hosting
We provide hosting for Magento in shared, semi-dedicated, and dedicated configurations.
Our Containers include free features like Magento support from Varien, SSL certificate, McAfee Secure, and hourly backups.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
Page 4 of 4
 
Sales: Call 877.832.5289 (North America) 310.295.4144 (International)
© Copyright 2008 Varien. Magento is a trademark of Irubin Consulting Inc. DBA Varien
Privacy Policy|Terms of Service
Magento Community Count
39968 users|445 users currently online|86015 forum posts