database help

[asduskun]

hi

when i wanted to import my database into my new host i got this error what should i do?

SQL sorgusu:

--
-- Tablo döküm verisi `backup_smf_openid_assoc`
--
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `backup_smf_package_servers`
--
CREATE TABLE IF NOT EXISTS `backup_smf_package_servers` (
`id_server` smallint( 5 ) unsigned NOT NULL AUTO_INCREMENT ,
`name` varchar( 255 ) COLLATE latin1_german2_ci NOT NULL DEFAULT '',
`url` varchar( 255 ) COLLATE latin1_german2_ci NOT NULL DEFAULTT '',
PRIMARY KEY ( `id_server` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_german2_ci AUTO_INCREMENT =3;

MySQL çıktısı: Belgeler
#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 'T '',
  PRIMARY KEY (`id_server`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLAT' at line 15

[ziycon]

You have 'DEFAULTT' which should be 'DEFAULT' with only one T, it works grand for me when you remove the second T.

CREATE TABLE IF NOT EXISTS `backup_smf_package_servers` (
`id_server` smallint( 5 ) unsigned NOT NULL AUTO_INCREMENT ,
`name` varchar( 255 ) COLLATE latin1_german2_ci NOT NULL DEFAULT '',
`url` varchar( 255 ) COLLATE latin1_german2_ci NOT NULL DEFAULTT '',
PRIMARY KEY ( `id_server` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_german2_ci AUTO_INCREMENT =3;

[CapadY]

Don't ask the same question in two different topics.

This question can better be discussed in your previous topic:

http://www.simplemachines.org/community/index.php?topic=426950.0

This topic will be closed.