Results 1 to 2 of 2

Thread: backup problem

  1. #1
    Join Date
    Mar 2006
    Location
    UK
    Posts
    30

    backup problem

    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?

  2. #2
    Join Date
    Apr 2009
    Posts
    2,441
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •