Custom Search
 


How to export Northwind Access database to MySQL


Inside This Article
1Export Northwind Access database to MySQL via ODBC
2Make northwind a true relational database in MySQL
3. Restore northwind database from SQL dump
   
4Northwind database schema
5Implement 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 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.

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...

Restore northwind mysql database step 3

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

Restore northwind mysql database step 4

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

Restore northwind mysql database step 5

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
1Export Northwind Access database to MySQL via ODBC
2Make northwind a true relational database in MySQL
3. Restore northwind database from SQL dump
   
4Northwind database schema
5Implement 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 Database SQL category:

1.Get single records when duplicate records exist
2.Find duplicate values or non-duplicate values in a table
3.How to get Top 1 record from Oracle by using PL/SQL
4.How to get Top N rows from Oracle by using SQL
5.How the data types in Access Northwind are converted to Oracle
6.How to do cross table update in Oracle
7.Export Northwind Access database to MySQL via ODBC

Copyright © 2017 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