Cum pot sa mut un forum phpbb3

[|Robert|]

Ma confrunt cu o problema... am schimbat hostingul si am salvat baza de date de pe host 1... nu reusesc sa pun baza de date pe host 2. imi da urmatoarea eroare in phpMyAdmin: ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; sau 'collate utf8_bin NOT NULL default '',
`is_global` tinyint(1)

ce pot sa fac ?

Multumesc anticipat

[Myky]

Sterge toate tabelele din PHPMyAdmin. Si incearca atunci.

[|Robert|]

nu am inca nici un tabel... am facut doar baza de date... restore sau import trebuie sa faca acest lucru... dar... nu face nimica din cauza erorii utf8

[shocker]

Pune un screenshot sa vedem exact ce iti arata

[|Robert|]

Error
SQL query:

CREATE TABLE `phpbb3_acl_groups` (

`group_id` mediumint( 8 ) unsigned NOT NULL default '0',
`forum_id` mediumint( 8 ) unsigned NOT NULL default '0',
`auth_option_id` mediumint( 8 ) unsigned NOT NULL default '0',
`auth_role_id` mediumint( 8 ) unsigned NOT NULL default '0',
`auth_setting` tinyint( 2 ) NOT NULL default '0',
KEY `group_id` ( `group_id` ) ,
KEY `auth_opt_id` ( `auth_option_id` ) ,
KEY `auth_role_id` ( `auth_role_id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_bin

MySQL said:

#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=utf8 COLLATE=utf8_bin' at line 10

sau

Error
SQL query:

CREATE TABLE `phpbb3_zebra` (

`user_id` mediumint( 8 ) unsigned NOT NULL default '0',
`zebra_id` mediumint( 8 ) unsigned NOT NULL default '0',
`friend` tinyint( 1 ) unsigned NOT NULL default '0',
`foe` tinyint( 1 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `user_id` , `zebra_id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_bin

MySQL said:

#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=utf8 COLLATE=utf8_bin' at line 7

cam astea sunt eroriile... la orice tabel vrau sa creez.... din backup-ul facut...