mysql/
  build-mysql.pl      # build mySQL database from (SQL commands generated from *.MDB)

cygwin/
  m           # - call mdb.py (Python code in Windows XP)
              #   to generate rb.sql from *.MDB (Microsoft Access database)
              # - ssh to server and run build-mysql.pl Perl code in Unix
              #   to load mySQL database
  mysql       # rb.sql is generated by Python code in Windows XP (called/timed by m above)

--python/
    mdb.py            # (Python code in Windows XP) converts *.MDB to mySQL via DAO

# --------------------------------------------------- Sun 14:59:46, 2005-11-20 -----------------
# ---------- MDB-to-mySQL 1.0 SQL IMPORT FROM `C:\robert\python\mysql\robertbody.mdb` ----------
# ----------------------------------------------------------------------------------------------

# ------ TABLE `Groups` ------
DROP TABLE IF EXISTS `Groups`;

CREATE TABLE `Groups` (
        `Count` INT NULL DEFAULT 0, 
        `Name` VARCHAR(50) NULL, 
        `Directory` VARCHAR(50) NULL, 
        `Filename` VARCHAR(50) NULL, 
        `Category` VARCHAR(50) NULL, 
        `done` VARCHAR(50) NULL, 
        `notes` VARCHAR(50) NULL,
        PRIMARY KEY (`Name`)
) TYPE=MyISAM;

INSERT INTO `Groups` (`Count`, `Name`, `Directory`, `Filename`, `Category`, `done`, `notes`) VALUES
  ("1", "Animals", "animals", "previews.html", "People-Animals", "2005/04/24-uploaded 4/25", "export");
      

# ---------- MdbToMySQL XP 0.9 MySQL IMPORT FROM `C:\robert\db\robertbody.mdb` ----------


# --- DROP TABLE `Table1` BEFORE (RE)CREATION 
DROP TABLE IF EXISTS `Table1`;
        
# ---------- CREATE TABLE `Table1` ----------
CREATE TABLE `Table1` (
        `Id` INT NOT NULL AUTO_INCREMENT,
        `Dir_Num` DOUBLE NULL,
        `Filename` VARCHAR(255) NULL,
        `Oldname` VARCHAR(50) NULL,
        `Oldname2` VARCHAR(50) NULL,
        `Directory` VARCHAR(255) NULL,
        `Location` VARCHAR(50) NULL,
        `Location2` VARCHAR(50) NULL,
        `Location3` VARCHAR(50) NULL,
        `Subject` VARCHAR(50) NULL,
        `Group_1` VARCHAR(255) NULL,
        `Subgroup` VARCHAR(50) NULL,
        `G2` VARCHAR(255) NULL,
        `G3` VARCHAR(255) NULL,
        `Description` VARCHAR(255) NULL,
        `Keywords` VARCHAR(255) NULL,
        `Picturename` VARCHAR(255) NULL,
        PRIMARY KEY (`Id`),
        KEY `Id` (`Id`),
        KEY `Keywords` (`Keywords`)
) TYPE=MyISAM;

# ---------- EMPTY TABLE `Table1` ----------
DELETE FROM `Table1`;

# ---------- POPUPLATE TABLE `Table1` ----------
INSERT INTO `Table1` (`Id`, `Dir_Num`, `Filename`, `Oldname`, `Oldname2`, `Directory`, `Location`, `Location2`, `Location3`, 
`Subject`, `Group_1`, `Subgroup`, `G2`, `G3`, `Description`, `Keywords`, `Picturename`) 
VALUES (2, 77, '1970s-me-dievcatko', 'me-dievcatko', NULL, 'me', NULL, 'Kosice', 'Slovakia', NULL, 'Me', NULL, NULL, NULL, 
'early years of dating \x85 Slovakia \x851970\'s', NULL, NULL);    it even "escapes" characters like & and ' 
                "dating ... Slovakia ... 1970's" is the right text, and \0x85 = "..." 
...

should check first if table exists (easy fix)
DROP TABLE Table1;                 
CREATE TABLE Table1
 (    AutoNumber, Increment, _PRIMARY KEY_ ??
        Id          Long Integer,           
        Dir_Num     Double, 
        Filename            Text (510),      
        Oldname     Text (100), double original ?
        Oldname2            Text (100), 
        Directory           Text (510), 
        Location            Text (100), 
        Location2           Text (100), 
        Location3           Text (100), 
        Subject     Text (100), 
        Group       Text (510), 
        Subgroup            Text (100), 
        G2          Text (510), 
        G3          Text (510), 
        Description         Text (510), 
        Keywords            Text (510), 
        Picturename         Text (510)
);          NO primary key specified


separate executables for schema above, and data below .... but not hard to fix with access to code
INSERT INTO Table1 (Id, Dir_Num, Filename, Oldname, Oldname2, Directory, Location, Location2, Location3, 
Subject, Group, Subgroup, G2, G3, Description, Keywords, Picturename) 
VALUES (2,77,"1970s-me-dievcatko","me-dievcatko",NULL,"me",NULL,"Kosice","Slovakia",NULL,"Me",NULL,NULL,NULL,
"early years of dating & Slovakia & 1970's",NULL,NULL)
             "dating ... Slovakia ... 1970's" is the right text, and here stored as "&" (wrong)
...

create table `Table1`(
    `Id` Counter not null ,
    `Dir_Num` Double ,
    `Filename` varchar(255) ,
    `Oldname` varchar(50) ,
    `Oldname2` varchar(50) ,
    `Directory` varchar(255) ,
    `Location` varchar(50) ,
    `Location2` varchar(50) ,
    `Location3` varchar(50) ,
    `Subject` varchar(50) ,
    `Group` varchar(255) ,
    `Subgroup` varchar(50) ,
    `G2` varchar(255) ,
    `G3` varchar(255) ,
    `Description` varchar(255) ,
    `Keywords` varchar(255) ,
    `Picturename` varchar(255) ,
    primary key `Id`
);

no data output :(