Error while backing up database xxxxx

[cagriekin]

Hi,

i'm getting this error while backup. same error @ user lvl, reseller lvl, admin lvl ..

mysql server : 5.0.21
os : debian 3.1
da: 1.27.1

da_admin user set correctly, mysql socket file set correctly at DA mysql.conf ..

anyone has an idea ? i love directadmin but error messages suck..

 

[DirectAdmin Support]

Hello,

1) Make sure there is quota space left under that user:
quota -v username

2) If using a remote ftp backup, make sure that:
/home/tmp
exists and is chmod 1777 (chmod 1777 /home/tmp)

3) Try dumping it manually with mysqldump:

/usr/local/mysql/bin/mysqldump -uda_admin -p[b]pass[/b] --host=localhost --add-drop-table --all --extended-insert --quick --quote-names --no-create-db [b]databasename[/b] > /path/file.sql

What I've seen happens is people install mysql/mysqldump in different locations such that DA can't find it.

If you've moved mysqldump, make sure you create a symbolic link to /usr/local/mysql/bin/mysqldump so that DA can find it.

Debian: /usr/local/mysql/bin/mysqldump
FreeBSD: /usr/local/mysql/bin/mysqldump
Everything Else: /usr/bin/mysqldump

John

 

[cagriekin]

1) quata checked.

2) /home/tmp exists & chmoded 1777

3) all mysql binaries have links at /usr/local/bin/

problem still exists

 

[chatwizrd]

Here is what I did to fix mine.

mkdir /usr/local/mysql
mkdir /usr/local/mysql/bin
ln -s /usr/local/bin/mysqldump /usr/local/mysql/bin/mysqldump

 

[oldsparky]

[..]

If you've moved mysqldump, make sure you create a symbolic link to /usr/local/mysql/bin/mysqldump so that DA can find it.

Debian: /usr/local/mysql/bin/mysqldump
FreeBSD: /usr/local/mysql/bin/mysqldump
Everything Else: /usr/bin/mysqldump

John [/B]

Thanks, it help me. But is it not possible to catch mysqldump bin with a which function or a config param?