Examples

The example below shows the actual result of a dumped SharePoint list.

To import the SharePoint list into MySQL simply import the generated .sql file or copy paste the result into a MySQL Console and execute.

-- Sharepoint MySQL dump
-- Dump created: 2010-09-28 23:14:21

--
-- Using database `sharepoint`
--

CREATE DATABASE IF NOT EXISTS `sharepoint`;
USE `sharepoint`;

--
-- Table structure for table `Colors`
--

DROP TABLE IF EXISTS `Colors`;
CREATE TABLE `Colors` (
`ID` int(11) PRIMARY KEY,
`LinkTitle` text,
`HexColor` varchar(6),
`Color Description` varchar(255),
`MyURL` text,
`Modified` datetime,
`DateColumn` datetime,
`ColorCost` double,
`UserField` text,
`ContentType` text,
`Attachments` int(11),
`BOOL` boolean,
`INT` int(11)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Colors`
--

LOCK TABLES `Colors` WRITE;
INSERT INTO `Colors` SET
 `ID` = 1,
 `LinkTitle` = 'Red',
 `HexColor` = 'ff0000',
 `Color Description` = 'Red color it is',
 `MyURL` = 'http://www.red.com, http://www.red.com',
 `Modified` = '2010-09-15 01:30:12',
 `DateColumn` = NULL,
 `ColorCost` = 78.89,
 `UserField` = '12,16',
 `ContentType` = 'Item',
 `Attachments` = 1,
 `BOOL` = 1,
 `INT` = NULL;
INSERT INTO `Colors` SET
 `ID` = 2,
 `LinkTitle` = 'Black',
 `HexColor` = '000000',
 `Color Description` = 'Black color it is - yes',
 `MyURL` = '',
 `Modified` = '2010-09-23 22:54:54',
 `DateColumn` = '2010-05-05 00:00:00',
 `ColorCost` = 94,
 `UserField` = '15,16',
 `ContentType` = 'Item',
 `Attachments` = 1,
 `BOOL` = 0,
 `INT` = NULL;
UNLOCK TABLES;
Visa     MasterCard