Last answered:

26 Mar 2023

Posted on:

03 Mar 2023

0

Final exam Load database error

Hello,


When i tried to upload the database (first one "db-albums") for the final exam I encountered the below error, hence all the tables was empty and I couldn't take the exam.


Also, I want to mention that I checked the row 37 and is nothing there, is empty.

How can I fix this for when I will try to take the exam again?


Also is there any possibility not to wait those 30 minutes considering the situation? Because I closed it from question 2.


Many thanks,

Andrei


5 answers ( 0 marked as helpful)
Instructor
Posted on:

03 Mar 2023

0

Hi Andrei!


Thanks for reaching out.


Can you please restart Workbench and retry uploading the db-albums database? 

Also, can you please confirm that you are executing the entire *.sql file at once, unlike executing query by query? To do this, you need to press the left icon (i.e. the lightning that doesn't contain the scroll symbol):


Looking forward to your answer.
Best,
Martin

Posted on:

09 Mar 2023

0

Hi Martin!


Yes, I tried all the posibilities including selecting everything (CTR+A) and I get the same error. I DROP the database and i uploaded again and I restarted the Workbench also but same thing happend...


The tables are available but all of them are empty.

If you need something else please let me know!


Many thnaks,
Andrei


Posted on:

15 Mar 2023

0

Hello again, 


Any suggestion for me? 

Thank you,

Andrei

Posted on:

21 Mar 2023

0

Hello,


I just wanna let you know that I have installed the latest version of MySQL and MySQL server and now it's working!


Thank you,
Andrei

Instructor
Posted on:

26 Mar 2023

0

Hi Andrei!


Thanks for reaching out and letting us about the solution of your issue, as well as letting us know that you can proceed with the course.


Good luck and please feel free to post another question should you encounter any difficulties. Thank you.
Best,
Martin

Submit an answer