Moving to a New Server

I’m moving wordpress to a new web hosting provider. The url and blog location will remain the same. However, the database name will change. I have followed these instructions: https://www.tamba2.org.uk/wordpress/restore/ and I’m getting this error:
[code]
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- https://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 09, 2006 at 12:47 AM
-- Server version: 4.1.14
-- PHP Version: 4.3.11
--
-- Database: wordpre_wrdp1
--
-- --------------------------------------------------------
--
-- Table structure for table wieonline
--
DROP TABLE IF EXISTS wieonline

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- https://www.phpmyadmin.net
--
' at line 1
[/code]

I chose to upload the sql file (it is 1.22 MB). I did change the information inside of this sql file to reflect the new database name. I have gone to the php site to look for help but was not able to find an answer that matched my situation.

I have made the appropriate backups. I dropped the databases as instructed before uploading the new sql database.

When I made the db backup should I have unchecked “Use hexadecimal for binary fields”. I followed the Codex instructions for backing up the database but that option was not in the instructions.

Please assist as I need to move this database over today before midnight.

All help is greatly appreciated. Thank you.