Skip to content

issues Search Results · repo:techouse/mysql-to-sqlite3 language:Python

Filter by

48 results
 (89 ms)

48 results

intechouse/mysql-to-sqlite3 (press backspace or delete to remove)

Describe the bug A table with a timestamp column with default of CURRENT_TIMESTAMP returns current_timestamp() in mariadb. But in transporter.py it only checks for CURRENT_TIMESTAMP. So for a table like ...
bug
mariadb
  • zokkis
  • 7
  • Opened 
    9 days ago
  • #99

Hi, Thanks for putting together this tool for the general public. I have been trying it out on a few databases that contain tables with foreign-key constraints. This always failed unless suppressing the ...
enhancement
  • langrock
  • 3
  • Opened 
    on May 25
  • #97

Describe the bug If neither --mysql-password nor --prompt-mysql-password is passed, mysql2sqlite attempts to authenticate using the literal string False as the password. This results in failed authentication ...
bug
  • lhopkins
  • 3
  • Opened 
    on May 21
  • #96

Describe the bug Table with that definition cause exception: CREATE TABLE `test` ( `test` text NOT NULL DEFAULT [] ) ENGINE=InnoDB; Expected behaviour Successful table creation Actual result mysql2sqlite ...
bug
mariadb
  • POPSuL
  • 4
  • Opened 
    on Nov 24, 2024
  • #91

Describe the bug I get a protocol mismatch error when I try to run the command mysql2sqlite -f /Users/whale/Downloads/chinook.db (is this meant to be an existing file that gets overwritten?) -d coreprotect ...
invalid
question
  • blue-pinapple
  • 1
  • Opened 
    on Nov 22, 2024
  • #90

Thanks for the great project. I am trying to convert the mysql database to sqlite. It works great, but it complains for one table that ERROR SQLite failed creating table abc: table abc has more than ...
bug
  • tianzhuqiao
  • 7
  • Opened 
    on Jun 27, 2024
  • #80

Describe the bug I encountered a syntax error when using the mysql2sqlite tool to convert a MySQL database to a SQLite database. The error occurred while trying to create a table named ops_sms_sent. Actual ...
duplicate
wontfix
  • TigerCatRabbit
  • 1
  • Opened 
    on Apr 23, 2024
  • #75

Describe the bug Mysql Field type is bit (1), default value is 0 ERROR SQLite failed creating table test : near 0 : syntax error near 0 : syntax error Expected behaviour What you expected. Actual result ...
duplicate
wontfix
  • jackwei
  • 2
  • Opened 
    on Apr 22, 2024
  • #74

temp_log= $(mktemp /tmp/xbackup.XXXXXX) exec 2 $temp_log docker exec nextclouddb /bin/bash -c mysql2sqlite -V -f /var/lib/mysql/backub.db -d mariadb -u user --mysql-password 12345 docker exec freshrssdb ...
need more info
question
  • Emporea
  • 3
  • Opened 
    on Apr 17, 2024
  • #73

Describe the bug Foreign keys are not being migrated to SQLite. Below is a sample MySQL table with foreign key to users table. CREATE TABLE `datasets` ( `id` int NOT NULL AUTO_INCREMENT, `createdByUserId` ...
invalid
need more info
question
  • Marigold
  • 2
  • Opened 
    on Apr 10, 2024
  • #71
Issue origami icon

Learn how you can use GitHub Issues to plan and track your work.

Save views for sprints, backlogs, teams, or releases. Rank, sort, and filter issues to suit the occasion. The possibilities are endless.Learn more about GitHub Issues
ProTip! 
Restrict your search to the title by using the in:title qualifier.
Issue origami icon

Learn how you can use GitHub Issues to plan and track your work.

Save views for sprints, backlogs, teams, or releases. Rank, sort, and filter issues to suit the occasion. The possibilities are endless.Learn more about GitHub Issues
ProTip! 
Restrict your search to the title by using the in:title qualifier.
Issue search results · GitHub