Importing Directory Database

Discussion in 'MySQL' started by bacanze, Oct 10, 2006.

0
  1. #1
    Ok, well I basically downloaded my directory database in .sql format onto my desktop and then I tried to re-upload it to my new server using phpmyadmin however I get the folowing error:

    SQL query:

    -- phpMyAdmin SQL Dump
    -- version 2.8.2.4
    -- http://www.phpmyadmin.net
    --
    -- Host: localhost
    -- Generation Time: Oct 08, 2006 at 08:43 AM
    -- Server version: 4.1.21
    -- PHP Version: 4.4.2
    --
    -- Database: `cloverde_killer`
    --
    -- --------------------------------------------------------
    --
    -- Table structure for table `PLD_BANLIST`
    --
    CREATE TABLE `PLD_BANLIST` (
    `ID` int( 11 ) NOT NULL AUTO_INCREMENT ,
    `BAN_IP` varchar( 15 ) default NULL ,
    `BAN_DOMAIN` varchar( 64 ) default NULL ,
    `BAN_EMAIL` varchar( 250 ) default NULL ,
    PRIMARY KEY ( `ID` )
    ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =1;

    MySQL said: Documentation
    #1046 - No database selected
     
    bacanze, Oct 10, 2006 IP
  2. T0PS3O

    T0PS3O Feel Good PLC

    Messages:
    13,219
    Likes Received:
    777
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Top left in PHPMyAdmin select a adatabase first. Or create one.
     
    T0PS3O, Oct 10, 2006 IP
  3. daboss

    daboss Guest

    Messages:
    2,249
    Likes Received:
    151
    Best Answers:
    0
    Trophy Points:
    0
    #3
    ;) you're trying to restore a backup into a 'non-existent' database because it [1] does not exist or [2] you have not created one or [3] it exists but you have not selected it to be run against...
     
    daboss, Oct 10, 2006 IP