<wbr>######Task: Upgrade the magento from 1.4 to 1.7<br> 1.Use Magento connection to upgrade the Magento Core files;<br><wbr><wbr> After upgrade, it will be 503error on both of frontend and backend. This is because magentoenter into maintenance mode.<br><wbr><wbr> If it is necessary, i willcompare the Magento connect mode with Mage command mode.<br><br> 2.After upgrade, come across following problem:<br> #SQLSTATE[HY000]: General error: 1025 Error on rename#<br> #SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicateentry#<br> ============================================<br> -<initStatements>SET NAMES utf8 ; SETFOREIGN_KEY_CHECKS=0;SETUNIQUE_CHECKS=0;</initStatements><br> -Check the duplicate<wbr> entry and remove them in thedatabase;<br> ============================================<br><br><br> 3.Check any<wbr> problem when upgrading localMagento;<br><br> Mage_Core_Model_Resource_Setup<wbr> This class is usedto run the sql directly or run the PHP scripts with SQLindirectly.<br><br><br> 4.Tips;<br> Use mysql command source and load to load the database or usePHPMYADMIN's copy database function to copy data structure and dataitself.<br></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>