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

Section with additional software for Vesta
skamasle
Collaborator
Posts: 360
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: 360
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: 360
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: 360
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: 360
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: 227
Joined: Wed Nov 25, 2015 7:30 pm
Location: Serbia

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 1 guest