Databases
StackOverflow2013
Postsdbo
POMove Magento Installation to new server
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMove Magento Installation to new server
    primarykey
    data
    text
    <p>I've been trying now for a few hours to move our Magento installation from dev to live. I found multiple links on the web saying that to move a Magento Installation you need to edit <code>/app/etc/local.xml</code> and update it with the new MySQL credentials and then delete the contents of <code>/var/cache/</code> (a few even suggested deleting the whole <code>/var</code> folder. I also deleted the contents of <code>/var/session/</code>. Our server is NOT cached (no memcached, varnish, etc). I even restarted apache to see if I could flush any cache that might be running.</p> <p>So the problem is our Magento installation is still attempting to connect to the old database somehow. We are given this error:</p> <pre><code>SQLSTATE[28000] [1045] Access denied for user 'oldDBUsername'@'localhost' (using password: YES) </code></pre> <p>If anyone has any ideas on how to fix this that I haven't already mentioned it would be greatly appreciated.</p> <p>EDIT:</p> <p>Here is the stack trace that Magento also reports:</p> <pre><code>Trace: #0 fileroot/lib/Zend/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract-&gt;_connect() #1 fileroot/lib/Varien/Db/Adapter/Pdo/Mysql.php(300): Zend_Db_Adapter_Pdo_Mysql-&gt;_connect() #2 fileroot/lib/Zend/Db/Adapter/Abstract.php(459): Varien_Db_Adapter_Pdo_Mysql-&gt;_connect() #3 fileroot/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract-&gt;query('SET NAMES utf8', Array) #4 fileroot/lib/Varien/Db/Adapter/Pdo/Mysql.php(389): Zend_Db_Adapter_Pdo_Abstract-&gt;query('SET NAMES utf8', Array) #5 fileroot/app/code/core/Mage/Core/Model/Resource.php(169): Varien_Db_Adapter_Pdo_Mysql-&gt;query('SET NAMES utf8') #6 fileroot/app/code/core/Mage/Core/Model/Resource.php(110): Mage_Core_Model_Resource-&gt;_newConnection('pdo_mysql', Object(Mage_Core_Model_Config_Element)) #7 fileroot/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(320): Mage_Core_Model_Resource-&gt;getConnection('core_read') #8 fileroot/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(335): Mage_Core_Model_Resource_Db_Abstract-&gt;_getConnection('read') #9 fileroot/app/code/core/Mage/Core/Model/Resource/Cache.php(53): Mage_Core_Model_Resource_Db_Abstract-&gt;_getReadAdapter() #10 fileroot/app/code/core/Mage/Core/Model/Cache.php(449): Mage_Core_Model_Resource_Cache-&gt;getAllOptions() #11 fileroot/app/code/core/Mage/Core/Model/Cache.php(491): Mage_Core_Model_Cache-&gt;_initOptions() #12 fileroot/app/code/core/Mage/Core/Model/App.php(1175): Mage_Core_Model_Cache-&gt;canUse('config') #13 fileroot/app/code/core/Mage/Core/Model/Config.php(414): Mage_Core_Model_App-&gt;useCache('config') #14 fileroot/app/code/core/Mage/Core/Model/Config.php(294): Mage_Core_Model_Config-&gt;_canUseCacheForInit() #15 fileroot/app/code/core/Mage/Core/Model/App.php(408): Mage_Core_Model_Config-&gt;loadModulesCache() #16 fileroot/app/code/core/Mage/Core/Model/App.php(338): Mage_Core_Model_App-&gt;_initModules() #17 fileroot/app/Mage.php(640): Mage_Core_Model_App-&gt;run(Array) #18 fileroot/index.php(80): Mage::run('', 'store') #19 {main} </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPeter
    1. USPeter
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POMove Magento Installation to new server
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POMove Magento Installation to new server
      1. USRails beginner
      1. VTFavorite
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload