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 ;
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.