MySQL Forums
Forum List  »  Newbie

Re: Migrating MySql from Debian to Windows
Posted by: Barry Galbraith
Date: June 04, 2014 11:49PM

>I would like to import them into Microsoft Access if that is possible
Possible, but NOT for the feint of heart.

First you need to install MySQL server on your windows machine, preferably the same version as what was installed on you Debian machine.
Once you have it up and running and stable, stop the MySQL server, and copy all of the /data folder from the old Debian disk, except /data/mysql to the \data folder on your windows machine.
Start the mysql server on your windows machine, and if you are lucky, your tables will be there.
If you install MySQL Workbench on you Windows machine, along with MySQL server, You should be able to see your tables/data.
You will then need to download and install a mysql ODBC connector to make connection from Access to MySQL.
Start Access, and open the ODBC connection to MySQL to see your tables.
You will then need to do whatever it takes to pull your tables from MySQL using Access.
Then you need to build yourself your GUI application in Access to use your data.

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: Migrating MySql from Debian to Windows
June 04, 2014 11:49PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.