import SQL file problems
Posted: Wed Jul 27, 2005 6:17 am
Im trying to import my vBulletin database from my local server to my hosting provider server
When i try to import it from the command line i get the following error
ERROR 1064 at 13: 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 'DEFAULT CHARSET=latin1' at line 10
Line 13 is in the code beolow is:
When i import this on my local machine, it works no problem but not with my hosting provider
Any ideas?!
When i try to import it from the command line i get the following error
ERROR 1064 at 13: 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 'DEFAULT CHARSET=latin1' at line 10
Line 13 is in the code beolow is:
Code: Select all
CREATE TABLE adminhelp (Code: Select all
DROP TABLE IF EXISTS access;
CREATE TABLE access (
userid int(10) unsigned NOT NULL default '0',
forumid smallint(5) unsigned NOT NULL default '0',
accessmask smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (userid,forumid)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS adminhelp;
CREATE TABLE adminhelp (
adminhelpid int(10) unsigned NOT NULL auto_increment,
script varchar(50) NOT NULL default '',
action varchar(25) NOT NULL default '',
optionname varchar(25) NOT NULL default '',
displayorder smallint(5) unsigned NOT NULL default '1',
volatile smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (adminhelpid),
UNIQUE KEY phraseunique (script,action,optionname)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;Any ideas?!