View Single Post
Old October 27th, 2004, 10:33 PM   #2 (permalink)
patrickb
the one who was
Super #1
 
patrickb's Avatar
 
Joined in Jul 2003
Lives in Memphis
1,967 posts
Gave thanks: 0
Thanked 3 times
Simple enough.. Make sure the database is already created and empty (depending on what is in the sql file). If it isn't empty, the easiest thing to do is to type:

mysqladmin drop databasename
mysqladmin create databasename

After that is done, then type:

mysql databasename < file.sql

Of course, replace databasename with the real name of the database and file.sql with the filename (full path if you aren't in the current directory of it).
__________________
Patrick

Warnings: The program(s) might crash unexpectedly or behave otherwise strangely. (But of course, so do many commercial programs on Windows.) --www.gimp.org
patrickb is offline   Reply With Quote