SQL backup not correct if large Database

TD

Tien Dung Dao July 28, 2018, 3:05 a.m. #1

Hello, I using function daily auto backup in cyberpanel (/usr/local/CyberCP/plogical/backupScheduleLocal.py) but if large database > 100mb script working not correct. It create incomplete sql files

Please help me how to fix this error.

us

usmannasir July 28, 2018, 8:23 a.m. #2

When you run backups please monitor your server via top for htop and see if your server have enough ram to handle this process.

TD

Tien Dung Dao July 28, 2018, 8:51 a.m. #3

When you run backups please monitor your server via top for htop and see if your server have enough ram to handle this process.

Yes, My server have enough ram to handle this process.

us

usmannasir July 28, 2018, 9:28 a.m. #4

Can you describe how it is generating incomplete backups? Do you see anything wrong in CyberPanel log file?

TD

Tien Dung Dao July 28, 2018, 2:25 p.m. #5

Can you describe how it is generating incomplete backups? Do you see anything wrong in CyberPanel log file?

I try backup with python and rclone, If small database it working perfect, but if large database is not enough MB compare to normal backup (hand backup)

No wrong in cyberpanel log file

us

usmannasir July 28, 2018, 8:04 p.m. #6

Can you describe how it is generating incomplete backups? Do you see anything wrong in CyberPanel log file?

I try backup with python and rclone, If small database it working perfect, but if large database is not enough MB compare to normal backup (hand backup)

No wrong in cyberpanel log file

Did you modify the code in any way? How are you incorporating rclone since the official code does not use rclone.

TD

Tien Dung Dao July 29, 2018, 7:24 a.m. #7

Can you describe how it is generating incomplete backups? Do you see anything wrong in CyberPanel log file?

I try backup with python and rclone, If small database it working perfect, but if large database is not enough MB compare to normal backup (hand backup)

No wrong in cyberpanel log file

Did you modify the code in any way? How are you incorporating rclone since the official code does not use rclone.

I create 1 file backup.sh

In this file have script to syn to gg drive

python /usr/local/CyberCP/plogical/backupScheduleLocal.py`


I think official code working not perfect for largn db

us

usmannasir July 29, 2018, 9:24 a.m. #8

I will test with a larger database to see if there are any issues.

TD

Tien Dung Dao July 30, 2018, 3:35 a.m. #9

I will test with a larger database to see if there are any issues.

Okay bro!