Solved

Sample MySQL database

Posted on 2013-01-26
7
233 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
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
This article discusses four methods for overlaying images in a container on a web page
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

911 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now