Helpful Information
 
 
Category: MySQL Help
New to mysql

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

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).]










privacy (GDPR)