Control Web Panel

WebPanel => MySQL => Topic started by: voymacao on April 23, 2018, 06:22:05 AM

Title: CWP to CWP Migration
Post by: voymacao on April 23, 2018, 06:22:05 AM
Hello,
Today i tried the new feature of CWP -> CWP migration.
Although everything i setup as described and the system worked with no errors, it seems the database is not created at all.
Files and database user/permissions seem to be moved successfully, but database is not generated on the remote server.
Any idea what might causing this?

Thank you.

Title: Re: CWP to CWP Migration
Post by: josemnunez on April 23, 2018, 10:05:44 AM
What do the records of the transfer tell you?
Title: Re: CWP to CWP Migration
Post by: voymacao on April 23, 2018, 01:35:31 PM
No obvious error despite the bytes - yet files are copied anyway:

-----------------
2018-04-22 21:18:51 Verifying...!
2018-04-22 21:18:51 Initial process balkan
2018-04-22 21:18:51 Starting. balkan
2018-04-22 21:18:51 {key:M1HJgVNNRzpQGsbnZ60AyD6tuDM1A8tJeinbsCUIg2fM5,action:add,domain:balkantrips.eu,user:balkan,pass:123qaz//,email:ipins.team@gmail.com,package:6,inode:0,limit_nproc:40,limit_nofile:100,server_ips:94.176.233.234}
2018-04-22 21:18:52 {status:OK}
2018-04-22 21:18:52 Response Api . OK
2018-04-22 21:18:52 Account created balkan
2018-04-22 21:18:52 Start copy of the pass balkan
2018-04-22 21:18:52 Final copy pass balkan
2018-04-22 21:18:52 initiation creation of domains and subdomains balkan
2018-04-22 21:18:52 ionice -c 3 nice -n +19 /usr/bin/rsync -avz -e 'ssh -p 22202 -o UserKnownHostsFile=/dev/null -o StrictHostKeyChecking=no -o LogLevel=quiet -i /usr/local/cwp/.conf/tranf_cwp.rsa' /var/vmail/balkantrips.eu/ root@94.176.233.234:/var/vmail/balkantrips.eu/
2018-04-22 21:18:52 sending incremental file list
created directory /var/vmail/balkantrips.eu

sent 12 bytes received 12 bytes 48.00 bytes/sec
total size is 0 speedup is 0.00

2018-04-22 21:18:52 start copy of mysql balkan
2018-04-22 21:18:52 Copying Files balkan
2018-04-22 21:20:02 Successfully migrated account balkan
2018-04-22 21:20:02 Creating user and mysql permissions on the remote machine balkan
2018-04-22 21:20:02 Successfully migrated account balkan
2018-04-22 21:20:02 END
--------------------
Title: Re: CWP to CWP Migration
Post by: josemnunez on April 23, 2018, 01:50:37 PM
Please try to execute the following command by the console of your source server and check the output

Code: [Select]
ionice -c 3 nice -n +19 /usr/bin/rsync -avz -e 'ssh -p 22202 -o UserKnownHostsFile=/dev/null -o StrictHostKeyChecking=no -o LogLevel=quiet -i /usr/local/cwp/.conf/tranf_cwp.rsa' /var/vmail/balkantrips.eu/ root@94.176.233.234:/var/vmail/balkantrips.eu/
Title: Re: CWP to CWP Migration
Post by: voymacao on April 23, 2018, 01:54:52 PM
Thanks, tried that and thats what i get:
------------
sending incremental file list
rsync: change_dir "/var/vmail/balkantrips.eu" failed: No such file or directory                                                                                         (2)
created directory /var/vmail/balkantrips.eu

sent 12 bytes  received 12 bytes  16.00 bytes/sec
total size is 0  speedup is 0.00
rsync error: some files/attrs were not transferred (see previous errors) (code 2                                                                                        3) at main.c(1052) [sender=3.0.9]

-----------
Title: Re: CWP to CWP Migration
Post by: voymacao on April 23, 2018, 04:30:04 PM
I have now moved some static html websites with CWP -> CWP and i can configure it works with the account and files. When i try to move a website with a database everything else seems to be copied except the database itself, which is not even created on the remote server. Any thoughts are much appreciated.
Title: Re: CWP to CWP Migration
Post by: josemnunez on April 25, 2018, 10:57:38 AM
which says the error log for migration
Title: Re: CWP to CWP Migration
Post by: crmgddn63 on August 31, 2018, 01:31:49 PM
unfortunately only users and create and email addresses. website files and databases.