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

Re: migrate to other domain

Hi @jaspreet60,

 

What is the process you follow to dump the database?

If my answer was useful, please give "Kudos" to this post.
If my answer helps you to resolve the problem, click on "Accept as Solution".

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 Managed Package. Get your e-commerce health checkup at http://ecommerce.fitness

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