Thread: New to mysql

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Location
    Aylesbury
    Posts
    1
    Rep Power
    0
    Hi,
    I am completely new to mysql and have a few questions,

    1. My database comes installed with my webspace , is there anyway I can buils the database offline or do I have to be logged on while I work on it, (UK metered calls
    2. Can mmsql import other databases such as access 2000.

    Thanks in advance
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 1999
    Location
    London
    Posts
    110
    Rep Power
    0
    1. if you install MySQL on your own computer, you can build at home do a dump of the db and then place that in your webspace.
    Or if you cant do that you can make the tables at home as they are 'only' text files see below
    ---------------------------------------------

    # MySQL dump 5.10
    #
    # Host: localhost Database: <db name>
    #--------------------------------------------------------
    # Server version 3.22.12-beta

    #
    # Table structure for table 'survey'
    #
    CREATE TABLE survey (
    id int(10) DEFAULT '0' NOT NULL auto_increment,
    ques1 text,
    ques2 text,
    email text,
    gender text,
    age text,
    PRIMARY KEY (id)
    );

    #
    # Dumping data for table 'survey'
    #

    INSERT INTO survey VALUES ('1','Y','N','bob@bob.com','MALE','30');

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

    and yes you can import other db's try
    http://www.mysql.net/links.html

    for a load of links etc that should get you going

    ------------------
    cheers


    [This message has been edited by timbo (edited February 01, 2000).]

Similar Threads

  1. Mysql problem.
    By Nik in forum MySQL Help
    Replies: 54
    Last Post: December 21st, 2006, 07:02 PM
  2. mysql and MS foxpro
    By wijbenga in forum MySQL Help
    Replies: 16
    Last Post: February 5th, 2004, 12:46 PM
  3. Hebrew Charset, MySQL, PHP, Searching
    By ezuk in forum MySQL Help
    Replies: 0
    Last Post: September 4th, 2003, 02:12 AM
  4. mysql connection
    By cindyqz in forum Java Help
    Replies: 0
    Last Post: August 25th, 2003, 08:33 PM
  5. Getting Access to use MySQL
    By -=-steve-=- in forum MySQL Help
    Replies: 1
    Last Post: November 11th, 2001, 12:01 PM

IMN logo majestic logo threadwatch logo seochat tools logo