your idea is good, but there is a real problem I think. You are gonna dump the WHOLE database at one time. This could crash if
a) the isp has memory restrictions for scripts
b) the isp has time restrictions for script
My table w3t_Posts has 30MB and every time I wanna backup with such a funktion the script dies with an error like "Mysqldump rans out of memory"
So I wrote a recursivly script to do the work and one which do the work for at least one table.
I´ve to make some changes to it and the I share the scripts this weekend.