Migration of CMSCS

[martin1660]

Hi,

I have built a website with CMCS with apache/php/mysql and co. on my local desktop pc (due to the better speed and so on). Now I would like to copy the actuell version to an internet server.
For that purpose first I copied the datas to the webserver. That followed I exported the structure of and contents of the database as sql-file  in order to import it on the webserver's database. At this point it occures the following error:

CREATE TABLE `cms_additional_htmlblob_users` (

`additional_htmlblob_users_id` int( 11 ) NOT NULL default '0',
`user_id` int( 11 ) default NULL ,
`htmlblob_id` int( 11 ) default NULL ,
PRIMARY KEY ( `additional_htmlblob_users_id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1

MySQL reports: 

#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 'DEFAULT CHARSET=latin1' at line 24

A tip from another forum to delete the syntax  DEFAULT CHARSET = latin1 in the sql-code let follow another error.

Is it possible in principle at all, to make a migration on this way? How can I avoid the problem with the database?

Independent from the problems with the database: Have I adjust other files apart from "config.php" to run the CMSCS?

Thanks for your help!