new server = SQL issues!

I know nothing about mySQL but have fumbled through the support threads and have tried several different methods to resolve my error, although i really don’t understand my issue all that well! Maybe/probably i’m missing something obvious.

I designed my church’s site (faithcommunity.net) while being hosted on my server (ryelidesign.com/clients/FCCWP) and then transfered everything over to the real domain, no problems. the hosts they were using were terribly slow and now i’m transfering the site to a new host.

this is my current error:
[START QUOTE]
Error

SQL query:

— phpMyAdmin SQL Dump
— version 2.6.0-pl3
— https://www.phpmyadmin.net
—
— Host: localhost
— Generation Time: Oct 12, 2006 at 09:17 AM
— Server version: 3.23.58
— PHP Version: 4.3.2
—
— Database: faithc21_wordpress
—
CREATE DATABASE faithc21_wordpress ;

USE faithc21_wordpress;

— ——————————————————–
—
— Table structure for table wp_categories
—
CREATE TABLE wp_categories (
cat_ID bigint( 20 ) NOT NULL AUTO_INCREMENT ,
cat_name varchar( 55 ) NOT NULL default ”,
category_nicename varchar( 200 ) NOT NULL default ”,
category_description longtext NOT NULL ,
category_parent bigint( 20 ) NOT NULL default ‘0’,
category_count bigint( 20 ) NOT NULL default ‘0’,
PRIMARY KEY ( cat_ID ) ,
KEY category_nicename ( category_nicename )
) TYPE = MYISAM AUTO_INCREMENT =14;

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 ‘cat_ID bigint(20) NOT NULL auto_increment,
cat_name` varcha
[END QUOTE]

One concern i have is myphpadmin doesn’t have privlidges to create databases… this was my first error, but i created it manually and seem to have resolved that error.

Any idea why last week i had no problems at all, i followed the instructions and it was fine… this time i’ve been trying different ways for about four hours now with no luck.

I’ve seen over and over people reccomending to manually install everything but not much more information than that… are there detailed instructions on how to manually install if nothing else works?

thank you!