OK. I have WordPress, and I’m trying to restore my database, errors including

I’m trying to upgrade my WordPress installation on my personal website at http://www.scotrick.com, and http://www.machighway.com needed me to upgrade to a new server so that I could upgrade my earlier version of WordPress to the latest version, because, according to them, only their newest servers had the required versions of MySQL.

So, I started the process, following both instructions on http://www.machighway.com, and the WordPress backup and restore sites.

Whichever directions I follow, I get the errors below when I try to restore my database from the backup I’ve made.

And because I’m not sure what do once I’ve restored the database, I’m not sure how critical this error is, all I know is that when I go to my website, my former blog is certainly not there.

HELP!

Error

SQL query:

— phpMyAdmin SQL Dump
— version 2.6.0-pl3
— http://www.phpmyadmin.net
—
— Host: localhost
— Generation Time: Jan 30, 2010 at 09:50 AM
— Server version: 4.0.23
— PHP Version: 4.3.11
—
— Database: scotrick_db
—
CREATE DATABASE scotrick_db ;

USE scotrick_db;

— ——————————————————–
—
— Table structure for table g2_AccessMap
—
DROP TABLE IF EXISTS g2_AccessMap ;

CREATE TABLE g2_AccessMap (
g_accessListId int( 11 ) NOT NULL default ‘0’,
g_userOrGroupId int( 11 ) NOT NULL default ‘0’,
g_permission int( 11 ) NOT NULL default ‘0’,
PRIMARY KEY ( g_accessListId , g_userOrGroupId ) ,
KEY g2_AccessMap_83732 ( g_accessListId ) ,
KEY g2_AccessMap_48775 ( g_userOrGroupId ) ,
KEY g2_AccessMap_18058 ( g_permission )
) TYPE = MYISAM ;

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 ‘g_accessListId int(11) NOT NULL default ‘0’,
g_userOrGroupId int(11) NOT N’ at line 1