FRIHOST • FORUMS • SEARCH • FAQ • TOS • BLOGS • COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


MySQL to SQLite?





alifax89
Is possible? if yes, how?
I can port a CMS from MySQL to SQLite?
rjraaz
http://www.sqlite.org/cvstrac/wiki?p=ConverterTools

You can find some converter tools at above link i hope it will helpful for you if not please ask here
Fire Boar
In general, no not easily. SQLite lacks some features of MySQL that, while not essential for most database usage, are used in a lot of CMS systems. Also, the oft-used auto-increment feature has a different syntax for SQLite.

You'll almost certainly have to edit some code. If the CMS does it properly and uses a database abstraction layer like PDO or their own layer (or both), you won't have to go about searching for every single call of mysql_query (a function that should never really be used anywhere now that PDO exists).
Related topics
.htaccess problem
[hosting] Cómo ahorrarle carga a los servidores de Frihost.
DATABASE + php help
SQLite
Mysql and PDO
Sqlite?
mySQL help needed, any other good database thing?
CMS without MYSQL
Python and SQLite
mysql connection question
php admin and mysql admin console
Mysql And PHP HELP PLZ
Question about MySQL!
Do you use a CMS script?
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.