How would I go about installing the Sakila database onto my Mac?
I've used the comment by user dr01 in this post, but I'm not sure if I'm ready to use it or not. The Sakila file I downloaded has 3 files (sakila-data.sql, sakila-schema.sql,sakila.mwb) but I only used the schema file while importing it into Workbench. Thanks.
Dec 17, 2011 - Hi All, A family members PC was held hostage by malware, I advised the run MWB, which they did and they could access the net again, but all. Nov 15, 2016 how to Install Photoshop Cs6 with seriel key. How to find the activation code, serial key of any software - must watch any software activate - Duration: 3:57. Larkon Ki Dunya 339,957 views.
Kelvin8716
Kelvin8716Kelvin8716
1 Answer
Pretty simple: the Sakila DB is so small you can just run the 2 SQL files in Workbench:
- Download the sakila dump from https://dev.mysql.com/doc/index-other.html.
- Open a connection to your server in MySQL Workbench, where you want to load Sakila.
- In the SQL editor toolbar there's a button to load a file. Click that and select
sakila-schema.sql
. - Once loaded you just execute the full editor content. This is for the DB structure.
- Now load the content by opening the
sakila-data.sql
script. Again, execute the entire editor.
Now refresh the schema tree by clicking on the small refresh icon
and you should see the Sakila schema in the tree. That's it.
Mike LischkeMike Lischke23.1k33 gold badges6161 silver badges109109 bronze badges
Not the answer you're looking for? Browse other questions tagged mysqlmysql-workbenchworkbench or ask your own question.
MWB File Summary
Most MWB files can be viewed with MySQL Workbench from Oracle Corporation (the only known affiliated software application) and associated with the MySQL Workbench Document format as it's primary file type. These files can be categorized as Database Files.
File Extension MWB files have been identified on both desktop and mobile devices. They are fully or partially supported by Windows, Mac, and Linux. The MWB File Extension carries a Popularity Rating of 'Low', meaning that these files are scarcely found in most user's file stores.
Please see the detailed information below to learn more about MWB files and the programs that can open them. In addition, we provide simple troubleshooting information to help you open your MWB file.
Open your files in %%os%% with FileViewPro File Viewer
Optional Offer for FileViewPro by Solvusoft | EULA | Privacy Policy | Terms | Uninstall
File Type Popularity
File Rank
/ 11690