help a newb

Discussion in 'MySQL' started by no-money, May 8, 2006.

0
  1. #1
    would be really greatful if someone could help me with this. When i try to upload my database (sql file) using phpmyadmin, i get this message:

    SQL query:

    # MySQL-Front Dump 2.1
    #
    # Host: localhost Database: recipes
    #--------------------------------------------------------
    # Server version 3.23.28-gamma
    #
    # Table structure for table 'ad_groups'
    #
    CREATE TABLE `ad_groups` (

    `groupid` int( 10 ) unsigned NOT NULL default '0',
    `groupname` varchar( 255 ) NOT NULL default '',
    PRIMARY KEY ( `groupid` ) ,
    UNIQUE KEY `groupid` ( `groupid` ) ,
    KEY `groupid_2` ( `groupid` )
    ) TYPE = MYISAM COMMENT = ''
    MySQL said:

    #1046 - No database selected

    i have managed to upload this database successfully on another host, but this is the host i want to go with.

    Successful Host

    MySQL Version : mysql 4.0.24, for pc-linux-gnu (i386)
    PHP Version : 4.3.4
    phpMyAdmin 2.6.4-pl2

    Failure

    PHP version 4.4.1
    MySQL version 4.0.24
    phpMyAdmin 2.6.4-pl3

    complete newb so would be really greatful if someone could tell me what the problem is.
     
    no-money, May 8, 2006 IP
  2. Bezzen

    Bezzen Peon

    Messages:
    244
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #2
    It seems to me like phpmyadmin is trying to add your table without having a database created first.

    If you click on the home icon in phpmyadmin and then click on the "databases" link, see what comes up there. If it's blank you should hopefully have "create new database"-option, if it's not blank you should already have a database. In that case click on the name of that database to make sure it's selected and try uploading again.
     
    Bezzen, May 10, 2006 IP