(Jan 22) Release 0.9.8-19 with bug fixes available now. Run this command for update v-update-sys-vesta-all

SK-cPanel-Importer | Restore cPanel Backup on Vesta Topic is solved

Section with additional software for Vesta
Forum rules
Before creating a new topic or reply on the forum you should fill out additional fields "Os" and "Web" in your profile section.
In case of violation, the topic can be closed or response from the support will not be received.
skamasle
Collaborator
Posts: 385
Joined: Mon Feb 29, 2016 6:36 pm

Re: SK-cPanel-Importer | Restore cPanel Backup on Vesta

Postby skamasle » Sat Apr 01, 2017 8:48 pm

coreXL wrote:Yes, I use the latest version of cPanel and I have migrated around 15 sites and in all accounts I migrated everything but the database.sql

And that's why I was curious because the database was never restored in phpMyAdmin, so I did it manually.
The backup is the cPanel standard, ie the one generated by the system itself.

The database is named %cpanelUser%_databasename.sql


Can you give one backup for test ?

If you have one or can create one account with database content

dmitry.vd
Posts: 6
Joined: Wed Apr 05, 2017 10:23 am

Re: SK-cPanel-Importer | Restore cPanel Backup on Vesta

Postby dmitry.vd » Wed Apr 05, 2017 10:36 am

Today I moved wordpress website from Cpanel to Vesta Cp using SK-cPanel-Importer script.
I did not receive any error during script run, database and files are restored.
But I do not see created database in Vesta CP new-restored user interface. And website got error "database error"
server restarted
packet default exist

skamasle
Collaborator
Posts: 385
Joined: Mon Feb 29, 2016 6:36 pm

Re: SK-cPanel-Importer | Restore cPanel Backup on Vesta

Postby skamasle » Wed Apr 05, 2017 1:49 pm

dmitry.vd wrote:Today I moved wordpress website from Cpanel to Vesta Cp using SK-cPanel-Importer script.
I did not receive any error during script run, database and files are restored.
But I do not see created database in Vesta CP new-restored user interface. And website got error "database error"
server restarted
packet default exist


Hi maybe you use ubuntu 16 ?

viewtopic.php?t=13239

dmitry.vd
Posts: 6
Joined: Wed Apr 05, 2017 10:23 am

Re: SK-cPanel-Importer | Restore cPanel Backup on Vesta

Postby dmitry.vd » Wed Apr 05, 2017 3:59 pm

Thanks for quick answer

yes, I use ubuntu 16.04.2 LTS
and mysql Ver 14.14 Distrib 5.7.17

I did instruction from your last link
restart vesta service and found

empty file /usr/local/vesta/data/users/user653/db.conf

skamasle
Collaborator
Posts: 385
Joined: Mon Feb 29, 2016 6:36 pm

Re: SK-cPanel-Importer | Restore cPanel Backup on Vesta

Postby skamasle » Wed Apr 05, 2017 7:08 pm

dmitry.vd wrote:Thanks for quick answer

yes, I use ubuntu 16.04.2 LTS
and mysql Ver 14.14 Distrib 5.7.17

I did instruction from your last link
restart vesta service and found

empty file /usr/local/vesta/data/users/user653/db.conf


Try apply patch

Then delete user and try restore it again

This is a vestacp bug, script works fine if you run it in any orther system if not have mysql 5.7

dmitry.vd
Posts: 6
Joined: Wed Apr 05, 2017 10:23 am

Re: SK-cPanel-Importer | Restore cPanel Backup on Vesta

Postby dmitry.vd » Thu Apr 06, 2017 9:33 am

I applied patch.

I deleted user and restored it again.
But /usr/local/vesta/data/users/user653/db.conf still empty.

How can I check that patch is working?

skamasle
Collaborator
Posts: 385
Joined: Mon Feb 29, 2016 6:36 pm

Re: SK-cPanel-Importer | Restore cPanel Backup on Vesta

Postby skamasle » Thu Apr 06, 2017 7:20 pm

For check, just create database and user, and see if md5= have some md5 string

If you not want problems try orther distro :)

dmitry.vd
Posts: 6
Joined: Wed Apr 05, 2017 10:23 am

Re: SK-cPanel-Importer | Restore cPanel Backup on Vesta

Postby dmitry.vd » Fri Apr 07, 2017 12:33 pm

I created test user, everything fine with database -

DB='test_test' DBUSER='test_test' MD5='*1BF3116A5372A85B80F3769F62A5162B482C00EE' HOST='localhost' TYPE='mysql' CHARSET='UTF8' U_DISK='0' SUSPENDED='no' TIME='15:28:00' DA$.......


and again file size of restored Cpanel user
/usr/local/vesta/data/users/user653/db.conf restored user = 0

skamasle
Collaborator
Posts: 385
Joined: Mon Feb 29, 2016 6:36 pm

Re: SK-cPanel-Importer | Restore cPanel Backup on Vesta

Postby skamasle » Sun Apr 09, 2017 12:08 am

I cant reproduce this yet. I will test with more backups

dpeca
Collaborator
Posts: 239
Joined: Wed Nov 25, 2015 7:30 pm

Re: SK-cPanel-Importer | Restore cPanel Backup on Vesta

Postby dpeca » Sun Apr 09, 2017 3:23 am

Please test scenario where (in cPanel) the same mysql user is used for two databases, or one database has granted to two different mysql users.
I noticed that importer script creates the same database two times in db.conf, and it brakes backup system.


Return to “3rd Party Software”



Who is online

Users browsing this forum: No registered users and 3 guests