Control Web Panel

WebPanel => Backup => Topic started by: Mak3000 on July 14, 2019, 12:14:20 PM

Title: Server never make mysql backup
Post by: Mak3000 on July 14, 2019, 12:14:20 PM
Hi all,

I've a fresh VPS that is hosting 3 simple sites, I decided to use CWP, I really like it, But I faced some issues,

The current issue is backup, The daily backup, in mysql directory, all db are 0 Bytes!! although the main site db is more than 400MB.

I tried to make a full backup from user panel, I got the same issue, db file is 0 Byte.

Any solution for that issue?
Title: Re: Server never make mysql backup
Post by: studio4host on July 14, 2019, 04:00:26 PM
cwp is using mysqldump so you can try first manually to see if it is working

http://wiki.centos-webpanel.com/import-export-mysql-database
Title: Re: Server never make mysql backup
Post by: Mak3000 on July 14, 2019, 05:07:20 PM
cwp is using mysqldump so you can try first manually to see if it is working

http://wiki.centos-webpanel.com/import-export-mysql-database

I tried it manually and got that error "mysqldump: unknown variable 'local-infile=0'", After removing this line "local-infile=0" from my.cnf, it done successfully.

Thanks for help.
Title: Re: Server never make mysql backup
Post by: Rug3r on July 14, 2019, 05:17:37 PM
cwp is using mysqldump so you can try first manually to see if it is working

http://wiki.centos-webpanel.com/import-export-mysql-database

I tried it manually and got that error "mysqldump: unknown variable 'local-infile=0'", After removing this line "local-infile=0" from my.cnf, it done successfully.

Thanks for help.

Do you have [mysqld] along with local-infile=0? It should look like the following in your etc/my.cnf file:

[mysqld]
local-infile=0

Title: Re: Server never make mysql backup
Post by: Mak3000 on July 14, 2019, 05:31:05 PM
cwp is using mysqldump so you can try first manually to see if it is working

http://wiki.centos-webpanel.com/import-export-mysql-database

I tried it manually and got that error "mysqldump: unknown variable 'local-infile=0'", After removing this line "local-infile=0" from my.cnf, it done successfully.

Thanks for help.

Do you have [mysqld] along with local-infile=0? It should look like the following in your etc/my.cnf file:

[mysqld]
local-infile=0

You are right, [mysqld] was missing, after adding it as you mentioned, also mysqldump worked fine.
Thank you.
Title: Re: Server never make mysql backup
Post by: Rug3r on July 14, 2019, 11:10:34 PM
No problem. I went through the same thing a while back.
Title: Re: Server never make mysql backup
Post by: sun on April 02, 2020, 03:40:19 PM
cwp is using mysqldump so you can try first manually to see if it is working

http://wiki.centos-webpanel.com/import-export-mysql-database

I tried it manually and got that error "mysqldump: unknown variable 'local-infile=0'", After removing this line "local-infile=0" from my.cnf, it done successfully.

Thanks for help.

Do you have [mysqld] along with local-infile=0? It should look like the following in your etc/my.cnf file:

[mysqld]
local-infile=0

You are right, [mysqld] was missing, after adding it as you mentioned, also mysqldump worked fine.
Thank you.

Thank you! (i had the same problem)