Results 1 to 16 of 16
-
11-07-2012, 05:29 PM #1Disabled
- Join Date
- Feb 2010
- Posts
- 19
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 databases0
-
11-07-2012, 05:35 PM #2Junior Guru Wannabe
- Join Date
- Jul 2010
- Location
- United Kingdom
- Posts
- 42
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
-
11-07-2012, 05:39 PM #3Web Hosting Master
- Join Date
- May 2009
- Location
- Midworld
- Posts
- 1,819
Have you tried alternatives like restoring a backup?
0
-
11-07-2012, 06:16 PM #4Disabled
- Join Date
- Feb 2010
- Posts
- 19
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 this0
-
11-07-2012, 08:24 PM #5Disabled
- Join Date
- Feb 2010
- Posts
- 19
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 guys0
-
11-07-2012, 08:33 PM #6Disabled
- Join Date
- Nov 2011
- Location
- Nasik, MH,INDIA
- Posts
- 862
Glad to hear that your issue has been resolved.
0
-
11-08-2012, 12:14 AM #7Web Hosting Master
- Join Date
- May 2009
- Location
- Midworld
- Posts
- 1,819
0
-
11-10-2012, 07:22 PM #8Disabled
- Join Date
- Feb 2010
- Posts
- 19
0
-
11-10-2012, 07:30 PM #9Hello World
- Join Date
- Nov 2009
- Location
- /etc/my.cnf
- Posts
- 10,657
UK Based Proactive Server Management.
Zabbix Enterprise 24/7 Monitoring.0
-
11-13-2012, 06:27 PM #10Newbie
- Join Date
- Nov 2012
- Posts
- 20
Helped me
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
Code:/scripts/fullhordereset
Thanks for your help.0
-
11-13-2012, 08:08 PM #11Newbie
- Join Date
- Jul 2011
- Posts
- 9
Please try to run the command; /usr/local/cpanel/bin/update-horde --force
0
-
11-16-2012, 09:03 PM #12Web Hosting Guru
- 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 databases0
-
11-17-2012, 12:57 PM #13Web Hosting Guru
- Join Date
- Sep 2010
- Posts
- 325
Please assist.
0
-
11-17-2012, 01:07 PM #14Unknown storage engine 'InnoDB'0
-
11-17-2012, 01:09 PM #15Web Hosting Guru
- 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-networking0
-
05-26-2013, 07:21 AM #16New Member
- Join Date
- May 2013
- Posts
- 1
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..
VarkanLast edited by bear; 05-26-2013 at 08:15 AM.
0
Similar Threads
-
Unable to copy account from other server
By Hassan in forum Hosting Security and TechnologyReplies: 9Last Post: 04-15-2011, 10:56 AM -
Copy an account from another server via WHM - Cannot copy mysql database. ?
By san-deep in forum Hosting Security and TechnologyReplies: 3Last Post: 10-09-2008, 04:56 AM -
Copy an account from another server with account password with Cpanel
By greenba in forum Dedicated ServerReplies: 9Last Post: 01-01-2005, 11:33 AM -
Copy an account from another server with account password
By seekhosting in forum Dedicated ServerReplies: 4Last Post: 07-19-2004, 11:26 AM -
Copy an account from another server with account password
By forumtalk in forum Hosting Security and TechnologyReplies: 3Last Post: 10-05-2003, 10:31 AM