Error installing Magento backup on localhost












0















I want to install a backup of Magento on local server to test that everything works to perfection before uploading to the server.



I returned the following error and can not find solution to it, please i need your help.



There has been an error processing your request
SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected

Trace:
#0 C:wamp-nuevo3wwwscshackeolibZendDbStatementPdo.php(228): PDOStatement->execute(Array)
#1 C:wamp-nuevo3wwwscshackeolibVarienDbStatementPdoMysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 C:wamp-nuevo3wwwscshackeoappcodecoreZendDbStatement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 C:wamp-nuevo3wwwscshackeolibZendDbAdapterAbstract.php(480): Zend_Db_Statement->execute(Array)
#4 C:wamp-nuevo3wwwscshackeolibZendDbAdapterPdoAbstract.php(238): Zend_Db_Adapter_Abstract->query('SHOW TABLE STAT...', Array)
#5 C:wamp-nuevo3wwwscshackeolibVarienDbAdapterPdoMysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SHOW TABLE STAT...', Array)
#6 C:wamp-nuevo3wwwscshackeolibVarienDbAdapterPdoMysql.php(347): Varien_Db_Adapter_Pdo_Mysql->query('SHOW TABLE STAT...')
#7 C:wamp-nuevo3wwwscshackeolibVarienDbAdapterPdoMysql.php(378): Varien_Db_Adapter_Pdo_Mysql->raw_query('SHOW TABLE STAT...')
#8 C:wamp-nuevo3wwwscshackeolibVarienDbAdapterPdoMysql.php(983): Varien_Db_Adapter_Pdo_Mysql->raw_fetchRow('SHOW TABLE STAT...')
#9 C:wamp-nuevo3wwwscshackeolibVarienDbAdapterPdoMysql.php(2510): Varien_Db_Adapter_Pdo_Mysql->showTableStatus('core_cache_opti...', NULL)
#10 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelResourceCache.php(58): Varien_Db_Adapter_Pdo_Mysql->isTableExists('core_cache_opti...')
#11 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelCache.php(478): Mage_Core_Model_Resource_Cache->getAllOptions()
#12 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelCache.php(520): Mage_Core_Model_Cache->_initOptions()
#13 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelApp.php(1183): Mage_Core_Model_Cache->canUse('config')
#14 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelConfig.php(414): Mage_Core_Model_App->useCache('config')
#15 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelConfig.php(294): Mage_Core_Model_Config->_canUseCacheForInit()
#16 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelApp.php(413): Mage_Core_Model_Config->loadModulesCache()
#17 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelApp.php(343): Mage_Core_Model_App->_initModules()
#18 C:wamp-nuevo3wwwscshackeoappMage.php(684): Mage_Core_Model_App->run(Array)
#19 C:wamp-nuevo3wwwscshackeoindex.php(87): Mage::run('', 'store')
#20 {main}









share|improve this question

























  • Have you updated your database configuration credentilals at app/etc/local.xml. (i)Flush all cache. (ii)Re-Index all data. (iii)Flush all cache. You may delete cache files from var/cache/

    – Praful Rajput
    Oct 21 '15 at 5:26











  • You may take more idea from following stuff. stackoverflow.com/questions/16538560/… insync.co.in/…

    – Praful Rajput
    Oct 21 '15 at 5:28
















0















I want to install a backup of Magento on local server to test that everything works to perfection before uploading to the server.



I returned the following error and can not find solution to it, please i need your help.



There has been an error processing your request
SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected

Trace:
#0 C:wamp-nuevo3wwwscshackeolibZendDbStatementPdo.php(228): PDOStatement->execute(Array)
#1 C:wamp-nuevo3wwwscshackeolibVarienDbStatementPdoMysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 C:wamp-nuevo3wwwscshackeoappcodecoreZendDbStatement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 C:wamp-nuevo3wwwscshackeolibZendDbAdapterAbstract.php(480): Zend_Db_Statement->execute(Array)
#4 C:wamp-nuevo3wwwscshackeolibZendDbAdapterPdoAbstract.php(238): Zend_Db_Adapter_Abstract->query('SHOW TABLE STAT...', Array)
#5 C:wamp-nuevo3wwwscshackeolibVarienDbAdapterPdoMysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SHOW TABLE STAT...', Array)
#6 C:wamp-nuevo3wwwscshackeolibVarienDbAdapterPdoMysql.php(347): Varien_Db_Adapter_Pdo_Mysql->query('SHOW TABLE STAT...')
#7 C:wamp-nuevo3wwwscshackeolibVarienDbAdapterPdoMysql.php(378): Varien_Db_Adapter_Pdo_Mysql->raw_query('SHOW TABLE STAT...')
#8 C:wamp-nuevo3wwwscshackeolibVarienDbAdapterPdoMysql.php(983): Varien_Db_Adapter_Pdo_Mysql->raw_fetchRow('SHOW TABLE STAT...')
#9 C:wamp-nuevo3wwwscshackeolibVarienDbAdapterPdoMysql.php(2510): Varien_Db_Adapter_Pdo_Mysql->showTableStatus('core_cache_opti...', NULL)
#10 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelResourceCache.php(58): Varien_Db_Adapter_Pdo_Mysql->isTableExists('core_cache_opti...')
#11 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelCache.php(478): Mage_Core_Model_Resource_Cache->getAllOptions()
#12 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelCache.php(520): Mage_Core_Model_Cache->_initOptions()
#13 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelApp.php(1183): Mage_Core_Model_Cache->canUse('config')
#14 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelConfig.php(414): Mage_Core_Model_App->useCache('config')
#15 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelConfig.php(294): Mage_Core_Model_Config->_canUseCacheForInit()
#16 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelApp.php(413): Mage_Core_Model_Config->loadModulesCache()
#17 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelApp.php(343): Mage_Core_Model_App->_initModules()
#18 C:wamp-nuevo3wwwscshackeoappMage.php(684): Mage_Core_Model_App->run(Array)
#19 C:wamp-nuevo3wwwscshackeoindex.php(87): Mage::run('', 'store')
#20 {main}









share|improve this question

























  • Have you updated your database configuration credentilals at app/etc/local.xml. (i)Flush all cache. (ii)Re-Index all data. (iii)Flush all cache. You may delete cache files from var/cache/

    – Praful Rajput
    Oct 21 '15 at 5:26











  • You may take more idea from following stuff. stackoverflow.com/questions/16538560/… insync.co.in/…

    – Praful Rajput
    Oct 21 '15 at 5:28














0












0








0








I want to install a backup of Magento on local server to test that everything works to perfection before uploading to the server.



I returned the following error and can not find solution to it, please i need your help.



There has been an error processing your request
SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected

Trace:
#0 C:wamp-nuevo3wwwscshackeolibZendDbStatementPdo.php(228): PDOStatement->execute(Array)
#1 C:wamp-nuevo3wwwscshackeolibVarienDbStatementPdoMysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 C:wamp-nuevo3wwwscshackeoappcodecoreZendDbStatement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 C:wamp-nuevo3wwwscshackeolibZendDbAdapterAbstract.php(480): Zend_Db_Statement->execute(Array)
#4 C:wamp-nuevo3wwwscshackeolibZendDbAdapterPdoAbstract.php(238): Zend_Db_Adapter_Abstract->query('SHOW TABLE STAT...', Array)
#5 C:wamp-nuevo3wwwscshackeolibVarienDbAdapterPdoMysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SHOW TABLE STAT...', Array)
#6 C:wamp-nuevo3wwwscshackeolibVarienDbAdapterPdoMysql.php(347): Varien_Db_Adapter_Pdo_Mysql->query('SHOW TABLE STAT...')
#7 C:wamp-nuevo3wwwscshackeolibVarienDbAdapterPdoMysql.php(378): Varien_Db_Adapter_Pdo_Mysql->raw_query('SHOW TABLE STAT...')
#8 C:wamp-nuevo3wwwscshackeolibVarienDbAdapterPdoMysql.php(983): Varien_Db_Adapter_Pdo_Mysql->raw_fetchRow('SHOW TABLE STAT...')
#9 C:wamp-nuevo3wwwscshackeolibVarienDbAdapterPdoMysql.php(2510): Varien_Db_Adapter_Pdo_Mysql->showTableStatus('core_cache_opti...', NULL)
#10 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelResourceCache.php(58): Varien_Db_Adapter_Pdo_Mysql->isTableExists('core_cache_opti...')
#11 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelCache.php(478): Mage_Core_Model_Resource_Cache->getAllOptions()
#12 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelCache.php(520): Mage_Core_Model_Cache->_initOptions()
#13 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelApp.php(1183): Mage_Core_Model_Cache->canUse('config')
#14 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelConfig.php(414): Mage_Core_Model_App->useCache('config')
#15 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelConfig.php(294): Mage_Core_Model_Config->_canUseCacheForInit()
#16 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelApp.php(413): Mage_Core_Model_Config->loadModulesCache()
#17 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelApp.php(343): Mage_Core_Model_App->_initModules()
#18 C:wamp-nuevo3wwwscshackeoappMage.php(684): Mage_Core_Model_App->run(Array)
#19 C:wamp-nuevo3wwwscshackeoindex.php(87): Mage::run('', 'store')
#20 {main}









share|improve this question
















I want to install a backup of Magento on local server to test that everything works to perfection before uploading to the server.



I returned the following error and can not find solution to it, please i need your help.



There has been an error processing your request
SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected

Trace:
#0 C:wamp-nuevo3wwwscshackeolibZendDbStatementPdo.php(228): PDOStatement->execute(Array)
#1 C:wamp-nuevo3wwwscshackeolibVarienDbStatementPdoMysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 C:wamp-nuevo3wwwscshackeoappcodecoreZendDbStatement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 C:wamp-nuevo3wwwscshackeolibZendDbAdapterAbstract.php(480): Zend_Db_Statement->execute(Array)
#4 C:wamp-nuevo3wwwscshackeolibZendDbAdapterPdoAbstract.php(238): Zend_Db_Adapter_Abstract->query('SHOW TABLE STAT...', Array)
#5 C:wamp-nuevo3wwwscshackeolibVarienDbAdapterPdoMysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SHOW TABLE STAT...', Array)
#6 C:wamp-nuevo3wwwscshackeolibVarienDbAdapterPdoMysql.php(347): Varien_Db_Adapter_Pdo_Mysql->query('SHOW TABLE STAT...')
#7 C:wamp-nuevo3wwwscshackeolibVarienDbAdapterPdoMysql.php(378): Varien_Db_Adapter_Pdo_Mysql->raw_query('SHOW TABLE STAT...')
#8 C:wamp-nuevo3wwwscshackeolibVarienDbAdapterPdoMysql.php(983): Varien_Db_Adapter_Pdo_Mysql->raw_fetchRow('SHOW TABLE STAT...')
#9 C:wamp-nuevo3wwwscshackeolibVarienDbAdapterPdoMysql.php(2510): Varien_Db_Adapter_Pdo_Mysql->showTableStatus('core_cache_opti...', NULL)
#10 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelResourceCache.php(58): Varien_Db_Adapter_Pdo_Mysql->isTableExists('core_cache_opti...')
#11 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelCache.php(478): Mage_Core_Model_Resource_Cache->getAllOptions()
#12 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelCache.php(520): Mage_Core_Model_Cache->_initOptions()
#13 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelApp.php(1183): Mage_Core_Model_Cache->canUse('config')
#14 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelConfig.php(414): Mage_Core_Model_App->useCache('config')
#15 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelConfig.php(294): Mage_Core_Model_Config->_canUseCacheForInit()
#16 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelApp.php(413): Mage_Core_Model_Config->loadModulesCache()
#17 C:wamp-nuevo3wwwscshackeoappcodecoreMageCoreModelApp.php(343): Mage_Core_Model_App->_initModules()
#18 C:wamp-nuevo3wwwscshackeoappMage.php(684): Mage_Core_Model_App->run(Array)
#19 C:wamp-nuevo3wwwscshackeoindex.php(87): Mage::run('', 'store')
#20 {main}






magento-1.9






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited 36 mins ago









Teja Bhagavan Kollepara

2,94841847




2,94841847










asked Oct 21 '15 at 4:33









Diego OteroDiego Otero

213




213













  • Have you updated your database configuration credentilals at app/etc/local.xml. (i)Flush all cache. (ii)Re-Index all data. (iii)Flush all cache. You may delete cache files from var/cache/

    – Praful Rajput
    Oct 21 '15 at 5:26











  • You may take more idea from following stuff. stackoverflow.com/questions/16538560/… insync.co.in/…

    – Praful Rajput
    Oct 21 '15 at 5:28



















  • Have you updated your database configuration credentilals at app/etc/local.xml. (i)Flush all cache. (ii)Re-Index all data. (iii)Flush all cache. You may delete cache files from var/cache/

    – Praful Rajput
    Oct 21 '15 at 5:26











  • You may take more idea from following stuff. stackoverflow.com/questions/16538560/… insync.co.in/…

    – Praful Rajput
    Oct 21 '15 at 5:28

















Have you updated your database configuration credentilals at app/etc/local.xml. (i)Flush all cache. (ii)Re-Index all data. (iii)Flush all cache. You may delete cache files from var/cache/

– Praful Rajput
Oct 21 '15 at 5:26





Have you updated your database configuration credentilals at app/etc/local.xml. (i)Flush all cache. (ii)Re-Index all data. (iii)Flush all cache. You may delete cache files from var/cache/

– Praful Rajput
Oct 21 '15 at 5:26













You may take more idea from following stuff. stackoverflow.com/questions/16538560/… insync.co.in/…

– Praful Rajput
Oct 21 '15 at 5:28





You may take more idea from following stuff. stackoverflow.com/questions/16538560/… insync.co.in/…

– Praful Rajput
Oct 21 '15 at 5:28










1 Answer
1






active

oldest

votes


















1














Change DB configuration in file




app/etc/local.xml




as per your local setup and open db table




core_config_data




change following value as per your local setup




web/unsecure/base_url




and




web/secure/base_url







share|improve this answer























    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "479"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: false,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f87127%2ferror-installing-magento-backup-on-localhost%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    1














    Change DB configuration in file




    app/etc/local.xml




    as per your local setup and open db table




    core_config_data




    change following value as per your local setup




    web/unsecure/base_url




    and




    web/secure/base_url







    share|improve this answer




























      1














      Change DB configuration in file




      app/etc/local.xml




      as per your local setup and open db table




      core_config_data




      change following value as per your local setup




      web/unsecure/base_url




      and




      web/secure/base_url







      share|improve this answer


























        1












        1








        1







        Change DB configuration in file




        app/etc/local.xml




        as per your local setup and open db table




        core_config_data




        change following value as per your local setup




        web/unsecure/base_url




        and




        web/secure/base_url







        share|improve this answer













        Change DB configuration in file




        app/etc/local.xml




        as per your local setup and open db table




        core_config_data




        change following value as per your local setup




        web/unsecure/base_url




        and




        web/secure/base_url








        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Oct 21 '15 at 6:55









        Minesh PatelMinesh Patel

        2,078621




        2,078621






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Magento Stack Exchange!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f87127%2ferror-installing-magento-backup-on-localhost%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Magento 2 controller redirect on button click in phtml file

            Polycentropodidae