You can try other solutions for importing the data into a SQLite format, but I’ve had the best luck with Mauricio Piacentini’s SQLite Database Browser. Other options<\/a> you might want to try include\u00a0a Firefox plugin<\/a>.<\/p>\n Here are the steps, using SQLite Database Browser:<\/strong><\/p>\n You’ll want to edit this to remove pretty much everything but the most basic information and normalize the data types to SQLite 3 Data Types<\/a>, which are TEXT, NUMERIC, INTEGER, REAL, or BLOB<\/strong>. Your CREATE TABLE should look something like this:<\/p>\n I was using id as a primary key so I’ve added “PRIMARY KEY ASC” after “id INTEGER”. (Primary Keys are aliases to row IDs in SQLite, if you have questions read this<\/a>.)<\/p>\n However, I’ve noticed that the SQLite Database browser exports SQL in the even more simplified format with no datatype specification as such, which also seemed to work for me and may work just as well for your needs:<\/p>\n Again these steps were derived mostly by trial-and-error, so there may be issues particular to your DB that these guidelines didn’t solve. Please feel free to add any corrections, tips, and questions to the comments area. <\/p>\n Also, I know that with the iPhone OS 3.0, Core Data can take care of a lot of database functionality for you. I’d love to hear how people made the transition, and especially how anyone got a pre-existing SQL database into a Core Data store.<\/p>\n","protected":false},"excerpt":{"rendered":" Although I started writing this as a cheat-sheet for myself (after many hours of struggling with this by trial-and-error), I figured it would be helpful for other iPhone developers who’d like to take a mySQL database online and migrate it … Continue reading \n
![\"phpMyAdmin](\"http:\/\/www.juggleware.com\/blog\/wp-content\/uploads\/2009\/09\/phpAdmin-SQLite_export-300x250.png\" "\\"phpAdmin-SQLite_export\\"")
<\/a>log into phpMyAdmin, select your database and go to Database> Export<\/strong>.<\/li>\n
\n
\nCREATE TABLE dictionary (
\nid int(11) NOT NULL auto_increment,
\nword varchar(100) NOT NULL,
\nadjective tinyint(1) NOT NULL default '0' COMMENT 'is an adjective',
\nnoun tinyint(1) NOT NULL default '0' COMMENT 'is a noun ',
\nintro tinyint(1) NOT NULL default '0' COMMENT 'is an intro',
\nPRIMARY KEY \u00a0(id),
\nUNIQUE KEY words (word)
\n);
\n<\/code><\/p>\nCREATE TABLE dictionary(
\nid INTEGER PRIMARY KEY ASC,
\nword TEXT,
\nadjective INTEGER,
\nnoun INTEGER,
\nintro TEXT
\n);<\/code><\/p>\nCREATE TABLE dictionary (id, word, adjective, noun, intro);
\n<\/code><\/li>\nyou're<\/code> becomes you''re<\/code>. This seemed to import fine as long as the other guidelines are followed. Here’s what an example INSERT should look like:\nINSERT INTO dictionary VALUES(305, 'ne''er-do-well', 0, 1, 0);
\n<\/code><\/li>\nBEGIN TRANSACTION;<\/code> and end with COMMIT;<\/code><\/li>\n<\/ol>\n