?
Solved

Sample MySQL database

Posted on 2013-01-26
7
Medium Priority
?
267 Views
Last Modified: 2013-02-10
Similar to Northwind.mdb database in MS Access, I hope MySQL also has a sample populated database for testing or some other learning practices.

I want to test some php search codes in such a database in MySQL.

Question: Do you know of a MySQL database with data in it for this use?

If it does, how can I get hold of it?


Thank you.
0
Comment
Question by:Mike Eghtebas
7 Comments
 
LVL 84

Expert Comment

by:Dave Baldwin
ID: 38822946
0
 
LVL 5

Expert Comment

by:Devario Johnson
ID: 38823527
If you have php my admin you can create a database and populate it with whatever data you want.

Php My Admin
0
 
LVL 11

Expert Comment

by:mcnute
ID: 38823969
Xampp installs you a fully functional local webserver with apache httpd, mysql-server, phpmyadmin, ftp, and many more. Ideal to test locally.

http://www.apachefriends.org/de/xampp.html
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 34

Author Comment

by:Mike Eghtebas
ID: 38871907
Hi devarioj,

Yes I have Php My Admin, what I am looking for is a sample database with lots of data in it. This way, I can focus on my search application part. I want to avoid creating and populating a database.

For example, MS Access has Northwind.mdb for a similar purpose. Is there anything like this for MySQL?

Thank you.
0
 
LVL 84

Accepted Solution

by:
Dave Baldwin earned 2000 total points
ID: 38871926
The 'employees' database at http://dev.mysql.com/doc/index-other.html is 160MB with 4 million records.
0
 
LVL 34

Author Comment

by:Mike Eghtebas
ID: 38873488
Hi Dave,

Yes this is what I need. Currently, I don't have access to my computer with MySQL installed (so I cannot check it); is 'employees' database included in the typical MySQL installation? Or, I have to download and install it myself. If so how.

Meanwhile, I am reading more at  http://dev.mysql.com/doc/index-other.html to figure out more about it.

FYI, I am working in windows 7 in case you want give pointers (code) to install it after download.

Thanks,

Mike
0
 
LVL 34

Author Closing Comment

by:Mike Eghtebas
ID: 38873518
Thank you
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
Suggested Courses
Course of the Month16 days, 1 hour left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question