Need help to create these mysql structur

[Anon]

Hi,
I got a script with a file that contains lots of mysql structures it needs to create in order to work.

Here is a part of the .sql file that contains all the structures:

---

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

#

Table structure for table 'PETadminUsers'

#

CREATE TABLE PETadminUsers (
username varchar(25) NOT NULL,
passwd varchar(25) NOT NULL,
FirstName varchar(40) NOT NULL,
LastName varchar(40) NOT NULL,
email varchar(100) NOT NULL,
groups varchar(25) DEFAULT 'admin' NOT NULL,
PRIMARY KEY (username)
);

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

#

Table structure for table 'PETalert'

#

CREATE TABLE PETalert (
ID int(7) NOT NULL auto_increment,
petitionID int(7) DEFAULT '0' NOT NULL,
sender varchar(25),
reciever varchar(25),
date datetime,
PRIMARY KEY (ID)
);

[....]

What should I do to have all this created ?
(i'm using telnet)

Thanks,
Dukan

[[deleted]]

just give the sql file as input to your mysql program:

mysql -h host -u username -ppassword databasename < sqlfile.sql

read the mysql man-page (mysql -h) for more info.