Error while backing up database

N

Nextreme

New member
Joined
Dec 16, 2008
Messages
3
Code: 
User admin has been backed up.
Error while backing up database xxxx1
Error while backing up database xxxx1: Cannot find the sql file after backup was run: /home/admin/admin_backups/xxx/backup/xxxx1.sql
Error while backing up database xxxx2
Error while backing up database xxxx2: Cannot find the sql file after backup was run: /home/admin/admin_backups/xxx/backup/xxxx2.sql
Error while backing up database xxxx3
Error while backing up database xxxx3: Cannot find the sql file after backup was run: /home/admin/admin_backups/xxx/backup/xxxx3.sql

Error Compressing the backup file /home/admin/admin_backups/xxx/backup/home.tar.gz :

I get this error when i'm backing up.

try this:
1) quota checked.

2) /home/tmp exists & chmoded 1777

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

and this

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

but still no solutions.

Can somebody help me?
 
Hi

I have similar problem. I'm getting this message:

Error while backing up database zsres_test
Error while backing up database zsres_test: Cannot find the sql file after backup was run: /home/admin/admin_backups/zsres/backup/zsres_test.sql
Click to expand...

User have no quote limit. Mysql binaries are in /usr/local/mysql/bin/
I had tried manual run of mysqldump and there is no error.

Files are copied and compressed correctly but only the mysql dump file does not exists.

Can someone help me? :)


Update
Above it was an clean instalation of DA. On another server we have exactly the same error after upgrade from 1.334 to 1.335. In 1.334 everything was working fine.
 
Last edited:
Same problem here since the updates today;
- directadmin from 1.334 to 1.335
- custombuild: new phpMyAdmin & Dovecot

Anyone a solution?

Thanx in advance!
 
Same problem here since the updates today;
- directadmin from 1.334 to 1.335
 
Same here, 1.334 to 1.335; we can't stay without backups. Please fix this ASAP.
EDIT: seems like an OS-related problem, Debian 5.0 here.
 
Last edited:
Also same problem here after update to 1.33.5 also Debian 4.

added the damycnf=... to the directadmin.conf file and restarted DA but didnt help.
 
Last edited:
You probably should email directadmin about this instead of simply posting "same here."
 
Hello,

What version of mysql are you using?
The change done in this feature:
http://www.directadmin.com/features.php?id=969

will make the mysqldump use:
--defaults-extra-file=/usr/local/directadmin/conf/my.cnf

so check to see if you have that particular my.cnf file.. and ensure it has the user/password values from the mysql.conf, right next to it. The conf/my.cnf is ovewritten for each call by DA, so no point in trying to edit it.

For debian, a sample call would be
Code: 
/usr/local/mysql/bin/mysqldump --defaults-extra-file=/usr/local/directadmin/conf/my.cnf --host=localhost --add-drop-table --all --extended-insert --quick --quote-names --no-create-db da_roundcube > /tmp/temp.sql 2> /tmp/test.log
which will dump the da_roundcube database to /tmp/temp.sql for testing. See if that throws any errors (check /tmp/test.log for clues)

If the version of mysql you're using doesn't support --default-extra-file, then let me know and I'll have to figure something else out.

John
 
My MySQL version:
mysql Ver 14.12 Distrib 5.0.77, for pc-linux-gnu (i686) using readline 5.1
Click to expand...

I'm using Debian 4.0 64-bit.
The output of your sample call is just empty.

But, at that future page it seems that there is added a line to directadmin.conf, right?
If I look into my directadmin.conf file, it isn't there.

Can I just add next line into "/usr/local/directadmin/conf/directadmin.conf"?
Code: 
damycnf=/usr/local/directadmin/conf/my.cnf

Kris
 
The output to the ssh console should be empty.
The error would be piped to /tmp/test.log and/or /tmp/test.sql.

You do not need to add anything or change anything in regards to your directadmin.conf. The damycnf is an internal default, so it's already there, eg:
cd /usr/local/directadmin
./directadmin c | grep damycnf

John
 
The dump is just working fine, no errors or anything in the log and the test.sql file looks fine, it contains the data of the roundcube as you said.

MySQL: 5.0.77
Debian 4
 
Last edited:
/usr/local/mysql/bin/mysqldump --defaults-extra-file=/usr/local/directadmin/conf/my.cnf --host=localhost --add-drop-table --all --extended-insert --quick --quote-names --no-create-db da_roundcube > /tmp/temp.sql 2> /tmp/test.log
Click to expand...

test.log is empty and da_roundcube database is correctly dumped to temp.sql.
There is no errors.

What version of mysql?
mysql Ver 14.14 Distrib 5.1.33, for pc-linux-gnu (i686) using readline 5.1
 
No errors in test.log
Database correctly dumped to temp.sql.
Output of the grep command:
Code: 
./directadmin c | grep damycnf
damycnf=/usr/local/directadmin/conf/my.cnf
So that's correct.

Mysql version: 5.0.77
Debian: 4.0

I don't know if the things blow matters, but just to inform you:
In directadmin.conf the line says:
mysqlconf=/usr/local/directadmin/conf/mysql.conf

In /usr/local/directadmin/conf directory there is still a mysql.conf present.

Furthermore the my.cnf has the [client] tag, mysql.conf does not.
my.cnf has "password=" and mysql.conf has "passwd=".
Username and pass match though.
 
Last edited:
You must log in or register to reply here.
Back
Top