I'm a complete newbie to SQL & MySQL. Installed MySQL on my MacBook running OS X 10.6.8. I can launch MySQL from Terminal. I can list the included databases using the "show databases;" command.
I am trying to install the sample files included with a book I'm using to learn MySQL (Ben Forta's MySQL Crash Course).
I would like to execute the two scripts to install the sample databases used as examples in this book. There are two script files, create.sql and populate.sql
I have copied both these files into /usr/local/mysql-5.1.73.osx10.6-x86_64/data folder, which is where I believe mysql stores the local databases.
When I try to run "use create.sql" from the mysql command line, I get an "ERROR 1049 (42000): Unknown database 'create.sql'
Please advise. Thanks in advance.