Is there a "Northwind" type database available for MySQL? [closed]

Question

I need some test data for a MySQL utility that I am creating. Does anybody know where I can find one that has a similiar (if not more) amount of data as Northwind for SQL Server?

Nadiya

And yes... I tried Googling for "mysql test database"... (rolls eyes) – Nadiya

I use a WordPress database and populate with dummy instead. – Sil

@rock I would prefer a more business-related schema, with dollar amounts, percentages, averages, etc. And of course, I don't have the time (nor the patience) to manually populate. – Nadiya

Answer 1

UPDATE:

This is an answer for about 4 years ago and links were dead because of time, I'll put new links as soon as I find some.

---

1- FlightStats

2- MySql Version of NW schema (InnoDB)

3- MySql Version of NW schema (MyISAM)

4- more info

and a suggestion from mindplay.dk:

5- Northwind (schema+data, as provided by mnk below)

Kenna

The FlightStats link seems to be dead. Anywhere else where it can be found? – Beaming

@NickJ This answer for about 4 years ago. I'll find new links asap. – Kenna

Answer 2

Here's a version of Northwind for MySQL on GitHub. The column names have been slightly altered to fit the MySQL standard.

https://github.com/dalers/mywind

Dejong

Answer 3

You may download it from here: http://dev.wavemaker.com/forums/?q=node/4721

Emporium

Link is dead... – Jackfish

Answer 4

One option would be to export the actual Northwind DB to MySQL. http://www.geeksengine.com/article/export-access-to-mysql.html

FlightStats seems to be another one you could use: http://flightstats.us/about.php

The purpose of this application is to demonstrate MySQL 4.1 and some of its new and more advanced features. As MySQL matures, it is the hope that this application will also mature. Currently, the following features are used in some meaningful way:

• Joins
• Subqueries
• Subqueries in the FROM clause
• Query cache

Tusche

Answer 5

I have tested quite all the dumps available in this thread with latest MariaDB but all of them were returning warnings or errors

searching out there I have found this

http://www.dotnettwitter.com/2011/05/northwind-database-scripts-for-sql.html

UPDATED LINK https://www.zentut.com/sql-tutorial/sql-sample-database/ (see at bottom)

ANOTHER LINK https://www.sourcecodester.com/sql/12809/3-sql-version-northwind-database.html (use blue download button in the page)

so far this is the unique Northwind for MariaDB MySQL that works like a charm

no errors, no warnings,

I link it since it is not listed in this thread

Harter

I too have had a number of issues with the other DBs in the the other answers, so I was hoping that this dump would work. However, unfortunately, the link seems to be dead? – Jackfish

Added an updated link. Please remeber to vote – Harter

The new link is the same as this answer. Is that the DB that the original links pointed to? I've found that the MyWInd doesn't exactly match the NorthWind DB, at least not the same as the DB used in these w3Schools examples, although I'm starting to think that maybe those examples are out of date anyway. – Jackfish

@Jackfish see new link, and remember to vote – Harter

Answer 6

Yes. Can be found here, for instance.

Koffman

Answer 7

There is a sample database provided by MySQL: https://dev.mysql.com/doc/employee/en/index.html

Scipio

Answer 8

There's a link at the beginning of the article where you can grab an SQL script with structure and data:

http://www.geeksengine.com/article/export-access-to-mysql.html

Katanga

Answer 9

I know this question is from a long time ago, but I needed specifically Northwind on MySQL a while ago. So I migrated the structure and data on the current version of Northwind in Codeplex to MySQL.

In case anyone else needs it, it can be found here

Anthodium

The second link is dead – Jackfish