Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools Database Foundations Installing MySQL Server and MySQL Workbench Running a Script and Using MySQL Workbench

Jeff Styles
Jeff Styles
2,784 Points

Can't get script to run...

Due to changes between the version used in the lesson, and the newer one I've used, the setup processes has been pretty rough going. I've managed to get this far but, now this movie db script will not run. I obviously know little about SQL but fear that this script may not be compatible with my version. Is this the case? Can it be modified to work? Thanks.

1 Answer

Andre West
Andre West
2,861 Points

I had the same problems but upto here its actually quite simple. You can go directly to file -> open SQL Script and search for movies_db. It will open and you can hit the lightning icon and run the script. If you hit the minimize/maximize button beside MANAGEMENT in the navigator section on the left, you can right click in the SCHEMAS window , refresh all and see the imported db.

Jeff Styles
Jeff Styles
2,784 Points

Thanks Andre. However, I had been following the instructions for running the script exactly, but every time I would hit the lightening icon it produced a spinning/loading symbol, the workbench would hang and finally have to be forced quit. I did some googling and apparently this is common problem - the newest version of WB has a bug. I tried progressively older versions until 6.1, which works perfectly. Thanks for the response!