Steve,You want to download the Sakila database for MySQL. Install and download details are available at:http://dev.mysql.com/doc/sakila/en/sakila.htmlI assume you have already installed MySQL. If not, you can download the community edition from:http://dev.mysql.com/downloads/mysql/Linda
Steve,You can do this from within the Toad client, although at some point you will need to know what the password actually is. If you didn't set anything, it may still have a blank root password.If you need to reset the root password, follow the instructions in the manual at:http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.htmlYou can open the Sakila SQL files in the Toad Editor and press F5 to run the entire script in one go. Make sure you run the schema script first, then the data script.Linda
how do you open the command line from the toad client?There's an editor...but it can't seem to take any commands...I tried to open a connection...it requires user name and password... wrote somethin' there... nothing is working...so...anyone can tell me step by step how this actually works?
I'm going under the assumption that you have the database already in hand from Linda's source.You don't need to open any MySQL command line. The purpose of having Toad is to replace the command line with a more simple GUI tool.1. You need to first create a connection from Toad to MySQL. Click on the Create new connection button in the Connection Manager. You need to enter "host", "username", and "password". You can leave everything else alone. (the "host" is the machine running the MySQL server. If this is your local machine, then leave it as "localhost"). The click connect. This will establish a connection to MySQL server2. Once the step 1 is done, Click on the Open File button and open your SQL file. I'm giong under the assumption that you have some filename.sql. From the sound of thing, you have one for the schema (which is basically the structure of the database), and second file for the data. Open the schema file first.3. This should open an editor with bunch of SQL commands. You need to run all the commands. You can run them all at once by pressing the F5 key.4. Once step 3 is done, repeat step 2 and 3 with the data file.At this point you should have the database with data loaded.Now if you want to run some SQL commands, you first want to open an Editor. Click on the button that says "Edit SQL". This will open a new window. Enter any commands in the editor. You can run the command by pressing the F5 or F9.