The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Error when restore fullbackup

Discussion in 'Data Protection' started by mahdy_sharifi, Nov 23, 2015.

  1. mahdy_sharifi

    mahdy_sharifi Well-Known Member

    Joined:
    Feb 26, 2012
    Messages:
    177
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    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 .

    Code:
    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
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  3. mahdy_sharifi

    mahdy_sharifi Well-Known Member

    Joined:
    Feb 26, 2012
    Messages:
    177
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    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
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  5. mahdy_sharifi

    mahdy_sharifi Well-Known Member

    Joined:
    Feb 26, 2012
    Messages:
    177
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    connection timeout or wait_timeout ?
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  7. mahdy_sharifi

    mahdy_sharifi Well-Known Member

    Joined:
    Feb 26, 2012
    Messages:
    177
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    no related error logged in error-log file
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  9. mahdy_sharifi

    mahdy_sharifi Well-Known Member

    Joined:
    Feb 26, 2012
    Messages:
    177
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Hello :
    I found databases restore without problem in mysql server , but not update in Cpanel . So user can't see them.
     
  10. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page