Bridgit's dashboard

Chris Olson replied on August 15, 2008 17:53 to the question "Why won't MySql reconize the address of my computer data file?" in O'Reilly Media:

Hi Bridgit,

if you use this command -
mysql -u lrngsql -p -D bank < LearningSQLExamples.sql
you need to be in the same directory as the LearningSQLExamples.sql file (since there is no path information before it). Also the -u tells mysql to start for the lrngsql user that you created in a previous step, and it will ask you for the password, which you also created in a previous step.

If you continue to have problems, send me an email at bookquestions@oreilly.com with the full path to your LearningSQLExamples.sql file and I'll help you get it working.

A comment on the question "Can't create my sample database for Learning SQL" in O'Reilly Media:

Sorry, that should read "step 13", referring to the instructions in the book. – Chris Olson, on August 13, 2008 17:32

A comment on the question "Can't create my sample database for Learning SQL" in O'Reilly Media:

What is set 13?

Bridgit – Bridgit, on August 09, 2008 17:53

Bridgit replied on August 09, 2008 17:49 to the question "Why won't MySql reconize the address of my computer data file?" in O'Reilly Media:

This still isn't working. Is the exact code "source c: Users\Owner\Desktop\LearningSQLExample.sql"? For the method you sent, does the "-u" and "-p" have to be replaced with a genuine username and my full length password?

Thanks,

Bridgit

Chris Olson replied on August 07, 2008 22:31 to the question "Why won't MySql reconize the address of my computer data file?" in O'Reilly Media:

Hi Bridgit,

Here is an alternative command that should load the sample data -
mysql -u lrngsql -p -D bank < LearningSQLExamples.sql

I hope that helps,
Chris

Chris Olson replied on August 05, 2008 21:45 to the question "Looking for learning sql's sample database" in O'Reilly Media:

Hi Bridgit,

Here is an alternative command that should load the sample data -
mysql -u lrngsql -p -D bank < LearningSQLExamples.sql

I hope that helps,
Chris

A comment on the question "Looking for learning sql's sample database" in O'Reilly Media:

Chris, hi

This Bridgit Waterman. I can download the text file. I just can't reach the file when I type the "Source..." sql line in MySql. It gets the the the letter "o" in my address and tells me MySql doesn't recognize this command or letter or element. Why not?

Thanks – Bridgit, on July 24, 2008 17:22

Bridgit asked a question in O'Reilly Media on July 18, 2008 00:53:

Why won't MySql reconize the address of my computer data file?

I'm trying to connect to the downloaded sql bank data in Learning SQL, but when I type the source path I get an error message saying that the server doesn't recognize the "o" in my "c:users\owner\desktop\..." file location.
Why I'm I not able to connect to the data file on my computer?

Chris Olson replied on July 17, 2008 21:28 to the question "Looking for learning sql's sample database" in O'Reilly Media:

Hi,

You can find the sample database for that book here -
http://examples.oreilly.com/learnings...

You'll probably need to right-click on the file and choose save as, because sometimes sql files open in the browser when you just click on the link, since it's basically text.

Bridgit started following the question "Looking for learning sql's sample database" in O'Reilly Media.