loading in sql commands

[djam]

How would I load in a file with sql commands in it? What do I need to call the file?


thanks

" ahhh computers, how they made our lives much simpler "

 

[sleipnir214]

There is no particular file name or extension you must use.

When I need to perform multiple SQL queries from a file, I just pipe the file to the mysql admin application:

mysql mydatabasename < mysqlfile

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[djam]

I require a password to login to the database, this is what I'm doing:

mysql -u databasename -p < mysqlfile

it's not correct, can anyone give me some advice


thanks

&quot; ahhh computers, how they made our lives much simpler &quot;

 

[sleipnir214]

Shouldn't that be:

mysql -u yourusername databasename -p < mysqlfile

?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[djam]

ahh.... got it

mysql -u yourusername -D databasename -p < mysqlfile

thanks for your help

&quot; ahhh computers, how they made our lives much simpler &quot;