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 server
2. 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.