.sql files

[ceanth]

Hi all, how do i load a .sql file into mysql?

cheers

ceanth

[jpmoriarty]

from the command line:

mysql -h host - u user - p < file.sql

note that you might have to set the path to mysql so you can run it from the folder containing your sql statement. Not sure how to do it (or even if you can) from within a running mysql.