Sir
I wanted to back up my database... I was basically on the look out for the
C APIS which would perform the exact same thing as .backup in cli mode.
From a link i got redirected to a page.. where i came to know of
sqlite3_backup i tried it but I was not able to get it working ..
Maybe i am going wrong somewhere.. kindly help me out..
My Code:-
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <sqlite3.h>
int main(int argc,char *argv[]){
int rc;
sqlite3 *sdb,*ddb;
sqlite3_backup *sql3b;
rc = sqlite3_open("/home/Desktop/source.db",&sdb);
if(rc != SQLITE_OK){
printf("%s\n",sqlite3_errmsg(ddb));
return 0;
}
rc = sqlite3_open("/home/Desktop/dest.db",&ddb);
if(rc != SQLITE_OK){
sqlite3_close(sdb);
printf("%s\n",sqlite3_errmsg(ddb));
return 0;
}
sql3b = sqlite3_backup_init(ddb,"main",sdb,"main");
if(sql3b == NULL){
sqlite3_close(sdb);
sqlite3_close(ddb);
printf("Error\n%s\n",sqlite3_errmsg(ddb));
return 0;
}
rc = sqlite3_backup_step(sql3b, -1);
if(rc != SQLITE_DONE){
printf("%s\n",sqlite3_errmsg(ddb));
return 0;
}
rc = sqlite3_backup_finish(sql3b);
if(rc!= SQLITE_OK){
printf("Error\n%s\n",sqlite3_errmsg(ddb));
return 0;
}
sqlite3_close(sdb);
sqlite3_close(ddb);
return 1;
}
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
