Author Topic: Remote backup not working  (Read 14409 times)

0 Members and 3 Guests are viewing this topic.

Offline
*
Remote backup not working
« on: October 27, 2016, 07:14:07 PM »
Hello,
i've got a problem with my remote backups.


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.

Code: [Select]
====================================================
============= 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
« Last Edit: October 27, 2016, 07:17:00 PM by g4m3r »

Offline
*
Re: Remote backup not working
« Reply #1 on: February 20, 2017, 02:13:16 PM »
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!!

Code: [Select]
====================================================
============= 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
###############################################
« Last Edit: February 20, 2017, 02:19:21 PM by n1kko »

Offline
*
Re: Remote backup not working
« Reply #2 on: February 24, 2017, 01:37:31 PM »
Really need backups to work can anyone help?

Offline
*****
Re: Remote backup not working
« Reply #3 on: February 25, 2017, 07:52:32 AM »
contact support for more investigations

Offline
***
Re: Remote backup not working
« Reply #4 on: July 08, 2017, 05:45:54 PM »
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

Offline
*
Re: Remote backup not working
« Reply #5 on: September 03, 2018, 09:17:33 PM »
contact support for more investigations

?!