creating a .sql text file from a database

How can i export a website database to an .sql file from the command prompt....pliz help me with the scripts i'm really stuck

 

Try this:

mysqldump -u username -ppassword database > /database.sql

 

You might want to make the target:

~/database.sql

Create it in your $HOME instead of on the root file system. Otherwise, if it is a large DB you can fill the root filesystem quickly which is not recommended.

You might like to look at the -h switch to specify a mysql host if the DB is not local.