Mark Harrison Mark Harrison - 1 year ago 116
MySQL Question

any sample MySQL databases I can download?

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.

Answer Source

There are some example databases at: MySQL Documentation

Or more specifically on: Other MySQL Documentation

Examples of DB's — MySQL


  • Download .zip file, unarchive it and put into (for ease): C:\

  • Open CMD.exe with admin. priveleges and write:

If relative path: mysql -uuser -ppassword < C:\database.sql

If full path: C:\path_to_your_directory_mysql\bin\mysql -uuser -ppassword < C:\database.sql

E. g.: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql -uroot -pp@ssw0rd < C:\world.sql

  • Complete. DB loaded. Log in MySQL and write: SHOW databases;

Files are here: C:\Program Files\MySQL\MySQL Server 5.7\data

Reference: Reloading SQL-Format Backups

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download