Magento 1.9.2 - Accessing an External Database an another domain

Question

On my site with Magento installed, I can't call up the database that is present on another domain. I wish I could have one database for multiple sites with Magento.

How can I retrieve the database with my site with Magento which is present on another domain?

Thanks so much for any help.

Answer 1

Make sure you have correct config for databse host in app\etc\local.xml file

<host><![CDATA[your-host-ip]]></host>

OR

<host><![CDATA[your-host-full-url]]></host>

and check you have permission to access mysql outside of your host

If it still not solve your problem check DNS Issue

Answer 2

You need to setup your magento with multistore.

You can point your each store with multiple domain with one database.

Read this guide : http://docs.magento.com/m1/ce/user_guide/store-operations/store-hierarchy.html

open up the index.php file and look for this line (it's the last line of the file):

Mage::run($mageRunCode, $mageRunType);

Add the following code right before the above code:

$mageRunCode = 'YOUR_WEBSITE_CODE';

$mageRunType = 'website';