Transfer Database to new location raised MySQL Error function already exists
The error suggests that you did run the import for the second time. The function cannot be created because it is already there. You can remove it with

DROP FUNCTION `civicrm_strip_non_numeric`


An alternative is to use the checkbox in phpmyadmin that is labeled add DROP TABLE / VIEW / PROCEDURE / FUNCTION

(To be honest: I am not a phpmyadmin user, I got this suggestion from What does the “Add DROP TABLE / VIEW / PROCEDURE / FUNCTION” checkbox do in phpmyadmin ).