Skip to main content

Posts

Showing posts with the label mysql

Using Docker Container for MySQL Service

Problem Suppose you are working on a project that relies on Mysql service but you do not want to install MySQL to your system. Using a Docker image can be a good solution. Remember that you can use many services through Docker containers. Steps 1- Install docker  Docker Community Edition can be freely downloaded from the  official page. It requires registration. https://www.docker.com/community-edition Install docker image. It may require a restart, if it does, do so. In case any problems occur that prevent Docker for Windows from starting check trouble shooting page. https://docs.docker.com/docker-for-windows/troubleshoot/ In Windows 10, hypervisor launch type needs to be "auto".  In order to check current status bcdedit command can be used via PowerShell (Administrator Mode). In order to set to "auto" following command can be used. bcdedit /set hypervisorlaunchtype auto 2- Find the Relevant Container Go to  Docker Store . Type M...

Exporting MS Access to MySQL

To export an access database ( mda  file) to  MySQL  database is quiet easy. All needed is to download 32 bit  MySQL Connector/ODBC  driver  from  http://dev.mysql.com/downloads/connector/odbc/  and follow steps below. 1-      Select the table to export. 2-      From  External Data  tab select  ODBC Database . See picture below. Picture  1  ODBC Database Export 3-        Specify table name to export onto. Typically the same name as the access table name. 4-         From  Select Data Source  dialog select  Machine Data Source  tab and click  new. Picture  2  MySql OBDC Driver 5-        Select  MySQL Connector/ODBC  driver   from list. Click OK.   6-        Specify co...