|
Custom Search
| |
|
Inside This Article
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 free Community Edition is a MySQL query analyzing tool. 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.
Step #1: Unzip the downloaded northwind-sql.zip to your Desptop. 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 © 2024 GeeksEngine.com. All Rights Reserved. This website is hosted by HostGator. No portion may be reproduced without my written permission. Software and hardware names mentioned on this site are registered trademarks of their respective companies. Should any right be infringed, it is totally unintentional. Drop me an email and I will promptly and gladly rectify it. |
Home | Feedback | Terms of Use | Privacy Policy |