Help needed in moving database

[knaphih]

i have been using my forum under a subdomain for around a month now...
i bought hosting n i decided to move my forum to my new host...i exported my current database under the subdomain.. i somehow managed to import the database...i can see my forum users also..but the problem is.. how can i run it?...o make it the default database?... wen i try to run SQL query by typing the exact name of the backup file i downloaded (maldive_smf1.sql) .... it shows this error:

SQL query:

maldive_smf1.sql

MySQL said: Documentation
#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 'maldive_smf1.sql' at line 1

wen i try using the browse button, shows another error:

Error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 30, 2007 at 02:15 PM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
--
-- Database: `maldive_smf1`
--
-- --------------------------------------------------------
--
-- Table structure for table `smf_attachments`
--
CREATE TABLE `smf_attachments` (
`ID_ATTACH` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`ID_THUMB` int( 10 ) unsigned NOT NULL default '0',
`ID_MSG` int( 10 ) unsigned NOT NULL default '0',
`ID_MEMBER` mediumint( 8 ) unsigned NOT NULL default '0',
`attachmentType` tinyint( 3 ) unsigned NOT NULL default '0',
`filename` tinytext NOT NULL ,
`size` int( 10 ) unsigned NOT NULL default '0',
`downloads` mediumint( 8 ) unsigned NOT NULL default '0',
`width` mediumint( 8 ) unsigned NOT NULL default '0',
`height` mediumint( 8 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `ID_ATTACH` ) ,
UNIQUE KEY `ID_MEMBER` ( `ID_MEMBER` , `ID_ATTACH` ) ,
KEY `ID_MSG` ( `ID_MSG` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =36;

MySQL said: Documentation
#1050 - Table 'smf_attachments' already exists

how can i connect my db?

[Harro]

So you already imported the database?
Just run repair_settings.php then.
What is repair_settings.php?

[knaphih]

thnx Harro. it really worked...