Results 1 to 16 of 16
  1. #1

    unable to Copy an Account From Another Server

    Hello everyone
    i am trying to transfer an account from my old vps to my new one

    but i am getting an error and than transfer is not done
    please help

    output from whm

    Attempting to copy fifatuni from 37.59.x.x
    Testing 37.59.x.1x for xfer streaming support....Supported!
    Packaging the account: (/usr/local/cpanel/scripts/pkgacct --use_backups --skiphomedir fifatuni "" --split --compressed --mysql 5.5)...

    pkgacct started.
    pkgacct -- attempting to use daily backup to create a account package
    pkgacct -- could not use daily backup because it is missing (/backup/cpbackup/daily/fifatuni)
    pkgacct version 10 - user : fifatuni - tarball: 1 - target mysql : 5.5 - split: 1 - incremental: 0 - homedir: 0 - archive version: 3 - running with uid 0
    pkgacct working dir : /home/cpmove-fifatuni
    Copying Reseller Config...Done
    Copying Suspension Info (if needed)...Done
    Copying SSL Certificates, CSRS, and Keys...Done
    Copying Domain Keys....Done
    Copying Counter Data....Done
    Copying Bandwidth Data....Done
    Copying Dns Zones.......fifatunisianplayers.com...Done
    Copying Mail files....Done
    Copying frontpage files....Done
    Copying proftpd file....Done
    Copying www logs.......log file sizes [1091 byte(s)]......fifatunisianplayers.com-bytes_log......ftp.fifatunisianplayers.com-ftp_log.offset......ftp.fifatunisianplayers.com-ftp_log.offsetftpbytes......fifatunisianplayers.com...Done
    Copy userdata...Done
    Copy custom virtualhost templates...Done
    Copying mailman lists and archives....
    Done
    Determining mysql dbs......mysql version: 5.5......mysqldump version: 5.5...Saving mysql privs...Done
    ERROR 1146 (42S02) at line 1: Table 'horde.kronolith_shares' doesn't exist
    ERROR 1146 (42S02) at line 1: Table 'horde.kronolith_shares' doesn't exist

    Skipping Logaholic Backup. Logaholic is globally disabled on this system.

    Storing mysql dbs............
    horde.turba_objectshorde.turba_objects
    Error : Table 'horde.turba_objects' doesn't exist
    status : Operation failed
    (779 bytes) horde.turba_shareshorde.turba_shares
    Error : Table 'horde.turba_shares' doesn't exist
    status : Operation failed
    (779 bytes) horde.horde_prefshorde.horde_prefs
    Error : Table 'horde.horde_prefs' doesn't exist
    status : Operation failed
    (779 bytes) horde.kronolith_shareshorde.kronolith_shares
    Error : Table 'horde.kronolith_shares' doesn't exist
    status : Operation failed
    (779 bytes) horde.kronolith_storagehorde.kronolith_storage
    Error : Table 'horde.kronolith_storage' doesn't exist
    status : Operation failed
    (779 bytes) horde.mnemo_memoshorde.mnemo_memos
    Error : Table 'horde.mnemo_memos' doesn't exist
    status : Operation failed
    (779 bytes) horde.nag_taskshorde.nag_tasks
    Error : Table 'horde.nag_tasks' doesn't exist
    status : Operation failed
    (779 bytes) roundcube.users,roundcube.identities,roundcube.contacts,roundcube.contactgroups(7065 bytes) roundcube.contactgroupmembers(2373 bytes)





    ERROR: Failed to dump one or more databases
      0 Not allowed!

  2. #2
    Join Date
    Jul 2010
    Location
    United Kingdom
    Posts
    42
    Quote Originally Posted by walid View Post
    Hello everyone
    Storing mysql dbs............
    horde.turba_objectshorde.turba_objects
    Error : Table 'horde.turba_objects' doesn't exist
    status : Operation failed
    (779 bytes) horde.turba_shareshorde.turba_shares
    Error : Table 'horde.turba_shares' doesn't exist
    status : Operation failed
    (779 bytes) horde.horde_prefshorde.horde_prefs
    Error : Table 'horde.horde_prefs' doesn't exist
    status : Operation failed
    (779 bytes) horde.kronolith_shareshorde.kronolith_shares
    Error : Table 'horde.kronolith_shares' doesn't exist
    status : Operation failed
    (779 bytes) horde.kronolith_storagehorde.kronolith_storage
    Error : Table 'horde.kronolith_storage' doesn't exist
    status : Operation failed
    (779 bytes) horde.mnemo_memoshorde.mnemo_memos
    Error : Table 'horde.mnemo_memos' doesn't exist
    status : Operation failed
    (779 bytes) horde.nag_taskshorde.nag_tasks
    Error : Table 'horde.nag_tasks' doesn't exist
    status : Operation failed
    (779 bytes)
    From what this is saying, I'm guessing either Horde isn't installed on your new server (there's an option for it in WHM somewhere, along with other mail clients), or that there was something wrong with the backup/transfer. Is it possible to repackage the account for importing to a new server?

    Regards,
    Ben.
    ExoHosting UK - cPanel Shared Hosting
    Daily Backups • Domain names • 99% Uptime
    24/7 friendly ticket and email support
    http://www.exohosting.co.uk/
      0 Not allowed!

  3. #3
    Join Date
    May 2009
    Location
    Midworld
    Posts
    1,819
    Have you tried alternatives like restoring a backup?
      0 Not allowed!

  4. #4
    actualy dear i am willing to move many account's not only this so working with backups will be a painfull work

    and horde installed on the new server and fully working, i am lost with this
      0 Not allowed!

  5. #5
    Fixed and here is the solution for any body facing similar problem

    take backup of your horde database :
    mysqldump --add-drop-table horde > horde.sql

    then full reisntall of horde

    /scripts/fullhordereset

    Good luck guys
      0 Not allowed!

  6. #6
    Join Date
    Nov 2011
    Location
    Nasik, MH,INDIA
    Posts
    862
    Glad to hear that your issue has been resolved.
      0 Not allowed!

  7. #7
    Join Date
    May 2009
    Location
    Midworld
    Posts
    1,819
    Quote Originally Posted by walid View Post
    actualy dear i am willing to move many account's not only this so working with backups will be a painfull work

    and horde installed on the new server and fully working, i am lost with this
    Depending on the size of <our accounts you'll frequently meet limitations with the transfer functionality in WHM.
      0 Not allowed!

  8. #8
    Quote Originally Posted by httpEasy View Post
    Depending on the size of <our accounts you'll frequently meet limitations with the transfer functionality in WHM.
    Its ok to move large amount account's it will take time but all good if you remove " compress " option to reduce usage of cpu and ram as well better to use FTP and disable ssl

    if you are facing troubles do not move all account's at once maybe few each time

    good luck
      0 Not allowed!

  9. #9
    Join Date
    Nov 2009
    Location
    /etc/my.cnf
    Posts
    10,657
    Quote Originally Posted by walid View Post
    Its ok to move large amount account's it will take time but all good if you remove " compress " option to reduce usage of cpu and ram as well better to use FTP and disable ssl

    if you are facing troubles do not move all account's at once maybe few each time

    good luck
    What ive noticed is that any account over the 35GB range you will have issues with it even at 35GB we noticed some files missing which was picked up when we Rsync'ed the files to make sure everything had been moved.

    Regards,
    UK Based Proactive Server Management.
    Zabbix Enterprise 24/7 Monitoring.
      0 Not allowed!

  10. #10

    Smile Helped me

    Quote Originally Posted by walid View Post

    then full reisntall of horde

    /scripts/fullhordereset
    Just wanted to let you know that this helped me. But I didn't know at first whether to do this on the server we were copying to or from. I should have known it was the from server.

    Here is my experience. I was trying to transfer all the accounts from one server to another but each one had this error at the end:

    Determining mysql dbs...DBD::mysql::db selectall_arrayref failed: Table 'roundcube.users' doesn't exist at /usr/local/cpanel/bin/cpmysqladmin line 195.
    DBD::mysql::db selectall_arrayref failed: Table 'roundcube.users' doesn't exist at /usr/local/cpanel/bin/cpmysqladmin line 195.
    ERROR 1146 (42S02) at line 1: Table 'horde.kronolith_shares' doesn't exist
    ERROR 1146 (42S02) at line 1: Table 'horde.kronolith_shares' doesn't exist

    Skipping Logaholic Backup. Logaholic is globally disabled on this system.

    Storing mysql dbs............
    horde.turba_objectsERROR 1146 (42S02) at line 1: Table 'roundcube.users' doesn't exist
    horde.turba_objects
    error : Table 'horde.turba_objects' doesn't exist
    (667 bytes) horde.turba_shareshorde.turba_shares
    error : Table 'horde.turba_shares' doesn't exist
    (667 bytes) horde.horde_prefs(1332 bytes) horde.kronolith_shareshorde.kronolith_shares
    error : Table 'horde.kronolith_shares' doesn't exist
    (667 bytes) horde.kronolith_storagehorde.kronolith_storage
    error : Table 'horde.kronolith_storage' doesn't exist
    (667 bytes) horde.mnemo_memoshorde.mnemo_memos
    error : Table 'horde.mnemo_memos' doesn't exist
    (667 bytes) horde.nag_taskshorde.nag_tasks
    error : Table 'horde.nag_tasks' doesn't exist
    (667 bytes)


    ERROR: Failed to dump one or more databases
    Transfer Error Unable to package account
    To fix had to log into shell of server that we were copying the account FROM. And run the command:

    Code:
    /scripts/fullhordereset
    then started the transfer again and it worked.

    Thanks for your help.
      0 Not allowed!

  11. #11
    Please try to run the command; /usr/local/cpanel/bin/update-horde --force
      0 Not allowed!

  12. #12
    Join Date
    Sep 2010
    Posts
    325
    Same problem here when using multiple transfer via whm (cpanel to cpanel server)

    ERROR: Failed to dump one or more database

    I tried below to no avail, on both servers (source/destination)

    /usr/local/cpanel/bin/update-horde --force
    /scripts/fullhordereset

    Trace output from whm transfer:

    root@xxx.xxx.xxx.50's password: ==sshcontroloutput==
    pkgacct started.
    pkgacct version 10 - user : client - tarball: 1 - target mysql : 5.5 - split: 1 - incremental: 0 - homedir: 0 - archive version: 3 - running with uid 0
    pkgacct working dir : /home/cpmove-client
    Copying Reseller Config...
    Copying Reseller Packages and Features ...
    Done
    Copying Suspension Info (if needed)...Done
    Copying SSL Certificates, CSRS, and Keys...Done
    Copying Domain Keys....Done
    Copying Counter Data....Done
    Copying Bandwidth Data......client-imap-rate.rrd....clientdomain.net-all-rate.rrd....client-smtp-rate.rrd....client-http-peak.rrd....client-pop3-rate.rrd....clientdomain.net-http-peak.rrd....client-imap-peak.rrd....clientdomain.net....clientdomain.net-all-peak.rrd....client-ftp-peak.rrd....client-ftp-rate.rrd....client-all-rate.rrd....clientdomain.net-http-rate.rrd....client....client-pop3-peak.rrd....client-smtp-peak.rrd....client-http-rate.rrd....client-all-peak.rrd..Done
    Copying Dns Zones.......clientdomain.net...Done
    Copying Mail files....Done
    Copying frontpage files....Done
    Copying proftpd file....Done
    Copying www logs.......log file sizes [3486 byte(s)]......clientdomain.net......clientdomain.net-bytes_log...Done
    Copy userdata...Done
    Copy custom virtualhost templates...Done
    Copying mailman lists and archives....
    Done
    .........
    Determining mysql dbs...DBD::mysql::db selectall_arrayref failed: Unknown storage engine 'InnoDB' at /usr/local/cpanel/bin/cpmysqladmin line 195.
    DBD::mysql::db selectall_arrayref failed: Unknown storage engine 'InnoDB' at /usr/local/cpanel/bin/cpmysqladmin line 195.
    ...mysql version: 5.5......mysqldump version: 5.5...Saving mysql privs...Done
    ERROR 1286 (42000) at line 1: Unknown storage engine 'InnoDB'
    ...Done

    Skipping Logaholic Backup. Logaholic is globally disabled on this system.

    Storing mysql dbs............
    horde.turba_objectshorde.turba_objects OK
    (1101 bytes) horde.turba_shareshorde.turba_shares OK
    (1062 bytes) horde.horde_prefshorde.horde_prefs OK
    (2996 bytes) horde.kronolith_shareshorde.kronolith_shares OK
    (1119 bytes) horde.kronolith_storagehorde.kronolith_storage OK
    (1119 bytes) horde.mnemo_memoshorde.mnemo_memos OK
    (1097 bytes) horde.nag_taskshorde.nag_tasks OK
    (1089 bytes)
    ERROR: Failed to dump one or more databases
      0 Not allowed!

  13. #13
    Join Date
    Sep 2010
    Posts
    325
    Please assist.
      0 Not allowed!

  14. #14
    Join Date
    Jul 2006
    Location
    Australia
    Posts
    3,809
    Unknown storage engine 'InnoDB'
    Maybe you have skip-innodb in your my.cnf file?
      0 Not allowed!

  15. #15
    Join Date
    Sep 2010
    Posts
    325
    No. My cnf file on both source and destination servers are

    [mysqld]
    bind-address=127.0.0.1
    default-storage-engine=MyISAM
    log-error="/var/log/mysqld.error.log"
    innodb_file_per_table=1
    log="/var/log/mysqld.log"
    query_cache_size=10M
    join_buffer_size=130K
    tmp_table_size=20M
    max_heap_table_size=20M
    thread_cache_size=4
    table_cache=500
    open_files_limit=65535
    local-infile=0
    skip-networking
      0 Not allowed!

  16. #16

    Solution..

    Hi everybody,

    We have the same problem and cpbackup was not working.

    We have copy horde.sql from our other server and import it to the not working one.

    It is working right now and we can backup right now.

    <<attachment removed>>

    Hello from Turkiye..

    Varkan
    Last edited by bear; 05-26-2013 at 08:15 AM.
      0 Not allowed!

Similar Threads

  1. Unable to copy account from other server
    By Hassan in forum Hosting Security and Technology
    Replies: 9
    Last Post: 04-15-2011, 10:56 AM
  2. Copy an account from another server via WHM - Cannot copy mysql database. ?
    By san-deep in forum Hosting Security and Technology
    Replies: 3
    Last Post: 10-09-2008, 04:56 AM
  3. Replies: 9
    Last Post: 01-01-2005, 11:33 AM
  4. Copy an account from another server with account password
    By seekhosting in forum Dedicated Server
    Replies: 4
    Last Post: 07-19-2004, 11:26 AM
  5. Copy an account from another server with account password
    By forumtalk in forum Hosting Security and Technology
    Replies: 3
    Last Post: 10-05-2003, 10:31 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •