sample mysql database

[alaios]

Hi i need a sample mysql database with many tables and fields. I prefer a database that contains bunch of texts in order to make extended use of mysql extended search capabilities...
Thx

[Basscyst]

Does it have to be MySQL? Because I think if you have access installed it comes with some sample DB's, you could try exporting them to MySQL.

Basscyst

[alaios]

I prefer a .sql file (mysql compatible) in order to use mysqldump command easily.

[Tangerine Dream]

Hi i need a sample mysql database with many tables and fields. I prefer a database that contains bunch of texts in order to make extended use of mysql extended search capabilities...
Hi, check World Database (http://dev.mysql.com/doc/world-setup.html) (dump file). If you find other sample MySQL databases, please post links in here

[alaios]

Thx a lot.... i need something like that... but i want to be bigger with more tables and data entries.. Do u have something else in mind?

[Tangerine Dream]

Thx a lot.... i need something like that... but i want to be bigger with more tables and data entries..
How many tables, average count of columns and rows per table, also what types and how many relationships do you need? Note that you may also generate test data by yourown using appropriate testing/stress or CASE tools. Also you may find other non-MySQL databases (MSSQL, Oracle, Access, etc.) and quite easily convert them to MySQL one. Check MySQL Migration Toolkit (http://dev.mysql.com/downloads/migration-toolkit/1.0.html). Don't forget to post links if you find such big databases 'cause this can be very useful for other people

Do u have something else in mind?
My production databases only which i also use for benchmarking, but they store sensitive data, so i can't give them to somebody else. Sorry :)

[alaios]

DFo u know any stress/case programme to test my database... Basically i need a table that contains big chunks of text in order to test full-text-search capabiities..

[Tangerine Dream]

You may want to try the following tools that support MySQL server and have trial/evaluation versions:

Upscene' Advanced Data Generator - MySQL Edition (http://www.upscene.com/products/adg/adg.htm#mysql)
EMS MySQL Data Generator (http://www.sqlmanager.net/products/mysql/datagenerator)
TurboData's Test Data Generator (http://www.turbodata.ca/overview02.htm)

Don't forget to post your feedback whether you found some of them suitable for your task :)

[alaios]

thx a lot...but these are demos... do u have something that is free like air?

[Tangerine Dream]

If i find tools for free, i'll post links in here immediately. Why don't you want to try trial versions of the above tools? Maybe they produce some data suitable enough for your needs

[cinepro]

There's a good db here:

http://www.eclipse.org/birt/db/

[Firmbyte]

there are 3 sample DB's hee: http://dev.mysql.com/doc/
(bottom of page)