Insert SQL table into DB

• • Reply

  18 years ago

  by jonorossi

  Jonathon Rossi

  Brisbane, Australia

  Joined 18 years ago

  i have a sql file [*.sql] and the install file says that i need to add the table to my database, i have no idea of how to add it if you know could you please direct me in the right direction
  

  
  the start of the file [nuke.sql] is
  

  Quote:

  # MySQL dump 8.14
  #
  

  Host: localhost    Database: nuke

  
  

  --------------------------------------------------------

  
  

  Server version    3.23.41

  
  

  
  #
  

  Table structure for table 'nuke_access'

  
  #
  

  
  CREATE TABLE nukeaccess (
   accessid int(10) NOT NULL autoincrement,
   accesstitle varchar(20) default NULL,
   PRIMARY KEY  (access_id)
  ) TYPE=MyISAM;
  

  
  #
  

  Dumping data for table 'nuke_access'

  
  #
  

  
  INSERT INTO nukeaccess VALUES (-1,'Deleted');
  INSERT INTO nukeaccess VALUES (1,'User');
  INSERT INTO nukeaccess VALUES (2,'Moderator');
  INSERT INTO nukeaccess VALUES (3,'Super Moderator');
  INSERT INTO nuke_access VALUES (4,'Administrator');
  

  
  #
  

  Table structure for table 'nuke_authors'

  
  #
  

  
  CREATE TABLE nuke_authors (
   aid varchar(25) NOT NULL default '',
   name varchar(50) default NULL,
   url varchar(255) NOT NULL default '',
   email varchar(255) NOT NULL default '',
   pwd varchar(40) default NULL,
   counter int(11) NOT NULL default '0',
   radminarticle tinyint(2) NOT NULL default '0',
   radmintopic tinyint(2) NOT NULL default

  
  

  
  Thanks
  

  
  Jono

  Report abuse