?
Solved

Sample MySQL database

Posted on 2013-01-26
7
Medium Priority
?
253 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 83

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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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 83

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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
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

770 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