Ok, I think this error occurred because I thought the instructions for moving to a new provider (see above) meant that in this command:
shell> mysql database < dump_file.sql
"database" should be the name of the database you created in the fresh install. I think instead, after creating the new install, the dump file should be sent to a blank database, and the siteaccesses should then point to the new database as well.
