Error when restore fullbackup
Hello :
when i restore fullbackup, following error occur, and then database not appear in cpanel. but they restore actually on server. I am using remote-mysql server .
How caan resolve this ? Regards
PUSHBULLET_ACCESS_TOKEN: The key "PUSHBULLET_ACCESS_TOKEN" is unknown, so the system will not restore this key.
CLAMAVSCANS: The key "CLAMAVSCANS" is unknown, so the system will not restore this key.
notify_account_login_for_known_netblock: The key "notify_account_login_for_known_netblock" is unknown, so the system will not restore this key.
The "Mysql" restore module failed because of an error: DBD::mysql::db selectrow_array failed: Lost connection to MySQL server during query at /usr/local/cpanel/Cpanel/Exception.pm line 156. Cpanel::Exception::new("Cpanel::Exception::Database::Error", Cpanel::ExceptionMessage::Raw=SCALAR(0x3d9f100), HASH(0x878dbf0)) called at /usr/local/cpanel/Cpanel/Exception.pm line 57 Cpanel::Exception::create("Database::Error", Cpanel::ExceptionMessage::Raw=SCALAR(0x3d9f100), HASH(0x878dbf0)) called at /usr/local/cpanel/Cpanel/Exception.pm line 72 Cpanel::Exception::create_raw("Database::Error", "DBD::mysql::db selectrow_array failed: Lost connection to MyS"..., HASH(0x878dbf0)) called at /usr/local/cpanel/Cpanel/DBI.pm line 105 Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::db=HASH(0x877ae78), "DBD::mysql::db selectrow_array failed: Lost connection to MyS"..., undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 93 Cpanel::DBI::_error_handler("DBD::mysql::db selectrow_array failed: Lost connection to MyS".."stmgr::Transfers::Session::Processor::_process_child_with_output_redirection(Whostmgr::Transfers::Session::Processor=HASH(0x6466c30), Whostmgr::Transfers::Session=HASH(0x6466690), 0) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Processor.pm line 154 Whostmgr::Transfers::Session::Processor::__ANON__() called at /usr/local/cpanel/Cpanel/ForkAsync.pm line 36 eval {...} called at /usr/local/cpanel/Cpanel/ForkAsync.pm line 36 Cpanel::ForkAsync::do_in_child(CODE(0x64fab58)) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Processor.pm line 156 Whostmgr::Transfers::Session::Processor::start(Whostmgr::Transfers::Session::Processor=HASH(0x6466c30)) called at bin/start_transfer.pl line 55 main::try {...} () called at /usr/local/cpanel/3rdparty/perl/514/lib64/perl5/cpanel_lib/Try/Tiny.pm line 81 eval {...} called at /usr/local/cpanel/3rdparty/perl/514/lib64/perl5/cpanel_lib/Try/Tiny.pm line 72 Try::Tiny::try(CODE(0x6464108), Try::Tiny::Catch=REF(0x3c914c0)) called at bin/start_transfer.pl line 70 How caan resolve this ? Regards
-
Hello :) Have you verified that connections to the remote MySQL server from the cPanel server are successful? For example, can you run the "mysql" command without an error message? Thank you. 0 -
Yes ... example : mysqladmin version Server version 5.6.26-cll-lve Protocol version 10 Connection mysql1.xxxxxx.net via TCP/IP TCP port 3306 Uptime: 9 min 54 sec 0 -
You can review the MySQL error log on the remote server to see if you notice any specific entries at the time of the failure. Also, review the /etc/my.cnf file on the remote MySQL server to see if there are any timeout options you may need to modify. Thank you. 0 -
connection timeout or wait_timeout ? 0 -
Were you able to review the MySQL error log (/var/lib/mysql/$hostname.err) when this happens to see the specific error message that's output? What are your current /etc/my.cnf configuration values? Thank you. 0 -
no related error logged in error-log file 0 -
Are you able to access your /etc/my.cnf file to show us the current values? Thank you. 0 -
Hello : I found databases restore without problem in mysql server, but not update in Cpanel . So user can't see them. 0 -
Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome. Thank you. 0
Please sign in to leave a comment.
Comments
9 comments