Sample dB
TerenceD
I have just installed Sequel Pro & MAMP on my Mac. I would like to
look at a sample dB. Can anyone point me at one to download and
examine?
I am a basic user with a little experience from Filemaker Pro and the
little brother Bento ( Mac & iPhone ).
I could export a filemaker/bento dB and import it I suppose, but I do
not know yet if that is a recommended way to start or if the field
types would be more of a hassle coming from a .CSV or .TAB file.
I have access to Lynda.com Sql training an opinions as to the quality
of those offerings?
Terence
matt langtree
You can try out the MySQL supplied sample database from this page:
http://dev.mysql.com/doc/index-other.html
The direct download link is:
http://downloads.mysql.com/docs/sakila-db.zip
---
The steps for importing the database are as follows:
Make the connection to your local MAMP server (Can I assume you've got
this working already? If not, have a look here:
http://www.sequelpro.com/docs/Connecting_to_MAMP_or_XAMPP ).
After you've connected, choose "Add Database..." from the Database
menu in Sequel Pro.
Enter the database called "sakila".
Then, choose File > "Import ..." and navigate to the sakila_db folder
that Safari unzipped when you downloaded the above file. Choose sakila-
schema.sql first and click Import.
Note: Sometimes the import throws up some errors, I'm not sure who's
at fault here, but if you get a list of tables in the sidebar, then
it's worked.
Repeat the import process for sakila-data.sql.
You're done. Let me know if you run into any trouble, or if I haven't
explained myself properly.
Cheers,
Matt Langtree