cancel
Showing results for 
Search instead for 
Did you mean: 

migrate to other domain

migrate to other domain

Hi i want to migrate my 1 website to another .

i backup all files and databases after that i upload all files and database to new hosting account and new domain

i changed config of database , user name, password of mysql.

i also changed URL & Secure URL.

 

after that when i open website i got error

please help me

Thank You

 

 

There has been an error processing your request
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fab_ink.log_visitor_info' doesn't exist, query was: DESCRIBE `log_visitor_info`
Trace: #0 /home/fab/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/fab/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /home/fab/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /home/fab/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('DESCRIBE `log_v...', Array) #4 /home/fab/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('DESCRIBE `log_v...', Array) #5 /home/fab/public_html/lib/Zend/Db/Adapter/Pdo/Mysql.php(171): Varien_Db_Adapter_Pdo_Mysql->query('DESCRIBE `log_v...') #6 /home/fab/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(1694): Zend_Db_Adapter_Pdo_Mysql->describeTable('log_visitor_inf...', NULL) #7 /home/fab/public_html/app/code/core/Mage/Core/Model/Resource/Abstract.php(212): Varien_Db_Adapter_Pdo_Mysql->describeTable('log_visitor_inf...') #8 /home/fab/public_html/app/code/core/Mage/Log/Model/Resource/Visitor.php(201): Mage_Core_Model_Resource_Abstract->_prepareDataForTable(Object(Varien_Object), 'log_visitor_inf...') #9 /home/fab/public_html/app/code/core/Mage/Log/Model/Resource/Visitor.php(129): Mage_Log_Model_Resource_Visitor->_saveVisitorInfo(Object(Mage_Log_Model_Visitor)) #10 /home/fab/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(463): Mage_Log_Model_Resource_Visitor->_afterSave(Object(Mage_Log_Model_Visitor)) #11 /home/fab/public_html/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mage_Log_Model_Visitor)) #12 /home/fab/public_html/app/code/core/Mage/Log/Model/Visitor.php(198): Mage_Core_Model_Abstract->save() #13 /home/fab/public_html/app/code/core/Mage/Core/Model/App.php(1357): Mage_Log_Model_Visitor->initByRequest(Object(Varien_Event_Observer)) #14 /home/fab/public_html/app/code/core/Mage/Core/Model/App.php(1336): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Log_Model_Visitor), 'initByRequest', Object(Varien_Event_Observer)) #15 /home/fab/public_html/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent('controller_acti...', Array) #16 /home/fab/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(527): Mage::dispatchEvent('controller_acti...', Array) #17 /home/fab/public_html/app/code/core/Mage/Core/Controller/Front/Action.php(69): Mage_Core_Controller_Varien_Action->preDispatch() #18 /home/fab/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(407): Mage_Core_Controller_Front_Action->preDispatch() #19 /home/fab/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('noRoute') #20 /home/fab/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #21 /home/fab/public_html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch() #22 /home/fab/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array) #23 /home/fab/public_html/index.php(83): Mage::run('', 'store') #24 {main}

Error log record number: 187158209710

7 REPLIES 7

Re: migrate to other domain

Hi @jaspreet60,

 

What is the process you follow to dump the database?

Welcome to the Magento Forums. Remember to introduce yourself and read the Magento Forums Guidelines.

Re: migrate to other domain

Hi,

 

Looks like database restore did not work properly. this can happen if there is a different version of mysql is running on new server. the easiest way can be asking your host to restore the database if you do not have ssh access.

 

Anton Pachkine @ magento2.hosting : Magento Small Business Package.

Re: migrate to other domain

It is definitely nor recommended to perform migration via database backup/restore,  since there might be different database structure and tables.

 

The correct process of performing transfer is via export/import. Here is also tutorial -

https://www.mag-manager.com/useful-articles/how-to/how-to-transfer-magento-data-from-one-store-to-an...

 

Store Manager for Magento 1.x and 2.x - inventory management tool to automatically update products, customers, orders, and other data across multiple sales channels and suppliers.

Re: migrate to other domain

First i make zip of all files in cpanel then i download it and upload to
new server i also do same for sql
i also changed data base details in new site but still getting error.

Re: migrate to other domain

Hi @jaspreet60

I'm sure that you have not export database successful. I guess you have used phpmyadmin to do, right?

 

You should use cmd sqldump to export database

Re: migrate to other domain

Thank you for your kind reply
can you please tell me all process i will do from start or tell me me cmd
sqldump process i also try with this

thank you in advance

Re: migrate to other domain