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. Steps to install PHP 5.x on Windows as a development machine 2. How to install Apache 2.x web server on Windows 3. How to connect two different versions of MySQL server on the same computer 4. How to configure MySQL server 5.1 on Windows 5. How to install MySQL server 5.1 on Windows with screenshots 6. Five ways to create include path for PHP 7. How to use Date and Time data as integer value in PHP and MySQL 8. How to use Apache Virtual Host to run multiple local websites on Windows 9. Install all PEAR packages by yourself 10. How to install PEAR on Windows 11. How to use PHP and Microsoft SMTP Virtual Server to send emails 12. How to install PHP server-side scripting language on Windows 13. How to install Apache 1.3 web server on Windows 14. How to install two different versions of MySQL server on the same PC 15. How to configure MySQL server 4.1 on Windows 16. How to install MySQL server 4.1 on Windows with screenshots 17. Export Northwind Access database to MySQL via ODBC Other Recent Articles from the WAMP & LAMP category: 1. Steps to install PHP 5.x on Windows as a development machine 2. How to install Apache 2.x web server on Windows 3. How to connect two different versions of MySQL server on the same computer 4. How to configure MySQL server 5.1 on Windows 5. How to install MySQL server 5.1 on Windows with screenshots 6. How to upgrade from PHP4 to PHP5 7. How to load time zone data for MySQL on Windows 8. How to use Apache Virtual Host to run multiple local websites on Windows 9. Install all PEAR packages by yourself 10. How to install PEAR on Windows 11. How to use PHP and Microsoft SMTP Virtual Server to send emails 12. How to install PHP server-side scripting language on Windows 13. How to install Apache 1.3 web server on Windows 14. How to install two different versions of MySQL server on the same PC 15. How to configure MySQL server 4.1 on Windows 16. How to install MySQL server 4.1 on Windows with screenshots 17. How to set up DSN in ODBC Data Source Administrator on Windows 18. Export Northwind Access database to MySQL via ODBC