distal-attribute
distal-attribute
distal-attribute
distal-attribute

SQLITE import ou export

User, date Message
Written by media90cj
2 years ago
Category: General
2 posts since Fri, 31 Aug 12
hi.smile
i use my phone to create and edit sqlite3 database but it seems so dificult to migrate for mysql or vice versa. can you put a command to import or export in sqlite format?
thanks
Written by jfalchMoney, Euro
2 years ago
406 posts since Sat, 17 Oct 09
it generally is quite difficult to migrate from one database system to another, and generally not doable mechanically without great effort (which is not available in a freeware product for one particular database). welcome to the real world.

I would advise you to
a) export sqlite database definition and data to an .sql file;
b) edit this with a text editor and change sqlite´s non-standard CREATE TABLE clauses into MySQL´s; mysql does not have INTEGER, REAL or TEXT, use INT, DECIMAL or VARCHAR, where you must know the maximum length of your column´s data to do this (eg VARCHAR(25)) since mysql, unlike sqlite, needs to know the maximum size of data fields.
c) create an appropriate database in myqsl,
d) feed the modified .sql to it and hope for the best.
Written by media90cj
2 years ago
2 posts since Fri, 31 Aug 12
hi.
my only good app is the DBConvert for SQLite & MySQL is a tool for database conversion but is shareware.
anyway using the export .sql bring some trouble making a import on various apps for sqlite. well i try using the simple csv format.
 

Please login to leave a reply, or register at first.