Click here to Skip to main content
11,496,146 members (1,597 online)
The site is currently in read-only mode for maintenance. Posting of new items will be available again shortly.
See more: PHP MySQL Sqlite
Hey Folks,
I am new to PHP. I want to convert a MYSQL database into .sqlite using PHP code. Can anyone offer me a solutions regarding it?
Posted 24-Sep-12 0:58am
Edited 24-Sep-12 0:59am
v2
Here's a list of converters.
  Permalink  
I finally found its solution.
Save sh file available at
https://gist.github.com/943776
and execute
"`./mysql2sqlite.sh DBNAME --databases DBNAME -u DB_USERNAME -pDB_PASSWORD | sqlite3 database.sqlite`"(without qoutes and with "`")
in php file.
Save both files in one folder
  Permalink  
Hi Every one,

I have tried but this script was not working as well.

I have also copy the both file in same folder and after executing PHP file than a blank sqlite file.

Could you please provide me another better way to execute this script and convert Mysql database into sqlite file.

Thanks,
Sam
  Permalink  
Comments
AakashGupta at 6-Dec-12 5:13am
   
What was the error you getting?
try running that stand alone script in terminal.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Dnyaneshwar@Pune 692
1 RyanDev 230
2 CHill60 208
3 Sascha Lefèvre 195
4 Sergey Alexandrovich Kryukov 124
0 Sergey Alexandrovich Kryukov 10,401
1 OriginalGriff 8,910
2 Sascha Lefèvre 3,899
3 Maciej Los 3,422
4 Richard Deeming 2,600


Advertise | Privacy | Mobile
Web01 | 2.8.150520.1 | Last Updated 5 Dec 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100