Loading Profile...
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?
Why I'm I not able to connect to the data file on my computer?
I’m frustrated
1 person has this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
-
Inappropriate?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
-
Inappropriate?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
I’m feeling stupid
-
Inappropriate?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.
EMPLOYEE
