How to force Magento to stand up normally on a new hosting?

Question

MySQL

Hello. The bottom line is this: I'm trying to raise a copy of the site on my server, so that later I can finish the necessary and not be afraid that the live, working site will fall.
All files have been transferred, the address of the new site has been corrected everywhere, changes have been made to the database in the same way. There were problems with it during import (and they don’t end), I had to upload it through the console. It seems that it got up normally, I mean, everything, without critical errors in the process.
As a result, the site is still down, the error-log shows the following:
a:5:{i:0;s:98:"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'p218811_okno.log_visitor' doesn't exist ";i:1;s:3278:"
#0 /home/p218811/domains/taiga-web.ru/public_html/oknoinjapan/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo-> _execute(Array)
#1 /home/p218811/domains/taiga-web.ru/public_html/oknoinjapan/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/p218811/ domains/taiga-web.ru/public_html/oknoinjapan/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/p218811/domains/taiga-web.ru/public_html /oknoinjapan/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `lo...', Array)
#4 /home/p218811/domains/taiga-web. en/public_html/oknoinjapan/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `lo...', Array)
#5 /home/p218811/domains/taiga -web.ru/public_html/oknoinjapan/lib/Zend/Db/Adapter/Abstract.php(576): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `lo...', Array)
#6 /home/p218811/domains/taiga-web.ru/public_html/oknoinjapan/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert('log_visitor' , Array)
#7 /home/p218811/domains/taiga-web.ru/public_html/oknoinjapan/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mage_Log_Model_Visitor) )
#8 /home/p218811/domains/taiga-web.ru/public_html/oknoinjapan/app/code/core/Mage/Log/Model/Visitor.php(168): Mage_Core_Model_Abstract->save()
#9 /home/ p218811/domains/taiga-web.ru/public_html/oknoinjapan/app/code/core/Mage/Core/Model/App.php(1338): Mage_Log_Model_Visitor->initByRequest(Object(Varien_Event_Observer))
#10 /home/p218811/domains/taiga-web.ru/public_html/oknoinjapan/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Log_Model_Visitor), 'initByRequest ', Object(Varien_Event_Observer))
#11 /home/p218811/domains/taiga-web.ru/public_html/oknoinjapan/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent('controller_acti...', Array)
# 12 /home/p218811/domains/taiga-web.ru/public_html/oknoinjapan/app/code/core/Mage/Core/Controller/Varien/Action.php(527): Mage::dispatchEvent('controller_acti...' , Array)
#13 /home/p218811/domains/taiga-web.ru/public_html/oknoinjapan/app/code/core/Mage/Core/Controller/Front/Action.php(64): Mage_Core_Controller_Varien_Action->preDispatch()
#14 /home/p218811/domains/taiga-web.ru/public_html/oknoinjapan/app/code/core/Mage/Core/Controller/Varien/Action.php(407): Mage_Core_Controller_Front_Action->preDispatch()
#15 /home /p218811/domains/taiga-web.ru/public_html/oknoinjapan/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('index')
#16 / home/p218811/domains/taiga-web.ru/public_html/oknoinjapan/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#17 / home/p218811/domains/taiga-web.ru/public_html/oknoinjapan/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#18 /home/p218811/domains/taiga-web.ru/public_html/oknoinjapan/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#19 /home/p218811/domains/taiga-web.ru/ public_html/oknoinjapan/index.php(87): Mage::run('', 'store')
#20 {main}";s:3:"url";s:1:"/";s:11: "script_name";s:10:"/index.php";s:4:"skin";s:7:"russian";
} does not help.
Indeed, the database was not completely flooded for some reason. I did it with the
command mysqldump -y -f -q --default-character-set=binary --create-options --single-transaction --skip-extended-insert --add-drop-table -h localhost -u p218811_anna -pubigasanbu p218811_okno > oknoinjapan.sql got the console response:
Warning: Using a password on the command line interface can be insecure.
mysqldump: Got error: 1044: Access denied for user 'p218811_anna'@'' to database 'add-drop-table' when selecting the
database , only with varning.

Answer 1

Hey! The table was not found in the database, try adding it yourself:

CREATE TABLE IF NOT EXISTS `log_visitor` (
  `visitor_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Visitor ID',
  `session_id` varchar(64) NOT NULL COMMENT 'Session ID',
  `first_visit_at` timestamp NULL DEFAULT NULL COMMENT 'First Visit Time',
  `last_visit_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Last Visit Time',
  `last_url_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Last URL ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`visitor_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Log Visitors Table' AUTO_INCREMENT=1 ;

Answer 2

Import of the database did not go correctly, reload the database.

Answer 3

Table p218811_okno.log_visitor not copied

Answer 4

try to dump the database with the command:
and then restore with the command:
replace new_database_name with the name of the new database already created and everything should work
just in case here is the cheat sheet habrahabr.ru/post/105954