I'm a total MySQL beginner, working my way through Joshua Mostafa's (very good) MySQL video tutorial course on VTC.com I'm running MySQL on Mac OS X 10.5.8 and I can access the MySQL Monitor via Terminal to manually create and manipulate very basic databases.
The VTC course comes with a set of work files which appear to be batch files that create sample databases to use during the course. Unfortunately, Joshua doesn't cover how to use these files to create databases on a Mac. He's using a PC and says do the following at the command line:
This obviously doesn't work on a Mac, so I've got a few questions:
1. Where should I drag and drop the 'filename.sql' batch file? (my 'usr/local/mysql/bin' directory is full of stuff and none of them are *.sql files and when I try to drop it in there it says I shouldn't modify that directory)
2. What is the correct thing to type into Terminal to make the file generate the database?
Any help is greatly appreciated!