Hi.


System error:   2 = No such file or directory

Check if file exists. Do you have permissions to read this file?





[EMAIL PROTECTED] wrote:

> [-- text/plain, encoding 8bit, charset: US-ASCII, 22 lines --]

> 

> 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



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to