View Single Post
  #12  
Old 04-24-2002, 05:30 AM
Lurker_005
Demi-God
 
Join Date: Jan 2002
Location: Tourist town USA
Posts: 1,671
Default

meliudaj,

Just put command you would want to run many times in a file

Code:
drop database test; 
create database test; 
use test
source db.sql
Then mysql -f mysql < resource-db.sql


I am pretty sure you have to specify a DB in the last line there. But you can't specify the one you want to drop. You can try it without listing the DB, but i don't know if that works.
Reply With Quote