views:

2044

answers:

6

I'm doing some inter-database operational research... e.g. synchronizing Oracle, MySQL, etc.

Are there any nice MySQL databases that I can download, so that I can test some importing on real-world cases? I'm thinking of some open project that might have a weekly data dump available for download.

Of course, anything similar for Oracle, Sql Server, etc is welcome as well.

Many TIA!

+3  A: 

There are some example databases at http://dev.mysql.com/doc/

kokos
@Mark Harrisonall, @kokos: I could only find reference manuals on this page. Where are the sample databases? Have they been moved?
Lazer
+1  A: 

I was going to suggest download.wikimedia.org but on looking, it seems they don't offer mysql dumps anymore, just the xml format. I can't think of any other projects off the top of my head that might offer raw data downloads.

You may want to clarify what format you're looking for. Do you want the typical tab-delimited ASCII dump, or do you want the actual table files? Or something else?

Greg Hewgill
+1  A: 

If you want some big data sets, try some of the Wikipedia dumps. You can also go straight to the Wikimedia dump page. There are a lot of files in XML form, but a lot are available in raw SQL form.

The first link also has some instructions on how to use the dumps; parsing, importing int MySQL, etc.

Here's a link straight to the wikipedia dumps: http://download.wikimedia.org/enwiki/. Click any date and you'll find a lot of data in both XML and SQL form.

Derek Park
A: 

@Greg: I'm experimenting the import tools Oracle SQL Developer, specifically the MySQL module. So it's not particularly important the format, so long as I can get it into MySQL, but the less work to import the better.

Thanks!

Mark Harrison
+1  A: 

It might be worth taking a peek at The Library of Free Data Models. The times I've used stuff from there, I just took the diagram and created the database myself, making the modifications I needed, but I know you can request schema dumps from him as well.

J Wynia
+1  A: 

Paul Dubois has some sample databases in his website (used with his MySQL 3rd Edition and MySQL cookbook)

http://www.kitebird.com/mysql-book/

http://www.kitebird.com/mysql-cookbook/downloads-2ed.php

Imran