Hi J, I think you shoud type of command prompt: mysql database < file.sql
and this will create the database Cheers, Caterina -----Original Message----- From: Jarlath . Hennelly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 2:19 PM To: MySQL (E-mail) Subject: Running SQL Scripts Dudes & Dudettes, I got a SQL script with all the SQL to setup a database. But I can't seem to access the script. I did this before so I know it can be done, but I've to do it for a new project, and I can't remeber how. So I've 2 questions : - Does my script file need to be a .sql file or just a plain .txt file??? - What command do I use : mysql < file_name <<<<<< Is this correct Any help would be greatly appreciated. cheers, J --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php