mysqldumps never enmds an creates files which fill whole harddisk

[André Bauer]

After Updating mysql-server (with all dependencies) in Ubuntu Dapper from mysql-server_5.0.22-0ubuntu6.06.6_all.deb to mysql-server_5.0.22-0ubuntu6.06.8_all.deb mysqldump does not work properly.

I do a nightly backup of a 4,2 GB database with mysqldump.

After upgrading mysqldump does not end and the created sql backup file fills my whole filesystem (200 GB!).

Small databases dont have this problem. It happens only with the big one.

I use the following command to backup:

mysqldump --opt --allow-keywords -uroot -pPASS -hlocalhost mybigdb > /tmp/mybigdb.sql

[Jamie Strandboge (jdstrand)]

I am not able to reproduce this. I created a database using 5.0.22-0ubuntu6.06.6 then used the above mysqldump command. Then I upgraded to 5.0.22-0ubuntu6.06.8 and used the above dump command and compared the resulting dumps. Only change was the 'Server version'. This was not on a large database though.

1. did mysqldump display any errors? If so, what were they?

2. can you see look in the dump file and see what is possibly causing the problem (eg repeated entries and what entries might have caused it)?

3. what is the output of:
$ dpkg -l|grep mysql

[André Bauer (monotek)]

You´re right. It was a broken table.

It works now with updated mysql version.

Sorry. After updating to the new version yesterday a bug was my first thought.

You can close this bug.

[Mathias Gug (mathiaz)]

 status invalid

--
Mathias Gug
Ubuntu Developer http://www.ubuntu.com