Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Change location of MySQL
 
sytram
Jr. Member
 
Total Posts:  4
Joined:  2008-01-28
 

I have successfully installed Magento on a server running CentOS & XAMPP now I would like to have my database located on another server.  How do I tell Magento where it is located?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Moshe
Magento Team
 
Avatar
Total Posts:  1770
Joined:  2007-08-07
Los Angeles
 

app/etc/local.xml - change in 2 places

 
Magento Community Magento Community
Magento Community
Magento Community
 
sytram
Jr. Member
 
Total Posts:  4
Joined:  2008-01-28
 

Thanks for the quick reply.  I made the changes and now when I make a change to the database from admin (went into manage labels under catalog attributes); the please wait screen comes up and never goes away.  When I make a local change it happens immediately but not with a remote database.  I tried turning off both firewalls to make sure that wasn’t it.  Any ideas.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top