sql version error when trying to move db to another host

theconsul · 14.01.2005, 19:59

Hi guys,

have siome problems concerning moving a mambo 4.5.1 site to another host:

at first i downloaded all files and uploaded them to the new host

second i modified the config file

third i want to download all db info and put ik back into the new database on my new host but....

if i do that i get following error..:

Code:

 # --------------------------------------------------------
#
# Tabel structuur voor tabel `mos_components`
#
CREATE TABLE mos_components( id int( 11 ) NOT NULL AUTO_INCREMENT ,
name varchar( 50 ) NOT NULL default '',
link varchar( 255 ) NOT NULL default '',
menuid int( 11 ) unsigned NOT NULL default '0',
parent int( 11 ) unsigned NOT NULL default '0',
admin_menu_link varchar( 255 ) NOT NULL default '',
admin_menu_alt varchar( 255 ) NOT NULL default '',
OPTION varchar( 50 ) NOT NULL default '',
ordering int( 11 ) NOT NULL default '0',
admin_menu_img varchar( 255 ) NOT NULL default '',
iscore tinyint( 4 ) NOT NULL default '0',
params text NOT NULL ,
PRIMARY KEY ( id ) ) TYPE = MYISAM

Code:

 MySQL retourneerde:  
 
#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 'option varchar(50) NOT NULL default '',
ordering int(11) NOT

still the system uploaded allready 18 tables like mos_banner

what can i do to fix it?

Many thx

Tc (Roger)

bvsweeney · 15.01.2005, 14:10

I ran into the same problem last week. I was debugging down all kinds of bizarre errors until I found a post that mentioned a utility called BIGDUMP (no joke

). The DB import was breeze after that and all of my bizarro errors disappeared.

theconsul · 16.01.2005, 09:57

i used bigdump, thx for that but..;

the system says that it went ok...still cannot connect to database and this is what i get: http://www.plotsandprojects.com/

germes · 16.01.2005, 16:47

Hi,
in CREATE TABLE the field that has the same name as mysql keywords must be quoted. you have field - ordering - it is key word. use `ordering`.
Thats all,
best regards.

theconsul · 16.01.2005, 19:02

Quote:

Originally Posted by germes

Hi,
in CREATE TABLE the field that has the same name as mysql keywords must be quoted. you have field - ordering - it is key word. use `ordering`.
Thats all,
best regards.

the quotes did the job

thx