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 ;
And these are the details of Menagerie DB
I have also Uncompressed the file.
But still there’s an error!
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.