//PHP sdms app: import table structure into MySQL ??

[tim0fee]

Hmm,

I'm trying to install this open-source app: http://sdms.cafuego.net/
It's a simple online document manager. Looks really good if I could make it work ! ;-)

So please does anyone know the command to import the following table stucture file into MySQL ?

create_db.sql

I am told to do this by the install file:

...create the tables required for the system by running the following command:

mysql [-u user -p] < create_db.sql

I have therefore gone into Terminal and typed:

mysql [-umyuser -pmypassword] < create_db.sql

I get this error:

-bash: create_db.sql: No such file or directory

I am new to this so I guess it's something pretty basic like a path to that file...!?

Any help gladly received ? Thank you.

tim0fee

Mac OSX 10.3.9
PHP 5.0.3
MySQL 4.0.21
Apache 1.3.33

[thorpe]

it is something as basic as the path to that file. once your in your terminal either go to the file using cd, or type the full path. eg

mysql [-umyuser -pmypassword] < /home/foo/create_db.sql

im not sure how simular mac is to linux, but if this file is in your accounts home directory you could try...

mysql [-umyuser -pmypassword] < ~/create_db.sql

[tim0fee]

Thanks very much thorpe!

That worked a treat...

peace.

tim0fee