Hi and thanks for your reply.
I am trying to install a chat script which as I say uses mysql.
The instructions say:
Create database and database user with access rights
Now you have to setup your database.
- create a database (In other cases than mysql, it may be called 'tablespace')
- create a database user with access rights to this database
- import PHPOpenChat's database-schema db.schema
The schema file looks like this~:
db.schema
SQL database schemas and initial test data
$Id: db.schema,v 1.48 2003/04/28 16:21:52 letreo Exp $
#
Dumping data for table 'poc_user_account'
#
DROP TABLE IF EXISTS poc_user_account;
CREATE TABLE poc_user_account (
USER varchar(255) NOT NULL,
PASSWORD varchar(255),
CONFIRM_CODE char(32),
DISABLED int NOT NULL DEFAULT '0',
PRIMARY KEY (USER)
) TYPE=MyISAM;
#
Test users in alphabetical order of family names
#
INSERT INTO poc_user_account (USER,PASSWORD,DISABLED) VALUES ('mirko','giese',0);
INSERT INTO poc_user_account (USER,PASSWORD,DISABLED) VALUES ('frerk','meyer',0);
INSERT INTO poc_user_account (USER,PASSWORD,DISABLED) VALUES ('michael','oertel',0);
INSERT INTO poc_user_account (USER,PASSWORD,DISABLED) VALUES ('operator','',0);
#
Dumping data for table 'poc_user_groups'
#
DROP TABLE IF EXISTS poc_user_groups;
CREATE TABLE poc_user_groups (
NAME varchar(255) NOT NULL,
MEMBER text,
PRIMARY KEY (NAME)
) TYPE=MyISAM;
and so on.
How can I load this type of file by using phpmyadmin or from the shell of the server.
If you could help it would be good
Regards and thanks in advance.
Dereck
