troubleshooting Question

Importing phpMyAdmin SQL Dump to MS Access or another Windows DB application

Avatar of LeighWardle
LeighWardleFlag for Australia asked on
DatabasesMicrosoft AccessMySQL Server
3 Comments1 Solution1170 ViewsLast Modified:
Hi Experts,

I have some MYSQL data that I have exported to a text file (see sample below).
I am unable to access the MYSQL database that the data is stored in.

Is there some simple way of resurrecting this data in MS Access or another Windows DB application, so I can run some simple queries?

Regards,
Leigh

-- phpMyAdmin SQL Dump
-- version 2.8.2.4
-- http://www.phpmyadmin.net
-- 
-- Host: localhost:3306
-- Generation Time: Jul 15, 2013 at 12:44 PM
-- Server version: 5.0.48
-- PHP Version: 5.2.6
-- 
-- Database: `mincad`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `help_gateway_log`
-- 

CREATE TABLE `help_gateway_log` (
  `strUserNameLoggedIn` varchar(256) NOT NULL,
  `strUserName` varchar(256) NOT NULL,
  `strUserOrganization` varchar(256) NOT NULL,
  `strComputerID` varchar(256) NOT NULL,
  `datetimeStamp` datetime NOT NULL,
  `ndxRecordNumber` int(11) unsigned NOT NULL auto_increment,
  `strProgramNameAndMajorVersion` varchar(12) NOT NULL,
  `sglMajorAndMinorVersion` float unsigned NOT NULL default '5',
  `longProgramBuildDateYYYYMMDD` bigint(20) NOT NULL,
  `intLicenceNumber` bigint(20) NOT NULL,
  `enumLicenceType` enum('Perpetual','Renewable','Evaluation') NOT NULL,
  `datetimeLicenceExpiry` datetime NOT NULL,
  `enumLicenceKeyType` enum('Hardware Lock','Software Lock','None') NOT NULL,
  `intErrorNumber` int(11) NOT NULL,
  `intSecondaryErrorNumber` int(11) NOT NULL,
  `datetimeUsersPCClock` datetime NOT NULL,
  `sglTimeZoneBias` float NOT NULL,
  `strWinVer` varchar(256) NOT NULL,
  UNIQUE KEY `ndxRecordNumber` (`ndxRecordNumber`)
) ENGINE=MyISAM AUTO_INCREMENT=5552 DEFAULT CHARSET=latin1 AUTO_INCREMENT=5552 ;

-- 
-- Dumping data for table `help_gateway_log`
-- 

INSERT INTO `help_gateway_log` (`strUserNameLoggedIn`, `strUserName`, `strUserOrganization`, `strComputerID`, `datetimeStamp`, `ndxRecordNumber`, `strProgramNameAndMajorVersion`, `sglMajorAndMinorVersion`, `longProgramBuildDateYYYYMMDD`, `intLicenceNumber`, `enumLicenceType`, `datetimeLicenceExpiry`, `enumLicenceKeyType`, `intErrorNumber`, `intSecondaryErrorNumber`, `datetimeUsersPCClock`, `sglTimeZoneBias`, `strWinVer`) VALUES ('scottyoung', 'Scott Young', 'Downer EDi Works Pty Ltd', '-82226820', '2010-08-05 11:10:18', 2520, 'CIRCLY5', 0, 20080604, 26880, 'Perpetual', '2099-12-31 00:00:00', 'Hardware Lock', 9501, 3051, '2010-08-05 11:10:17', -11, 'Windows XP 5.1 build 2600 (Service Pack 2)'),
('scottxxxxxx', 'Scott xxxxxxxxxxx', 'xxxxxxxxxxxx', '-82226820', '2010-08-05 09:29:32', 2519, 'CIRCLY5', 0, 20080604, 26880, 'Perpetual', '2099-12-31 00:00:00', 'Hardware Lock', 9501, 3051, '2010-08-05 09:29:31', -11, 'Windows XP 5.1 build 2600 (Service Pack 2)'),
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros