Error when importing my database

Discussion in 'Databases' started by cluongo18, Jul 5, 2010.

  1. #1
    I got a new host and tried to import my database but i got this error:

    Error
    
    SQL query:
    
    -- phpMyAdmin SQL Dump
    -- version 2.8.0.1
    -- http://www.phpmyadmin.net
    -- 
    -- Host: custsqlmoo09
    -- Generation Time: Jul 04, 2010 at 10:07 AM
    -- Server version: 5.0.83
    -- PHP Version: 4.4.9
    -- 
    -- Database: `Tutcovewp`
    -- 
    -- --------------------------------------------------------
    -- 
    -- Table structure for table `wp_commentmeta`
    -- 
    CREATE TABLE `wp_commentmeta` (
    `meta_id` bigint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
    `comment_id` bigint( 20 ) unsigned NOT NULL default '0',
    `meta_key` varchar( 255 ) default NULL ,
    `meta_value` longtext,
    PRIMARY KEY ( `meta_id` ) ,
    KEY `comment_id` ( `comment_id` ) ,
    KEY `meta_key` ( `meta_key` )
    ) ENGINE = MYISAM AUTO_INCREMENT =6 DEFAULT CHARSET = utf8 AUTO_INCREMENT =6;
    
    MySQL said: Documentation
    #1046 - No database selected 
    Code (markup):

     
    cluongo18, Jul 5, 2010 IP
  2. netload

    netload Member

    Messages:
    105
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    28
    #2
    You should select database in the PhpMyAdmin or do this sql-query: use your_database_name;
     
    netload, Jul 6, 2010 IP
  3. xtrecoolx

    xtrecoolx Greenhorn

    Messages:
    43
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #3
    netLoad is right. At least use default mySQL Query application and choose a DB there and then run this query directly inside the tool.
     
    xtrecoolx, Jul 16, 2010 IP