Geek Answers Handbook

Mysqldump: Got errno 28 when writing

I get this error even if there is enough space on my disks.

https://sittinginoblivion.com/wiki/backup-failed-mysqldump-got-errno-28-write talks about a problem with disk space.

I use PUTTY and this command to export the database

mysqldump -h [HOST] --port=[PORT] -u [USERNAME] -p [DBNAME] > E:\[FILENAME].sql
+16
source share
4 answers

Something is wrong with the spackler.

Do not use putty, just go to the Windows command prompt, go to the folder where mysql.exe, mysqldump.exe, etc. eat and just type this command.

Remember, never try to take a dump from the MYSQL> command line MYSQL>

C: \ xampp \ mysql \ bin> mysqldump -h [HOST] --port = [PORT] -u [USERNAME] -p [DBNAME]> E: [FILENAME] .sql

Enter password: ------

Worked great !!

0
source

Error message

Backup error: mysqldump: received 28 with write error

Meaning

Not enough disk space to store output.

Decision

Free up disk space. You might want to track down the reason for the lack of disk space.

Source: https://sittinginoblivion.com/wiki/backup-failed-mysqldump-got-errno-28-write

+31
source

I came here with the same problem, a lot of space. Also putty.

I noticed that using the same command, but in a different folder with mod 777 (write to everyone), the space problem disappeared, and the command works successfully.

0
source

I got the same error, but it turned out that there was no memory left to place a new file. It helped to remove unnecessary files to free up space for a new file (* .sql).

PS: You can see the memory consumption by the command: df -h.

-1
source

More articles:


All Articles