Create Database

[thanx]

Hello,

i'm new to mysql and trying to set up a database i modelled with an ER-tool.
How do i run the file (*.sql)to create my database?
Sorry for my english.

 

[piti]

when you have a plain sql file, u can use
a) the command mysql -> mysql -u username -ppassswd < yourfile.sql
b) phpmyadmin or any other gui

i think your file should have the &quot;create database&quot; and &quot;use&quot; statements on the top, e.g.:

create database mydb;
use mydb;
<now your sql commands>

 

[KarveR]

from the mysql command line too :
mysql>\./path/to/file.sql ***************************************
Party on, dudes!