Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

How to import data and settings from old magento
 
Spyder DSN
Jr. Member
 
Total Posts:  11
Joined:  2008-10-17
Newcastle upon Tyne, United Kingdom
 

Hi I have to delete my old magento ver 1.0.x and install the new one 1.1.6 my old mageto crash an now I have long list of errors

SQLSTATE[HY000]General error2013 Lost connection to MySQL server during query
Trace
:
#0 /home/niceshop/public_html/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/niceshop/public_html/lib/Zend/Db/Adapter/Abstract.php(406): Zend_Db_Statement->execute(Array)
#2 /home/niceshop/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(Object(Varien_Db_Select), Array)
#3 /home/niceshop/public_html/lib/Zend/Db/Adapter/Abstract.php(636): Zend_Db_Adapter_Pdo_Abstract->query(Object(Varien_Db_Select), Array)
#4 /home/niceshop/public_html/lib/Varien/Data/Tree/Dbp.php(203): Zend_Db_Adapter_Abstract->fetchRow(Object(Varien_Db_Select))
#5 /home/niceshop/public_html/app/code/core/Mage/Catalog/Helper/Category.php(56): Varien_Data_Tree_Dbp->loadNode('2')
#6 /home/niceshop/public_html/app/code/core/Mage/Catalog/Block/Navigation.php(58): Mage_Catalog_Helper_Category->getStoreCategories()
#7 /home/niceshop/public_html/app/design/frontend/default/default/template/catalog/navigation/top.phtml(28): Mage_Catalog_Block_Navigation->getStoreCategories()
#8 /home/niceshop/public_html/app/code/core/Mage/Core/Block/Template.php(131): include('/home/niceshop/...')
#9 /home/niceshop/public_html/app/code/core/Mage/Core/Block/Template.php(163): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#10 /home/niceshop/public_html/app/code/core/Mage/Core/Block/Template.php(180): Mage_Core_Block_Template->renderView()
#11 /home/niceshop/public_html/app/code/core/Mage/Core/Block/Abstract.php(554): Mage_Core_Block_Template->_toHtml()
#12 /home/niceshop/public_html/app/code/core/Mage/Core/Block/Text/List.php(37): Mage_Core_Block_Abstract->toHtml()
#13 /home/niceshop/public_html/app/code/core/Mage/Core/Block/Abstract.php(554): Mage_Core_Block_Text_List->_toHtml()
#14 /home/niceshop/public_html/app/code/core/Mage/Core/Block/Abstract.php(431): Mage_Core_Block_Abstract->toHtml()
#15 /home/niceshop/public_html/app/code/core/Mage/Core/Block/Abstract.php(408): Mage_Core_Block_Abstract->_getChildHtml('topMenu', true)
#16 /home/niceshop/public_html/app/design/frontend/default/default/template/page/html/header.phtml(39): Mage_Core_Block_Abstract->getChildHtml('topMenu')
#17 /home/niceshop/public_html/app/code/core/Mage/Core/Block/Template.php(131): include('/home/niceshop/...')
#18 /home/niceshop/public_html/app/code/core/Mage/Core/Block/Template.php(163): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#19 /home/niceshop/public_html/app/code/core/Mage/Core/Block/Template.php(180): Mage_Core_Block_Template->renderView()
#20 /home/niceshop/public_html/app/code/core/Mage/Core/Block/Abstract.php(554): Mage_Core_Block_Template->_toHtml()
#21 /home/niceshop/public_html/app/code/core/Mage/Core/Block/Abstract.php(431): Mage_Core_Block_Abstract->toHtml()
#22 /home/niceshop/public_html/app/code/core/Mage/Core/Block/Abstract.php(408): Mage_Core_Block_Abstract->_getChildHtml('header', true)
#23 /home/niceshop/public_html/app/design/frontend/default/default/template/page/3columns.phtml(36): Mage_Core_Block_Abstract->getChildHtml('header')
#24 /home/niceshop/public_html/app/code/core/Mage/Core/Block/Template.php(131): include('/home/niceshop/...')
#25 /home/niceshop/public_html/app/code/core/Mage/Core/Block/Template.php(163): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#26 /home/niceshop/public_html/app/code/core/Mage/Core/Block/Template.php(180): Mage_Core_Block_Template->renderView()
#27 /home/niceshop/public_html/app/code/core/Mage/Core/Block/Abstract.php(554): Mage_Core_Block_Template->_toHtml()
#28 /home/niceshop/public_html/app/code/core/Mage/Core/Model/Layout.php(505): Mage_Core_Block_Abstract->toHtml()
#29 /home/niceshop/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(319): Mage_Core_Model_Layout->getOutput()
#30 /home/niceshop/public_html/app/code/core/Mage/Cms/Helper/Page.php(77): Mage_Core_Controller_Varien_Action->renderLayout()
#31 /home/niceshop/public_html/app/code/core/Mage/Cms/controllers/IndexController.php(26): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), 'home')
#32 /home/niceshop/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(342): Mage_Cms_IndexController->indexAction()
#33 /home/niceshop/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(159): Mage_Core_Controller_Varien_Action->dispatch('index')
#34 /home/niceshop/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(146): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#35 /home/niceshop/public_html/app/Mage.php(427): Mage_Core_Controller_Varien_Front->dispatch()
#36 /home/niceshop/public_html/index.php(40): Mage::run()
#37 {main}

I decided to delete all files and database ( before make a backup). My questions are:

1. I have about 200 products with photos in database how do I import them from old database into the new one?
2. How do I keep old settings from old magento?
3. Can I just copy old template into the new one and all should works?
4. Maybe I can fix this problem above?

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top