Fetching database from MySQL to SQLite

Question

I am trying to complete an iPhone app. And for this i need to fetch a database from MySQL to SQLite. For this case i did use some code like bellow-

MCPConnection *theConnec;
MCPResult *theRes;
//initialize connection string vars
NSString *dbURL = @"XXXXXX";
NSString *userName = @"XXXXXX";
NSString *pass = @"XXXXXX";
//open connection to database
theConnec = [theConnec initToHost:dbURL withLogin:userName password:pass usingPort:3306];
//NSLog(@"The connection to database was successfull");
[theConnec selectDB:@"XXXXXX"];
//{
// NSLog(@"Database found");
//}
//else
//{
// NSLog(@"Database not found");
//}
theRes = [theConnec queryString:@"select * from seahawk_tag"];
//get the number of rows
NSInteger numberOfRows = [theRes numofRows];
NSLog(@"Query of MySQL Database %@", numberOfRows);
return NSApplicationMain(argc, (const char **) argv);
[theConnec release];

But this code does not work properly. Here also mention that i have used some framework like cocoa.framework, cocos2d, openGLES.framework, openAL.framework, APPKit.framework, MCPKit.framework, Quartzcore.framewrok . and finally i get an error msg that CIColer.h is missing.

freinds, if u know the solution or if u have another code then pls help me

Coud you put code tag around code. It looks encrypted now.

dmajkic
– dmajkic

2009-01-28 11:12:28 +00:00
Commented Jan 28, 2009 at 11:12 — dmajkic
– dmajkic, Commented Jan 28, 2009 at 11:12

warren · Accepted Answer · 2009-09-16 04:18:42Z

2

Are you asking how to poll a remote database, or how to pre-export?

Polling a remote database and importing data should be as simple as opening the socket to the remote db, executing the query, and closing again.

answered Sep 16, 2009 at 4:18

warren

33.6k23 gold badges90 silver badges131 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Fetching database from MySQL to SQLite

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related