Having a problem with a Games Database!!

Discussion in 'Databases' started by ariyes, Jul 22, 2008.

  1. #1
    Hi
    I have a Free online games site www.arcadegamers.org

    For that games site i buy a games Pack and I upload everything Correctly (picture and games) but when i go to upload the Database in the PHP MY ADMIN the Database says
    #1050 - Table 'ava_games' already exists

    Here is my .sql file

    Any Solution?

    See the Picture
    [​IMG]

    Thanks:)
     
    ariyes, Jul 22, 2008 IP
  2. spyrit

    spyrit Well-Known Member

    Messages:
    1,788
    Likes Received:
    94
    Best Answers:
    0
    Trophy Points:
    150
    #2
    delete this part from the file and try again:

    -- 
    -- Tabel structuur voor tabel `ava_games`
    -- 
    
    CREATE TABLE `ava_games` (
      `id` int(10) unsigned NOT NULL auto_increment,
      `name` text NOT NULL,
      `description` text NOT NULL,
      `url` text NOT NULL,
      `catergory_id` varchar(10) NOT NULL default '',
      `hits` int(11) NOT NULL default '0',
      `published` tinyint(3) NOT NULL default '0',
      `user_submit` varchar(10) NOT NULL default '0',
      `width` varchar(4) NOT NULL default '',
      `height` varchar(4) NOT NULL default '',
      `image` text NOT NULL,
      `import` char(1) NOT NULL default '0',
      `filetype` char(3) NOT NULL default '',
      PRIMARY KEY  (`id`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=169 ;
    
    -- 
    -- Gegevens worden uitgevoerd voor tabel `ava_games`
    -- 
    Code (markup):
     
    spyrit, Jul 22, 2008 IP
  3. ariyes

    ariyes Notable Member

    Messages:
    1,123
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    245
    #3
    WOW its working now! Thanks Spyrit.
     
    ariyes, Jul 22, 2008 IP
  4. spyrit

    spyrit Well-Known Member

    Messages:
    1,788
    Likes Received:
    94
    Best Answers:
    0
    Trophy Points:
    150
    #4
    glad to hear that :)
    cheers.
     
    spyrit, Jul 23, 2008 IP