backup problem

uvhost

Verified User
Joined
Mar 26, 2006
Messages
40
Location
UK
Hi,

While trying to backup my server to external server, DA is not able to backup databases and i get errors like this:

Code:
User admin has been backed up. <19:38:47>
Error while backing up database ehost_bles472
Error while backing up database ehost_bles472: The sql file is 0 bytes in size: /home/tmp/admin.15006/ehost/backup/ehost_bles472.sql
mysqldump error output: /usr/bin/mysqldump: unknown variable 'local-infile=0'
any idea how can i solve this issue?
 

ditto

Verified User
Joined
Apr 27, 2009
Messages
2,538
You need to edit /etc/my.cnf and move local-infile=0 AFTER [mysqld] - if your my.cnf file does not have the line [mysqld], then you should create [mysqld] right above local-infile=0

It other words, local-infile=0 needs to be below [mysqld] in my.cnf
 
Top