commands.sql

[blue928]

I have written a pretty lengthy set of mysql commands and stored them in a file called commands.sql. now that I have taht file, how do I access it? I have been reading everwhere that you can call commands from a file, but no details on how the file is accessed or what folder it's stored in. anyone shed some light? thx

blue

[Anon]

Hi Blue,

Put the file in the same general location as your php pages and use include:

<? include("/home/http/commands.sql"); ?>

Then you can call any functions or check any variables that were assigned in your file further down in your PHP.

Note I've used an absolute path above, but you might use realtive "../commands.sql" or just copy the file to every location you're going to use it from and use "commands.sql". It is really up to you.

Note that the user won't be burdened with a huge download time for these pages just because commands.sql is big. Only the print, echo and unescaped HTML in the include file gets sent to the browser. BUT... if you're commands.sql file is REALLY huge, you'll still have a delay as the server side PHP picks up the entire file and processes it. If this is the case, consider breaking it up into smaller files: "inserts.sql" "updates.sql" "transactions.sql".

Hope this helps...

[[deleted]]

Are those commands they MySQL queries or PHP code?

[blue928]

its a set of mysql commands.. sorry, should have been more explicit

blue

[[deleted]]

On unix:
If you just want mysql to run those commands asif you were typing them by hand, just do "mysql < commands.sql"

Note that depending on what you have in the commands, you may have to specify which database you want to use:
"mysql database_name < commands.sql"