On 7 Aug 2019, at 9:16pm, Thomas Kurz wrote:
> Well, that's why I asked for an *import* support. It's widely spread practice
> to offer at least import capabilities from other software.
This is what the .import function in SQLite's shell tool is for. It reads a
well-documented text format.
Wednesday, August 07, 2019, 9:16:17 PM, Thomas Kurz
wrote:
>> I highly doubt the SQLite team will undertake this task. They
>> Surely have the skill to do so, but their priority is the one
>> software product you desire to use, undoubtedly due to its
>> high utility. I doubt that utility would
> I highly doubt the SQLite team will undertake this task. They
> Surely have the skill to do so, but their priority is the one
> software product you desire to use, undoubtedly due to its
> high utility. I doubt that utility would exist if they were
> to wander off tacking the conversion
Mr. Kurz writes:
> I suppose I am not the only one having to convert between
> MySQL/MariaDB and SQLite databases every now and then. I
> know there are converters for MySQL dumps but none of any
> I have ever tried did work nearly reliable.
If you dislike the available converters and do not wish
The BIGGEST problem I had with importing data from MySQL to SQLite is the
table definitions.
If you do two dumps, one specifically for table definitions, the other for
the actual data to be imported, you could get a script to handle the table
definition file to make it conform to what SQLite can
archar(50) not null
END TRANSACTION;
- Original Message -
From: Simon Slavin
To: SQLite mailing list
Sent: Wednesday, August 7, 2019, 18:25:45
Subject: [sqlite] Feature request: import MySQL dumps in CLI
On 7 Aug 2019, at 5:13pm, Thomas Kurz wrote:
> So my suggestion would
On 7 Aug 2019, at 5:13pm, Thomas Kurz wrote:
> So my suggestion would be to add an import feature to the CLI that allows to
> directly import MySQL/MariaDB dumps into an SQLite database keeping as many
> information as possible. As SQLite already has a complete SQL parser I expect
> much
Dear SQLite team,
I suppose I am not the only one having to convert between MySQL/MariaDB and
SQLite databases every now and then. I know there are converters for MySQL
dumps but none of any I have ever tried did work nearly reliable.
So my suggestion would be to add an import feature to the
8 matches
Mail list logo