I want to take some sql commands I have in a txt file and load them via the mysql monitor to populate some tables (rather than type it all again) but the command I have doesn't seem to work ... could someone advise me?
I'm using :
C:\mysql>mysql -h hostname -u username -D databasename -p > F:\Examples\chapter09\book_insert.sql
but can't get it to work.
If it helps I'm using mysql 3.23.58

Thanks,
Craig.

You should use "<" sign instead of ">" to post your file content to the mysql console.