I am trying to utilize MySQL's batch execution functionality by using build scripts to create tables in my database (ref: http://dev.mysql.com/doc/mysql/en/Batch_Commands.html )
Is it possible to execute additional source files from within a source file from the MySQL command line? Ex: mysql> \. c:\file1.sql ## execute the first sql batch file <file1.sql> create table employees{...}; \. c:\file2.sql; ## execute the second sql batch file <eof> <file2.sql> create table customers{...}; <eof> I 've tried this and get an error: "failed to open file 'c:\file2.sql;', error 2