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.
There are some example databases at: MySQL Documentation
Or more specifically on: Other MySQL Documentation
Download .zip file, unarchive it and put into (for ease):
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
C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql -uroot -pp@ssw0rd < C:\world.sql
Files are here:
C:\Program Files\MySQL\MySQL Server 5.7\data
Reference: Reloading SQL-Format Backups