Hi, is there a simple way to generate an SQL dump from a Base program?
I am running Libreoffice 6.3 on Windows and/or Lubuntu1604, and from the .odb file would like to generate an SQL dump, that I can then feed into another database. Below an example of a similar dump from an MS Access file:
CREATE DATABASE IF NOT EXISTS `movedb`;
USE `movedb`;
#
# Table structure for table 'tbl_106'
#
DROP TABLE IF EXISTS `tbl_106`;
CREATE TABLE `tbl_106` (
`ID` INTEGER NOT NULL AUTO_INCREMENT,
`VOL` INTEGER,
`REC` INTEGER DEFAULT 0,
`PAG` INTEGER DEFAULT 0,
`INDX` VARCHAR(50),
`FOTO` INTEGER DEFAULT 0,
`FOTOLINK` LONGTEXT,
`ANNO` INTEGER,
`DATAIMMAGINE` DATETIME,
`TIPO` VARCHAR(50),
`CHIESA` VARCHAR(50),
`DA` INTEGER DEFAULT 0,
`A` INTEGER DEFAULT 0,
PRIMARY KEY (`ID`)
) ENGINE=myisam DEFAULT CHARSET=utf8;
#
# Dumping data for table 'tbl_106'
#
INSERT INTO `tbl_106` (`ID`, `VOL`, `REC`, `PAG`, `INDX`, `FOTO`, `FOTOLINK`, `ANNO`, `DATAIMMAGINE`, `TIPO`, `CHIESA`, `DA`, `A`) VALUES (413, 106, NULL, 1, NULL, 5417, 'cataldo106_001_5417#C:\\d\\access\\erice casa sales 2019/vol 106/cataldo106_001_5417.PAG 01.jpg#', 1675, '2019-08-24 00:00:00', 'Matrimoni', 'S.Cataldo', 1675, 1686);