Backup and restore

Thanks, I found it a bit odd that the "root" login to MySql had restrictions on permissions, but you were exactly right.  In my case it certainly was a privileged account but did not have the "create temporary table" permission which had to be granted by the ISP's support function.