Gossamer Forum: General: Databases and SQL: MySQL Error When Migrating to another hosting provider

Greetings,
I am having real trouble when attempting to move my site from one hosting company to another.
I am running GL Links with current hosting company who I still have MySQL Version: 3.23.56.
I am trying to migrate to a new hosting company but their MySQL Version is: 5.5.37.
I followed the this URL to convert the backup file from 3.23 to 5.5:
http://hisdeedsaredust.com/...sion-3-to-version-5/
I also changed TYPE=MyISM to ENGINE=MyISM as some sites recommended.

Now, when I use mysql command to restore the backup (filtered) file into the new database with the new hosting company, I get the following error.. whether I do it from the command prompt, or whether I do it in the new PHPMYADMIN import command (with Comparability 3.23 is selected during the import)

Code:
CREATE TABLE glinks_Category (
  ID int(10) unsigned NOT NULL auto_increment,
  Name varchar(255) NOT NULL default '',
  FatherID int(10) unsigned NOT NULL default '0',
  CatRoot int(10) unsigned NOT NULL default '0',
  CatDepth int(10) unsigned NOT NULL default '0',
  Full_Name varchar(255) NOT NULL default '',
  Description longtext,
  Meta_Description longtext,
  Meta_Keywords longtext,
  Header longtext,
  Footer longtext,
  Category_Template varchar(28) default NULL,
  Number_of_Links int(11) NOT NULL default '0',
  Direct_Links int(11) NOT NULL default '0',
  Has_New_Links enum('No','Yes') NOT NULL default 'No',
  Has_Changed_Links enum('No','Yes') NOT NULL default 'No',
  Newest_Link date default NULL,
  Timestmp timestamp(14) NOT NULL,
  Payment_Mode tinyint(4) NOT NULL default '0',
  Payment_Description longtext,
  Template varchar(75) default 'category.html',
  category_title varchar(40) default NULL,
  Category_Sort int(11) default NULL,
  Nonenglis[..]

=========================
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 '(14) NOT NULL,
Payment_Mode tinyint(4) NOT NULL default '0',
Payment_Descr' at line 19

=========================

When I edit the database backup file and go to the above area to see what is wrong, I see the following:

Code:
CREATE TABLE glinks_Category (
  ID int(10) unsigned NOT NULL auto_increment,
  Name varchar(255) NOT NULL default '',
  FatherID int(10) unsigned NOT NULL default '0',
  CatRoot int(10) unsigned NOT NULL default '0',
  CatDepth int(10) unsigned NOT NULL default '0',
  Full_Name varchar(255) NOT NULL default '',
  Description longtext,
  Meta_Description longtext,
  Meta_Keywords longtext,
  Header longtext,
  Footer longtext,
  Category_Template varchar(28) default NULL,
  Number_of_Links int(11) NOT NULL default '0',
  Direct_Links int(11) NOT NULL default '0',
  Has_New_Links enum('No','Yes') NOT NULL default 'No',
  Has_Changed_Links enum('No','Yes') NOT NULL default 'No',
  Newest_Link date default NULL,
  Timestmp timestamp(14) NOT NULL,
  Payment_Mode tinyint(4) NOT NULL default '0',
  Payment_Description longtext,
  Template varchar(75) default 'category.html',
  category_title varchar(40) default NULL,
  Category_Sort int(11) default NULL,
  Nonenglish varchar(75) default NULL,
  Image varchar(60) default '/flags/ball.gif',
  PRIMARY KEY  (ID),
  KEY c_p (Payment_Mode),
  KEY fthrindex (FatherID),
  KEY namndx (Full_Name),
  KEY rootndx (CatRoot),
  KEY catndx (Name)
) ENGINE=MyISAM;
 

--
-- Dumping data for table 'glinks_Category'
--
 

 

LOCK TABLES glinks_Category WRITE;
@                                                                                                                            @
=======================================

What do I need to modify in order to have a successful move to version 5.5 with my new hosting company?

Thank you in advance for your help
Mark

Subject	Author	Views	Date
MySQL Error When Migrating to another hosting provider - from MySQL V 3.23.56 to V 5.5.37	Mark2	11357	Oct 14, 2014, 8:50 PM

MySQL Error When Migrating to another hosting provider - from MySQL V 3.23.56 to V 5.5.37