mySQL problem

Anon

I need to create a table to database where is all top-level domains and descriptions. This is my first time when I need to create a table and insert data there during the creation. I have all TLDs and descriptions but I don't have a clue how I could do this effictiently. What would be the best way to create a table and inset all TLDs there when I create the table? I have following kind of table structure:

CRAETE TABLE country (
id INTEGER UNSIGNED auto_increment,
cc VARCHAR(11) NOT NULL,
description VARCHAR(100) NOT NULL,
PRIMARY KEY (id)
)

Thanks for you co-operation!

Anon

Create a db dump file i.e. dbname.dump.

Inside the file write:
CRAETE TABLE country (
id INTEGER UNSIGNED auto_increment,
cc VARCHAR(11) NOT NULL,
description VARCHAR(100) NOT NULL,
PRIMARY KEY (id)
);
Then write:

INSERT INTO country VALUES (
values go here.
);

start up MSDOS change dir to mysql\bin:
Type:
C:\mysql\bin> mysqladmin create dbname

then type:
C:\mysql\bin> mysql dbname < dbname.dump

This should do the trick with a little modifiction.

Anon

By the way. Make sure the dump file is in the same file as the mysql exe (mysql\bin).