php - SQLite2 database conversion -
so far examples of converting sqlite2 database sqlite3 or mysql answers assume person has access on computer tools needed conversion or access specific folders on webserver host.
can give working answer allow using web host on shared server convert or export contents of sqlite2 database sqlite3 or mysql database please?
i have webserver on pc , php version of php have not support sqlite2 stuck because have use particular version of php webserver, can't swap out version, options appear doing conversion on webserver.
help in solving issue appreciated.
you don't need php convert database. download:
- sqlite 2.8 https://www.sqlite.org/sqlite-2_8_17.zip
- sqlite 3.2 https://www.sqlite.org/2013/sqlite-shell-win32-x86-3080200.zip
decompress both in folder. assuming db file called old.db
, put in same folder 2 executables, navigate folder cmd.exe
, run following command:
sqlite old.db .dump | sqlite3 new.db
as recommended in sqlite 3.x announcement. new.db
contain same data in 3.x format.
Comments
Post a Comment