An error occurred during the backup (id=2)

[hungle]

Dear everyone,

Sorry my English, I used Admin backup/transfer on Admin Tools and everything was ok until I changed da_admin password and I downloaded the backup, it created the username.sql files, but they were zero bytes. Even though there was plenty of data in the databases. I researched and found the same case as me on your forum

database backup feature won't work

Hi, The database part of the site backup feature isn't working on the server I'm on at ProWebSpace. When you download the backup, it creates the username_database.sql files, but they're zero bytes big. I know that there's plenty of data in the databases too. It's the same on 3 of their...

forum.directadmin.com

Got error: 1045: Access denied for user 'root

hello this is my problem when I full backup , this error looks Error while backing up database tunak_db Error while backing up database tunak_db: The sql file is 0 bytes in size: /home/tunak/backups/backup/ifede_db.sql mysqldump error output: mysqldump: Got error: 1045: Access denied for user...

forum.directadmin.com

Unfortunately, it didn't work for me so please help me sir. I can login mysql normal and I backup manually by command line: "mysqldump -u da_admin -p" is fine.

My logs:


The ways that I have been tried to fixed:
1. Find /root/my.cnf to delete
=> Not solved because nothing there
2. mysqlcheck -uda_admin -p`grep "^passwd=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2` --auto-repair --optimize --all-databases
=> Nothing changed
3. changing my da password, and then changing it back again
=> Still not worked

*note: my version is MySQL 5.7

I really do appreciate your help.

Thanks & regards,
Hung Le

 

[Ohm J]

normally Directadmin use authentication from /usr/local/directadmin/conf/

there have 2 find in this folder that store mysql auth, like my.cnf and mysql.conf

Version 1.61.4 | Directadmin Docs

DirectAdmin Knowledge Base

www.directadmin.com

 

[hungle]

normally Directadmin use authentication from /usr/local/directadmin/conf/

there have 2 find in this folder that store mysql auth, like my.cnf and mysql.conf

Version 1.61.4 | Directadmin Docs

DirectAdmin Knowledge Base

www.directadmin.com

Yes sir, I have already updated my.cnf, mysql.conf in path /usr/local/directadmin/conf and I can access Mysql with the new password. But running the backup tool failed.

 

[hungle]

Hi there,

Anyone can help me, please ?

Thanks & regards,
Hung Le

 

[Ohm J]

what's happend before you got this problem ?

Create Account or Domain from web panel is working normally ?

I think you have problem with some file in directadmin/conf/my.cnf or mysql.conf

try remove contain in that 2 file and use script to reset password with contain only " A-Za-z0-9 " and check it that can work again

 

[hungle]

what's happend before you got this problem ?

Create Account or Domain from web panel is working normally ?

I think you have problem with some file in directadmin/conf/my.cnf or mysql.conf

try remove contain in that 2 file and use script to reset password

Thanks for your help ! I solved my problem because my password has special character '@'