Solved

Sample MySQL database

Posted on 2013-01-26
7
237 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 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 33

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 500 total points
ID: 38871926
The 'employees' database at http://dev.mysql.com/doc/index-other.html is 160MB with 4 million records.
0
 
LVL 33

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 33

Author Closing Comment

by:Mike Eghtebas
ID: 38873518
Thank you
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

810 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