Bootstrap Magento in external script with a second database connection

Question

I use below code to bootstrap Magento in an external script, which works. As an example it gets the name of a specific product.

Is it possible to connect to another Magento database (on the same server) from such a script? If yes, how would I do this? I tried several things but didn't got a working end result.

<?php

require_once '../app/Mage.php';
Mage::app();

$sku = 'product X';
$product = Mage::getModel('catalog/product')->loadByAttribute('sku', $sku);

var_dump($product->getName());

Answer 1

This is achievable. You need to define database credentials in your local.xml where you have your script placed. You can have something like below:

Once you have some create a module / model to connect to second database and play around it to achieve what you want.