Backup problems

[Mitch]

Hi There,

I have a few questions and I don't know how to solve them:

1. Could not preserve times for admin.root.admin.tar.gz: UTIME failed.

2. /bin/tar: domains/domain.com/app/cache/prod/sessions/sess_19b5g73uaya7d8d2o6ombfccb2: Cannot open: Permission denied
Got a lot more of the permission denied.

3.
Error while backing up database name_new
Error while backing up database name_new: The sql file is 0 bytes in size: /home/tmp/admin/name/backup/name_new.sql
mysqldump error output: mysqldump: unknown variable 'local-infile=0'

This error with databases are also for all the users the same error.


I hope somebody can help me out.


Regards Mitch

 

[nobaloney]

I hope somebody can help me out.

Hopefully a bit of help:

1. Could not preserve times for admin.root.admin.tar.gz: UTIME failed.

Are you running in a VPS environment? What OS are you running? If your environment doesn't support UTIME then you won't have it.

Here's what the man page says:

The utime() system call changes the access and modification times of the inode specified by filename to the actime and modtime fields of times respectively.

But some OS eenvironments may not offer it.

2. /bin/tar: domains/domain.com/app/cache/prod/sessions/sess_19b5g73uaya7d8d2o6ombfccb2: Cannot open: Permission denied
Got a lot more of the permission denied.

Who owns these files? They should be owned by the same user whom you're backing up.

3.
Error while backing up database name_new
Error while backing up database name_new: The sql file is 0 bytes in size: /home/tmp/admin/name/backup/name_new.sql
mysqldump error output: mysqldump: unknown variable 'local-infile=0'

This error with databases are also for all the users the same error.

Likely the master MySQL password has been changed and DirectAdmin doesn't have access to the MySQL databases for backup.

Jeff

 

[zEitEr]

mysqldump error output: mysqldump: unknown variable 'local-infile=0'

I'd rather guess that local-infile=0 is located by a mistake in a wrong section, or even at the very bottom of the file (probably [mysqldump] section). But it should be located under [mysqld] section.

http://help.directadmin.com/item.php?id=208

 

[Mitch]

Are you running in a VPS environment? What OS are you running? If your environment doesn't support UTIME then you won't have it.

CentOS release 6.5 (Final)

Who owns these files? They should be owned by the same user whom you're backing up.

Well, I guess the admin does the backups and not the user by there self?

Likely the master MySQL password has been changed and DirectAdmin doesn't have access to the MySQL databases for backup.

I have checked the DirectAdmin config (/usr/local/directadmin/conf/mysql.conf) and tried to login with the users and that works, If I do 'show databases;' I see all the databases, so that user has access.

About the local-infile,

cat /etc/my.cnf
[client]
local-infile=0

[mysqld]
bind-address = 127.0.0.1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

 

[smtalk]

Please move "local-infile=0" below "[mysqld]" and restart MySQL.