Admin Backup/Transfer mysqldump error
- Thread starter jirawat
- Start date
nobaloney
NoBaloney Internet Svcs - In Memoriam †
It's telling you that the sql file is 0 bytes in size. So it can't back it up.
If the database is unused, then 0 bytes in size, and not being able to back it up is fine.
If the database has been used and should be full of data, but isn't, you'd have to have a backup from somewhere else to use, because the current file contains no data.
Jeff
If the database is unused, then 0 bytes in size, and not being able to back it up is fine.
If the database has been used and should be full of data, but isn't, you'd have to have a backup from somewhere else to use, because the current file contains no data.
Jeff
tillo
Verified User
Sometimes concurrent stdout and stderr is not synchronized, leading to wrong assumptions; my guess is that the "Access denied" error is the cause for the sql file to be of 0 bytes, and this is easily understandable: for a couple of versions DA has introduced a new dependency: the file /usr/local/directadmin/conf/my.cnf must contain those lines:
My guess is that you don't have it.
If you do a copy/paste from the mysql.conf file, make sure you modify "passwd" with "password".
http://www.directadmin.com/features.php?id=969
Code:
[client]
user=da_admin
password=<same password as in /usr/local/directadmin/conf/mysql.conf>If you do a copy/paste from the mysql.conf file, make sure you modify "passwd" with "password".
http://www.directadmin.com/features.php?id=969
Last edited:
Thank you for your reply.
Actually, a file /usr/local/directadmin/conf/my.cnf already exist.
I'm notice why DA using root to backup database?
So I edit file /root/.my.cnf then try to backup again and no error now.
I move /root/.my.cnf to /root/my.cnf.bak and backup again, then I go back to Message System I found Your backups are now ready without error.
I guess DA read /root/.my.cnf first, if /root/.my.cnf is not exist then read /usr/local/directadmin/conf/mysql.conf
P.S. My DA v1.33.7
Actually, a file /usr/local/directadmin/conf/my.cnf already exist.
I'm notice why DA using root to backup database?
So I edit file /root/.my.cnf then try to backup again and no error now.
I move /root/.my.cnf to /root/my.cnf.bak and backup again, then I go back to Message System I found Your backups are now ready without error.
I guess DA read /root/.my.cnf first, if /root/.my.cnf is not exist then read /usr/local/directadmin/conf/mysql.conf
P.S. My DA v1.33.7
- Joined
- Feb 27, 2003
- Messages
- 9,158
I see this from time to time where admins create:
with user/pass values set in there. This overrides everything and is very good at creating a lot of confusion and breaking things. Delete /root/.my.cnf if you have it.
This is related for when we added the feature:
http://www.directadmin.com/features.php?id=969
It uses the --defaults-extra-file option, which means it still accepts other my.cnf data in case you have custom settings you need.
John
Code:
/root/.my.cnfThis is related for when we added the feature:
http://www.directadmin.com/features.php?id=969
It uses the --defaults-extra-file option, which means it still accepts other my.cnf data in case you have custom settings you need.
John