Gossamer Forum
Home : General : Databases and SQL :

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

Quote Reply
MySQL Error When Migrating to another hosting provider - from MySQL V 3.23.56 to V 5.5.37
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