Transfer fail

boazor

• April 03, 2024 10:44
• Edited

Hi guys,

I use the transfer tool to transfer all my site but only one site fail , I move one by one to make sure no issue.

Last one is big site 3GB mysql+file but its keep failing .

Moving from Centos to AlmaLinux 8 

any advice how to transfer this site without keep fail?

Cpanel::Exception::Database::Error/(XID j89mrq) The system received an error from the “MySQL” database “databasename ”: ER_PARSE_ERROR (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''http://domain.com/pbv2/getwall/r8u9m4days/5/1/subid/payout/1/status/1/campi' at line 1)\x0A at /usr/local/cpanel/Cpanel/DBI.pm line 200, <$rfh> line 2721.\x0A\x09Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::db=HASH(0x1df4188), "DBD::mysql::db do failed: You have an error in your SQL synta"..., undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 188\x0A\x09Cpanel::DBI::_error_handler("DBD::mysql::db do failed: You have an error in your SQL synta"..., Cpanel::DBI::Mysql::db=HASH(0x1df4188), undef) called at /usr/local/cpanel/Cpanel/Mysql/Restore/Client.pm line 456\x0A\x09Cpanel::Mysql::Restore::Client::_handle_one_delimited_mysql_statement(Cpanel::Mysql::Restore::Client=HASH(0x1aa7b08), SCALAR(0xdfc888), Cpanel::DBI::Mysql::db=HASH(0x1df4188)) called at /usr/local/cpanel/Cpanel/Mysql/Restore/Client.pm line 234\x0A\x09Cpanel::Mysql::Restore::Client::__ANON__() called at /usr/local/cpanel/Cpanel/Mysql/Restore/Client.pm line 283\x0A\x09Cpanel::Mysql::Restore::Client::run(__CPANEL_HIDDEN__, Cpanel::Output::Callback=HASH(0x1a7f058), __CPANEL_HIDDEN__, GLOB(0x1a6d418), __CPANEL_HIDDEN__, __CPANEL_HIDDEN__, __CPANEL_HIDDEN__, __CPANEL_HIDDEN__, ...) called at bin/restore_mysql_for_account_restore.pl line 106\x0A\x09bin::restore_mysql_for_account_restore::__ANON__() called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/Try/Tiny.pm line 100\x0A\x09eval {...} called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/Try/Tiny.pm line 91\x0A\x09Try::Tiny::try(CODE(0x1a7cd68), Try::Tiny::Catch=REF(0xda0bd8)) called at bin/restore_mysql_for_account_restore.pl line 119\x0A\x09bin::restore_mysql_for_account_restore::run(bin::restore_mysql_for_account_restore=HASH(0x1a7ee18)) called at bin/restore_mysql_for_account_restore.pl line 62\x0A at bin/restore_mysql_for_account_restore.pl line 118, <$rfh> line 2721.

Boaz

• 

  cPRex Jurassic Moderator

  • April 03, 2024 17:40

  Within the Transfer Tool you can also move over packages and settings if you'd like:

  https://docs.cpanel.net/whm/transfers/transfer-tool/#service-configurations

  0
• 

  boazor

  • April 03, 2024 20:02

  I got to dead end no matter what I try cant cross any directory only main one 

  0
• 

  boazor

  • April 03, 2024 20:45

  I found the issue it was PHP version I install 7.4 site back to work .

  I am working on new site so it will support 8.3

  Thanks for all the help

  0
• 

  cPRex Jurassic Moderator

  • April 03, 2024 20:52

  I'm glad you found that!

  0

Please sign in to leave a comment.