View Single Post

  #5 (permalink)  
Old 03-29-2008
Jerry Stuckle
 
Posts: n/a
Default Re: mysql -u root -p db < script1.sql script2.sql

gert wrote:
> is it possible to run multiple sql script files at once ?
>
> mysql -u root -p db < script1.sql script2.sql
>


You might be able to use

mysql -u root -p db < script1.sql + script2.sql

but I haven't tried it.

Normally, I just do it from the SQL command prompt:

mysql -u root -p db
source script1.sql
source2 script2.sql

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Reply With Quote