Author Topic: Server never make mysql backup  (Read 499 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Server never make mysql backup
« 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?

Offline
*
Re: Server never make mysql backup
« Reply #1 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
VPS & Dedicated server provider with included FREE Managed support for CWP.
http://www.studio4host.com/

*** Don't allow that your server or website is down, choose hosting provider with included expert managed support for your CWP.

Offline
*
Re: Server never make mysql backup
« Reply #2 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.

Offline
*
Re: Server never make mysql backup
« Reply #3 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


Offline
*
Re: Server never make mysql backup
« Reply #4 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.

Offline
*
Re: Server never make mysql backup
« Reply #5 on: July 14, 2019, 11:10:34 PM »
No problem. I went through the same thing a while back.