Error when restore fullbackup

[mahdy_sharifi]

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 .

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

 

[cPanelMichael]

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.

 

[mahdy_sharifi]

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

 

[cPanelMichael]

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.

 

[mahdy_sharifi]

connection timeout or wait_timeout ?

 

[cPanelMichael]

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.

 

[mahdy_sharifi]

no related error logged in error-log file

 

[cPanelMichael]

Are you able to access your /etc/my.cnf file to show us the current values?

Thank you.

 

[mahdy_sharifi]

Hello :
I found databases restore without problem in mysql server , but not update in Cpanel . So user can't see them.

 

[cPanelMichael]

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.