database import help

[aycan.naime27]

please help about this problem , i can t import my old database into x10hosting when i want to do so i get this error below

CREATE DATABASE `asduskun` DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci; then i removed this line and i got this error below

-- Tablo için tablo yapýsý `backup_smf_admin_info_files`
--
CREATE TABLE `backup_smf_admin_info_files` (
`id_file` tinyint( 4 ) unsigned NOT NULL AUTO_INCREMENT ,
`filename` varchar( 255 ) COLLATE latin1_german2_ci NOT NULL DEFAULT '',
`path` varchar( 255 ) COLLATE latin1_german2_ci NOT NULL DEFAULT '',
`parameters` varchar( 255 ) COLLATE latin1_german2_ci NOT NULL DEFAULT '',
`data` text COLLATE latin1_german2_ci NOT NULL ,
`filetype` varchar( 255 ) COLLATE latin1_german2_ci NOT NULL DEFAULT '',
PRIMARY KEY ( `id_file` ) ,
KEY `filename` ( `filename` ( 30 ) )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_german2_ci AUTO_INCREMENT =8;
MySQL çýktýsý: Belgeler
#1050 - Table 'backup_smf_admin_info_files' already exists

so what is wrong? i also have this error at the bottom of my database "additional feature working with related tables have been disabled. click here to see why" when i click there i see these below

$cfg['Servers'][$i]['pmadb'] ... 	Not ok [ documents ]
$cfg['Servers'][$i]['relation'] ... 	Not ok [ documents]
General relation specs: inactive
 
$cfg['Servers'][$i]['table_info'] ... 	Not ok [ documents]
show specs: inactive
 
$cfg['Servers'][$i]['table_coords'] ... 	Not ok [ documents]
$cfg['Servers'][$i]['pdf_pages'] ... 	Not ok [ documents]
creating pdf s: inactive
 
$cfg['Servers'][$i]['column_info'] ... 	Not ok [ documents]
showing column comments: inactive
SQL query signed: inactive
Browser mappings: inactive
 
$cfg['Servers'][$i]['history'] ... 	Not ok [ documents]
SQL history: inactive
 
$cfg['Servers'][$i]['designer_coords'] ... 	Not ok [ documents]
designer: inactive

 

[descalzo]

Are you trying to move an SMF database onto a new install?

Is there anything in the new install you wish to keep?

Your SQL dump wants to create tables, but your new install already has them. Hence, you get an error.

How many databases do you have? If you have only one

A. Use cPanel-->MySQL Databases to create a new database
B. Add the user for the SMF database that is already there to the new database
C. Now cPanel-->phpMyAdmin to import the tables and data (having removed the CREATE DATABASE instructions) to the new database
D. Find the SMF configuration file and change the name of the database to the newly created one

If everything works out, you can delete the SMF database that is there now.

 

[aycan.naime27]

the only thing i did was i downloaded my already installed smf files from my previous host and uploaded them on x10hosting and i also exported my database from my previous hosting and now can not import it on my current host, but i upgraded my smf when i was in my previous host and as of now since i can t import my upgraded database i used my first database which was created before smf upgrade so i think the problem is here and i can t solve it