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
Secure remote access solution to your private network, in the cloud or on-prem.
OpenVPN is here to bring simple, flexible, and cost-effective secure remote access to companies of all sizes, regardless of where their resources are located.
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); } } ... --------