Why Can't i build my database in symfony using propel orm.?

Question

I am new to the php framework symfony.I have a problem creating the database.I am using propel orm. As usual I made necessary changes in the database.yml page then I edited the schema.yml page. and in order to build the database in the command prompt typed the command..

c:>php propel:build-all

and i am getting the error message as

"could not open input file:propel:build-all"

Answer 1

Before propel build all in symfony 1.4 . Make an edit in MysqlDDLBuilder.php as mentioned in link then Enter project directory in command prompt and type as below example in my windows system:

C:\wamp\bin\php\php5.3.5\php.exe symfony propel:build-all

Answer 2

Check this link on how to create the sql using propel:

Building The Database

to create the sql use : // will create a sqlfile.sql

propel-gen sql

then create your database using mysqladmin

mysqladmin -u root -p create my_db_name

import the sql file

mysql -u root -p my_db_name < sqlfile.sql