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
Accounting practice management software
Canopy is a cloud-based practice management software for accounting and tax firms, offering tools for client engagement, document management, workflow automation, and time & billing. Its Client Engagement platform centralizes interactions with a secure portal, customizable branding, and email integration, while the Document Management system enables organized, paperless file storage. The Workflow module enhances visibility into tasks and projects through templates, task assignments, and automation, reducing human error. Additionally, the Time & Billing feature tracks billable hours, generates invoices, and processes payments, ensuring accurate financial management. With its comprehensive features, Canopy streamlines operations, reduces stress, and enhances client experiences.
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); } } ... --------
