database backup like phpMyAdmin

[eluser]skunkbad[/eluser]
Maybe I haven't looked in the right place, or just haven't found what I am looking for. I'd like to have complete database backup made in standard sql format. Click a button, download the sql file. Yes, I could do this in phpMyAdmin, but I want the other users (the site owners) to be able to do their own backups.

I saw a solution that uses SELECT into $filename, and wondering if this is the best way to get started.