asked on

Sample MySQL database

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.

Dave Baldwin

Here: http://dev.mysql.com/doc/index-other.html

Devario Johnson

If you have php my admin you can create a database and populate it with whatever data you want.

Php My Admin

mcnute

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

Mike Eghtebas

ASKER

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.

ASKER CERTIFIED SOLUTION

Dave Baldwin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mike Eghtebas

ASKER

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

Mike Eghtebas

ASKER

Thank you