mysql2sqlite

mysql2sqlite copied to clipboard

I've used your excellent converter but I've hit a snag. My SQL dumps separate the keys assignments into separate ALTER TABLE queries. Is there any way I can a) force...

andyg2

LOCK/UNLOCK keyword issue

1

MySQL dump file has LOCK and UNLOCK TABLES in between inserting values to table. Result from converter does not remove this and when executing the file it causes error.

emaccheese

Timestamp rows not ported correctly

1

row with a timestamp from MySQL dump file, : " `dateCreated` timestamp NULL DEFAULT current_timestamp()," These cause syntax errors when trying to read the sqlite result. I believe correct way...

emaccheese

"Number" in field name translate to wrong field name

1

If a field name includes the word 'Number', it gets converted to the wrong field name. ``` -- MySQL DROP TABLE IF EXISTS `employees`; CREATE TABLE `employees` ( `employeeNumber` int(11)...

crysanthus

CURRENT_TIMESTAMP() is not converted

1

CURRENT_TIMESTAMP() is not converted: ` `date_created` timestamp NOT NULL DEFAULT current_timestamp(),` Found this in Stackoverflow: `(datetime('now','localtime'))` https://stackoverflow.com/questions/381371/sqlite-current-timestamp-is-in-gmt-not-the-timezone-of-the-machine

timint

Primary key with AUTO_INCREMENT not converted right

1

A problem with AUTO INCREMENT: This ``` CREATE TABLE IF NOT EXISTS `table_name` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, ... PRIMARY KEY (`id`) ); ``` Should become ``` CREATE...

timint

Suggestion and little troubles on convertion

1

Your tool is very good, but I think to make it even more complete, it could have the option to save the file directly. I have some little troubles in...

ghost

adds support for hex blobs

ivoputzer