Transfer fail
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
-
Hey there! On the Source machine, are you able to run "/scripts/pkgacct username" without errors? Just replace "username" with the cPanel account username you are working with.
0 -
Hi cPRex ,
Thanks for the reply.
Forgive me if I dont understand what you mean where I do this "/scripts/pkgacct username" ?
0 -
pkgacct is the tool that creates the cPanel backup that you move to the other server. Testing this on the command line directly may give you more information about the database failure so we can get that resolved.
0 -
OK,
no error.
Boaz
0 -
So that completed fully for the user with no error? Nothing odd showed up with the database when you ran that?
0 -
No , and its create file on server 900MB but full account is 2.5GB
[root@cp ~]# /scripts/pkgacct xxxxxx (user name)
[2024-04-03 08:04:26 -0700] pkgacct started.
[2024-04-03 08:04:26 -0700] pkgacct version 10 - user : xxxxxxx- tarball: 1 - target mysql : default - split: 0 - incremental: 0 - homedir: 1 - mailman: 1 - backup: 0 - archive version: 4 - running with uid 0
[2024-04-03 08:04:26 -0700] pkgacct using '/usr/local/cpanel/3rdparty/bin/pigz -6 --processes 1 --blocksize 4096 --rsyncable' to compress archives
[2024-04-03 08:04:26 -0700] pkgacct working dir : /home/cpmove-xxxxxx
[2024-04-03 08:04:26 -0700] Copying Reseller Config...[2024-04-03 08:04:26 -0700] Done
[2024-04-03 08:04:26 -0700] Copying Suspension Info (if needed)...[2024-04-03 08:04:26 -0700] Done
[2024-04-03 08:04:26 -0700] Copying Team Info (if needed)...[2024-04-03 08:04:26 -0700] Done
[2024-04-03 08:04:26 -0700] Copying installed SSL certificates and keys...[2024-04-03 08:04:26 -0700] Performing “ApacheTLS” component....
[2024-04-03 08:04:26 -0700] Completed “ApacheTLS” component.
[2024-04-03 08:04:26 -0700] Done
[2024-04-03 08:04:26 -0700] Copying DKIM keys....[2024-04-03 08:04:26 -0700] Done
[2024-04-03 08:04:26 -0700] Copying Bandwidth Data....[2024-04-03 08:04:26 -0700] Performing “Bandwidth” component....
Summary databases … done!
[2024-04-03 08:04:27 -0700] Completed “Bandwidth” component.
[2024-04-03 08:04:27 -0700] Done
[2024-04-03 08:04:27 -0700] Copying Dns Zones.......xxxxxxx...[2024-04-03 08:04:27 -0700] Done
[2024-04-03 08:04:27 -0700] Copying Mail files....[2024-04-03 08:04:27 -0700] Performing “MailConfig” component....
[2024-04-03 08:04:27 -0700] Completed “MailConfig” component.
[2024-04-03 08:04:27 -0700] Done
[2024-04-03 08:04:27 -0700] Copying proftpd file....[2024-04-03 08:04:27 -0700] Done
[2024-04-03 08:04:27 -0700] Performing “Logs” component....
...log file sizes [40086 byte(s)]......xxxxxxxx-ssl_log......xxxxxxx.....xxxxxxxx-bytes_log...[2024-04-03 08:04:27 -0700] Completed “Logs” component.
[2024-04-03 08:04:27 -0700] Copy userdata...[2024-04-03 08:04:27 -0700] Done
[2024-04-03 08:04:27 -0700] Copy custom virtualhost templates...[2024-04-03 08:04:27 -0700] Done
[2024-04-03 08:04:27 -0700] Copying mailman lists and archives....Done copying mailman lists and archives.
[2024-04-03 08:04:27 -0700] Copying homedir.............
[2024-04-03 08:04:28 -0700] Done
[2024-04-03 08:04:28 -0700] Fixing up EA4 .htaccess blocks: /home/xxxxxx/public_html/.htaccess Done.
[2024-04-03 08:04:28 -0700] Performing “Postgresql” component....
[2024-04-03 08:04:28 -0700] Completed “Postgresql” component.
[2024-04-03 08:04:28 -0700] Performing “Mysql” component....
[2024-04-03 08:04:28 -0700] Determining mysql dbs...[2024-04-03 08:04:28 -0700] ...mysqldump version: 5.7.44...[2024-04-03 08:04:28 -0700] ...mysql version: 5.7...[2024-04-03 08:04:28 -0700] Saving mysql privs...[2024-04-03 08:04:28 -0700] Done
[2024-04-03 08:04:28 -0700] Saving mysql authentication information...[2024-04-03 08:04:28 -0700] Done
[2024-04-03 08:04:28 -0700] Storing MySQL databases...[2024-04-03 08:04:28 -0700] Storing database rewardsc_cpanewnetworkscr
[2024-04-03 08:05:11 -0700] Storing database rewardsc_support
[2024-04-03 08:05:11 -0700] Done
[2024-04-03 08:05:11 -0700] ...Done
[2024-04-03 08:05:11 -0700] ...Done
[2024-04-03 08:05:11 -0700] Completed “Mysql” component.
[2024-04-03 08:05:11 -0700] Performing “MysqlRemoteNotes” component....
[2024-04-03 08:05:11 -0700] Completed “MysqlRemoteNotes” component.
[2024-04-03 08:05:11 -0700] Performing “CpUserFile” component....
[2024-04-03 08:05:11 -0700] Completed “CpUserFile” component.
[2024-04-03 08:05:11 -0700] Performing “Cron” component....
[2024-04-03 08:05:11 -0700] Readable crontab file (/var/spool/cron/xxxxxxx) found; copying …
[2024-04-03 08:05:11 -0700] Completed “Cron” component.
[2024-04-03 08:05:11 -0700] Performing “Quota” component....
[2024-04-03 08:05:11 -0700] Completed “Quota” component.
[2024-04-03 08:05:11 -0700] Performing “Integration” component....
[2024-04-03 08:05:11 -0700] Completed “Integration” component.
[2024-04-03 08:05:11 -0700] Performing “AuthnLinks” component....
[2024-04-03 08:05:11 -0700] Completed “AuthnLinks” component.
[2024-04-03 08:05:11 -0700] Performing “APITokens” component....
[2024-04-03 08:05:11 -0700] Completed “APITokens” component.
[2024-04-03 08:05:11 -0700] Performing “DNSSEC” component....
[2024-04-03 08:05:11 -0700] Completed “DNSSEC” component.
[2024-04-03 08:05:11 -0700] Performing “Custom” component....
[2024-04-03 08:05:11 -0700] No custom components to perform.
[2024-04-03 08:05:11 -0700] Completed “Custom” component.
[2024-04-03 08:05:11 -0700] Performing “AutoSSL” component....
[2024-04-03 08:05:11 -0700] Completed “AutoSSL” component.
[2024-04-03 08:05:11 -0700] Storing Subdomains....
[2024-04-03 08:05:11 -0700] Done
[2024-04-03 08:05:11 -0700] Storing Parked Domains....
[2024-04-03 08:05:11 -0700] Done
[2024-04-03 08:05:11 -0700] Storing Addon Domains....
[2024-04-03 08:05:11 -0700] Performing “Password” component....
[2024-04-03 08:05:11 -0700] Completed “Password” component.
[2024-04-03 08:05:11 -0700] Performing “DigestShadow” component....
[2024-04-03 08:05:11 -0700] Completed “DigestShadow” component.
[2024-04-03 08:05:11 -0700] Copying shell.......[2024-04-03 08:05:11 -0700] Done
[2024-04-03 08:05:11 -0700] Performing “WebCalls” component....
[2024-04-03 08:05:11 -0700] Completed “WebCalls” component.
[2024-04-03 08:05:11 -0700] Performing “BrandCustomizations” component....
[2024-04-03 08:05:11 -0700] Completed “BrandCustomizations” component.
[2024-04-03 08:05:11 -0700] Performing “PublicContact” component....
[2024-04-03 08:05:11 -0700] Completed “PublicContact” component.
[2024-04-03 08:05:11 -0700] Performing “MailLimits” component....
[2024-04-03 08:05:11 -0700] Completed “MailLimits” component.
[2024-04-03 08:05:11 -0700] Performing “LinkedNodes” component....
[2024-04-03 08:05:11 -0700] Completed “LinkedNodes” component.
[2024-04-03 08:05:11 -0700] Creating Archive ............................................
[2024-04-03 08:06:53 -0700] Done
[2024-04-03 08:06:53 -0700] pkgacctfile is: /home/cpmove-xxxxxxx.tar.gz
[2024-04-03 08:06:56 -0700] md5sum is: 18546be90b59721a34beeccbc8883659
[2024-04-03 08:06:56 -0700]
[2024-04-03 08:06:56 -0700] size is: 932719402
[2024-04-03 08:06:56 -0700]
[2024-04-03 08:06:56 -0700] homesize is: 849899520
[2024-04-03 08:06:56 -0700]
[2024-04-03 08:06:56 -0700] homefiles is: 8331
[2024-04-03 08:06:56 -0700]
[2024-04-03 08:06:56 -0700] mysqlsize is: 3115304532
[2024-04-03 08:06:56 -0700] pkgacct completed0 -
Well, that's a good sign then! Is there a major difference between the MySQL versions on the two systems?
0 -
on new server MySQL 8.0 on old server MySQL 5.7
0 -
I'm wondering if there was just a temporary issues - if you try the Transfer Tool again, does it still fail?
0 -
I try like few times yesterday , I ever try to do it when account suspend didnt work.
I moved like few WP website's all moved easy even with 1GB data
0 -
Could you try manually moving over that pkgacct file you created as a test and see if a manual restore would work? Once the file is moved over to the Destination machine and placed in /home you can restore it through WHM or you can run "/scripts/restorepkg /full/path/to/file"
0 -
I can do that just need to know if its include the database is its only 900MB and all account is 2.5GB is that ok?
0 -
Yes, everything for the account is included in that package we made.
0 -
Do I need to create account on new server or its will create everything ?
0 -
You don't need to pre-create anything as the package will do all that for you.
1 -
Its look like move everything no error .
Thank you very much .
Can I do it on suspend account to?
its live site and I need to take it down before I start
0 -
Yes, although you may need to manually unsuspend it on the Destination after the restore is complete as it will likely also move the suspended flag.
0 -
Ok,
On list account the size of account will take time to update ? as I see now 800mb
0 -
That's also correct - you can manually run /scripts/fixquotas to force an update to that, but it will happen automatically as part of the nightly maintenance.
0 -
cPRex thank you very much for all the help and patience is greatly appreciated
0 -
You're very welcome - it's what I'm here for!
1 -
Hi cPRex,
everything moved , But I am getting error can it be something with .htaccess ?
he requested URL was not found on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
0 -
It's hard to say - do you see anything helpful in the main Apache log at /etc/apache2/logs/error_log?
Do other files on that domain work properly?
0 -
I dont see any error regard this just something about file permission but I fix it as was on old server
755 and 644
0 -
I'm glad you were able to get that fixed quickly!
0 -
I didnt :( I fix the permission but still not working.
I remove somethings from htaccess domain start work but not everything
0 -
We might need to see a ticket on this issue as we'll need more details to troubleshoot this.
0 -
I found this : ModSecurity: collections_remove_stale: Failed to access DBM file "/var/cpanel/secdatadir/
And this is how to fix it just need to be sure its not open some security issues
0 -
There are no security issues by applying that fix.
0 -
On EasyApache 4 I notice its not the same as the old one maybe I will try to compere and add what missing ?
0
Please sign in to leave a comment.
Comments
34 comments