Jump to content
Larry Ullman's Book Forums
KeepLearning

Sql Commands And Sample Data From The Book'S Web Site: How To Use?

Recommended Posts

Can anyone help me get the sample data and SQL commands into Workbench?

 

The book says "You can download the complete SQL commands, along with some sample data, from the account page on the book’s Web site." (Page 64)

 

Are these files for use in MySQL Workbench? If so, how can I get the commands and sample data into Workbench?

 

I have already opened the yii_cms.mwb fil in Workbench, and I can see the visual of the table relationships. But I don't know how to import the data and SQL commands.

 

This is not obvious to me, since Workbench is new for me.

 

I have already downloaded and unzipped these files:

 

 

SQL commands 
MySQL WorkBench file for the CMS site 
Edited Code for the CMS Example 
 
I am using version 0.5 of Larry Ullman's Yii book.
 
I'm on Win XP, with XAMPP and Workbench running. 

 

Any help would be much appreciated.

 

Thanks in advance!

 

Share this post


Link to post
Share on other sites

I figured out part of the process:

 

To import the data, open the Workbench home page, click Server Administration, then Data Import/ Restore, then locate the cms.sql file, etc.

 

But I'm still puzzled by Larry's "cms-code" folder. Should I copy and paste the contents to overwrite any existing files in the "Site Shell" that was started on page 34 with yiic?

 

Also, where can I find the SQL commands? And what should I do with them?

 

Thanks.

Share this post


Link to post
Share on other sites

Personally, here's how I view it:

- The MySQL Workbench file is for those that like to work with MySQL Workbench. You don't have to use it.

- The SQL commands (cms.sql) can be used with MySQL Workbench or any other tool to create and populate your database. 

- I would not copy the cms-code folders to your site, but rather use my code to compare to the code you're writing and editing. Or you can cut and paste as necessary.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...