Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

SIRprise/MySQL2SQLiteWin

Open more actions menu

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 

Repository files navigation

MySQL2SQLiteWin

MySQL to SQLite converter for Windows

usage:
copy a mysqldump-file (with .sql-extension) to the same directory and execute start.bat
This will convert the sql-file to a sqlite3 compatible output.db-file.

prerequirements:
sqlite3.exe and awk.exe in same directory
sqlite3.exe can be found at [https://www.sqlite.org/2019/sqlite-tools-win32-x86-3300100.zip]
awk.exe can be found in gawk-3.1.6-1-bin.zip at [http://gnuwin32.sourceforge.net/packages/gawk.htm]

notes:
I have tested it with a phpBB database and DB Browser from here: [https://github.com/sqlitebrowser/sqlitebrowser]
Find an example database dump here: [https://www.mysqltutorial.org/mysql-sample-database.aspx]
in comparison with linux, the windows version changes the encoding from UTF8, so newline-behaviour can be different. if this is important to you, you could rewrite the batch script for PowerShell and configure PowerShell for UTF8 standard encoding.

About

MySQL to SQLite converter for Windows

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published
Morty Proxy This is a proxified and sanitized view of the page, visit original site.