Here is the problem I am having. All I have is the backed up files from the original UBB Threads Infopop board. I am trying to restore that file to a live DB but I get the following error.
This happens when I try to restore that backup file into a live DB so that I can then use IMPEX to move it to VBULLETIN. What am I doing wrong? Help.
Code:
[B]Error[/B] SQL-query : [B][COLOR=#990099]CREATE[/COLOR][/B] [B][COLOR=#990099]TABLE[/COLOR][/B] [COLOR=#008000]`w3t_AddressBook`[/COLOR] [COLOR=#ff00ff]([/COLOR] [COLOR=#008000]`Add_Owner`[/COLOR] [COLOR=#ff9900]int[/COLOR][COLOR=#ff00ff]([/COLOR] [COLOR=#008080]9[/COLOR] [COLOR=#ff00ff])[/COLOR] [COLOR=#0000ff]unsigned[/COLOR] [B][COLOR=#990099]NOT[/COLOR][/B] [B][COLOR=#990099]NULL[/COLOR][/B] [COLOR=#0000ff]default[/COLOR] [COLOR=#008000]'0'[/COLOR][COLOR=#ff00ff], [/COLOR][COLOR=#008000]`Add_Member`[/COLOR] [COLOR=#ff9900]int[/COLOR][COLOR=#ff00ff]([/COLOR] [COLOR=#008080]9[/COLOR] [COLOR=#ff00ff])[/COLOR] [COLOR=#0000ff]unsigned[/COLOR] [COLOR=#0000ff]default[/COLOR] [B][COLOR=#990099]NULL[/COLOR][/B] [COLOR=#ff00ff], [/COLOR][B][COLOR=#990099]KEY[/COLOR][/B] [COLOR=#008000]`address_ndx1`[/COLOR] [COLOR=#ff00ff]([/COLOR] [COLOR=#008000]`Add_Owner`[/COLOR] [COLOR=#ff00ff])[/COLOR] [COLOR=#ff00ff])[/COLOR]ENGINE [COLOR=#ff00ff]=[/COLOR] [COLOR=#0000ff]InnoDB[/COLOR] [COLOR=#0000ff]DEFAULT[/COLOR]CHARSET [COLOR=#ff00ff]=[/COLOR] latin1 MySQL said: 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 'ENGINE=InnoDB DEFAULT CHARSET=latin1' at line 5
Comment