anuneznyc
asked on
Running a MySQL script from MySQL Command Prompt on a Mac
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.os x10.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.
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.os
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome, glad to help.
ASKER