Closed Thread
Results 1 to 3 of 3

Thread: database import help

  1. #1
    aycan.naime27 is offline x10Hosting Member aycan.naime27 is an unknown quantity at this point
    Join Date
    Mar 2011
    Posts
    16

    database import help

    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

    Code:
    $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

  2. #2
    descalzo's Avatar
    descalzo is offline Grim Squeaker descalzo has a brilliant futuredescalzo has a brilliant futuredescalzo has a brilliant future
    Join Date
    Jul 2009
    Location
    Ankh-Morpork
    Posts
    7,635

    Re: database import help

    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.
    Last edited by descalzo; 03-23-2011 at 02:13 PM.
    Nothing is always absolutely so.

  3. #3
    aycan.naime27 is offline x10Hosting Member aycan.naime27 is an unknown quantity at this point
    Join Date
    Mar 2011
    Posts
    16

    Re: database import help

    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

Closed Thread

Similar Threads

  1. can not import my old database
    By aycan.naime27 in forum Free Hosting
    Replies: 2
    Last Post: 03-20-2011, 12:41 PM
  2. Database cannot connect after import
    By samsungflashwiki in forum Free Hosting
    Replies: 1
    Last Post: 07-21-2010, 12:56 PM
  3. Mysql Database import in phpmyadmin
    By eveind in forum Free Hosting
    Replies: 0
    Last Post: 11-13-2008, 02:06 PM
  4. How to import *.doc Database dump
    By smartbox in forum Free Hosting
    Replies: 1
    Last Post: 04-20-2008, 10:21 AM
  5. How to import large MySQL database to X10?
    By lachu in forum Free Hosting
    Replies: 12
    Last Post: 03-10-2008, 09:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers