2

I wanted to load the Sample Database Menagerie into MySQL. So, it's showing 'FAILED TO OPEN' in MySQL. My text.file for the same is

Drop database if exists menagerie ;
CREATE DATABASE menagerie ;
USE menagerie ;
SOURCE C:/SampleDB/cr_pet_tbl.sql
LOAD DATA LOCAL INFILE 'C:/SampleDB/pet.txt' INTO TABLE pet ;
SOURCE C:/SampleDB/ins_puff_rec.sql
SOURCE C:/SampleDB/cr_event_tbl.sql
LOAD DATA LOCAL INFILE 'C:/SampleDB/event.txt' INTO TABLE event ;

enter image description here

And these are the details of Menagerie DB enter image description here

I have also Uncompressed the file. enter image description here

But still there's an error!

enter image description here

Where am I going wrong please can anyone tell? Don't ignore please, it takes a lot of efforts to type so much here. I have downloaded Menagerie from MySQL site into a folder SampleDB on drive C.

3

The answer was, the file was not in the Folder C:/SampleDB

the screenshot is from the temporary unzipped file.

After creating the foldeer and copying the files, all was in order.

| improve this answer | |
  • That BTW teaches you to not cut out (location url) the most important info in screenshots ,) people do that all the time. – eckes Oct 31 at 23:10

Not the answer you're looking for? Browse other questions tagged or ask your own question.