Inside This Article

1.  Export Northwind Access database to MySQL via ODBC 2.  Make northwind a true relational database in MySQL 3.  Restore northwind database from SQL dump

4.  Northwind database schema 5.  Implement file directory based image management

Restore northwind database from SQL dump




On previous page of this article, we have gone thru quite a bit in details to explain how to convert our original, plain vanilla northwind MySQL database into a true relational MySQL database. Now, if you haven't followed each step and manually implemented the conversion by yourself, you can download the finished version into MySQL. This process is called restore a database.

Download northwind SQL database script if you haven't done so.

Use SQLyog to restore northwind in MySQL SQLyog is an open-source software. Its functionalities are very similar to those in Microsoft SQL Server Query Analyzer. When I first started to use MySQL server five years ago, I used command based SQL for various database operations on Windows and that was not fun. At that time, Microsoft SQL Server Query Analyzer was already a popular client tool which I hoped there was a similar one for MySQL. I searched and tried a few client tools for MySQL and finally settled down with SQLyog. Over the years, SQLyog is just getting better and better.

Step #1: Unzip the downloaded northwind-sql.zip to your Desptop.

After unzip, northwind.sql normally is in this directory C:\Documents and Settings\Desktop\northwind\northwind.sql

Step #2: Open and log into SQLyog.

Step #3: On the menu bar across the top, click Tools -> Restore From SQL Dump...



Step #4: When the restore window is opened, select northwind.sql from the unzipped file on your Desktop.



Step #5: Click Execute to restored from the dump.

Things to note when restoring northwind 1. The restore works on MySQL version 5.0 or greater because I included character set and collation information in varchar and text columns.

2. If you have already got northwind database set up in your mysql server, you need to remove it before restore this downloaded one.

Next page shows the generated Northwind database schema. It was automatically generated by SQLyog.

Copyright© GeeksEngine.com

Inside This Article 1.  Export Northwind Access database to MySQL via ODBC 2.  Make northwind a true relational database in MySQL 3.  Restore northwind database from SQL dump     4.  Northwind database schema 5.  Implement file directory based image management Related Articles: 1. How to set up MySQL DSN in ODBC Data Source Administrator on Windows 2. How to install MySQL server 4.1 on Windows with screenshots 3. How to configure MySQL server 4.1 on Windows 4. How to install two different versions of MySQL server on the same PC 5. How to Connect to a MySQL Database from PHP Other Recent Articles from the WAMP & LAMP category: 1. How to upgrade from PHP4 to PHP5 2. How to load time zone data for MySQL on Windows 3. How to use Apache Virtual Host to run multiple local websites on Windows 4. How to install PEAR on your shared web hosting account 5. How to install PEAR on Windows 6. How to use PHP and Microsoft SMTP Virtual Server to send emails on Windows 7. How to install PHP on Windows as part of WAMP installation 8. Step by step guide on how to install Apache web server on Windows 9. How to install two different versions of MySQL server on the same PC 10. How to configure MySQL server 4.1 on Windows