"Migrating Server" page gives conflicting advice, leads to errors

Created by: MegaphoneJon

See here for reference.

In short: The migration guide tells you to install a fresh copy of Civi on the new server, then dump a copy of your old DB while selecting the "Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement" option (in PHPMyAdmin).

This won't work because you'll be dropping tables that have foreign key constraints. That line should be removed from the guide entirely. Optionally, we can tell people to DROP/CREATE the entire Civi db.