Download
Convert a mysql database to a Sqlite database.
Includes two projects :
A) A php script
B) A windows executable, based on a python script
Converts data, indexes and foreign key constraints.
About the php script :
-don't need a lot of memory
-good speed
Was projected to use on VDS/VPS.
Usage:
wget https://sourceforge.net/projects/mysql2sqlite/files/mysql2sqlite/download
chmod +x mysql2sqlite
./mysql2sqlite
About the Windows executable and the Python script :
Usage : edit the in i file to fit your system, and just run the exe or the python script.
License
GNU General Public License version 3.0 (GPLv3)Follow mysql2sqlite
Other Useful Business Software
Keep company data safe with Chrome Enterprise
Make AI work your way with Chrome Enterprise. Block unapproved sites and set custom data controls that align with your company's policies.
Rate This Project
Login To Rate This Project
User Reviews
-
This script worked for me on LinuxMint 17 running PHP 5.6, but the following steps were required. [1] Complete the PHP declaration at the start of the script ("<?php" instead of "<?") [2] $ apt-get install php5.6-sqlite3 [3] Check that $pdoMy->query returns a valid result, otherwise the script fails if your MySQL database has views in it. Here's an abbreviated script with my changes: -------- #!/usr/bin/php <?php ... #create table foreach($tbls as $tbl){ echo "creating table '$tbl'\n"; $q=$pdoMy->query("SELECT * FROM `$tbl` LIMIT 1"); if ($q !== FALSE) { ... query("CREATE TABLE IF NOT EXISTS $tbl(\n".implode(",\n",$cols)."\n);\n",$pdoLi); } } #insert rows foreach($tbls as $tbl){ echo "inserting data into '$tbl'\n"; $qs=array(); $i=0; $q=$pdoMy->query("SELECT * FROM `$tbl`"); if ($q !== FALSE) { ... query($qs,$pdoLi); } } ... --------