mysql2sqlite
mysql2sqlite copied to clipboard
dumblob
Converts MySQL dump to SQLite3 compatible dump
I see you don't have time to maintain this excellent tool anymore, but anyway here's one more for the heap. It seems that MySQL is [case insensitive by default](http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html), while...
In MySQL the default foreign key ON DELETE behavior is RESTRICT, in SQLite it's NO ACTION. I think it would make sense if this script would automatically add "ON DELETE...
as per "README.md" from author of "mysql2sqlite" we used these: 1. Dump MySQL DB mysqldump --skip-extended-insert --compact trading_db crb_portfolios_table 1. Convert the dump to SQLite3 DB ./mysql2sqlite crb_portfolios_table | sqlite3...
``` ./mysql2sqlite mydump.sql | sqlite3 maindb.sqlite memory Error: near line 1308: unrecognized token: "`); END TRANSACTION;" ``` is probably an sqlite3 problem? or I did mysqldump "wrong" ?
Converting a database hanged up for me. It seems that the following code was the culprit: https://github.com/dumblob/mysql2sqlite/blob/d14d22ad7029cdf4d11825ee3c96922e8fbb0122/mysql2sqlite#L129-L133 This will hang up if the input contains two hex numbers, such as...
Mysql (8.0) supports a descending index, while [sqlite not](https://sqlite.org/lang_createtable.html). Currently the shell script is not generate the correct DDL for sqlite. the mysql DDL ```sql CREATE TABLE `t_sample` ( `event_date`...
the feature result like this: ```sql /*!50001 VIEW `kv_text_view` AS select `t`.`id` AS `id`,`t`.`l` AS `l`,`t2`.`p` AS `path` from (`kv_text_v155` `t` left join `file_list` `t2` on(`t`.`f` = `t2`.`id`)) group by...
I tried to run the executable on my Mac Book Pro with 317.46 GB available. Managed to get a memory error. Just speculating if this might be the result of...
From README.md: 2. Convert the dump to SQLite3 DB `./mysql2sqlite dump_mysql.sql | sqlite3 mysqlite3.db` and.. ``` mysql2sqlite mysql_dump.sql | sqlite3 database.sqlite3 Usage: mysql2sqlite [OPTIONS] Try 'mysql2sqlite --help' for help. Error:...
Replace `utc_timestamp` with `CURRENT_TIMESTAMP`. MySQL allows using `UTC_TIMESTAMP` as the default value for a column (i.e. `DatetimeCreated DATETIME DEFAULT UTC_TIMESTAMP`). This is useful in MySQL since the timezone of the...
