Loading database information from a text file

Hi, I have a text file with all my database information from creating databases to setting up tables. I have looked throught the mysql docs on how to load these on from a text file via the mysql prompt. But all I can find is: load data infile "filename.txt" into table whatever But this is not what I am looking for. :( As the tables are already defined in the text file and the appropiate database name to enter them into. Is there a way to load these into the database directly instead of doing each table seperately from the mysql prompt? (not web admin) Thanks in advance. Kind Regards, Jerry http://mobile.yahoo.com.au - Yahoo! Mobile - Check & compose your email via SMS on your Telstra or Vodafone mobile.