[RESOLVED] Adding Tables etc. to a Hosted Database?

[middleman666]

hey, new to sql and i have a hosted database but is there a way of inputting the tables etc without having to ask my server guy to do it for me?

I have what i want to input written to a file, this is a snipet:

DROP DATABASE IF EXISTS content;

CREATE DATABASE content;

USE content;

DROP table IF EXISTS writers;

CREATE table writers (
  username    varchar(16) PRIMARY KEY,
  password    char(40) NOT NULL,
  full_name   text
);

DROP table IF EXISTS stories;

CREATE table stories (
  id          int PRIMARY KEY auto_increment,
  writer      varchar(16) NOT NULL,            # FOREIGN KEY writers.username
  page        varchar(16) NOT NULL,            # FOREIGN KEY pages.code
  headline    text,
  story_text  text,
  picture     text,
  created     int,
  modified    int,
  published   int
);

is there an online app i can use to simply load the file into the database?

[devinemke]

phpMyAdmin (assuming you are using mySQL)

[middleman666]

cheers for that, had heard of phpmyadmin but didnt really understand what it was or where to find it.

cheers again.