mysql2sqlite

mysql2sqlite copied to clipboard

ALTER TABLE over multiple lines produces Syntax errors

2

Hi, thanks for this nice script. Running mysql2sqlite on https://github.com/pau1ie/bbcmicro.co.uk/blob/master/db/db.sql then piping the result through sqlite3 produces syntax errors (but does convert the database more or less ok). It looks...

TobyLobster

OperationalError: unrecognized token Errors with mysql2sqlite

3

Yesterday I tried to use mysql2sqlite.exe on a windows machine to migrate a dump from a rather big mysql-database to sqlite. I made the mysql dump as suggested with ./mysqldump...

tacitus5

Fix mysql current_timestamp() to be current_timestamp.

1

Signed-off-by: Robert LeBlanc

rldleblanc

detect empty input file and issue a warning

4

You have the code comment # FIXME detect empty input file and issue a warning one approach is set a flag in the BEGIN reset it in any section before...

TomConlin

ignore CREATE SCHEMA

1

tapple

Mysqldump uses database_name.table_name on TRIGGER statement

2

When dumping a trigger, mysqldump generated the table names with the scchema name which cuases an error when importing the dump. sqlite 3.8.7.1 mysqldump Ver 10.13 Distrib 5.5.59, for debian-linux-gnu...

HalimNaim

Table with reserved name is not quoted.

2

We have a table called `transaction` which is not escaped an causes an error. sqlite 3.8.7.1 mysqldump Ver 10.13 Distrib 5.5.59, for debian-linux-gnu (x86_64)

HalimNaim

USING BTREE in KEY

1

Hi. I was getting this error: > Error: near line 4: near "USING": syntax error When I had the following syntax in my SQL backup file: ``` CREATE TABLE `table_name`...

PikMaster

``` CREATE TABLE `measurement_logs` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `UserId` int(11) DEFAULT NULL, `CreatedOn` datetime NOT NULL, `MeasuringPointId` int(11) NOT NULL, `StartDate` datetime NOT NULL, `EndDate` datetime NOT NULL,...

raphaelquati

Keep getting 'file is encrypted or is not a database' error

8

I tried the same commands as mentioned: mysqldump --no-data -u user -pxxx dbname > dbname_dump.sql ./mysql2sqlite.sh dbname_dump.sql | sqlite3 dbname.db But get Error: near line XXX: file is encrypted or...

SwethaEnixta