i want move website built in joomla 3.5.1 new server. bought domain/space @ new server , backed database/files old one.
i transferred files via ftp new server , opened phpmyadmin import .sql file. thing after it's uploaded, following error:
sql query:
create table `jos_assets` ( `id` int(10) unsigned not null comment 'primary key', `parent_id` int(11) not null default '0'comment `nested set parent.`, `lft` int(11) not null default '0'comment `nested set lft.`, `rgt` int(11) not null default '0'comment `nested set rgt.`, `level` int(10) unsigned not null comment 'the cached level in nested tree.', `name` varchar(50) collate utf8_unicode_ci not null comment 'the unique name asset.\n', `title` varchar(100) collate utf8_unicode_ci not null comment 'the descriptive title asset.', `rules` varchar(5120) collate utf8_unicode_ci not null comment 'json encoded access control.' ) engine=innodb default charset=utf8 collate=utf8_unicode_ci mysql said: documentation
#1064 - have error in sql syntax; check manual corresponds mariadb server version right syntax use near 'as `nested set parent.`, `lft` int(11) not null default '0'comment `nested ' @ line 3
tried edits on sql import file no luck. knows how fix it?
there missing spaces before keyword comment:
'0'comment should
'0' comment there 3 occurrences here bet might find more errors, can fix simple find/replace (sed);
best of should try , new backup: possibly these have been linux line endings trimmed in double conversion windows , back? might zip / gzip sql dump on source server , explode on destination server, guarantee line ending integrity; or ftp transfer choose binary mode.
Comments
Post a Comment