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
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
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
Hello again,
Any suggestion for me?
Thank you,
Andrei
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
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