Can u us a "source code" file to setup a db in MySQL ?

[TopMailBox]

When created a complicated db in MySQL can you first create a "source file"
with all the MySQL commands... and then either pipe them to MySQL or have
MySQL read the "source file" and then create the db accordingly ??

Or, must you input/key in one command at a time to the program in real time?

Thanks for any info.