Control Web Panel
WebPanel => Backup => Topic started by: g4m3r on October 27, 2016, 07:14:07 PM
-
Hello,
i've got a problem with my remote backups.
(https://i.imgur.com/LP6pXoP.png)
My settings are ok. The connection is ok.
The folder structure will be created on my backup vps, but no files will be synced (cwp_remote/mysql/daily, not more).
Here is a log I got from the daily cron.
====================================================
============= CentOS Web Panel Cron ================
====================================================
###########################
Firewall Flush Daily Blocks
###########################
######################
Update Server Packages
######################
Your CWP version: 0.9.8.71
No update needed, your CWP is up to date.
************
Date which backup script is using: 2016-10-27 19:07:04
###############################################
Remote Daily Files Backup starting
###############################################
Username: a
========================================
Username: b
========================================
Username: c
========================================
Username: d
========================================
Username: r
========================================
Username: f
========================================
Username: g
========================================
###############################################
Remote Daily Files Backup finished
###############################################
###############################################
Remote Daily MySQL Backup starting
###############################################
Skipping database: information_schema.
Database Backup: a --> a.sql
Database Backup: b --> b.sql
Database Backup: c --> c.sql
Skipping database: mysql.
Database Backup: performance_schema --> performance_schema.sql
Database Backup: postfix --> postfix.sql
Database Backup: d --> d.sql
Database Backup: root_cwp --> root_cwp.sql
Database Backup: roundcube --> roundcube.sql
Database Backup: r --> r.sql
Database Backup: f --> f.sql
###############################################
Remote Daily MySQL Backup finished
###############################################
Regards
-
Not working for me either. I have everything set correct ran /etc/cron.daily/cwp
<img src="http://imgur.com/0Kcfkpi />
No backups inside backups folder!!
====================================================
============= CentOS Web Panel Cron ================
====================================================
###########################
Firewall Flush Daily Blocks
###########################
######################
Update Server Packages
######################
Your CWP version: 0.9.8.248
No update needed, your CWP is up to date.
111.222.333.444--2017-02-20 13:59:59-- http://dl1.centos-webpanel.com/files/apache/mod-security/comodo_waf.zip
Resolving dl1.centos-webpanel.com (dl1.centos-webpanel.com)... 37.187.72.216
Connecting to dl1.centos-webpanel.com (dl1.centos-webpanel.com)|37.187.72.216|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 264737 (259K) [application/zip]
Saving to: ‘comodo_waf.zip’
100%[======================================>] 264,737 --.-K/s in 0.07s
2017-02-20 13:59:59 (3.81 MB/s) - ‘comodo_waf.zip’ saved [264737/264737]
Redirecting to /bin/systemctl reload httpd.service
Date which backup script is using: 2017-02-20 13:59:59
###############################################
Remote Daily Files Backup starting
###############################################
Username: grimg
========================================
sending incremental file list
sent 355328 bytes received 1556 bytes 101966.86 bytes/sec
total size is 290477439 speedup is 813.93
Username: loumacco
========================================
sending incremental file list
sent 218 bytes received 14 bytes 92.80 bytes/sec
total size is 5552 speedup is 23.93
Username: healingn
========================================
sending incremental file list
sent 60193 bytes received 352 bytes 40363.33 bytes/sec
total size is 74396665 speedup is 1228.78
Username: familyenterprise
========================================
sending incremental file list
sent 1385 bytes received 22 bytes 938.00 bytes/sec
total size is 2020367 speedup is 1435.94
Username: lillybobsjewelle
========================================
sending incremental file list
sent 161403 bytes received 655 bytes 64823.20 bytes/sec
total size is 119374936 speedup is 736.62
Username: loumacme
========================================
sending incremental file list
sent 418190 bytes received 2084 bytes 120078.29 bytes/sec
total size is 321894172 speedup is 765.92
Username: scioltic
========================================
sending incremental file list
public_html/system/storage/cache/
deleting public_html/system/storage/cache/cache.product.latest.1.0.1.0.1487602374
public_html/system/storage/cache/cache.product.latest.1.0.1.0.1487602593
sent 250312 bytes received 958 bytes 71791.43 bytes/sec
total size is 272033109 speedup is 1082.63
###############################################
Remote Daily Files Backup finished
###############################################
###############################################
Remote Daily MySQL Backup starting
###############################################
Database Backup: grimg_site --> grimg_site.sql
sending incremental file list
grimg_site.sql
sent 327 bytes received 1045 bytes 548.80 bytes/sec
total size is 118286 speedup is 86.21
Database Backup: grimg_wp1 --> grimg_wp1.sql
sending incremental file list
grimg_wp1.sql
sent 463 bytes received 16489 bytes 6780.80 bytes/sec
total size is 7504785 speedup is 442.71
Database Backup: healingn_site --> healingn_site.sql
sending incremental file list
healingn_site.sql
sent 100 bytes received 1501 bytes 1067.33 bytes/sec
total size is 170811 speedup is 106.69
Skipping database: information_schema.
Database Backup: lillybob_site --> lillybob_site.sql
sending incremental file list
lillybob_site.sql
sent 296 bytes received 5563 bytes 2343.60 bytes/sec
total size is 840606 speedup is 143.47
Database Backup: loumacme_clients --> loumacme_clients.sql
sending incremental file list
loumacme_clients.sql
sent 420 bytes received 12265 bytes 8456.67 bytes/sec
total size is 4126098 speedup is 325.27
Database Backup: loumacme_site --> loumacme_site.sql
sending incremental file list
loumacme_site.sql
sent 408 bytes received 15187 bytes 6238.00 bytes/sec
total size is 6343884 speedup is 406.79
Skipping database: mysql.
mysqldump: Got error: 1142: "SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'accounts'" when using LOCK TABLES
Database Backup: performance_schema --> performance_schema.sql
sending incremental file list
performance_schema.sql
sent 90 bytes received 43 bytes 53.20 bytes/sec
total size is 797 speedup is 5.99
Database Backup: postfix --> postfix.sql
sending incremental file list
postfix.sql
sent 251 bytes received 175 bytes 284.00 bytes/sec
total size is 16157 speedup is 37.93
Database Backup: root_cwp --> root_cwp.sql
sending incremental file list
root_cwp.sql
sent 327 bytes received 145 bytes 314.67 bytes/sec
total size is 12842 speedup is 27.21
Database Backup: roundcube --> roundcube.sql
sending incremental file list
roundcube.sql
sent 94 bytes received 415 bytes 339.33 bytes/sec
total size is 44119 speedup is 86.68
Database Backup: scioltic_site --> scioltic_site.sql
sending incremental file list
scioltic_site.sql
sent 321 bytes received 6349 bytes 2668.00 bytes/sec
total size is 1094722 speedup is 164.13
Database Backup: scioltic_site15 --> scioltic_site15.sql
sending incremental file list
scioltic_site15.sql
sent 298 bytes received 9733 bytes 4012.40 bytes/sec
total size is 2612105 speedup is 260.40
Database Backup: scioltic_site16 --> scioltic_site16.sql
sending incremental file list
scioltic_site16.sql
sent 483 bytes received 11089 bytes 4628.80 bytes/sec
total size is 3389283 speedup is 292.89
###############################################
Remote Daily MySQL Backup finished
###############################################
-
Really need backups to work can anyone help?
-
contact support for more investigations
-
Someone get the solution..??!!
I'm having the problem:
(...)
Database Backup: mysql --> /backup/mysql/daily//mysql.sql
mysqldump: Got error: 1142: "SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'accounts'" when using LOCK TABLES
(...)
Regards,
Netino
-
contact support for more investigations
?!