Segmentation Fault on mysqldump on View

[fred_the_red]

For details, please see http://bugs.mysql.com/bug.php?id=21014.

I noticed this bug immediately after I requested the upgrade to MySQL5 (since the cron job I was using for database backups started failing daily :dopey: ).

I searched the FQ posts and couldn't find any reference to this bug.

The patch that is mentioned in the above link: is this a patch that can be applied independently, or will we have to wait until MySQL 5.1.12 is approved for use at FQ?

[Kevin]

Which mysqldump binary are you using? The ROCKO server has both 4.0.20 and 5.0.27 installed. According to the bug report you referenced >=5.0.25 is already fixed. The default on our servers is currently the 4.0.x version since that is what most of the site owners are using. If you want to run the 5.0.x version (which you should) you need to run /usr/local/mysql5/bin/mysqldump instead.

This was previously discussed in http://www.aota.net/forums/showthread.php?t=22506

[fred_the_red]

I had a feeling I was missing something; I was referencing the wrong mysqldump binary.

Thanks, Kevin!